You can also supply a filename to the dump_tnsnames command. ie. dump_tnsnames /tmp/tnsnames.tmp
Jared On Tuesday 15 July 2003 11:14, John Kanagaraj wrote: > Jesse, > > You could always get around this problem by obtaining an upto date > TNSNAMES.ORA on any Names-aware client using the 'namesctl dump_tnsnames' > command that will create/update the tnsnames.ora with the entries from > Names servers. I would suggest renaming the original tnsnames.ora _just_ > before doing this, and having some script check the sizes of the created > file (just in case). > > John Kanagaraj > Oracle Applications DBA > DBSoft Inc > (W): 408-970-7002 > > What would you see if you were allowed to look back at your life at the end > of your journey in this earth? > > ** The opinions and statements above are entirely my own and not those of > my employer or clients ** > > > -----Original Message----- > > From: Jesse, Rich [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, July 15, 2003 9:25 AM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: MicroSlop DTC > > > > > > Unfortunately, it's not just a problem with this product. Some Oracle > > products like OEM can incorrectly populate TNSNAMES.ORA "for > > you" because of > > course that's always the best thing to do (and isn't there > > another Oracle > > product that requires it or am I confusing that with the > > semi-Intelligent > > Agent's requirement of a LISTENER.ORA?). > > > > And Quest's QCO will largely not work correctly in v2.4 (and > > to some extent > > in 2.5) without a correctly populated TNSNAMES.ORA (sorry > > Jacques!). I went > > around and around with Quest Support as to why this is > > incorrect and why I > > refuse to manually populate a TNSNAMES.ORA on some or all clients. > > Supposedly, it'll be fixed in v3. > > > > Desperately trying to get rid of all TNSNAMES.ORAs on all > > non-DBA boxes... > > > > > > Rich > > > > Rich Jesse System/Database Administrator > > [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > > > > > -----Original Message----- > > > From: Goulet, Dick [mailto:[EMAIL PROTECTED] > > > Sent: Monday, July 14, 2003 2:15 PM > > > To: Multiple recipients of list ORACLE-L > > > Subject: RE: MicroSlop DTC > > > > > > > > > Yes, as well as SQL*Plus and ODBCTST. > > > > > > Dick Goulet > > > Senior Oracle DBA > > > Oracle Certified 8i DBA > > > > > > -----Original Message----- > > > Sent: Monday, July 14, 2003 2:59 PM > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > > > > Hum, does tnsping resolve the service correctly? > > > > > > Ron Thomas > > > > > > 9.2.0.1.0 On Win 2K. > > > > > > Dick Goulet > > > Senior Oracle DBA > > > Oracle Certified 8i DBA > > > > > > -----Original Message----- > > > Sent: Monday, July 14, 2003 1:54 PM > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > > > > I've seen this happen with older versions of the sqlnet > > > client (Different application, same > > > symptom). What version of the client are you using? > > > > > > Ron Thomas > > > Hypercom, Inc > > > [EMAIL PROTECTED] > > > Each new user of a new system uncovers a new class of bugs. > > > -- Kernighan > > > > > > > > > > > > [EMAIL PROTECTED] > > > > > > To All, especially any WEB developers out there. > > > > > > We've a WEB based application that uses MS DTC. > > > OK, so we turned on XA in the > > > database, but the web servers do not want to play with our > > > normal ONmase setup. Instead they only > > > want to work with a TNSNAMES.ORA file in the appriopriate > > > place. I've been all over MicroSlop > > > Technet and Metalink as well as several other IIS sites with > > > no results. Therefore anyone know why > > > this is?? > > > > > > Dick Goulet > > > Senior Oracle DBA > > > Oracle Certified 8i DBA > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Jesse, Rich > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > > San Diego, California -- Mailing list and web hosting services > > --------------------------------------------------------------------- > > 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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).