AnsweredAssumed Answered

ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only

Question asked by Manish_Sharma on Dec 8, 2017
Latest reply on Dec 13, 2017 by Gene_Howard

We have RAC DB monitoring configured, now a days we are getting these alerts from stand by nodes and after the research we found that these alert generates when A query was issued against an object not recognized as a fixed

table or fixed view before the database or pluggable database has been opened.

 

Stand by nodes usually remains in mount state and when we try to check the connection message comes up "cannot connect to database: (ORA-01033: ORACLE initialization or shutdown in progress )" 

 

We suppressed this alert but now this new alert ORA-01219 started to come through all of sudden and we have lot of such DB servers in monitoring.

 

Please let me know that how can we get rid of this sort of alert.

 

Regards,

Manish Sharma

 

Outcomes