Re: Can you create a database link back to same database instance?
If DB2 and DB2 are in two different ORACLE_HOMEs check the sqlnet.ora files as well (ie, besides the tnsnames.ora files). Also confirm that the tnsnames lookup for the "self" database (DB2) works -- by doing a sqlplus arcdb/arc_db@DB2 when in the same ORACLE_HOME as DB2. 

Hemant K Chitale

At 06:13 PM Tuesday, Romeo Ybanez wrote:


Hi,
I have this application that archives data to a different schema on the same instance using database link. This is probably due to the fact that in the Production environment it is archived to a different instance. Two schemas are using database links to connect to themselves. One successfully connects using the same service name to itself but the other does not. I am wondering what the trick the schema has while the other one can't connect. 




Hemant K Chitale
http://hemantoracledba.blogspot.com


--
http://www.freelists.org/webpage/oracle-l

Other related posts: