Select on read-only standby database returns ORA-04045 and ORA-16000
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: