Home » RDBMS Server » Networking and Gateways » Create database link
Create database link [message #112081] Tue, 22 March 2005 19:02 Go to next message
cq4oracle
Messages: 1
Registered: March 2005
Location: San Jose
Junior Member
Hi,

I have a question in creating database link and accessing data from other database. I created a link

create database link dblink connect to scott identified by tiger
using 'test';

and when tried to access the data

select count(*) from emp@dblink

it gives me
ORA-12154: TNS:could not resolve service name

but, when i connect the same user with like this
sqlplus scott/tiger@test it works fine.


Can anyone tell me what the problem is?

Thanks,
Srilatha

Report message to a moderator

Re: Create database link [message #112119 is a reply to message #112081] Wed, 23 March 2005 02:28 Go to previous message
easywebtech123
Messages: 22
Registered: March 2005
Location: c
Junior Member
You did not mention that , both databases are in the same computer or not.

If your databases are in two different computers this error can occur due to tnames.ora/sqlnet.ora configuration.

More troubleshooting details

http://www.easywebtech.com/oracle/con_err.html

Report message to a moderator

Previous Topic: error when trying to configure enterprise manager-no listener
Next Topic: ORA-03113: end of file on communication channel
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 22 03:31:31 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.