| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: DB Link Problem
That's for Advanced Replication only.
On Thu, 2002-03-14 at 12:59, Suzy Vordos wrote:
Yep, sorry I didn't clarify. Think I heard once that in 9i global_names must be TRUE, can anyone confirm that?
Scott.Shafer_at_dcpds.cpms.osd.mil wrote:
>
> 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).
--
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: 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 - 13:26:30 CST
 |
 |