Folks, Since I recently slammed into this unexpected wall I'll pass along the experience. A couple of weeks ago I upgraded an 8.0.5.2.1 instance to 8.1.7 and subsequently at OTS's request to 8.1.7.4. To make a long story short most things with database links worked OK, but a describe across one did not (ORA-02019). The problem ended up being a small error in Oracle's INIT parameter documentation. Back in 8.0.5.2.1, due to a bug introduced, you needed to have DB_DOMAIN=.WORLD or DB_DOMAIN=.VICR.COM. Note the '.' before the domain. Well in 8.1.7, or sometime before that, they fixed the bug, but forgot about those of us who don't always follow the 'yellow brick road'. So if your having problems with ORA-02019's take a second and check this parameter in your init.ora. I changed mine & the problems went away.
Dick Goulet ____________________Reply Separator____________________ Author: "Ratnesh Kumar Singh" <[EMAIL PROTECTED]> Date: 7/15/2002 11:43 PM Refer to Oracle docs / oracle SQL reference / DROP ....... -----Original Message----- N - Systems Sent: Tuesday, July 16, 2002 12:33 PM To: Multiple recipients of list ORACLE-L HI AMJAD, HOW TO DROP THE DATABASE LINK. ANAND ITW SIGNODE INDIA LIMITED ----- Original Message ----- From: Amjad To: Multiple recipients of list ORACLE-L Sent: Thursday, July 11, 2002 1:43 PM Subject: RE: dblink problem ( ORA-02019 ) CREATE PUBLIC DATABASE LINK dblink CONNECT TO user IDENTIFIED BY password USING 'connect_string' Regards, Amjad. www.medicomsoft.com : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Anand Kumar N - Systems Sent: Thursday, July 11, 2002 9:33 AM To: Multiple recipients of list ORACLE-L Subject: Re: dblink problem ( ORA-02019 ) Hi all, How to Create dblink, can u please explain me. bye Anand ----- Original Message ----- From: Ratnesh Kumar Singh To: Multiple recipients of list ORACLE-L Sent: Wednesday, July 10, 2002 6:23 PM Subject: dblink problem ( ORA-02019 ) hi i have 3 databases(A,B,X) on 3 diff boxes. i have created 1 dblink each from A to X & from B to X. The syntax for dblink creation is exactly same for both dblinks. I am able to query from dblink A-X as "select * from user.table@dblinkAX" but when i try to query from dblink B-X as "select * from user.table@dblinkBX" i get the foll error Error: ORA-02019: connection description for remote database not found When i modify my query by suffixing '.world' as "select * from [EMAIL PROTECTED]" , the query works fine. I have compared the entries in init,sqlnet,tnsnmames,listener files on both A & B databases and they are absolutely similar . i was thinking that the domain or globalnames parameters might be diff on A & B , but they are absolutely same . any suggestions are most welcome ... thanks in advance ratnesh ----------------------------------------------- Ratnesh Kumar Singh Sr. Software Engineer Patni Computer Systems Ltd TTC Mahape , Navi Mumbai Work : (91 22) 7611090/110/128/350 Ext. 2107 Home : (91 22) 8662162 http://www.patni.com World-Wide Partnerships. World-Class Solutions. ----------------------------------------------- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ratnesh Kumar Singh 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). <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=Content-Type content="text/html; charset=iso-8859-1"> <META content="MSHTML 5.50.4807.2300" name=GENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=#ffffff> <DIV><SPAN class=378274406-16072002><FONT face=Arial color=#0000ff size=2>Refer to Oracle docs / oracle SQL reference / DROP .......</FONT></SPAN></DIV> <DIV><SPAN class=378274406-16072002><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]<B>On Behalf Of </B>Anand Kumar N - Systems<BR><B>Sent:</B> Tuesday, July 16, 2002 12:33 PM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> Re: dblink problem ( ORA-02019 )<BR><BR></FONT></DIV> <DIV><FONT face="Century Gothic" color=#000080><FONT size=2>HI AMJAD,<SPAN class=378274406-16072002><FONT face=Arial color=#0000ff> </FONT></SPAN></FONT></FONT></DIV> <DIV><FONT face="Century Gothic" color=#000080 size=2>HOW TO DROP THE DATABASE LINK.</FONT></DIV> <DIV><FONT face="Century Gothic" color=#000080 size=2></FONT> </DIV> <DIV><FONT face="Century Gothic" color=#000080 size=2>ANAND</FONT></DIV> <DIV><FONT face="Century Gothic" color=#800000 size=2>ITW SIGNODE INDIA LIMITED</FONT></DIV> <BLOCKQUOTE dir=ltr style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000080 2px solid; MARGIN-RIGHT: 0px"> <DIV style="FONT: 10pt arial">----- Original Message ----- </DIV> <DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B> <A [EMAIL PROTECTED] href="mailto:[EMAIL PROTECTED]">Amjad</A> </DIV> <DIV style="FONT: 10pt arial"><B>To:</B> <A [EMAIL PROTECTED] href="mailto:[EMAIL PROTECTED]">Multiple recipients of list ORACLE-L</A> </DIV> <DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, July 11, 2002 1:43 PM</DIV> <DIV style="FONT: 10pt arial"><B>Subject:</B> RE: dblink problem ( ORA-02019 )</DIV> <DIV><BR></DIV> <DIV><FONT color=#0000ff><FONT face=Arial><FONT size=2><FONT size=1>CREATE<SPAN class=360394606-11072002> </SPAN>PUBLIC DATABASE LINK dblink<SPAN class=360394606-11072002> </SPAN>CONNECT TO user IDENTIFIED BY password USING ’connect_string’<BR></FONT></FONT></FONT></FONT><FONT color=#0000ff><FONT face=Arial><FONT size=2><SPAN class=360394606-11072002></SPAN></FONT></FONT></FONT></DIV> <DIV><FONT color=#0000ff><FONT face=Arial><FONT size=2><SPAN class=360394606-11072002>Regards,</SPAN></FONT></FONT></FONT></DIV> <DIV><FONT color=#0000ff><FONT face=Arial><FONT size=2><SPAN class=360394606-11072002>Amjad. </SPAN></FONT></FONT></FONT></DIV> <DIV><FONT color=#0000ff><FONT face=Arial><FONT size=2><SPAN class=360394606-11072002><A href="http://www.medicomsoft.com">www.medicomsoft.com</A></SPAN></FONT></FONT> </FONT></DIV> <BLOCKQUOTE style="MARGIN-RIGHT: 0px"> <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma size=2><B>:</B> <A href="mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]</A> [mailto:[EMAIL PROTECTED]]<B>On Behalf Of </B>Anand Kumar N - Systems<BR><B>Sent:</B> Thursday, July 11, 2002 9:33 AM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> Re: dblink problem ( ORA-02019 )<BR><BR></DIV></FONT> <DIV><FONT color=#000080 size=2>Hi all,</FONT></DIV> <DIV><FONT color=#000080 size=2>How to Create dblink, can u please explain me.</FONT></DIV> <DIV><FONT color=#000080 size=2></FONT> </DIV> <DIV><FONT color=#000080 size=2>bye</FONT></DIV> <DIV><FONT color=#000080 size=2>Anand</FONT></DIV> <BLOCKQUOTE style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000080 2px solid; MARGIN-RIGHT: 0px"> <DIV style="FONT: 10pt arial">----- Original Message ----- </DIV> <DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B> <A [EMAIL PROTECTED] href="mailto:[EMAIL PROTECTED]">Ratnesh Kumar Singh</A> </DIV> <DIV style="FONT: 10pt arial"><B>To:</B> <A [EMAIL PROTECTED] href="mailto:[EMAIL PROTECTED]">Multiple recipients of list ORACLE-L</A> </DIV> <DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, July 10, 2002 6:23 PM</DIV> <DIV style="FONT: 10pt arial"><B>Subject:</B> dblink problem ( ORA-02019 )</DIV> <DIV><BR></DIV>hi<BR><BR>i have 3 databases(A,B,X) on 3 diff boxes.<BR>i have created 1 dblink each from A to X & from B to X.<BR>The syntax for dblink creation is exactly same for both dblinks.<BR><BR>I am able to query from dblink A-X as "select * from <A href="mailto:user.table@dblinkAX">user.table@dblinkAX</A>"<BR>but when i try to query from dblink B-X as "select * from<BR><A href="mailto:user.table@dblinkBX">user.table@dblinkBX</A>"<BR>i get the foll error<BR>Error: ORA-02019: connection description for remote database not found<BR><BR>When i modify my query by suffixing '.world' as<BR>"select * from <A href="mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]</A>" , the query works fine.<BR><BR>I have compared the entries in init,sqlnet,tnsnmames,listener files on both<BR>A & B<BR>databases and they are absolutely similar .<BR>i was thinking that the domain or globalnames parameters might be diff on A<BR>& B ,<BR>but they are absolutely same .<BR><BR>any suggestions are most welcome ...<BR><BR>thanks in advance<BR>ratnesh<BR><BR><BR><BR>---------------------------------------- -------<BR>Ratnesh Kumar Singh<BR>Sr. Software Engineer<BR>Patni Computer Systems Ltd<BR>TTC Mahape , Navi Mumbai<BR>Work : (91 22) 7611090/110/128/350 Ext. 2107<BR>Home : (91 22) 8662162<BR><A href="http://www.patni.com">http://www.patni.com</A><BR>World-Wide Partnerships. World-Class Solutions.<BR>-----------------------------------------------<BR><BR>-- <BR>Please see the official ORACLE-L FAQ: <A href="http://www.orafaq.com">http://www.orafaq.com</A><BR>-- <BR>Author: Ratnesh Kumar Singh<BR> INET: <A href="mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]</A><BR><BR>F at City Network Services -- (858) 538-5051 FAX: (858) 538-5051<BR>San Diego, California -- Public Internet access / Mailing Lists<BR>----------------------------------------------------------------- ---<BR>To REMOVE yourself from this mailing list, send an E-Mail message<BR>to: <A href="mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]</A> (note EXACT spelling of 'ListGuru') and in<BR>the message BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing list you want to be removed from). You may<BR>also send the HELP command for other information (like subscribing).</BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML> -- 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).