Re: ORA-04068: existing state of packages has been discarded

Posted by satish on Jan 02, 2019; 12:39pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/ORA-04068-existing-state-of-packages-has-been-discarded-tp7030p7036.html

Thanks for the update erman

All 20 are custom invalids.
below error is seen in alert log

ORA-00060: deadlock resolved; details in file .../diag/rdbms/proddb/PRODDB1/trace/PROD_ora_14324.trc
Errors in file .../diag/rdbms/proddb/PRODDB1/trace/PROD_ora_13290.trc  (incident=359524):
ORA-03137: TTC protocol internal error : [3120] [94] [] [] [] [] [] []
Incident details in: /u02/PRODDB/12.1.0/admin/PRODDB_erpproddb1/diag/rdbms/proddb/PRODDB1/incident/incdir_359524/PRODDB1_ora_13290_i359524.trc

ORA-04045: errors during recompilation/revalidation of APPS.CSP_RECEIVING_LINES_V
but current status is as below

SQL> select OBJECT_NAME,OBJECT_TYPE,STATUS from apps.ad_objects where OBJECT_NAME='CSP_RECEIVING_LINES_V';

OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE        STATUS
------------------ -------
CSP_RECEIVING_LINES_V
VIEW               VALID