Sunday, 19 July 2020

ORA-20000: Please manually fix the following invalid packages: "PACKAGE BODY SYSTEM.APPS_ARRAY_DDL"

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.

No comments:

Post a Comment

OS Watcher Installation in RAC

 Step:1 Download and untar the oswbb812.tar under the grid user in RAC on the both nodes. Follow the OS Watcher User's Guide (Doc ID 153...