Database Link Problem in 9i

[zeenat khan]

I have created a database link from one database to another (for instance,
DB link from DB1 to DB2 and then from DB2 to DB1). This is in Oracle 9i. I am able to access data from DB1 to DB2. But when I try from DB2 to DB1, I am getting the error "ORA-12505: TNS Could not resolve SID given in connect descriptor."

I have checked the tnsnames.ora in the system and entries according to documentation.

[ahmadbilal]

The ORA-12505 error simply means that the ORACLE_SID in your TNS alias does not match with ORACLE_SID defined for the database listener.
You will have to make sure your TNS alias matches the one defined in the listener's LISTENER.ORA configuration file.

I have created a database link from one database to another (for instance,
DB link from DB1 to DB2 and then from DB2 to DB1). This is in Oracle 9i. I am able to access data from DB1 to DB2. But when I try from DB2 to DB1, I am getting the error "ORA-12505: TNS Could not resolve SID given in connect descriptor."

I have checked the tnsnames.ora in the system and entries according to documentation.

<i><div align="right">Originally posted by zeenat khan - 10/05/2007 : 10:54:43 PM</div id="right"></i>

[2jliu]

and others clinet also too? maybe focus your server