Re: Database Link question

From: Dante <dnotari_at_my-dejanews.com>
Date: Fri, 07 May 1999 15:15:05 GMT
Message-ID: <7gv01k$bqj$1@nnrp1.deja.com>

Josef,
It is
CREATE PUBLIC DATABASE LINK <link>

        <CONNECT TO <user> IDENTIFIED BY <password>>
        USING <connectstring>;

But I assume you know that anyway ... do you have the TNSNAMES entries on the servers as well ?

Don't forget ... the server has to resolve the TNS entry not the client !

Regards
Dante
In article <01be988d$9c893140$95884f8b_at_rac17217.hasler.ascom.ch>, "Buergi Josef" <josef.buergi_at_ascom.ch> wrote:
> Hello
>
> I have two servers (same Network, Unix, each runs ORACLE V7, SQLNet V2) and
> want to set up a DB-link.
>
> Server one is called OBELIX
> ----------------------------------------
>
> part of tnsnames.ors:
>
> V734MTS=(description=
> (address=
> (community=tcpcom)
> (protocol=tcp)
> (host=obelix)
> (port=1521)
> )
> (connect_data=
> (sid=V734MTS)
> )
> )
>
> Server two is called IDEFIX
> ---------------------------------------
>
> part of tnsnames.ors:
>
> V716MTS=(description=
> (address=
> (community=tcpcom)
> (protocol=tcp)
> (host=idefix)
> (port=1521)
> )
> (connect_data=
> (sid=V716MTS)
> )
> )
>
> Each DB is running properly. Ich can do sqlplus scott/tiger_at_v716mts from
> obelix or sqlplus scott/tiger_at_v734mts from idefix.
>
> But .....
>
> I tried more than two hours to make a db link, but it does not work.
>
> Can anybody please give me the CREATE PUBLIC DATABASE LINK command ? Any
> help is
> really welcome.
>
> Regards
> josef
>
> josef.buergi_at_ascom.ch
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri May 07 1999 - 10:15:05 CDT