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.
Database Link Problem in 9i
-
- Posts: 35
- Joined: Wed Apr 04, 2007 4:15 am
- Location: Pakistan
-
- Posts: 615
- Joined: Mon Sep 18, 2006 1:32 am
- Location: United Arab Emirates
- Contact:
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.
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>
Who is online
Users browsing this forum: No registered users and 8 guests