Oracle process eating /tmp

From: <npm_at_netcom.com>
Date: Thu, 4 Jun 1998 21:12:25 GMT
Message-ID: <npmEu1pKp.GAL@netcom.com>

I'm running into a strange problem with oracle, I'm not a DBA so I may say this wrong. They're running Oracle 7.2.3 on a Digital Unix 3.2G system. They've got an application that uses Oracle and it appears to create "deleted files" in /tmp that are actually open and assigned to file descriptors 1 & 2 (stdout and stderr). Then it consumes all available disk space and causes havoc. Output from lsof looks like this:

Process	  PID     Owner   Mode              FileSize   inode file system
oracle    19714   oracle    0r  VREG   11,0       26   187 / (/dev/re0a)
oracle    19714   oracle    1w  VREG   11,0 61926315   186 / (/dev/re0a)
oracle    19714   oracle    2w  VREG   11,0 61926315   186 / (/dev/re0a)
xyz0000   19965    ptman    0r  VREG   11,0       26   187 / (/dev/re0a)

xyz0000 19965 ptman 1w VREG 11,0 61926315 186 / (/dev/re0a) xyz0000 19965 ptman 2w VREG 11,0 61926315 186 / (/dev/re0a)

The file descriptor referenced is in /tmp and does not point to an existing file so I suspect, strongly, that something is opening up a file in /tmp, deleting the file, then holding the file open and writing to it.

Has anyone run into this, and more importantly, have any clues on how to fix it?

Many Thanks!
--

Nancy Milligan		Milligan Consulting Services	
npm_at_netcom.com		System Administration, Perl/C/shell programming
			Internet Connectivity, Security, Usenet, WWW, and so on.
			http://nmcs.com

Received on Thu Jun 04 1998 - 16:12:25 CDT