Xref: alice comp.databases.oracle.misc:45393 comp.databases.oracle.server:71586 Path: alice!news-feed.fnsi.net!newsfeed.icl.net!newsfeed.wirehub.nl!bullseye.news.demon.net!demon!news.demon.nl!demon!sybrandb.demon.nl!not-for-mail From: "Sybrand Bakker" Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server Subject: Re: Mystery files Date: Tue, 26 Oct 1999 19:03:08 +0200 Message-ID: <940957416.18069.0.pluto.d4ee154e@news.demon.nl> References: <3815DDCB.1B94503B@Unforgettable.com> Reply-To: "Sybrand Bakker" X-Trace: news.demon.nl 940957416 pluto:18069 NO-IDENT sybrandb.demon.nl:212.238.21.78 X-Complaints-To: abuse@demon.net X-Newsreader: Microsoft Outlook Express 5.00.2014.211 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211 Lines: 47 They're not mystery files. They are the physical representation of the sockets Oracle is using for interprocess communication between the background processes. 'Obsolete' files can be safely deleted. Hth, -- Sybrand Bakker, Oracle DBA Kenneth C Stahl wrote in message news:3815DDCB.1B94503B@Unforgettable.com... > I have come across something that puzzles me - but before I get into the > details of what I've discovered I'll describe the environment: > > Hardware: Compaq ProLient > OS: Unixware 2.1.2 > RDBMS: Oracle V7.3.4.0 > Sqlnet: V2 > Database instances: 2 - using MTS. Both instances use a common listener on > port 1521. > > > Hopefully that is enough info. > > What I have found is that in the /var/tmp directory there is a hidden > directory named .oracle and in this directory is a number of files which > have a form like S#nnnnn.1 (where nnnn is a 1-5 digit number). If I run > 'file' against these files it is reported as a fifo. If I do a 'ls -l' the > permissions are > p-w--w--w- > > While I can't be sure of this, the timestamps of the files seems to > coincide with the times over the past few months when the server (or just > database) has been bounced. > > Does anyone know what these function these files fulfill? Is it safe to > delete files that are older than the most recent file? Is there any place > where > these files are documented? Is it possible that they should not be there > and that they only exist because of a mistake in installation/configuration > of the database instances? > > Any info appreciated.