Home » Server Options » Data Guard » Changing SID after switchover (oracle 11.2)
Changing SID after switchover [message #605846] Wed, 15 January 2014 04:45 Go to next message
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 Go to previous messageGo to next message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
Use Dataguard Broker to manage your failover.
Re: Changing SID after switchoer [message #605852 is a reply to message #605849] Wed, 15 January 2014 05:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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?

Re: Changing SID after switchoer [message #605853 is a reply to message #605846] Wed, 15 January 2014 05:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: Changing SID after switchoer [message #605854 is a reply to message #605852] Wed, 15 January 2014 05:51 Go to previous messageGo to next message
gazzag
Messages: 1118
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 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Ok, so moving it to Data Guard forum.

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


Current Time: Thu Mar 28 05:47:59 CDT 2024