Home » RDBMS Server » Networking and Gateways » dblink with a new server
dblink with a new server [message #197137] Tue, 10 October 2006 03:53 Go to next message
Messages: 1
Registered: October 2006
Location: VIGNOLA
Junior Member
We have two server which one replicate the other; the second in stand by mode; last week a disk of the principal server was damaged. So we put in service his "twin", but this have different host-name and different ip-address. Another database acceded to this through a db-link. Now the db-link doesn't work. The database have the identical database and instance name.
Where and what parameter I can change to put on line the db-link ?
Thank you all and sorry for my bad English .
Re: dblink with a new server [message #201477 is a reply to message #197137] Sat, 04 November 2006 14:45 Go to previous messageGo to next message
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
Depends how You have created the DB link .-)

Probably, it is using an entry in Your tnsnames.ora file on the (other/third) database, so all You need to do is edit the IP/hostname in this to point at the new server running the db.

It could also be that You have hardcoded the network path in the db link. Is so, You need to drop + recreate the link, using the correct IP/hostname.

Re: dblink with a new server [message #201516 is a reply to message #201477] Sun, 05 November 2006 08:06 Go to previous message
Messages: 21131
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Another option would be NOT changing Oracle-dependant properties (TNSNAMES.ORA etc.), but changing auxiliary server's name and IP address. Doing so, you wouldn't have to modify DB links etc., but simply use replicated database as if it was the original one.
Previous Topic: Shutdown database & lsnrctl start
Next Topic: specified index does not exist while rebuilding the index
Goto Forum:

Current Time: Fri Jul 28 12:26:34 CDT 2017

Total time taken to generate the page: 0.08595 seconds