Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: RE: dblink problem ( ORA-02019)

Re: RE: dblink problem ( ORA-02019)

From: Ramon E. Estevez <com.banilejas_at_codetel.net.do>
Date: Wed, 17 Jul 2002 08:58:28 -0800
Message-ID: <F001.0049A286.20020717085828@fatcity.com>


Check the parameter GLOBAL_NAMES, the best if have them FALSE in both instances.

Ramon

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ramon E. Estevez
  INET: com.banilejas_at_codetel.net.do

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).
Received on Wed Jul 17 2002 - 11:58:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US