Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

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

    Hi

    What does alert log has to say?

    Please check alert log on primary and standby node.

    Regards

    Prithviraj

    Add comment
    10|10000 characters needed 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.

    Regards,

    Harish Karra

    Add comment
    10|10000 characters needed characters exceeded