Message-ID: <F001.004B0189.20020808162823@fatcity.com>
Date: Thu, 08 Aug 2002 16:28:23 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: root@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: Jared.Still@radisys.com
Subject: RE: DB Link Error - More Info
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit

Kevin,

This is a bug in sqlplus.  You are using two different releases Oracle,
and when you are using the 8i version of sqlplus and trying to describe
a table on a lower version of Oracle through a dblink, you will get this 
error.

The work around is:  Don't do that.  Seriously.  It's not fixed, nor will 
it
be fixed.  You can find details on MetaLink.

Jared


Kevin Lange <kgel@ppoone.com>
Sent by: root@fatcity.com
08/08/2002 04:04 PM
Please respond to ORACLE-L

 
        To:     Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
        cc: 
        Subject:        RE: DB Link Error - More Info


Sorry for the lack of info.   Her it all is:
 
  1) I have tns entries on both database machines that point to each 
other.
  2) I have global_names set to false on both machines.
  3) I have the same ID defined with the same password on both machines.
  4) We do not use Oracle Names.
 
On machine A: 
  I created a link :
    create database link b using 'b.world';
 
On machine B:
  I created a link :
    create database link a using 'a.world';
 
Here are the results:
 
  1. I can select data back and fourth between both machines wit no 
errors.
  2. When I try to describe a table accross the link I get the ORA-0219 
error.
  3. When I try to use the plsql copy command (ultimately what I want to 
do) , on machine B, I get an error stating that I am trying to Fetch out 
of sequence.   On machine A I get an unknow error that can not be 
interpreted ....  a long string of numbers as the error number.
 
 
So, thats it.    Currently I am resorting to small selects accross the 
working part of the links.  But, eventually I need to get to the copy 
commands because they have the commits in them.
 
Any help is greatly appreciated.
 
Kevin
-----Original Message-----
Sent: Thursday, August 08, 2002 5:29 PM
To: Multiple recipients of list ORACLE-L

1)    are you using global_names = true?  do the link names match the 
global names?
 
2)    is there a local tns entry on the machine with database A that 
points to database B?  we had a problem like then that was traced to our 
using Oracle Names without local tns files.
 
-bill
-----Original Message-----
Sent: Thursday, August 08, 2002 6:05 PM
To: Multiple recipients of list ORACLE-L

Does anyone know the most common reasons why a DB LINK would give me the 
following error :
 
ORA-02019: connection description for remote database not found
 
Both databases exist ....   And even though I get this error going from 
Database A to Database B, the link I have between Database B and Database 
A works fine.
 
Kevin


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Jared.Still@radisys.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).