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