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_COLUMNS&&2 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 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: Baker, Barbara 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kirsh, Gary 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).