Re: ORA-2085

I think that this is one of the few Oracle error messages where the suggested "action" truly represents the solution. Far more helpful than "Contact your Oracle Representative"... :-)

This might be a long shot, however...

        SQL> create synonym "dual_at_DONOT_TRIGGER.WORLD" for sys.dual;

        Synonym created.

        SQL> select count(*) from "dual_at_DONOT_TRIGGER.WORLD";

          COUNT(*)
        ----------
                 1

        SQL> select count(*) from dual_at_DONOT_TRIGGER.WORLD;
        select count(*) from dual_at_DONOT_TRIGGER.WORLD
                              *
        ERROR at line 1:
        ORA-02019: connection description for remote database not found

Naturally, you would not make the synonym reference SYS.DUAL, but DUAL@<db-name> instead, to avoid the ORA-02085 error and keep GLOBAL_NAMES enabled...

Of course, this might mean changes to the application if you have to add quotation marks around each reference to a table or view, which is what I imagine you are trying to avoid. However, you might be in luck if this application is accessing Oracle via Oracle's own ODBC drivers. By a stroke of luck, the Oracle ODBC drivers (downloadable from "otn.oracle.com") tend to wrap the names of all objects within quotation marks, at least in my limited experience...

Hey, it might be worth a look-see. Sometimes you just get lucky...

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

> 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: Tim Gorman
  INET: Tim_at_SageLogix.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).