ORA-04068: existing state of packages has been discarded

Posted by satish on Jan 01, 2019; 11:19am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/ORA-04068-existing-state-of-packages-has-been-discarded-tp7030.html

Dear Erman,

we are on R12.2.5
database version 12.1.0.2(2 node rac)

Our concurrent requests got stuck in  output post processor for long time with error "ORA-04068: existing state of packages has been discarded".

FNDOPP24989.txt:[1/1/19 2:37:33 PM] [UNEXPECTED] [OPPAQMON:24989] java.sql.SQLException: ORA-04068: existing state of packages has been discarded
FNDOPP24989.txt:[1/1/19 2:58:54 PM] [UNEXPECTED] [24989:RT6955214] java.sql.SQLException: ORA-04068: existing state of packages has been discarded
FNDOPP24989.txt:[1/1/19 3:01:11 PM] [UNEXPECTED] [24989:RT6955223] java.sql.SQLException: ORA-04068: existing state of packages has been discarded
FNDOPP24990.txt:[1/1/19 2:37:33 PM] [UNEXPECTED] [OPPAQMON:24990] java.sql.SQLException: ORA-04068: existing state of packages has been discarded
FNDOPP24990.txt:[1/1/19 2:55:07 PM] [UNEXPECTED] [24990:RT6955199] java.sql.SQLException: ORA-04068: existing state of packages has been discarded
FNDOPP24990.txt:[1/1/19 3:12:38 PM] [UNEXPECTED] [24990:RT6955289] java.sql.SQLException: ORA-04068: existing state of packages has been discarded
FNDOPP24991.txt:[1/1/19 2:37:33 PM] [UNEXPECTED] [OPPAQMON:24991] java.sql.SQLException: ORA-04068: existing state of packages has been discarded
FNDOPP24991.txt:[1/1/19 2:59:08 PM] [UNEXPECTED] [24991:RT6955215] java.sql.SQLException: ORA-04068: existing state of packages has been discarded
FNDOPP24991.txt:[1/1/19 3:06:32 PM] [UNEXPECTED] [24991:RT6955267] java.sql.SQLException: ORA-04068: existing state of packages has been discarded

recent changes:

granted privileges on synonyms to readonly schema
compiled invalids using utlrp.sql->while compiling,we found invalids increased to 15,000 then cancelled the script
compiled invalids using adadmin(compile apps schema)->invalids count decreased and back to normal 12

Please need your expertise which of the above operation would have caused the error "ORA-04068: existing state of packages has been discarded"

Also,please let us know "can we compile invalids using adadmin when instance is in use"?
Also,please let us know "can we compile invalids using utlrp.sql when instance is in use"?

Thanks for all the support