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_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: kkennedy
> INET: kkennedy_at_firstpoint.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: 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: Suzy Vordos
  INET: lvordos_at_qwest.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).