ORA-04023: Object could not be validated or authorized

No comments
While running any queries, or after creating any view,procedures we may start getting ORA-04023 errors.

Error:
ORA-04023: Object could not be validated or authorized

We may also see ORA-00001 errors in  alert log file parallely.

If we have RAC database and then we may see ORA-04023 error only on one of the nodes which would be specific to instance or node

Cause:
This would be due to shared pool corruption.

Solution:

SQL> alter system flush shared_pool;

or bounce the database or specific instance.

If this does not solve the issue, we need to contact Oracle Support for further details.

No comments :

Post a Comment