Re: ORA-2085

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