ORA-16623: member detected role change
Playing with dataguard failover scenarios I bumped into this error: That’s due to inconsistent information within the broker files from both servers. To fix this, we can do this:
TNS-12564: TNS:connection refused while reinstating a failed database
One of the reasons for getting this error might be that the sqlnet.ora does not contain the proper settings like in this particular case: As you can see there is nothing set in sqlnet.ora. Therefor when I was trying to reinstate a former PRIMARY as STANDBY, I was seeing in alert log of the reinstated…
ORA-16631: operation requires shutdown of database or instance
On short, after upgrading one of my databases from 11203 to 11204, I’ve noticed that the standby database was in a DISABLED state: DGMGRL> show configuration Configuration – DG_CONFIG Protection Mode: MaxPerformance Databases: DB_PRI- Primary database DB_STANDBY – Physical standby database (disabled) Fast-Start Failover: DISABLED Configuration Status: SUCCESS I tried to set it…
