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@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). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: kkennedy > 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). > > -- > 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suzy Vordos 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).
