RE: ORA-2085

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