Re: ORA-2085

Been there, Done that, Works in production.

Yechiel Adar
Mehish
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Thursday, May 23, 2002 3:33 PM

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

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