This discussion is archived
1 Reply Latest reply: Mar 20, 2013 7:11 AM by mseberg RSS

DG Broker issue

997985 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points