oerr

Select on read-only standby database returns ORA-04045 and ORA-16000

Luis

06 Jan 2023 • 2 min read

A customer reports that while doing a select through a DB Link or directly to a standby database that is opened in read-only, the following error is shown:

SQL> select * from DATAHUB1;
                  *
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of PUBLIC.DATAHUB1
ORA-16000: database open for read-only access

This what you need to consider and the steps to take to resolve this: