Re: ORA-12154: TNS:could not resolve service name

From: <sybrandb_at_yahoo.com>
Date: 17 Aug 2004 01:21:41 -0700
Message-ID: <a1d154f4.0408162354.1f436db0_at_posting.google.com>


spathiyal_at_yahoo.ca (Sheela) wrote in message news:<678ae5f9.0408160905.7e0aac46_at_posting.google.com>...
> I am trying to access the tables of a remote database(db2) from db1
> database. I am getting the following error: ORA-12154: TNS:could not
> resolve service name
> I tried tnsping the db2 service_name and it is working.
>
>
> I created a dblink like this at db1.
>
>
> CREATE DATABASE LINK db2.oracle.com
> CONNECT TO scott IDENTIFIED BY tiger
> USING 'db2servicename';
>
>
>
> When I will tried to access the db2 database tables from db1, I am
> getting the above error.
>
> sql> select sysdate from dual_at_db2.oracle.com ( from db1)
> ORA-12154: TNS:could not resolve service name
>
> The TNSNAMEs.ora file looks like this.
>
> db2.oracle.com =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 85))
> )
> (CONNECT_DATA =
> (SID = db2)
> (SERVER = DEDICATED)
> (SERVICE_NAME = db2servicename)
>
> Do I need to add anything else in the tnsnames.ora file?

The tnsnames.ora *on the database server* must list the remote database. Database links are from server to server.

Sybrand Bakker
Senior Oracle DBA Received on Tue Aug 17 2004 - 10:21:41 CEST

Original text of this message