Re: database link

From: <tienlee_at_mailexcite.com>
Date: Thu, 25 Mar 1999 22:17:50 GMT
Message-ID: <7decm5$8vh$1@nnrp1.dejanews.com>

Might want to make sure that your db_link name is the same as your db_name in your init.ora. Also, make sure 'billusr01/billusr01_at_remotedb' is the alias in your tnsname.ora.

Hope this helps.

create database link dlink using 'billusr01/billusr01_at_remotedb'

In article <36f7041f.88346826_at_butler.psa>, chong_at_hq.psa.com.sg 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
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Mar 25 1999 - 16:17:50 CST