Check the parameter GLOBAL_NAMES, the best if have them FALSE in both instances.
Ramon ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, July 17, 2002 5:28 AM > 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez 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).
