| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> System
--0-1121121821-1058290218=:33868
Content-Type: text/plain; charset=us-ascii
John Kanagaraj <john.kanagaraj_at_hds.com> 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?
> -----Original Message-----
> From: Jesse, Rich [mailto:Rich.Jesse_at_qtiworld.com]
> 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
> rjesse_at_qtiworld.com Quad/Tech Inc, Sussex, WI USA
>
> > -----Original Message-----
> > From: Goulet, Dick [mailto:DGoulet_at_vicr.com]
> > 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
> > rthomas_at_hypercom.com
> > Each new user of a new system uncovers a new class of bugs.
> > -- Kernighan
> >
> >
> >
> > DGoulet_at_vicr.com
> >
> > 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: Rich.Jesse_at_qtiworld.com
>
> 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: 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.net -- Author: John Kanagaraj INET: john.kanagaraj_at_hds.com 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: 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). --------------------------------- Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo. --0-1121121821-1058290218=:33868 Content-Type: text/html; charset=us-ascii <DIV><BR><BR><B><I>John Kanagaraj <john.kanagaraj_at_hds.com></I></B> wrote: <BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid; WIDTH: 100%">Jesse,<BR><BR>You could always get around this problem by obtaining an upto date<BR>TNSNAMES.ORA on any Names-aware client using the 'namesctl dump_tnsnames'<BR>command that will create/update the tnsnames.ora with the entries from Names<BR>servers. I would suggest renaming the original tnsnames.ora _just_ before<BR>doing this, and having some script check the sizes of the created file (just<BR>in case). <BR><BR>John Kanagaraj<BR>Oracle Applications DBA<BR>DBSoft Inc<BR>(W): 408-970-7002<BR><BR>What would you see if you were allowed to look back at your life at the end<BR>of your journey in this earth?<BR><BR>** The opinions and statements above are entirely my own and not those of my<BR>employer or clients **<BR><BR>> -----Original Message-----<BR>> From: Jesse, Rich [mailto:Rich.Jesse_at_qtiworld.com]<BR>> Sent: Tuesday, July 15, 2003 9:25 AM<BR>> To: Multiple recipients of list ORACLE-L<BR>> Subject: RE: MicroSlop DTC<BR>> <BR>> <BR>> Unfortunately, it's not just a problem with this product. Some Oracle<BR>> products like OEM can incorrectly populate TNSNAMES.ORA "for <BR>> you" because of<BR>> course that's always the best thing to do (and isn't there <BR>> another Oracle<BR>> product that requires it or am I confusing that with the <BR>> semi-Intelligent<BR>> Agent's requirement of a LISTENER.ORA?).<BR>> <BR>> And Quest's QCO will largely not work correctly in v2.4 (and <BR>> to some extent<BR>> in 2.5) without a correctly populated TNSNAMES.ORA (sorry <BR>> Jacques!). I went<BR>> around and around with Quest Support as to why this is <BR>> incorrect and why I<BR>> refuse to manually populate a TNSNAMES.ORA on some or all clients.<BR>> Supposedly, it'll be fixed in v3.<BR>> <BR>> Desperately trying to get rid of all TNSNAMES.ORAs on all <BR>> non-DBA boxes...<BR>> <BR>> <BR>> Rich<BR>> <BR>> Rich Jesse System/Database Administrator<BR>> rjesse_at_qtiworld.com Quad/Tech Inc, Sussex, WI USA<BR>> <BR>> > -----Original Message-----<BR>> > From: Goulet, Dick [mailto:DGoulet_at_vicr.com]<BR>> > Sent: Monday, July 14, 2003 2:15 PM<BR>> > To: Multiple recipients of list ORACLE-L<BR>> > Subject: RE: MicroSlop DTC<BR>> > <BR>> > <BR>> > Yes, as well as SQL*Plus and ODBCTST.<BR>> > <BR>> > Dick Goulet<BR>> > Senior Oracle DBA<BR>> > Oracle Certified 8i DBA <BR>> > <BR>> > -----Original Message-----<BR>> > Sent: Monday, July 14, 2003 2:59 PM<BR>> > To: Multiple recipients of list ORACLE-L<BR>> > <BR>> > <BR>> > <BR>> > Hum, does tnsping resolve the service correctly?<BR>> > <BR>> > Ron Thomas<BR>> ><BR>> > 9.2.0.1.0 On Win 2K.<BR>> > <BR>> > Dick Goulet<BR>> > Senior Oracle DBA<BR>> > Oracle Certified 8i DBA<BR>> > <BR>> > -----Original Message-----<BR>> > Sent: Monday, July 14, 2003 1:54 PM<BR>> > To: Multiple recipients of list ORACLE-L<BR>> > <BR>> > <BR>> > <BR>> > I've seen this happen with older versions of the sqlnet <BR>> > client (Different application, same<BR>> > symptom). What version of the client are you using?<BR>> > <BR>> > Ron Thomas<BR>> > Hypercom, Inc<BR>> > rthomas_at_hypercom.com<BR>> > Each new user of a new system uncovers a new class of bugs. <BR>> > -- Kernighan<BR>> > <BR>> > <BR>> > <BR>> > DGoulet_at_vicr.com<BR>> > <BR>> > To All, especially any WEB developers out there.<BR>> > <BR>> > We've a WEB based application that uses MS DTC. <BR>> > OK, so we turned on XA in the<BR>> > database, but the web servers do not want to play with our <BR>> > normal ONmase setup. Instead they only<BR>> > want to work with a TNSNAMES.ORA file in the appriopriate <BR>> > place. I've been all over MicroSlop<BR>> > Technet and Metalink as well as several other IIS sites with <BR>> > no results. Therefore anyone know why<BR>> > this is??<BR>> > <BR>> > Dick Goulet<BR>> > Senior Oracle DBA<BR>> > Oracle Certified 8i DBA<BR>> -- <BR>> Please see the official ORACLE-L FAQ: http://www.orafaq.net<BR>> -- <BR>> Author: Jesse, Rich<BR>> INET: Rich.Jesse@qtiworld.com<BR>> <BR>> Fat City Network Services -- 858-538-5051 http://www.fatcity.com<BR>> San Diego, California -- Mailing list and web hosting services<BR>> ---------------------------------------------------------------------<BR>> To REMOVE yourself from this mailing list, send an E-Mail message<BR>> to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>> the message BODY, include a line containing: UNSUB ORACLE-L<BR>> (or the name of mailing list you want to be removed from). You may<BR>> also send the HELP command for other information (like subscribing).<BR>> <BR>-- <BR>Please see the official ORACLE-L FAQ: http://www.orafaq.net<BR>-- <BR>Author: John Kanagaraj<BR>INET: john.kanagaraj@hds.com<BR><BR>Fat City Network Services -- 858-538-5051 http://www.fatcity.com<BR>San Diego, California -- Mailing list and web hosting services<BR>---------------------------------------------------------------------<BR>To REMOVE yourself from this mailing list, send an E-Mail message<BR>to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the message BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing list you want to be removed from). You may<BR>also send the HELP command for other information (like subscribing).</BLOCKQUOTE></DIV><p><hr SIZE=1> Do you Yahoo!?<br>Received on Tue Jul 15 2003 - 12:30:18 CDT
 |
 |