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

Posted by ErmanArslansOracleBlog on Jan 03, 2019; 8:06am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/ORA-04068-existing-state-of-packages-has-been-discarded-tp7030p7038.html

1)Were these errors recorded while you were  doing that utlrp compilation?
2) Your database is 12C. So you need to leave this parameter as is. It should be FALSE by default..
Please check the value of it using the below query:

--Remember it is a hidden parameter..
--Following query is for displaying all the hidden parameters (parameter name starting with "_")

SELECT
  ksppinm,
  ksppstvl
FROM
  x$ksppi a,
  x$ksppsv b
WHERE
  a.indx=b.indx
AND
  substr(ksppinm,1,1) = '_'
ORDER BY ksppinm