Check your tnsnames.ora file on the database server where this database
resides. You need to add an entry for the KPIT connection.
Remember, a database becomes a client when it uses a database link - so the
tnsnames.ora file needs to be updated containing entries for all database
links.
Hope this helps.
Tom Mercadante
Oracle Certified Professional
-- --Original Message-- --
From: Srinivas T [mailto:SrinivasT@(protected)]
Sent: Wednesday, September 29, 2004 8:08 AM
To: oracle-l@(protected)
Subject: DBlink
Hi friends,
I am having the following problem while selecting data trhu the dblink
My oracle version is 9.0.2 and I am creating dblink to the database version
8.1.7 ie KPIT.
CREATE PUBLIC DATABASE LINK KPIT CONNECT TO SCOTT IDENTIFIED BY TIGER USING
'KPIT ';
Database link created.
But I am unable to see the remote data......
SQL > SELECT * FROM EMP@(protected);
SELECT * FROM EMP@(protected)
*
ERROR at line 1:
ORA-12154 (See ORA-12154.ora-code.com): TNS:could not resolve service name
