Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

Runnning adpatch to upgrade from R12.1.1 to R12.1.3 - how to speed up UTL_RECOMP.RECOMP_PARALLEL

edited Aug 20, 2021 10:17AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 17 commentsAnswered

Upgrading from R12.1.1 to R12.1.3 - applying adpatch 9239089 - R12.AD.B.delta.3

adpatch is sitting at UTL_RECOMP.RECOMP_PARALLEL..

Per adpatch log :

STRT_TASK: [Run ST parallel compile (APPS)] [] [Fri Mar 09 2018 08:50:54]

sqlplus -s APPS/***** @/r05/oracle/apps/apps_st/appl/ad/12.0.0/sql/adutlrcmp.sql APPLSYS ***** APPS ***** ***** 2  0 NONE FALSE

Arguments are:

AOL_schema = APPLSYS, AOL_password = *****,

Schema_to_compile = APPS, Schema_to_compile_pw = *****,

SYSTEM_password = *****, Total_workers = 2, Logical_worker_num = 0

Object_type_to_not_compile = NONE

Use_stored_dependencies = FALSE

  1. Connected.

Running utl_recomp.recomp_parallel(2), if it exists

OWNER                          NUM_INVALID

------------------------------ -----------

APPLSYS                                  2

APPS                                 21157

CTXSYS                                   5

XXX_ELS                                  3

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center