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