My Oracle Support Banner

ORA-06550 Running Sys.Utl_recomp.Recomp_parallel(1) During ADPATCH or ADADMIN Session (Doc ID 362727.1)

Last updated on AUGUST 10, 2020

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.