ORA-04045: errors during recompilation/revalidation of ORA-16000: database open for read-only acces
edited Dec 3, 2015 10:04AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 3 commentsAnswered
Hi Gurus,
11203 Primary RAC
11203 Standby RAC(ADG)
we are using active dataguard for reporting purpose and getting ORA-04045 intermittently,on checking primary database which is production there are no invalid objects in application schema nor any DDL operation was being performed on any objects.
Surprising, we are getting the error when querying the tables (through synonyms) not any views or any plsql code either from sqldeveloper or sqlplus client and is, intermittent.The tables are being accessed by the reporting application using synonyms through application userid and gets the same issue or error.
What is it that might be causing this,should i compile the synonyms under the application userid.
11203 Primary RAC
11203 Standby RAC(ADG)
we are using active dataguard for reporting purpose and getting ORA-04045 intermittently,on checking primary database which is production there are no invalid objects in application schema nor any DDL operation was being performed on any objects.
Surprising, we are getting the error when querying the tables (through synonyms) not any views or any plsql code either from sqldeveloper or sqlplus client and is, intermittent.The tables are being accessed by the reporting application using synonyms through application userid and gets the same issue or error.
What is it that might be causing this,should i compile the synonyms under the application userid.
0