Re: GLOBAL_NAME, DBLINKS and Replication

Hi Matthias and thank you for the answer.

my two database are V8.1.6.
I don't understand very well but i've a dblink named SDGTRD01 on DB1 which is pointing to data on DB2.
what i've understand is that if the global_name is FALSE it works, but as soon as i have it to TRUE it cannot work.

because of the multiple existing db link on DB1, i want in fact be able to use any name for my dblink.

It seems that the replication mechanisme want the GLOBAL_NAME to TRUE for it to be sure that the replication is working fine. But what i understand is that I can go back for this parameter to FALSE.

Patrice

Matthias Rogel <rogel_at_web.de> wrote in message news:<arb03h$guunc$1_at_ID-86071.news.dfncis.de>...
> hi patrice,
>
> in oracle 7.3 replication used to work also with GLOBAL_NAMES=false
> does your oracle has a version ?
>
> but i think it is a better idea to work with global_names=true
> to get db links work, U just have to change the global name of your
> (target-database)
>
> use the
> alter database rename global_name to ...
> statement
>
> matthias
>
> ps.
> i thought, replication thru eurotunnel was easier
> i'll stay on the ferry again next time :-)
>
>
>
> Patrice LENOIR wrote:
> > Hi
> >
> > I'm in front of a problem :
> >
> > I've installed the replication between two database db1 and db2. for
> > that i had to change the GLOBAL_NAME instance parameter from false to
> > true. Since i've change it, all my dblinks which are not created with
> > the same name as the remote database it wants to access are no more
> > working. I understand that because of the global_name parameter but i
> > need to make the replication works.
> >
> > does anyone have experience this problem?, do i really need to have
> > this parameter to true for the replication?
> >
> > Many Thanks
> >
> > patrice
Received on Tue Nov 19 2002 - 04:52:46 CST