During Patching Ontup251.Sql Is Running for Long Times

(Doc ID 2065792.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Patch Application Issues

ACTUAL BEHAVIOR
---------------
The ontup251.sql script is running for more than 15 minutes on each node.
We have 11 nodes NON-SHARED APPL_TOP environment. We need apply the patch on all nodes .
The SQL ontup251.sql is taking around 15 to 20 minutes for each node.

EXPECTED BEHAVIOR
-----------------------
Expect script ontup251.sql to complete is less time.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply patch 20163596:R12.PO.B
2. Review adworker log to see elapsed time for ontup251.sql

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms