Re: database link

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 23 Mar 1999 07:14:58 +0100
Message-ID: <36F73162.AC72BC53@sybrandb.demon.nl>

remotedb should be in the tnsnames.ora on the SERVER. Made that mistake myself a few years ago, took me weeks to isolate it.

Hth,

Sybrand Bakker, Oracle DBA

Ong Chin Hui wrote:

> Hi, I am trying to access a remote database using database link
> but I keep encountering hitting some error messages. I will be glad if
> someone could point out my mistakes or how to troubleshoot them.
>
> What I did:
>
> SQL> create database link dlink using 'billusr01/billusr01_at_remotedb';
>
> note: remotedb the SID of the remote database.
>
> SQL> describe user_tables_at_dlink;
> ERROR:
> ORA-12154: TNS:could not resolve service name

Received on Tue Mar 23 1999 - 00:14:58 CST