OraFAQ Forum: Networking and Gateways » dblink with a new server

Home » RDBMS Server » Networking and Gateways » dblink with a new server

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

dblink with a new server [message #197137]

Tue, 10 October 2006 03:53

gmacchi
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 .

Report message to a moderator

Re: dblink with a new server [message #201477 is a reply to message #197137]

Sat, 04 November 2006 14:45

kimant
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.

Hr
Kim

Report message to a moderator

Re: dblink with a new server [message #201516 is a reply to message #201477]

Sun, 05 November 2006 08:06

Littlefoot
Messages: 21823
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.

Report message to a moderator

Previous Topic:	Shutdown database & lsnrctl start
Next Topic:	specified index does not exist while rebuilding the index

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 17 00:43:17 CDT 2025