Re: RE: dblink problem ( ORA-02019)
Check the parameter GLOBAL_NAMES, the best if have them FALSE in both instances. Ramon - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, July 17, 2002 5:28 AM > Hi > > thanks for your mail. > Dick , I checked out , both db's are 8.1.7.2 and have same db_domain as > world. > i also tried out Suzy Vordos' suggestion : > selected "name,value,ismodified from v$paramater" for both databases , > but the result for both is same . So change in init.ora or "alter system" > after db startup does not seem likely. > > regards > Ratnesh > > > -Original Message- > Sent: Tuesday, July 16, 2002 6:57 PM > To: Ratnesh Kumar Singh; Multiple recipients of list ORACLE-L > > > 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 > > - 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez 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).
RE: RE: dblink problem ( ORA-02019)
Hi thanks for your mail. Dick , I checked out , both db's are 8.1.7.2 and have same db_domain as world. i also tried out Suzy Vordos' suggestion : selected "name,value,ismodified from v$paramater" for both databases , but the result for both is same . So change in init.ora or "alter system" after db startup does not seem likely. regards Ratnesh -Original Message- Sent: Tuesday, July 16, 2002 6:57 PM To: Ratnesh Kumar Singh; Multiple recipients of list ORACLE-L 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 - 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).
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" <[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).
Refer
to Oracle docs / oracle SQL reference / DROP ...
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Anand Kumar N -
SystemsSent: Tuesday, July 16, 2002 12:33 PMTo: Multiple
recipients of list ORACLE-LSubject: Re: dblink problem ( ORA-02019
)
HI AMJAD,
HOW TO DROP THE DATABASE
LINK.
ANAND
ITW SIGNODE INDIA
LIMITED
- Original Message -
From:
mailto:[EMAIL PROTECTED]";>Amjad
To: mailto:[EMAIL PROTECTED]";>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
pass
Re: dblink problem ( ORA-02019 )
Hi, Use Drop database link (if the link is a private link and u are the owner) Drop public database link . Hope this helps shreepad Anand Kumar N - Systems To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED] <[EMAIL PROTECTED]> node.co.in> cc: Subject: Re: dblink problem ( ORA-02019 ) 16/07/02 12:33 Please respond to ORACLE-L HI AMJAD, HOW TO DROP THE DATABASE LINK. ANAND ITW SIGNODE INDIA LIMITED - Original Message - From: Amjad <mailto:[EMAIL PROTECTED]> To: Multiple recipients of list ORACLE-L <mailto:[EMAIL PROTECTED]> 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 <http://www.medicomsoft.com> : [EMAIL PROTECTED] <mailto:[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 <mailto:[EMAIL PROTECTED]> To: Multiple recipients of list ORACLE-L < mailto:[EMAIL PROTECTED]> 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 <mailto:user.table@dblinkAX>" but when i try to query from dblink B-X as "select * from user.table@dblinkBX <mailto: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] < mailto:[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 <http://www.patni.com> World-Wide Partnerships. World-Class Solutions. --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com < http://www.orafaq.com> -- Author: Ratnesh Kumar Singh INET: [EMAIL PROTECTED] <mailto:[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] <mailto:[EMAIL PROTECTED]> (note EXACT spelling of 'ListGuru') and in the message BODY, include a l
RE: dblink problem ( ORA-02019 )
drop public database link dblink dear anand iam sorry to say this but such things u can always look up in the documentation... no 1 will spoon feed u to such a level if its something more logical problem or something that is new we r always here to help each other out , after all this list is made to help each other... i hope u can understand... thanx and regards, Amjad. www.medicomsoft.com -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Anand Kumar N - SystemsSent: Tuesday, July 16, 2002 11:03 AMTo: Multiple recipients of list ORACLE-LSubject: Re: dblink problem ( ORA-02019 ) 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 - SystemsSent: Thursday, July 11, 2002 9:33 AMTo: Multiple recipients of list ORACLE-LSubject: Re: dblink problem ( ORA-02019 ) Hi all, How to Create dblink, can u please explain me. bye Anand
RE: dblink problem ( ORA-02019 )
Hi,
Use
this
DROP
DATABASE LINK name;
Or
if you have created public link then..
DROP
PUBLIC DATABASE LINK name;
Sanjay
-Original Message-From: Anand Kumar N - Systems
[mailto:[EMAIL PROTECTED]]Sent: 16 July, 2002 3:03
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
dblink problem ( ORA-02019 )
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 -
SystemsSent: Thursday, July 11, 2002 9:33 AMTo:
Multiple recipients of list ORACLE-LSubject: 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
)
hii 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 * fromuser.table@dblinkBX"i get the
foll errorError: ORA-02019: connection description for remote
database not foundWhen 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 bothA & Bdatabases
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
advanceratnesh---Ratnesh
Kumar SinghSr. Software EngineerPatni Computer Systems
LtdTTC Mahape , Navi MumbaiWork : (91 22) 7611090/110/128/350
Ext. 2107Home : (91 22) 8662162http://www.patni.comWorld-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-5051San Diego,
California -- Public Internet
access / Mailing
ListsTo
REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT
spelling of 'ListGuru') and inthe message BODY, include a line
containing: UNSUB ORACLE-L(or the name of mailing list you want to
be removed from). You mayalso send the HELP command for other
information (like
subscribing).
Re: dblink problem ( ORA-02019 )
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 - SystemsSent: Thursday, July 11, 2002 9:33 AMTo: Multiple recipients of list ORACLE-LSubject: 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 ) hii 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 * fromuser.table@dblinkBX"i get the foll errorError: ORA-02019: connection description for remote database not foundWhen 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 bothA & Bdatabases 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 advanceratnesh---Ratnesh Kumar SinghSr. Software EngineerPatni Computer Systems LtdTTC Mahape , Navi MumbaiWork : (91 22) 7611090/110/128/350 Ext. 2107Home : (91 22) 8662162http://www.patni.comWorld-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-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: dblink problem ( ORA-02019 )
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 - SystemsSent: Thursday, July 11, 2002 9:33 AMTo: Multiple recipients of list ORACLE-LSubject: 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 ) hii 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 * fromuser.table@dblinkBX"i get the foll errorError: ORA-02019: connection description for remote database not foundWhen 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 bothA & Bdatabases 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 advanceratnesh---Ratnesh Kumar SinghSr. Software EngineerPatni Computer Systems LtdTTC Mahape , Navi MumbaiWork : (91 22) 7611090/110/128/350 Ext. 2107Home : (91 22) 8662162http://www.patni.comWorld-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-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: dblink problem ( ORA-02019 )
If db_domain is in fact set in B's init.ora, you might check if: 1) there are multiple init.ora's and the one you're looking at isn't the one used, 2) if the database has been bounced since the init.ora was changed. Also from sqlplus type: show parameter db_domain, to see if it's set. Ratnesh Kumar Singh wrote: > > Hi > > many thanks to all who replied to my query. > I was able to solve the problem by changing the dblink create stmt. > It seems the user had created the links as > " CREATE PUBLIC DATABASE LINK abc.WORLD CONNECT TO username > IDENTIFIED BY pwd USING 'dbname.world' ; " > I recreated the dblinks as > " CREATE PUBLIC DATABASE LINK abc CONNECT TO username > IDENTIFIED BY pwd USING 'dbname.world' ; " > > However , Kevin's reply has resulted in me finding another problem. > When i did a "select * from global_name" on db A , i get "dbname.world" . > but when i do the same on db B , i get only "dbname" ??? > > i crosschecked all init.ora , sqlnet & tnsnames params on both A & B ,and i > did > not find any differences. db_domain for both A & B is world, global_names is > FALSE. > db_name, instance_name & service_names are consistent across both A & B. > > According to oradocs , global_name is a view for the init.ora param > GLOBAL_NAME. > Why is this diff coming and how do i resolve it. > > thanks again > ratnesh > > -Original Message- > Sent: Wednesday, July 10, 2002 10:23 PM > To: Multiple recipients of list ORACLE-L > > I had this problem in the past at a site where we were switching from .world > to named domains. I can't remember exactly where I found it but I remember > that the method Oracle used to determining the dblink domain was funky. On > both databases, check "select * from global_name" and compare the result to > "select * from dba_db_links". It seems to me that the domain extension on > the global_name was used as the default extension when creating links. > Caused me no end of heartburn -- nothing I couldn't work around, but more > work arounds than I was happy with. > > Hope my memory is sufficient since I don't have the problem at my current > site. > > Kevin Kennedy > First Point Energy Corporation > > -Original Message- > Sent: Wednesday, July 10, 2002 5:53 AM > To: Multiple recipients of list ORACLE-L > > 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). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: kkennedy > 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: R
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 - SystemsSent: Thursday, July 11, 2002 9:33 AMTo: Multiple recipients of list ORACLE-LSubject: 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 ) hii 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 * fromuser.table@dblinkBX"i get the foll errorError: ORA-02019: connection description for remote database not foundWhen 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 bothA & Bdatabases 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 advanceratnesh---Ratnesh Kumar SinghSr. Software EngineerPatni Computer Systems LtdTTC Mahape , Navi MumbaiWork : (91 22) 7611090/110/128/350 Ext. 2107Home : (91 22) 8662162http://www.patni.comWorld-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-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: dblink problem ( ORA-02019 )
yes i cross checked , the 2 sqlnet.ora files are exactly the same. i am using 8.1.7.2.0 for all 3 db's. -Original Message- Bruce (CALBBAY) Sent: Thursday, July 11, 2002 12:33 PM To: Multiple recipients of list ORACLE-L Check the sqlnet.ora on both boxes - are they the same? There was a bug in 1 version where the domain would get selected from the default_domain present in sqlnet.ora HTH, Bruce Reardon -Original Message- Sent: Thursday, 11 July 2002 16:13 Hi many thanks to all who replied to my query. I was able to solve the problem by changing the dblink create stmt. It seems the user had created the links as " CREATE PUBLIC DATABASE LINK abc.WORLD CONNECT TO username IDENTIFIED BY pwd USING 'dbname.world' ; " I recreated the dblinks as " CREATE PUBLIC DATABASE LINK abc CONNECT TO username IDENTIFIED BY pwd USING 'dbname.world' ; " However , Kevin's reply has resulted in me finding another problem. When i did a "select * from global_name" on db A , i get "dbname.world" . but when i do the same on db B , i get only "dbname" ??? i crosschecked all init.ora , sqlnet & tnsnames params on both A & B ,and i did not find any differences. db_domain for both A & B is world, global_names is FALSE. db_name, instance_name & service_names are consistent across both A & B. According to oradocs , global_name is a view for the init.ora param GLOBAL_NAME. Why is this diff coming and how do i resolve it. thanks again ratnesh -Original Message- Sent: Wednesday, July 10, 2002 10:23 PM I had this problem in the past at a site where we were switching from .world to named domains. I can't remember exactly where I found it but I remember that the method Oracle used to determining the dblink domain was funky. On both databases, check "select * from global_name" and compare the result to "select * from dba_db_links". It seems to me that the domain extension on the global_name was used as the default extension when creating links. Caused me no end of heartburn -- nothing I couldn't work around, but more work arounds than I was happy with. Hope my memory is sufficient since I don't have the problem at my current site. Kevin Kennedy First Point Energy Corporation -Original Message- Sent: Wednesday, July 10, 2002 5:53 AM 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: Reardon, Bruce (CALBBAY) 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: 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).
RE: dblink problem ( ORA-02019 )
Check the sqlnet.ora on both boxes - are they the same? There was a bug in 1 version where the domain would get selected from the default_domain present in sqlnet.ora HTH, Bruce Reardon -Original Message- Sent: Thursday, 11 July 2002 16:13 Hi many thanks to all who replied to my query. I was able to solve the problem by changing the dblink create stmt. It seems the user had created the links as " CREATE PUBLIC DATABASE LINK abc.WORLD CONNECT TO username IDENTIFIED BY pwd USING 'dbname.world' ; " I recreated the dblinks as " CREATE PUBLIC DATABASE LINK abc CONNECT TO username IDENTIFIED BY pwd USING 'dbname.world' ; " However , Kevin's reply has resulted in me finding another problem. When i did a "select * from global_name" on db A , i get "dbname.world" . but when i do the same on db B , i get only "dbname" ??? i crosschecked all init.ora , sqlnet & tnsnames params on both A & B ,and i did not find any differences. db_domain for both A & B is world, global_names is FALSE. db_name, instance_name & service_names are consistent across both A & B. According to oradocs , global_name is a view for the init.ora param GLOBAL_NAME. Why is this diff coming and how do i resolve it. thanks again ratnesh -Original Message- Sent: Wednesday, July 10, 2002 10:23 PM I had this problem in the past at a site where we were switching from .world to named domains. I can't remember exactly where I found it but I remember that the method Oracle used to determining the dblink domain was funky. On both databases, check "select * from global_name" and compare the result to "select * from dba_db_links". It seems to me that the domain extension on the global_name was used as the default extension when creating links. Caused me no end of heartburn -- nothing I couldn't work around, but more work arounds than I was happy with. Hope my memory is sufficient since I don't have the problem at my current site. Kevin Kennedy First Point Energy Corporation -Original Message- Sent: Wednesday, July 10, 2002 5:53 AM 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: Reardon, Bruce (CALBBAY) 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).
RE: dblink problem ( ORA-02019 )
Hi If u make the Global_names as true u can use u r own link name to connect to the database thru the TNSNAMES.ora config Ayap "Dreams translate into thoughts, and thoughts translate into action: Kalam" This communication contains information, which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s), please note that any distribution, printing, copying or use of this communication or the information in it is strictly prohibited. If you have received this communication in error, please notify the sender immediately and then destroy any copies of it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ayyappan S 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).
RE: dblink problem ( ORA-02019 )
Hi many thanks to all who replied to my query. I was able to solve the problem by changing the dblink create stmt. It seems the user had created the links as " CREATE PUBLIC DATABASE LINK abc.WORLD CONNECT TO username IDENTIFIED BY pwd USING 'dbname.world' ; " I recreated the dblinks as " CREATE PUBLIC DATABASE LINK abc CONNECT TO username IDENTIFIED BY pwd USING 'dbname.world' ; " However , Kevin's reply has resulted in me finding another problem. When i did a "select * from global_name" on db A , i get "dbname.world" . but when i do the same on db B , i get only "dbname" ??? i crosschecked all init.ora , sqlnet & tnsnames params on both A & B ,and i did not find any differences. db_domain for both A & B is world, global_names is FALSE. db_name, instance_name & service_names are consistent across both A & B. According to oradocs , global_name is a view for the init.ora param GLOBAL_NAME. Why is this diff coming and how do i resolve it. thanks again ratnesh -Original Message- Sent: Wednesday, July 10, 2002 10:23 PM To: Multiple recipients of list ORACLE-L I had this problem in the past at a site where we were switching from .world to named domains. I can't remember exactly where I found it but I remember that the method Oracle used to determining the dblink domain was funky. On both databases, check "select * from global_name" and compare the result to "select * from dba_db_links". It seems to me that the domain extension on the global_name was used as the default extension when creating links. Caused me no end of heartburn -- nothing I couldn't work around, but more work arounds than I was happy with. Hope my memory is sufficient since I don't have the problem at my current site. Kevin Kennedy First Point Energy Corporation -Original Message- Sent: Wednesday, July 10, 2002 5:53 AM To: Multiple recipients of list ORACLE-L 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: kkennedy 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: 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 infor
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 ) hii 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 * fromuser.table@dblinkBX"i get the foll errorError: ORA-02019: connection description for remote database not foundWhen 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 bothA & Bdatabases 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 advanceratnesh---Ratnesh Kumar SinghSr. Software EngineerPatni Computer Systems LtdTTC Mahape , Navi MumbaiWork : (91 22) 7611090/110/128/350 Ext. 2107Home : (91 22) 8662162http://www.patni.comWorld-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-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: dblink problem ( ORA-02019 )
Sounds like your SQLNET.ORA file is different between the servers. Also check the Global_Names parameter. Ron Smith -Original Message- Sent: Wednesday, July 10, 2002 11:53 AM To: Multiple recipients of list ORACLE-L I had this problem in the past at a site where we were switching from .world to named domains. I can't remember exactly where I found it but I remember that the method Oracle used to determining the dblink domain was funky. On both databases, check "select * from global_name" and compare the result to "select * from dba_db_links". It seems to me that the domain extension on the global_name was used as the default extension when creating links. Caused me no end of heartburn -- nothing I couldn't work around, but more work arounds than I was happy with. Hope my memory is sufficient since I don't have the problem at my current site. Kevin Kennedy First Point Energy Corporation -Original Message- Sent: Wednesday, July 10, 2002 5:53 AM To: Multiple recipients of list ORACLE-L 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: kkennedy 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: Smith, Ron L. 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).
RE: dblink problem ( ORA-02019 )
I had this problem in the past at a site where we were switching from .world to named domains. I can't remember exactly where I found it but I remember that the method Oracle used to determining the dblink domain was funky. On both databases, check "select * from global_name" and compare the result to "select * from dba_db_links". It seems to me that the domain extension on the global_name was used as the default extension when creating links. Caused me no end of heartburn -- nothing I couldn't work around, but more work arounds than I was happy with. Hope my memory is sufficient since I don't have the problem at my current site. Kevin Kennedy First Point Energy Corporation -Original Message- Sent: Wednesday, July 10, 2002 5:53 AM To: Multiple recipients of list ORACLE-L 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: kkennedy 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).
RE: dblink problem ( ORA-02019 )
Hi ratnesh, try this checks first : 1.Check if the GLOBAL_NAMES=TRUE in init.ora parameter. 2.In the sqlnet.ora check whether the WORLD domain is mentioned in both. 3.Tnsnames.ora file ,the database name should be test.world like that. 4.How are you creating the database link with which qualifier you are using?Are you using the world domain or simply creating the link with a particular domain. This is not clear. IF you can send me exactly how you are creating the database link in both the databases we can know where you went wrong. Anyway frist try the above check steps first. Regards Amjad. PS: hey give my regards to Murtuza Chitalwala working in ur company (New Bombay). thanx. -Original Message- Kumar Singh Sent: Wednesday, July 10, 2002 4:53 PM To: Multiple recipients of list ORACLE-L 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Amjad 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).
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).
