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

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

Thanks for the update erman

1)Did you check the concurrent program that was generating ORA-04068? What was the PLSQL object that the concurrent program was trying to use?

Inventory summary report..issue happened only for 5 request ids

2)What was the invalid count before running utlrp.sql?

20 invalids

3)Did you only grant some synonyms? or did you recreate any synonyms ?

Granted synonyms

4)What is the value of the hidded parameter named -> "_DISABLE_FAST_VALIDATE" ?

_DISABLE_FAST_VALIDATE is not set

5)any errors in the alert log?

Working on it

6)Are specific objects always involved or does the problem seem to randomly affect any package?

Issue happended only once

8)How is the problem cleared, albeit temporarily, e.g. by flushing the shared pool, manually recompiling certain objects, recreating synonyms etc?

We cancelled the request id's from backend

Also,please let us know is it safe to run admin or utlrp while instance is in use?

Thank you,
satish