RE: DBlink

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Wed, 29 Sep 2004 08:25:04 -0400
Message-ID: <C9995D8C5E0DDA4A8FF9D68EE666CE07A7F8E2@exchsen0a1ma>

Srinivas,

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_at_KPITCummins.com] Sent: Wednesday, September 29, 2004 8:08 AM To: oracle-l_at_freelists.org
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_at_KPIT;
SELECT * FROM EMP_at_KPIT

                  *

ERROR at line 1:
ORA-12154: TNS:could not resolve service name

Help .. and thanks in advance....

Srinivas

--

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

http://www.freelists.org/webpage/oracle-l Received on Wed Sep 29 2004 - 07:20:59 CDT