From ivo.libal@knapp-systems.com Thu, 17 May 2001 07:41:09 -0700
From: "Libal, Ivo" <ivo.libal@knapp-systems.com>
Date: Thu, 17 May 2001 07:41:09 -0700
Subject: RE: ??? strange database link problem
Message-ID: <F001.00306254.20010517064125@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain
Title: RE: ??? strange database link problem



<FONT face=Arial color=#0000ff 
size=2>Check
<FONT 
face=Arial color=#0000ff size=2>NAMES.DEFAULT_DOMAIN in 
sqlnet.ora
<FONT face=Arial color=#0000ff 
size=2>Regards
Ivo 
Libal
<FONT face=Arial color=#0000ff 
size=2> 

  <FONT face=Tahoma 
  size=2>-----Original Message-----From: Adams, Matthew (GEA, 088130) 
  [mailto:MATT.ADAMS@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@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@yahoo.com">mailto:andreaoracle@yahoo.com] 
  > Sent: Wednesday, May 16, 2001 11:30 PM <FONT 
  size=2>> To: Multiple recipients of list ORACLE-L <FONT 
  size=2>> Subject: ??? strange database link problem <FONT 
  size=2>> > > Hi 
  all, > > I tried to 
  create a database link like this: > 
  > create database link test connect icssowner 
  identified > by icssowner using 'AU40CNV'; 
  > > when I used it, I 
  got: > ERROR at line 1: <FONT 
  size=2>> ORA-02085: database link TEST.WORLD connects to <FONT 
  size=2>> AU34TD.WORLD > <FONT 
  size=2>> I created other links to AU40CNV, but I got that err 
  > again, the link ALWAYS goes to AU34TD.WORLD!!! 
  why? > > Thanks 
  > > Andrea <FONT 
  size=2>> > 
  __________________________________________________ <FONT 
  size=2>> Do You Yahoo!? > Yahoo! Auctions - buy 
  the things you want at great prices > <A 
  target=_blank 
  href="http://auctions.yahoo.com/">http://auctions.yahoo.com/ 
  > -- > Please see the official 
  ORACLE-L FAQ: <A target=_blank 
  href="http://www.orafaq.com">http://www.orafaq.com <FONT 
  size=2>> -- > Author: Andrea Oracle 
  >   INET: andreaoracle@yahoo.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@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). >