Tuesday, December 13, 2016

ORA-04061: existing state of has been invalidated

Getting below error.

ORA-04061: existing state of has been invalidated
ORA-04061: existing state of package "" has been invalidated
ORA-04065: not executed, altered or dropped package
ORA-06508: PL/SQL: could not find program unit being called:

Do below step to resolve this issue.

1. If it is EBS, then check workflow notification mailer , and OPMN services.
2. If it is other application or does not resolved after 1 search the search the session which is holding this ovject in cache.
3. Kill that session.

No comments:

Post a Comment

Command to do active duplicate for Oracle Database

1. First login to target server 2. Validate tns connectivity between Source DB and Target DB 3. Prepare and validate space availability 4. S...