| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re:RE: dblink problem ( ORA-02019)
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" <ratnesh.singh_at_patni.com> 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
CREATE PUBLIC DATABASE LINK dblink CONNECT TO user IDENTIFIED BY password USING 'connect_string'
Regards,
Amjad.
www.medicomsoft.com
: root_at_fatcity.com [mailto:root_at_fatcity.com]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
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_at_dblinkAX"
but when i try to query from dblink B-X as "select * from
user.table_at_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 user.table_at_dblinkBX.world" , 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: ratnesh.singh_at_patni.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).
<!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>
<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 INDIALIMITED</FONT></DIV>
<A title=amjad_at_medicomsoft.com href="mailto:amjad_at_medicomsoft.com">Amjad</A> </DIV> <DIV style="FONT: 10pt arial"><B>To:</B> <A title=ORACLE-L_at_fatcity.comhref="mailto:ORACLE-L_at_fatcity.com">Multiple recipients of list ORACLE-L</A> </DIV>
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
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
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color:
black"><B>From:</B>
<A title=ratnesh.singh_at_patni.com
href="mailto:ratnesh.singh_at_patni.com">Ratnesh Kumar Singh</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=ORACLE-L_at_fatcity.com
href="mailto:ORACLE-L_at_fatcity.com">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_at_dblinkAX">user.table_at_dblinkAX</A>"<BR>but when i
try to query from dblink B-X as "select * from<BR><A
href="mailto:user.table_at_dblinkBX">user.table_at_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:user.table_at_dblinkBX.world">user.table_at_dblinkBX.world</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:ratnesh.singh_at_patni.com">ratnesh.singh_at_patni.com</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:ListGuru_at_fatcity.com">ListGuru_at_fatcity.com</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
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: dgoulet_at_vicr.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-LReceived on Tue Jul 16 2002 - 09:33:24 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
 |
 |