ERPstuff - Oracle EBS Community

Posted: **Fri May 11, 2007 2:54 am**

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.

Posted: **Fri May 11, 2007 2:58 am**

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>

Posted: **Fri May 11, 2007 9:08 pm**

and others clinet also too? maybe focus your server

ERPstuff - Oracle EBS Community

Database Link Problem in 9i

Database Link Problem in 9i