Skip to Content

Unable to Connect to New Standby Database After Switchover Using DataGuard Broker

Dec 07, 2016 at 03:40 AM


avatar image
Former Member

Dear Gurus,

We are in the middle of implementing DataGuard Broker. We had a problem when performing switchover from primary database (aog) to standby database (aogdr). There is an error showing that the broker on the aogdr unable to connect to new standby database (aog) indicated by error ORA-12541: TNS:no listener.

Here is the error message:

DGMGRL> switchover to aogdr; Performing switchover NOW, please wait... New primary database "aogdr" is opening... Operation requires startup of instance "AOG" on database "aog" Starting instance "AOG"... Unable to connect to database ORA-12541: TNS:no listener

Failed. Warning: You are no longer connected to ORACLE.

Please complete the following steps to finish switchover: start up and mount instance "AOG" of database "aog"

The workaround for this issue is I start the new standby database (aog) manually and restart the listener on aog system. But I think that the switchover command should able to perform smoothly without error. Kindly need your help to solve this issue.



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Dec 07, 2016 at 06:41 AM


What does alert log has to say?

Please check alert log on primary and standby node.



10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 08, 2016 at 02:27 PM

Hi Kris,

Looks like an issue with TNSNAMES.ora or Listener.ora. Do you have your listener configured for standby whenever failover occurs?

Check if you can connect to DB after manual switch over to standby.


Harish Karra

10 |10000 characters needed characters left characters exceeded