ORA-06550 Running Sys.Utl_recomp.Recomp_parallel(1) During ADPATCH or ADADMIN Session
(Doc ID 362727.1)
Last updated on DECEMBER 04, 2024
Applies to:
Oracle iSupplier Portal - Version 11.5.1 to 11.5.10 [Release 11.5]Oracle Applications DBA - Version 11.5.0 to 11.5.10.2 [Release 11.5 to 11.5.10]
Information in this document applies to any platform.
Application Install - Version: 11.5iSupplier Portal - Version: 11.5Microsoft Windows 2000Solaris Operating System (x86)Microsoft Windows XP (64-bit Itanium)AIX5L Based Systems (64-bit)Red Hat Enterprise Linux Advanced Server ItaniumSUSE \ UnitedLinux x86-64Red Hat Enterprise Linux Advanced Server x86-64 (AMD Opetron Architecture)Linux x86-64Solaris Operating System (SPARC 64-bit)AIX Based Systems (32-bit)AIX 4.3 Based Systems (64-bit)Solaris Operating System (SPARC 32-bit)Linux x86HP-UX PA-RISC (64-bit)HP Tru64 UNIXMicrosoft Windows (32-bit)
Symptoms
The following errors appear in the log file when applying an applications patch via the adpatch utility or when compiling invalid objects using the adadmin utility:
sqlplus -s APPS/***** @/u001/app/ten2appl/ad/11.5.0/admin/sql/adutlrcmp.pls
APPLSYS ***** APPS ***** ***** 16 0 NONE FALSE
Arguments are:
AOL_schema = APPLSYS, AOL_password = *****,
Schema_to_compile = APPS, Schema_to_compile_pw = *****,
SYSTEM_password = *****, Total_workers = 16, Logical_worker_num = 0
Object_type_to_not_compile = NONE
Use_stored_dependencies = FALSE
Connected.
Running utl_recomp.recomp_parallel(16), if it exists
OWNER NUM_INVALID
------------------------------ -----------
APPS 24
CLR 1
CUSTOM 3
EUL_GD 2
GDX 14
Elapsed: 00:00:00.43
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.01
STATUS_MESSAGE
------------------------------------------------------------------------------
Running UTL_RECOMP.RECOMP_PARALLEL...
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.01
STATUS_MESSAGE
------------------------------------------------------------------------------
Got the following error running SYS.UTL_RECOMP.RECOMP_PARALLEL(16)------------
: ORA-06550: line 1, column 7:
PLS-00201: identifier 'SYS.UTL_RECOMP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Both the adadmin and adpatch processes are able to be completed after the error message is displayed.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |