Oracle-L: RE: DB Link Error

From: Kirsh, Gary <gary.kirsh_at_gs.com>
Date: Tue, 13 Aug 2002 11:29:03 -0800
Message-ID: <F001.004B3760.20020813112903@fatcity.com>

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:

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.
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

the table to be described
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:kgel_at_ppoone.com]
> Reply To: 	ORACLE-L_at_fatcity.com
> 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: ORACLE-L_at_fatcity.com
> Cc: kgel_at_ppoone.com
> 
> 
> 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_at_ppoone.com>
> Sent by: root_at_fatcity.com
> 08/08/2002 04:04 PM
> Please respond to ORACLE-L
> 
>  
>         To:     Multiple recipients of list ORACLE-L
> <ORACLE-L_at_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: Kevin Lange
>   INET: kgel_at_ppoone.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).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Kevin Lange
>   INET: kgel_at_ppoone.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).
>

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Baker, Barbara
INET: bbaker_at_denvernewspaperagency.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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Kevin Lange
INET: kgel_at_ppoone.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------