ERROR:
======
ATTENTION: All workers either have failed or are waiting:
FAILED: file adinvset.pls on worker 1.
ERROR at line 1:
ORA-20000: Please manually fix the following invalid packages: "PACKAGE BODY
SYSTEM.APPS_ARRAY_DDL"
ORA-06512: at "SYSTEM.AD_INVOKER", line 776
ORA-06512: at "SYSTEM.AD_COMPILE", line 103
ORA-06512: at "SYSTEM.AD_INVOKER", line 762
ORA-06512: at line 2
SOLUTIONS:
=========
Please check list of invalid objects and compile.
SELECT owner, object_name FROM all_objects
WHERE object_name= 'APPS_ARRAY_DDL'
AND object_type = 'PACKAGE';
>> execute below steps from application.
SQL>show user
APPS
SQL>@/mwdb-pl/ebsap/fs1/EBSapps/appl/ad/12.0.0/admin/sql/adinvset.pls Superbarwa20 10 0 TRUE FALSE
Connect with sysdba
SQL>utlrp.sql
>> Restart failed worker from adctrl utility.
======
ATTENTION: All workers either have failed or are waiting:
FAILED: file adinvset.pls on worker 1.
ERROR at line 1:
ORA-20000: Please manually fix the following invalid packages: "PACKAGE BODY
SYSTEM.APPS_ARRAY_DDL"
ORA-06512: at "SYSTEM.AD_INVOKER", line 776
ORA-06512: at "SYSTEM.AD_COMPILE", line 103
ORA-06512: at "SYSTEM.AD_INVOKER", line 762
ORA-06512: at line 2
SOLUTIONS:
=========
Please check list of invalid objects and compile.
SELECT owner, object_name FROM all_objects
WHERE object_name= 'APPS_ARRAY_DDL'
AND object_type = 'PACKAGE';
>> execute below steps from application.
SQL>show user
APPS
SQL>@/mwdb-pl/ebsap/fs1/EBSapps/appl/ad/12.0.0/admin/sql/adinvset.pls Superbarwa20 10 0 TRUE FALSE
Connect with sysdba
SQL>utlrp.sql
>> Restart failed worker from adctrl utility.
No comments:
Post a Comment