| 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 .
|
|
|
|
| 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
|
|
|
|
| Re: dblink with a new server [message #201516 is a reply to message #201477] |
Sun, 05 November 2006 08:06 |
 |
Littlefoot
Messages: 21808
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
