Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Unix Script Quest : Urgent

RE: Unix Script Quest : Urgent

From: Seefelt, Beth <Beth.Seefelt_at_TetleyUSA.com>
Date: Fri, 09 Aug 2002 08:08:26 -0800
Message-ID: <F001.004B0920.20020809080826@fatcity.com>

I think that will give you files that it successfully accessed, but not the ones that were referenced but not found.

You can do what you're asking on VMS and NT, so it seems like there should be a way in Unix, although I asked my Unix SA's that same question a few years back and they said that there isn't. They were pretty sharp guys so I tend to believe them.

-----Original Message-----
Sent: Friday, August 09, 2002 11:33 AM
To: Multiple recipients of list ORACLE-L

> Is there a way to capture all files hit by a process/user in unix (Sun
> Solaris 9, ksh)? I am seeing an OCI file not found on my production
box.
> I can't resovle it.
> So, I want to run the same process on my development box (where it
works)
> and get a list of files that it is hitting (I can grep by username)
for
> comparison in production. Only I am definitely NOT the Unix guru and
as
> this is for a prod issue, so my time is very limited.
> Thanks in advance,

    touch BEFORE;
    ...
    find $wherever -newer ./BEFORE;

will give you a list of files that have changed since the BEFORE file. If you are sure that the files are being created (vs. modified or accessed) by one specific userid then:

    find / -newer BEFORE -user <id>

will work also.

If you are going to run the thing regularly then take a look at "find2p", which will spit out a perl script to match your find command. The perly code will give you finer control and better sanity checks (e.g., comparing to a list in memory of what has already been found to avoid dup's) than find can.

enjoi.

--
Steven Lembark                               2930 W. Palmer
Workhorse Computing                       Chicago, IL 60647
                                            +1 800 762 1582
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steven Lembark
  INET: lembark_at_wrkhors.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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.com
-- 
Author: Seefelt, Beth
  INET: Beth.Seefelt_at_TetleyUSA.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
Received on Fri Aug 09 2002 - 11:08:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US