Re: Database link

From: Nikunj Gupta <good_dba_at_hotmail.com>
Date: Mon, 10 Dec 2001 21:59:48 -0800
Message-ID: <F001.003D9886.20011210215019@fatcity.com>

Check for DB_DOMAIN..  in
INIT.ORA
else
Set <FONT face="Times New Roman"
size=3>GLOBAL_NAMES to FALSE
ALTER SYSTEM SET GLOBAL_NAMES=FALSE;
HTH
 
 

------------------------------------Make a FREE long distance call from 

your PC!<A
href="http://www.eboom.com/free/">http://www.eboom.com/free/ <BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

• Original Message -----
  <DIV
  style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From:
  <A title=wiwaniec_at_novalistech.com
  href="mailto:wiwaniec_at_novalistech.com">Witold Iwaniec To: <A title=ORACLE-L_at_fatcity.com href="mailto:ORACLE-L_at_fatcity.com">Multiple recipients of list ORACLE-L

  Sent: Monday, December 10, 2001 11:00   AM
  Subject: Database link   

  Hi
  DBAs   

  I have a
  problem with database links in one of the databases - the name of the link   gets us.oracle.com appended to it.   

<SPAN

  style="FONT-SIZE: 10pt">create<SPAN 
  style="FONT-SIZE: 10pt"> <SPAN 
  style="FONT-SIZE: 10pt">database<SPAN 
  style="FONT-SIZE: 10pt"> <SPAN 
  style="FONT-SIZE: 10pt">link<SPAN 
  style="FONT-SIZE: 10pt"> test 

<SPAN

  style="FONT-SIZE: 10pt">connect<SPAN 
  style="FONT-SIZE: 10pt"> <SPAN 
  style="FONT-SIZE: 10pt">to<SPAN 
  style="FONT-SIZE: 10pt"> test_user <FONT face=Arial 
  color=#0000f0>identified<FONT 

  face=Arial> <FONT face=Arial
  color=#0000f0>by<FONT
  face=Arial> test_pwd using <FONT
  face=Arial color=#ff0000><SPAN
  style="FONT-SIZE: 10pt">'test_db'   

  When I
  execute:   

  select * from
  my_table_at_test   

  I get the
  ORA-02085 error message the the link test.us.oracle.com connects to   test.   

  When I
  execute:
  select * from
  global_name;   

  in the target
  database the result is:   

<SPAN

  style="FONT-SIZE: 10pt">TEST   

  but in the
  database where I created the link the database name has the   suffix:   

<SPAN

  style="FONT-SIZE: 10pt">NOVALIS.US.ORACLE.COM   

  I have no
  problem with database links in the TEST database but would like to know which   parameter causes the suffix to be appended in the NOVALIS   database.   

  In both
  init.ora files the global_names is set to true and db_domain is commented out.   

  In both
  databases the command
  show
  parameters;   

  returns the
  db_domain as blank.   

  Actually both
  databases are on the same server - Oracle 8.1.6.   

  What should I
  change to remove the US.ORACLE.COM suffix. I don't care too much about the   database, it's my test only, but don't want it appended in the links and maybe   other objects...   

<SPAN

  style="FONT-SIZE: 10pt">Thanks   

<SPAN

  style="FONT-SIZE: 10pt">Witold
<SPAN

  style="FONT-SIZE: 10pt">==================================

  Witold
  Iwaniec
  Sr Software
  Developer
  NovaLIS
  Technologies
<SPAN

  style="FONT-SIZE: 10pt">wiwaniec_at_novalistech.com
<SPAN

  style="FONT-SIZE: 10pt">http://www.novalistech.com

• Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Witold Iwaniec INET: wiwaniec@novalistech.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 Mon Dec 10 2001 - 23:59:48 CST