Database link
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@remotedb';
note: remotedb the SID of the remote database.
SQL> describe user_tables@dlink;
ERROR:
ORA-12154: TNS:could not resolve service name
Ans1:
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
Ans2:
Try
create database link dlink connect to billusr01 identified by billusr01
using 'remotedb';
And make sure you have configured tnsnames.ora properly to
include service name 'remotedb' which points to your remote
database.
Hth
bjin