Re: ORA-2085

I'd never have thought that this was possible in Advanced Replication

Hemant K Chitale

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, 23 May, 2002 12:48 AM

> At last something that I have experience in.
>
> Just do the following:
>
> On the target database issue the following:
> Alter database rename global_name to donot_trigger;
>
> We had the same problem. This solves it.
> The global name has no other influence.
>
> Yechiel Adar
> Mehish
> ----- Original Message -----
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Sent: Tuesday, May 21, 2002 6:08 PM
>
>
> > Yes, I "inherited" this, and I am setting up Multimaster
> > Advanced Replication, setting global_names=false isn't an
> > option. I have suggested moving the donotfiretrigger logic
> > into the trigger, which has some initial support. For the
> > moment, we are changing the code to point to a link with the
> > same name as the service name (which has obvious limitations,
> > so hopefully a real fix will get done).
> >
> > I was really hoping there might be another workaround bandaid
> > though, as I really don't want the "fix" to end up permanent.
> >
> > Thanks,
> >
> > John P Weatherman
> > Database Administrator
> > Replacements Ltd.
> >
> >
> >
> > -----Original Message-----
> > Sent: Tuesday, May 21, 2002 11:23 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > My guess is that you "inherited" an environment
> > where the DB-Link was setup that way [link-name different
> > from DB-name] ..... and then, sometime later,
> > you set GLOBAL_NAMES=TRUE
> >
> > Well you have no choice :
> > "// *Action: create a database link with the same name as the database
it
> > > // connects to, or set global_names=false."
> >
> > Are you setting up Advanced Replication [MultiMaster]
> > or Simple Replication [Snapshots] ? I believe that
> > Simple Replication does not mandate GLOBAL_NAMES=TRUE.
> >
> >
> > Hemant K Chitale
> >
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > Sent: Tuesday, 21 May, 2002 9:23 PM
> >
> >
> > > Hi all.
> > >
> > > I have recently had to enable global_names in order to set up a
> > > replicated environment. The application uses a database link to
> > > reconnect to the database under a differant user id (I inheirited
> > > this, I had nothing to do with the design!). Appearantly,
> > > global_names has a prblem with this...
> > >
> > > SQL> select * from dual_at_DONOT_TRIGGER.WORLD;
> > > select * from dual_at_DONOT_TRIGGER.WORLD
> > > *
> > > ERROR at line 1:
> > > ORA-02085: database link DONOT_TRIGGER.WORLD connects to DRL2.WORLD
> > >
> > > SQL> !oerr ORA 2085
> > > 02085, 00000, "database link %s connects to %s"
> > > // *Cause: a database link connected to a database with a different
> name.
> > > // The connection is rejected.
> > > // *Action: create a database link with the same name as the database
it
> > > // connects to, or set global_names=false.
> > >
> > > So, does anybody have any work arounds or ideas how I can get this
> > > thing working again?
> > >
> > > TIA,
> > >
> > > John P Weatherman
> > > Database Administrator
> > > Replacements Ltd.
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: John Weatherman
> > > INET: john.weatherman_at_replacements.com
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > San Diego, California -- Public Internet access / Mailing Lists
> > > --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You may
> > > also send the HELP command for other information (like subscribing).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Hemant K Chitale
> > INET: hkchital_at_singnet.com.sg
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: John Weatherman
> > INET: john.weatherman_at_replacements.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Yechiel Adar
> INET: adar76_at_inter.net.il
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hemant K Chitale
  INET: hkchital_at_singnet.com.sg

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).