Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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
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-LReceived on Wed Jul 17 2002 - 05:28: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).