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

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

This would be due to shared pool corruption.


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.