RE: DB Link Problem

Funny, I have 35 sites working with global_names=FALSE doing snapshot replication (7.3.4 and 8.1.7 sites), without specifying the domain name at link creation time. Are you refering to advanced replication/multi-master replication only?

Scott Shafer
San Antonio, TX
210-581-6217

"Common sense will not accomplish great things. Simply become insane and desperate."

> -----Original Message-----
> From: Suzy Vordos [SMTP:lvordos_at_qwest.com]
> Sent: Thursday, March 14, 2002 9:59 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: DB Link Problem
>
>
> If using Replication, init.ora must have global_names=TRUE. So in that
> case you'd either want to execute 'alter session set global_names=FALSE'
> at connect time, or create the database link as 'create database link
> maxtest.tfmc.co.za ...'.
>
> > Rodd Holman wrote:
> >
> > 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: Suzy Vordos
> INET: lvordos_at_qwest.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: 
  INET: Scott.Shafer_at_dcpds.cpms.osd.mil

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