Re: Oracle networking temp files in /tmp
Thanks for the update Rich, have a good day off, the rest of us still work:-(, should be interesting to see how many of your states side people cannot resist coming here and answering a question or two ..:-) kind regards Pete Americans, Happy Thanksgiving! The rest of the world, enjoy working tomorrow. -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan 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).
Re: Oracle networking temp files in /tmp
Hi Rich Try lsof or fuser on them?, if you get the process ID you could try attaching truss to it and see what its being used for. IPC springs to mind? kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan 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).
RE: Oracle networking temp files in /tmp
Yup, tried those with no hits. Those processes must be long gone. I had mistakenly copied over my Windohs version of SQLNET.ORA, which the SQLNET.AUTHENTICATION_SERVICES parameter seems to have a problem on Linux. I tried re-enabling that, but am unable to recreate the dumps. I also see that some of the files were generated with the listener down, at least according to $ORACLE_HOME/network/log/listener.log. Even Oracle Support is stumped. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Wednesday, November 26, 2003 12:39 PM To: Multiple recipients of list ORACLE-L Hi Rich Try lsof or fuser on them?, if you get the process ID you could try attaching truss to it and see what its being used for. IPC springs to mind? kind regards Pete -- 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).
RE: Oracle networking temp files in /tmp
A-ha! Just when I'm on the virge of bashing them, Oracle Support comes thru (to be fair, I've had very good response from them lately). The files are leftovers from linking and can be safely deleted. Americans, Happy Thanksgiving! The rest of the world, enjoy working tomorrow. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Tuesday, November 25, 2003 1:04 PM To: Multiple recipients of list ORACLE-L Hey all, Running Oracle 9.2.0.4 on Linux, I've noticed several files in /tmp owned by the oracle user: BEQ10202 DCE10202 DEC10202 I1S2 ISPX10202 ITCP10202 LU6210202 NMP10202 RAW10202 SPX10202 TCP10202 TCPS10202 US10202 VI10202 BEQ29871 DCE29871 DEC29871 I2S4 ISPX29871 ITCP29871 LU6229871 NMP29871 RAW29871 SPX29871 TCP29871 TCPS29871 US29871 VI29871 [snip] -- 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).
Re: Oracle networking temp files in /tmp
Rich, Cannot verify now but if I remember correctly, these files are generated by a program in $ORACLE_HOME/bin Look for something like gen* (gennttab ??) This program is generally called during some oracle relink. HTH At 11:04 25/11/2003 -0800, you wrote: Hey all, Running Oracle 9.2.0.4 on Linux, I've noticed several files in /tmp owned by the oracle user: BEQ10202 DCE10202 DEC10202 I1S2 ISPX10202 ITCP10202 LU6210202 NMP10202 RAW10202 SPX10202 TCP10202 TCPS10202 US10202 VI10202 BEQ29871 DCE29871 DEC29871 I2S4 ISPX29871 ITCP29871 LU6229871 NMP29871 RAW29871 SPX29871 TCP29871 TCPS29871 US29871 VI29871 It would appear that these files may be related to networking based on the filename prefixes, but I can't find anything about them in the docs nor Metalink. The only files with anything in them are the BEQ*, TCP*, and US* ones, which coincides with the installed networking protocols, except for the US* ones. It appears that those contain some sort of dump or trace. For example, the file TCPS29871 starts off with: ntz.o: d NZPKCS12_MAGIC_NUM U _GLOBAL_OFFSET_TABLE_ U calloc U free t gcc2_compiled. U lxmcpen U lxsCmpStr U memcpy U nldsfprintf U nldtotrc U nlepeget U nlhthfre U nlhthget U nlnvcrb U nlnvdeb U nlnvfbp U nlnvgap U nlpagbp U nlpagsp U nlpagvc U ntctst U ntpafind 6d00 T ntzAllocate 7040 t ntzCheckServerDN 1120 t ntzConfigure 24c0 t ntzConvertToNumeric 6860 t ntzCreateCipherSpec 08e0 t ntzCreateConnection Anyone know what these might be? Since this is my desktop, I'm really tempted to just blow them away and see what happens, but if nothing happens it won't be much fun. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -- 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). Gilles Parc carpe diem !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gilles PARC 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).