Return
-
Title
Post stopped due to ORA-04068 and or ORA-04061 and or ORA-04065 -
Description
The Post is stopped due to errors as below:
Info 2019-04-05 18:38:18.898475 40595 1598670672 Poster exited with code=1, pid = 36673 (posting from SID1, queue queue_name, to SID2)
Error 2019-04-05 18:38:18.868464 36673 3765647680 s:3 Poster: que/seq = 3/ 6514834319 seqno/offset = 113973/24822300 Unexpected Oracle error: ORA-04068: existing state of packages has been discarded.ORA-04061: existing state of package body "OWNER.PACKAGE_NAME" has been invalidated.ORA-04065: not executed, altered or dropped package body "OWNER.PACKAGE_NAME". (object name: "OWNER"."OBJECT_NAME") (posting from SID1, queue queue_name, to SID2) [module opo]
-
Cause
There are PL/SQL issues on target impacting the Post that need to be addressed. -
Resolution
Resolve the PL/SQL issues for objects mentioned in the error messages in event_log and then restart Post.