Oracle-L: Re: DB Link Problem

From: Rodd Holman <roddholman_at_HotPOP.com>
Date: Thu, 14 Mar 2002 06:33:24 -0800
Message-ID: <F001.00429180.20020314063324@fatcity.com>

In your init<SID>.ora file add the following:

global_names = FALSE

Then it won't care. All it will want at that point is to have a correct and working tnsnames.ora entry in the USING clause of the dblink create statement.

Rodd

On Thu, 2002-03-14 at 07:03, Denham Eva wrote:

Hello List,

    Have a problem,
    Oracle 817
    Win3K sp6
    Trying to create a DB link between the production and the test dbs.

The db_link creates fine ( so it appears). However when you try to run a script to reference the other, I get

select count(*) from workorder_at_maxie

ERROR at line 1:
ORA-02085: database link MAXIE connects to MAXTEST.TFMC.CO.ZA

    I checked out the manual, but it seems as thou I have created the     link
    correctly.
    I also checked out metalink, which suggested changing the     global_name with
    ALTER DATABASE RENAME global_name TO MAXTEST     But this causes the following error:     ORA-02019: connection description for remote database not found.

Has anyone got any ideas? Is this a bug?

TIA
Denham

This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Rodd Holman
INET: roddholman_at_HotPOP.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). Received on Thu Mar 14 2002 - 08:33:24 CST