OraFAQ Forum: Data Guard » dataguard broker issue

Home » Server Options » Data Guard » dataguard broker issue

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

dataguard broker issue [message #270072]

Tue, 25 September 2007 10:44

alanm
Messages: 284
Registered: March 2005

Senior Member

hello all,
am getting the following errors from the broker

Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys/Fes7Evu6@emrep
Connected.
DGMGRL> switchover to offsite_emrep;
Performing switchover NOW, please wait...
Operation requires shutdown of instance "emrep" on database "office_emrep"
Shutting down instance "emrep"...
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
Operation requires shutdown of instance "emrep" on database "offsite_emrep"
Shutting down instance "emrep"...
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
Operation requires startup of instance "emrep" on database "office_emrep"
Starting instance "emrep"...
Unable to connect to database
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Failed.
You are no longer connected to ORACLE
Please connect again.
Unable to start instance "emrep"
You must start instance "emrep" manually
Operation requires startup of instance "emrep" on database "offsite_emrep"
You must start instance "emrep" manually
Switchover succeeded, new primary is "offsite_emrep"
DGMGRL>

If I disable the broker and carry out the switchover from the database evrything works as it should. Can anyone point me in the right direction to resolve this issue.

rgds

Alan

Report message to a moderator

Re: dataguard broker issue [message #270100 is a reply to message #270072]

Tue, 25 September 2007 14:15

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Check it.

Attachment: DATAGUARD CONFIGURATION.doc
(Size: 100.00KB, Downloaded 3160 times)

Report message to a moderator

Re: dataguard broker issue [message #270897 is a reply to message #270100]

Fri, 28 September 2007 05:16

alanm
Messages: 284
Registered: March 2005

Senior Member

thanks for the info.

Got it working and surprisingly is was the 'case' of the SID in the listener.ora file which was causing the problem. I set it to upper case and all now works.

cheers

Alan

Report message to a moderator

Previous Topic:	About listener and Backup/Restore
Next Topic:	Config issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 02 09:39:24 CDT 2026