Re: Unix Script Quest : Urgent

Never say "never".

The output from "truss" shows all "system calls"; which includes file opens.

Here is an interesting exercise for those on *nix boxes.
>From one window/session do the following ...
$ sqlplus
>From a different window where you are logged onto the system as root
find the pid (process ID) of the SQLPLUS process from 1st window. $ truss -p pid | tee /tmp/capture
After the truss command has been initiated go back to the 1st window and enter a valid Oracle username/password to connect to the DB. In the window running the truss you'll see all the various "login" files which SQL*Plus attempts to open before returning control to the user & presenting the SQL> prompt.

HTH & YMMV HAND! "Seefelt, Beth" wrote:
>
> 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).

-- 
Charlie Mengler                                  Maintenance Warehouse  
charliem_at_mwh.com                                 10641 Scripps Summit Ct.
858-831-2229                                     San Diego, CA 92131    
Lack of planning on your part doesn't constitute an emergency on my part!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  INET: charliem_at_mwh.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).