Home » SQL & PL/SQL » SQL & PL/SQL » Failure to create database link
Failure to create database link [message #18953] Fri, 22 February 2002 11:11 Go to next message
Murali Sai M
Messages: 4
Registered: February 2002
Junior Member
Hi,
I have tried creating a database link in ORACLE 8i from one db to other db (remote). When I tried to select a remote object with the link name it says TNS could not resolve service name. When I create a db link from the same db to the same db it is working fine. why is it so ?. I am able to connect to the two different databases. I have the services defined in my tnsnames.ora I have services for both the dbs defined. I tried from enterprise manager also. but it is giving the same problem.Is it because the databases are not installed using distributed options. I understand some people are pulling data from these databases.

Urgent solution required. Pl post your replies to my mail id
email : m_muralisai@yahoo.com
m_muralisaie@hotmail.com
Re: Failure to create database link [message #18954 is a reply to message #18953] Fri, 22 February 2002 11:32 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
what is global_names parameter setting in remote database?
Previous Topic: I got two errors when I start the PL/SQL plus for the first time.
Next Topic: A question about NUMBER datatype
Goto Forum:
  


Current Time: Fri Sep 24 03:10:34 CDT 2021