database link issue

[maswien]

I created database link in a oracle 10g database to connect to a oracle 9i database, when I access the tables from these link, it keeps giving me the error like :

ORA-12154: TNS:could not resolve the connect identifier specified


Any idea?

 

[maswien]

The same create database link SQL statement works in the 9i database, I mean I can query the link created with the same statement in a 9i database, but not in a 10g database.

 

[johnherman]

Make sure the names in the TNSNAMES file are consistent with those in the link script where the link is created.

-------------------------
The trouble with doing something right the first time is that nobody appreciates how difficult it was - Steven Wright

 

[maswien]

I checked the tnsnames.ora and listener.ora, I started 10g listener using lsnrctl, I run command 'status' then I got list of databases, I found this list is not stable, at beginning one or two 9i database are missing, then after while I run status I can see they appear! then the database link works!

Why that happen?

 

[dbtoo2001]

Probably dynamic service registration

http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10743/dist_pro.htm