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