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.
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.
Post a Comment
Post a Comment