ORA-20000 APPS_DDL/APPS_ARRAY_DDL Package(s) Missing Or Invalid In Schema CTXSYS
Error:
When attempting to apply a Patch the following error occurs:
sqlplus -s APPS/***** @$AD_TOP/12.0.0/patch/115/sql/adgrnctx.sql &systempwd &un_fnd CTXSYS &un_icx ICX
Connected.
User altered.
declare
*
ERROR at line 1:
ORA-20000: APPS_DDL/APPS_ARRAY_DDL package(s) missing or invalid in schema
CTXSYS
ORA-06512: at "SYSTEM.AD_DDL", line 165
ORA-06512: at line 19
The issue is caused by the missing AD_DLL object in the Database. Please execute following script, to verif
sqlplus apps/<pwd>
SELECT owner, object_name FROM all_objects
WHERE object_name= 'AD_CTX_DDL'
AND object_type = 'PACKAGE';
select owner,SYNONYM_NAME from dba_synonyms
where table_owner='CTXSYS' and TABLE_NAME='AD_CTX_DDL';
SOLUTION:
To implement the solution, please execute the following steps :
1. Execute the script adctxpkg.sql located under the $AD_TOP/patch/115/sql directory to create the AD_CTX_DDL package:
sqlplus APPS/<Password> @adctxpkg.sql <SYSTEM Password> CTXSYS APPS
Post a Comment
Post a Comment