1 Reply Latest reply: Mar 20, 2013 9:11 AM by mseberg RSS

    DG Broker issue

    997985
      Hi Team,

      Recently I configure data guard and data broker. Data Guard is working fine.

      When I am switching primary database to another standby , I am getting below error.

      DGMGRL> switchover to dg1;
      Performing switchover NOW, please wait...
      New primary database "dg1" is opening...
      Operation requires shutdown of instance "dg2" on database "dg2"
      Shutting down instance "dg2"...
      ORACLE instance shut down.
      Operation requires startup of instance "dg2" on database "dg2"
      Starting instance "dg2"...
      ORA-24327: need explicit attach before authenticating a user

      I am using same password for password file.
      Listener file in dg1:
      [oracle@inatechrac1 admin]$ cat listener.ora

      LISTENER=
      (DESCRIPTION=
      (ADDRESS_LIST=
      (ADDRESS=(PROTOCOL=tcp)(HOST=10.50.10.32)(PORT=1521))
      (ADDRESS=(PROTOCOL=ipc)(KEY=extproc))))
      SID_LIST_LISTENER=
      (SID_LIST=
      (SID_DESC=
      (GLOBAL_DBNAME=dg1.blr.com)
      (ORACLE_HOME=/u01/app/oracle/product/11.2.0)
      (SID_NAME=dg1))
      (SID_DESC=
      (SID_NAME=dg1)
      (ORACLE_HOME=/u01/app/oracle/product/11.2.0)
      (GLOBAL_DBNAME=dg1_DGMGRL.blr.com)
      (PROGRAM=extproc)))
      ADR_BASE_LISTENER = /u01/app/oracle



      Listener file in dg2:
      LISTENER=
      (DESCRIPTION=
      (ADDRESS_LIST=
      (ADDRESS=(PROTOCOL=tcp)(HOST=10.50.10.33)(PORT=1521))
      (ADDRESS=(PROTOCOL=ipc)(KEY=extproc))))
      SID_LIST_LISTENER=
      (SID_LIST=
      (SID_DESC=
      (GLOBAL_DBNAME=dg2.blr.com)
      (ORACLE_HOME=/u01/app/oracle/product/11.2.0)
      (SID_NAME=dg2))
      (SID_DESC=
      (SID_NAME=dg2)
      (ORACLE_HOME=/u01/app/oracle/product/11.2.0)
      (GLOBAL_DBNAME=dg2_DGMGRL.blr.com)
      (PROGRAM=extproc)))
      ADR_BASE_LISTENER = /u01/app/oracle

      Please help me on this issue

      Edited by: 994982 on Mar 20, 2013 1:46 AM
        • 1. Re: DG Broker issue
          mseberg
          Hello;

          I would check the tnsnames.ora on the Standby that's about to become the new Primary.

          Based on the information you provided I'm thinking you cannot connect from the Standby site to the Primary and thus the switchover fails and throws this error.

          If that checks out make sure the firewall rules for both server line up.

          Best Regards

          mseberg