OraFAQ Forum: Data Guard » Changing SID after switchover

Home » Server Options » Data Guard » Changing SID after switchover (oracle 11.2)

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

Changing SID after switchover [message #605846]

Wed, 15 January 2014 04:45

7777
Messages: 1
Registered: January 2014

Junior Member

Hi all,

I wanted to ask how to minimize the work of tnsnames.ora reconfiguration
in case if I change IP-adress (new ip-adress of standby = old ip-adress of primary)

Thanks in adv. for Your replys

[EDITED by LF: fixed topic title typo; was "switchoer"]

[Updated on: Wed, 15 January 2014 06:32] by Moderator

Report message to a moderator

Re: Changing SID after switchoer [message #605849 is a reply to message #605846]

Wed, 15 January 2014 05:26

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Use Dataguard Broker to manage your failover.

Report message to a moderator

Re: Changing SID after switchoer [message #605852 is a reply to message #605849]

Wed, 15 January 2014 05:47

Michel Cadot
Messages: 68773
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

@gazzag, what does the question has to do with Data Guard?
Where do you see any fail over is in question?

Report message to a moderator

Re: Changing SID after switchoer [message #605853 is a reply to message #605846]

Wed, 15 January 2014 05:48

Michel Cadot
Messages: 68773
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

tnsnames.ora should contain only names not IP addresses, then you change the IP in your DNS if a server sees its IP changed.

Report message to a moderator

Re: Changing SID after switchoer [message #605854 is a reply to message #605852]

Wed, 15 January 2014 05:51

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Quote:

new ip-adress of standby = old ip-adress of primary

And "switchover" is mentioned in the title of the OP.

[Updated on: Wed, 15 January 2014 06:02]

Report message to a moderator

Re: Changing SID after switchoer [message #605866 is a reply to message #605854]

Wed, 15 January 2014 07:58

Michel Cadot
Messages: 68773
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Ok, so moving it to Data Guard forum.

Report message to a moderator

Previous Topic:	Incorrect database role
Next Topic:	Need to make standby database of oracle express edition

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 01 16:51:50 CST 2026