# Global Naming -- enforce that a dblink has same
name as the db it connects toglobal_names = true
Your problem is this.
make it to false or obey the rules.
<BLOCKQUOTE dir=ltr
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
- Original Message -----
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From:
<A href="mailto:ivo.libal_at_knapp-systems.com"
title=ivo.libal_at_knapp-systems.com>Libal, Ivo
To: <A href="mailto:ORACLE-L_at_fatcity.com"
title=ORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L
Sent: Thursday, May 17, 2001 5:41
PM
Subject: RE: ??? strange database link
problem
<FONT color=#0000ff face=Arial
size=2>Check
<SPAN
class=629023913-17052001><FONT color=#0000ff face=Arial
size=2>NAMES.DEFAULT_DOMAIN in sqlnet.ora
<FONT color=#0000ff face=Arial
size=2>Regards
Ivo
Libal
<FONT color=#0000ff face=Arial
size=2>
<FONT face=Tahoma
size=2>-----Original Message-----From: Adams, Matthew (GEA,
088130) [<A
href="mailto:MATT.ADAMS_at_APPL.GE.COM">mailto:MATT.ADAMS_at_APPL.GE.COM]Sent:
Thursday, May 17, 2001 03:55 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: ??? strange database link
problem
Check out the global_name init.ora parameter.
It is probably set to true, which forces the name of the
database link to be the same as the alias.
- R. Matt Adams - GE
Appliances - matt.adams_at_appl.ge.com Meddle
not in the affairs of troff, for it is subtle
and quick to anger.
> -----Original Message----- >
From: Andrea Oracle [<A
href="mailto:andreaoracle_at_yahoo.com">mailto:andreaoracle_at_yahoo.com]
> Sent: Wednesday, May 16, 2001 11:30 PM
> To: Multiple recipients of list ORACLE-L
> Subject: ??? strange database link problem
> > <FONT
size=2>> Hi all, > <FONT
size=2>> I tried to create a database link like this: <FONT
size=2>> > create database link test connect
icssowner identified > by icssowner using
'AU40CNV'; > > when I
used it, I got: > ERROR at line 1:
> ORA-02085: database link TEST.WORLD connects to
> AU34TD.WORLD >
> I created other links to AU40CNV, but I got
that err > again, the link ALWAYS goes to
AU34TD.WORLD!!! why? > <FONT
size=2>> Thanks > >
Andrea > >
__________________________________________________ <FONT
size=2>> Do You Yahoo!? > Yahoo! Auctions -
buy the things you want at great prices > <A
href="http://auctions.yahoo.com/"
target=_blank>http://auctions.yahoo.com/ > --
> Please see the official ORACLE-L FAQ: <A
href="http://www.orafaq.com" target=_blank>http://www.orafaq.com
> -- > Author: Andrea
Oracle > INET:
andreaoracle_at_yahoo.com > <FONT
size=2>> 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 <FONT
size=2>> (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 May 17 2001 - 10:21:55 CDT