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

[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.

Thanks,

Kris

[Former Member]

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.

Regards,

Harish Karra

[Former Member]

Hi

What does alert log has to say?

Please check alert log on primary and standby node.

Regards

Prithviraj