Re: GLOBAL_NAME, DBLINKS and Replication

Hi,

I think, replication will work even if you set globale_name to false. However, it's recommanded to set it to true. This will allow unique identification for each database in your replication environment.

Dias

patrice.lenoir_at_eurotunnel.com (Patrice LENOIR) wrote in message news:<28470373.0211190252.7985518d_at_posting.google.com>...
> 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 - 14:39:47 CST