Re: Oracle networking temp files in /tmp

2003-11-27 Thread Pete Finnigan
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

2003-11-26 Thread Pete Finnigan
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

2003-11-26 Thread Jesse, Rich
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

2003-11-26 Thread Jesse, Rich
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

2003-11-26 Thread Gilles PARC
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).