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: Oracle replication

Re: Oracle replication

From: Lothar Dickhoff <dickhofl_at_ada.de>
Date: Tue, 2 Mar 1999 11:11:38 -0000
Message-ID: <7bgdd8$ip6$1@news.ecrc.de>


Hi marcus,
the name is bound to Database Instance name if Parameter "global_names = TRUE"
in init<sid>.ora.
If it is set to FALSE you can use different names.

Regs. Lothar

Marcus N Hofer schrieb in Nachricht ...
>This is right.
> if the name of the DB link matches the name of the valid connect string
>(as in this case 'den')
>the DB link will work. But if it does not you get
>
>ORA-02085: database link DEN.WORLD.COM connects to given_connectstring
>
>accessing the link. somehow the name of the DB link seems to be bound to
the
>connect string.
>I know this but I do definitly not understand this :-)
>do You?
>
>regards
>--marcus
>
>
>Lothar Dickhoff schrieb in Nachricht <7b6b1p$si8$1_at_news.ecrc.de>...
>>Just Try:
>>CREATE DATABASE LINK den CONNECT TO scott IDENTIFIED BY tiger using den;
>>
>>should work, if you can connect to den with sqlplus.
>>Regs, Lothar
>>
>>
>>
>>
>>
>>
>
>
Received on Tue Mar 02 1999 - 05:11:38 CST

Original text of this message

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