RE: DB Link Error - More Info
Kevin,
I've seen this problem when the global_name and db_domain don't match. I've
been able to solve it one of two ways:
1. Create another db link, this one with using the domain instead of
.WORLD, i.e. create database link a.dallashq using Don't drop the
original link otherwise selects won't work.
2. Change the global_name, i.e.
alter database rename global_name to GETDATAP.DALLASHQ
HTH,
Gary
-Original Message-
Sent: Friday, August 09, 2002 6:48 PM
To: Multiple recipients of list ORACLE-L
I thought of those myself
On DB A:
GLOBAL_NAME = GETDATAP.WORLD
DB_DOMAIN = DALLASHQ
On DB B:
GLOBAL_NAME = NXTP.WORLD
DB_DOMAIN = DALLASHQ
-Original Message-
Sent: Friday, August 09, 2002 4:39 PM
To: Multiple recipients of list ORACLE-L
Kevin,
I might have a solution. On each machine, can you tell me what you get when
you do the following:
select * from global_name;
show parameter db_domain
Gary
Gary Kirsh
Next Extent Consulting
-Original Message-
Sent: Friday, August 09, 2002 5:13 PM
To: Multiple recipients of list ORACLE-L
They both failed. The describe is not the important part. That was just
something I found out.
The thing I really need to have running is the copy.
-Original Message-
Sent: Friday, August 09, 2002 3:43 PM
To: Multiple recipients of list ORACLE-L
What failed, the describe or the copy?
Here's a work-around for the describe bug (I think from Tom on this list.)
Perhaps give it a try and see if the link works at all??
/*
produces output similar to the 'desc' command over a db_link
takes two parameters
1. the table to be described
2. the name of the db_link (with @ sign)
*/
-- t. day 9-25-01
set verify off
select column_name, data_type, data_length from all_tab_COLUMNS2
where table_name = upper('1') order by 1
/
--
From: Kevin Lange[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Friday, August 09, 2002 2:03 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: DB Link Error - More Info
I ran the copy using SQLPLUS from 8.0.5 trying to copy between 2 8.0.5
databases and it still failed.
Any further suggestions Jared ?
-Original Message-
Sent: Friday, August 09, 2002 9:38 AM
To: Multiple recipients of list ORACLE-L
OK. I am using an 8i client here. Let me try and do it thru the 8.0.5
SQLPLUS.
Thanks
-Original Message-
Sent: Thursday, August 08, 2002 6:21 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
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 [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
08/08/2002 04:04 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
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
RE: DB Link Error - More Info
Thanks Jared. Looks like I will have to use some other method besides copy. It would have been good since it had the auto-commit on it. Oh well. -Original Message- Sent: Friday, August 09, 2002 8:18 PM To: Multiple recipients of list ORACLE-L SQL set arraysize 1 SQL set copycommit 1000 SQL copy from kgel/vinotamu@nxtp - insert nxtp.temp_mgh - using - select * from rrs$.temp_mgh Array fetch/bind size is 1. (arraysize is 1) Will commit after every 1000 array binds. (copycommit is 1000) Maximum long size is 80. (long is 80) select * from rrs$.temp_mgh * Error in SELECT statement: ORA-01002: fetch out of sequence Kevin, This appears to be a well known problem. Two entries from MetaLink: SQL*Plus Technical Forum From: Gorm Heilskov 12-Jun-01 19:58 Subject: ORA-01002: fetch out of sequence for Copy statement ORA-01002: fetch out of sequence for Copy statement I receive an ORA-01002 when trying to use the copy statement on an 8.0.4 database on Netware from an 8.1.7 client. The copy statement runs fine on an 8.1.7 database on Windows 2000 using an 8.1.7 client. It also works fine using an 8.0.5 client. What is preventing the copy statement from working? From: Oracle, Anil Shenoy 15-Jun-01 07:32 Subject: Re : ORA-01002: fetch out of sequence for Copy statement Hi, A bug with no 644413 has been filed on this and has been fixed in 8.1.5 and 8.0.6.1. I cannot file a backport request as 8.0.4 is desupported. However you can use the workaround as below 1) Create a Database link from the 8.1.x db to the 8.0.x db using 'CREATE DATABASE' ie: SQL create database link linkName connect to UserId identified by 2) Create a new table using 'CREATE TABLE' ie: SQL create table TableName as select * from RemoteTableName@linkName or 2) Insert data into an existing table using 'INSERT' ie: SQL insert into TableName select * from RemoteTableName@linkName Regards, Anil Oracle Support Services Bookmark Fixed font Go to End Doc ID: Note:110364.1 Subject: Workaround for ORA-1002 on COPY COMMAND from 8.Xto 8.X Type: PROBLEM Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 26-MAY-2000 Last Revision Date: 22-JAN-2002 Problem Description: You are using the COPY command to copy data from one 8.x database to another 8.x database. You receive an ORA-01002 error. ORA-01002: fetch out of sequence Cause: This may be caused by fetching from a 'select for update' cursor after a commit. A PL/SQL cursor loop implicitly does fetches and may also cause this error. You see there are several bugs on the issue but not all of them are included in patchsets or have fixes. In this example you are using COPY from 8.1.6 to 8.0.6: Testcase: SQL select INSTANCE_NAME from v$instance; INSTANCE_NAME V816 SQL select INSTANCE_NAME from v$instance@V806; INSTANCE_NAME V806 SQL copy from [EMAIL PROTECTED] - insert copy2 using select * from copy1; select * from copy1 * Error in SELECT statement: ORA-1002: fetch out of sequence Solution Description: = Use the following Workaround: 1. Create a Database link from the 8.1.x db to the 8.0.x db using 'CREATE DATABASE' SQL create database link linkName connect to UserId identified by @ 'Password' using 'SID'; 2. Create a new table using 'CREATE TABLE' SQL create table TableName as select * from RemoteTableName@linkName - OR - 2. Insert data into an existing table using 'INSERT' SQL insert into TableName select * from RemoteTableName@linkName Example: SQL select INSTANCE_NAME from v$instance@V806; INSTANCE_NAME V806 SQL create table copy806 as select * from copy1@V806; Table created. SQL insert into copy806 select * from copy1@V806; 64 rows created. References: === [BUG:903258] ORA-1002 COPYING FROM A REMOTE DATABASE Search Words: = ORA-1002 SQL*Plus . Copyright (c) 1995,2000 Oracle Corporation. All Rights Reserved. Legal Notices and Terms of Use. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX:
RE: DB Link Error - More Info
Arraysize 1 and copycommit 1000 -Original Message- Sent: Thursday, August 08, 2002 7:03 PM To: Multiple recipients of list ORACLE-L What values are set for SQL*Plus variables arraysize and copycommit? Maybe adjusting those wwould eliminate the fetch out of sequence error. Kevin Lange wrote: 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- From: Magaliff, Bill [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 5:29 PM To: Multiple recipients of list ORACLE-L Subject: RE: DB Link Error 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- From: Kevin Lange [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 6:05 PM To: Multiple recipients of list ORACLE-L Subject: DB Link Error 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: Suzy Vordos INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: DB Link Error - More Info
OK. I am using an 8i client here. Let me try and do it thru the 8.0.5 SQLPLUS. Thanks -Original Message- Sent: Thursday, August 08, 2002 6:21 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] 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 [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/08/2002 04:04 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 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: Kevin Lange INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: DB Link Error - More Info
They are both 8.0.5. -Original Message- Sent: Thursday, August 08, 2002 6:48 PM To: Multiple recipients of list ORACLE-L What version of Oracle are the two databases? There are bugs with desc over db_links (can't remember the details but see it often), and also with copy 'fetch out of sequence' errors between 8.0 and 8i databases. Kevin Lange wrote: 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- From: Magaliff, Bill [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 5:29 PM To: Multiple recipients of list ORACLE-L Subject: RE: DB Link Error 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- From: Kevin Lange [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 6:05 PM To: Multiple recipients of list ORACLE-L Subject: DB Link Error 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: Suzy Vordos INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: DB Link Error - More Info
I ran the copy using SQLPLUS from 8.0.5 trying to copy between 2 8.0.5 databases and it still failed. Any further suggestions Jared ? -Original Message- Sent: Friday, August 09, 2002 9:38 AM To: Multiple recipients of list ORACLE-L OK. I am using an 8i client here. Let me try and do it thru the 8.0.5 SQLPLUS. Thanks -Original Message- Sent: Thursday, August 08, 2002 6:21 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] 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 [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/08/2002 04:04 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 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: Kevin Lange INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: DB Link Error - More Info
What failed, the describe or the copy?
Here's a work-around for the describe bug (I think from Tom on this list.)
Perhaps give it a try and see if the link works at all??
/*
produces output similar to the 'desc' command over a db_link
takes two parameters
1. the table to be described
2. the name of the db_link (with @ sign)
*/
-- t. day 9-25-01
set verify off
select column_name, data_type, data_length from all_tab_COLUMNS2
where table_name = upper('1') order by 1
/
--
From: Kevin Lange[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Friday, August 09, 2002 2:03 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: DB Link Error - More Info
I ran the copy using SQLPLUS from 8.0.5 trying to copy between 2 8.0.5
databases and it still failed.
Any further suggestions Jared ?
-Original Message-
Sent: Friday, August 09, 2002 9:38 AM
To: Multiple recipients of list ORACLE-L
OK. I am using an 8i client here. Let me try and do it thru the 8.0.5
SQLPLUS.
Thanks
-Original Message-
Sent: Thursday, August 08, 2002 6:21 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
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 [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
08/08/2002 04:04 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
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: Kevin Lange
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Lange
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (note EXACT spelling
RE: DB Link Error - More Info
They both failed. The describe is not the important part. That was just
something I found out.
The thing I really need to have running is the copy.
-Original Message-
Sent: Friday, August 09, 2002 3:43 PM
To: Multiple recipients of list ORACLE-L
What failed, the describe or the copy?
Here's a work-around for the describe bug (I think from Tom on this list.)
Perhaps give it a try and see if the link works at all??
/*
produces output similar to the 'desc' command over a db_link
takes two parameters
1. the table to be described
2. the name of the db_link (with @ sign)
*/
-- t. day 9-25-01
set verify off
select column_name, data_type, data_length from all_tab_COLUMNS2
where table_name = upper('1') order by 1
/
--
From: Kevin Lange[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Friday, August 09, 2002 2:03 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: DB Link Error - More Info
I ran the copy using SQLPLUS from 8.0.5 trying to copy between 2 8.0.5
databases and it still failed.
Any further suggestions Jared ?
-Original Message-
Sent: Friday, August 09, 2002 9:38 AM
To: Multiple recipients of list ORACLE-L
OK. I am using an 8i client here. Let me try and do it thru the 8.0.5
SQLPLUS.
Thanks
-Original Message-
Sent: Thursday, August 08, 2002 6:21 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
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 [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
08/08/2002 04:04 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
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: Kevin Lange
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Lange
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538
RE: DB Link Error - More Info
Kevin, This part just now caught my eye: 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. The COPY command is a SQLPLUS command, not PL/SQL. Can you post the actual PL./SQL code, or a simplified example if it is complex? Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: DB Link Error - More Info
Kevin,
I might have a solution. On each machine, can you tell me what you get when
you do the following:
select * from global_name;
show parameter db_domain
Gary
Gary Kirsh
Next Extent Consulting
-Original Message-
Sent: Friday, August 09, 2002 5:13 PM
To: Multiple recipients of list ORACLE-L
They both failed. The describe is not the important part. That was just
something I found out.
The thing I really need to have running is the copy.
-Original Message-
Sent: Friday, August 09, 2002 3:43 PM
To: Multiple recipients of list ORACLE-L
What failed, the describe or the copy?
Here's a work-around for the describe bug (I think from Tom on this list.)
Perhaps give it a try and see if the link works at all??
/*
produces output similar to the 'desc' command over a db_link
takes two parameters
1. the table to be described
2. the name of the db_link (with @ sign)
*/
-- t. day 9-25-01
set verify off
select column_name, data_type, data_length from all_tab_COLUMNS2
where table_name = upper('1') order by 1
/
--
From: Kevin Lange[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Friday, August 09, 2002 2:03 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: DB Link Error - More Info
I ran the copy using SQLPLUS from 8.0.5 trying to copy between 2 8.0.5
databases and it still failed.
Any further suggestions Jared ?
-Original Message-
Sent: Friday, August 09, 2002 9:38 AM
To: Multiple recipients of list ORACLE-L
OK. I am using an 8i client here. Let me try and do it thru the 8.0.5
SQLPLUS.
Thanks
-Original Message-
Sent: Thursday, August 08, 2002 6:21 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
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 [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
08/08/2002 04:04 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
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: Kevin Lange
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name
RE: DB Link Error - More Info
Here is a copy of the SQlPLUS command used: SQL set arraysize 1 SQL set copycommit 1000 SQL copy from kgel/vinotamu@nxtp - insert nxtp.temp_mgh - using - select * from rrs$.temp_mgh Array fetch/bind size is 1. (arraysize is 1) Will commit after every 1000 array binds. (copycommit is 1000) Maximum long size is 80. (long is 80) select * from rrs$.temp_mgh * Error in SELECT statement: ORA-01002: fetch out of sequence The table on the remote system is owned by RRS$ where the table I want to copy it to is owned by NXTP. The table structure is : SQL describe temp_mgh Name Null?Type - CALC_SCHED_ID VARCHAR2(6) CALC_SCHED_TYPEVARCHAR2(15) SELECT_DATEDATE -Original Message- Sent: Friday, August 09, 2002 3:32 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Importance: High Kevin, This part just now caught my eye: 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. The COPY command is a SQLPLUS command, not PL/SQL. Can you post the actual PL./SQL code, or a simplified example if it is complex? Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: DB Link Error - More Info
I thought of those myself
On DB A:
GLOBAL_NAME = GETDATAP.WORLD
DB_DOMAIN = DALLASHQ
On DB B:
GLOBAL_NAME = NXTP.WORLD
DB_DOMAIN = DALLASHQ
-Original Message-
Sent: Friday, August 09, 2002 4:39 PM
To: Multiple recipients of list ORACLE-L
Kevin,
I might have a solution. On each machine, can you tell me what you get when
you do the following:
select * from global_name;
show parameter db_domain
Gary
Gary Kirsh
Next Extent Consulting
-Original Message-
Sent: Friday, August 09, 2002 5:13 PM
To: Multiple recipients of list ORACLE-L
They both failed. The describe is not the important part. That was just
something I found out.
The thing I really need to have running is the copy.
-Original Message-
Sent: Friday, August 09, 2002 3:43 PM
To: Multiple recipients of list ORACLE-L
What failed, the describe or the copy?
Here's a work-around for the describe bug (I think from Tom on this list.)
Perhaps give it a try and see if the link works at all??
/*
produces output similar to the 'desc' command over a db_link
takes two parameters
1. the table to be described
2. the name of the db_link (with @ sign)
*/
-- t. day 9-25-01
set verify off
select column_name, data_type, data_length from all_tab_COLUMNS2
where table_name = upper('1') order by 1
/
--
From: Kevin Lange[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Friday, August 09, 2002 2:03 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: DB Link Error - More Info
I ran the copy using SQLPLUS from 8.0.5 trying to copy between 2 8.0.5
databases and it still failed.
Any further suggestions Jared ?
-Original Message-
Sent: Friday, August 09, 2002 9:38 AM
To: Multiple recipients of list ORACLE-L
OK. I am using an 8i client here. Let me try and do it thru the 8.0.5
SQLPLUS.
Thanks
-Original Message-
Sent: Thursday, August 08, 2002 6:21 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
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 [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
08/08/2002 04:04 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
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: Kevin Lange
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
RE: DB Link Error
Kevin - You might be specifying a database link that doesn't exist. The connection string in the database link might be incorrect. The database link might be owned by a different user and not be public. Do you receive this message consistently every time you attempt to use the link, or is it intermittent? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, August 08, 2002 5: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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: DB Link Error - More Info
Title: RE: missed Anjo's webcast.. 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 linkb 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-From: Magaliff, Bill [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 08, 2002 5:29 PMTo: Multiple recipients of list ORACLE-LSubject: RE: DB Link Error 1) are you using global_names = true? do the link namesmatch 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-From: Kevin Lange [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 08, 2002 6:05 PMTo: Multiple recipients of list ORACLE-LSubject: DB Link Error 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
Re: DB Link Error - More Info
What version of Oracle are the two databases? There are bugs with desc over db_links (can't remember the details but see it often), and also with copy 'fetch out of sequence' errors between 8.0 and 8i databases. Kevin Lange wrote: 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- From: Magaliff, Bill [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 5:29 PM To: Multiple recipients of list ORACLE-L Subject: RE: DB Link Error 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- From: Kevin Lange [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 6:05 PM To: Multiple recipients of list ORACLE-L Subject: DB Link Error 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: Suzy Vordos INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: DB Link Error - More Info
What values are set for SQL*Plus variables arraysize and copycommit? Maybe adjusting those wwould eliminate the fetch out of sequence error. Kevin Lange wrote: 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- From: Magaliff, Bill [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 5:29 PM To: Multiple recipients of list ORACLE-L Subject: RE: DB Link Error 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- From: Kevin Lange [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 6:05 PM To: Multiple recipients of list ORACLE-L Subject: DB Link Error 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: Suzy Vordos INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: DB Link Error - More Info
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 [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/08/2002 04:04 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
