Solution for “ORA-04023: Object could not be validated or authorized” error
Solution for ORA-04023 error:
Some times you may notice that after recreation of some views or procedures, you may start getting ORA-04023 errors.
ORA-04023: Object could not be validated or authorized
You may also see ORA-00001 errors in your alert log file during the same time.
If you have RAC database and if you are getting ORA-04023 error only on one of the nodes then it is very clear that the issue is related to specific “instance” and not the “database“.
This error means that the shared pool is corrupt. You can try to flush the shared pool so that it may populate the fresh objects again in the shared pool. This should resolve the problem.
SQL> alter system flush shared_pool;
If this does not solve the issue, you need to contact Oracle Support for further details.
it was helpful. Thanks
I ran into the ora-4023 error on a physical standby which followed a more scary ora-604 error on some user account logins (SYS could login fine) that failed ..
That was caused by running catalog.sql and catproc.sql on the primary – That left SYS objects in an invalid state..once they were recompiled,
Then the above ALTER SYSTEM FLUSH SHARED_POOL on the standby was issued.. replication from the Primary resumed and all was well again.
Thanks Tushar !
THanks Tushar,
This post helped me in fixing the issue.