RE: db link from oracle 8.1.7 to 8.0.5

From: Kimberly Smith <kimberly.smith_at_gmd.fujitsu.com>
Date: Tue, 11 Sep 2001 17:39:27 -0700
Message-ID: <F001.0038A4CF.20010911100028@fatcity.com>

A good
way to test is to just use SQL*Plus from both servers and try and connect to other
<FONT face=Arial color=#0000ff

size=2>database. A lot of times when links won't work its just because the tnsnames.ora file is not
<FONT face=Arial color=#0000ff

size=2>setup. It has to be in the tnsnames.ora file on the server.

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Arslan Dar   [mailto:arslandar_at_skm.org.pk]Sent: Tuesday, September 11, 2001   10:10 AMTo: Multiple recipients of list ORACLE-LSubject:   db link from oracle 8.1.7 to 8.0.5
  hi list,
  i am trying to make a database link from   oracle 8.1.7 to oracle 8.0.5, but
  its failing, giving message "DB
  LINK NOT ACTIVE" global_names
  parameter is false on both the database, <FONT face="Courier New"   size=2>the schema in which its being created exists in both the databases with   same password and privillages, and i am using CONNECTED USER mode of database   link,
  is that possible to create db link in such   conditions, any suggestions,

Thanks in Advance
Arslan Received on Tue Sep 11 2001 - 19:39:27 CDT