Hi everyone,
we encountered a problem with DB link recently, and I would like it if someone could explain to me what was the problem...
we had two Oracle 10g instances on two different machines, the inst1 and inst2, and we had public a dblink between them which used the tns_entry to connect:
CREATE PUBLIC DATABASE LINK DBL_INST1_TO_INST2
CONNECT TO user
IDENTIFIED by password
USING tns_entry
No problem here.
Databases were upgraded to 11g. Tnsnames entries were updated accordingly, users and passwords stayed the same, so DB link remained as above.
But when we tried to use db link, it didn't work. we called the DBA and he said that the link is pointing to old, 10g instances.
He dropped the link and recreated it again, just as above, and everything is ok now.
If tns_entry was ok (it was updated with new ips and service names, for the 11g dbs), why was db link pointing to old database? Obviously we solved the issue so this question is not a priority, but I would like to know why this was happening. Also, how did the DBA know where excatly is db link pointing?
br,
Vatro