Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Database Link question

Re: Database Link question

From: Sean McMurray <smcmurr_at_xmission.com>
Date: Fri, 07 May 1999 16:44:01 -0700
Message-ID: <37337AC1.8AE72AC0@xmission.com>

>>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.

Dante wrote:

> 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

Also remember that the name of the DB link must match the name of the database being referenced. This can be affected by GLOBAL NAMES usage, etc. but it's important to take into account.

>

> >
> > 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 - 18:44:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US