RE: Unix Script Quest : Urgent
Don't forget the lsof command (list open files). Just as invaluable as truss. Get it at http://www.sunfreeware.com/ chris.w.johnson@b t.comTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: Unix Script Quest : Urgent 08/09/02 09:08 AM Please respond to ORACLE-L Hannah, I'm no Unix guru either but in this situation I use 'truss', e.g. truss procname HTH Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 09 August 2002 16:08 To: Multiple recipients of list ORACLE-L Subject: Unix Script Quest : Urgent 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, Hannah -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [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: Unix Script Quest : Urgent
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: [EMAIL PROTECTED] 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: [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: Unix Script Quest : Urgent
ldd filename should give you the dependencies. --- [EMAIL PROTECTED] wrote: 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, Hannah = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] 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: [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: Unix Script Quest : Urgent
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: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] 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: [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: Unix Script Quest : Urgent
Thanks, But I don't know the file or pid. Here's what we are doing: From an NT box, we are trying to run Sagent software to an Oracle db on unix sun solaris (both 64bit). When we try to refresh, we get a sagent error - OCI file not found. Of course it does not specifiy the file name. Using the same client, I can connect and run on my development box. Now, I know the username that Sagent connect to unix as, so I was hoping that I could run a trace on the Unix box based on the user name. But I am not finding a clear way to do this. I want to run the trace on the develpment box (the one that works), so that I can retrieve a list of filenames that the sagent process is hitting. Then I would want to compare the filenames to the directories on the prod bix to see what file is missing. Anyway, I am not seeing a clear way of doing this. I thinkg I'm going to wind up dumping the directories to file and doing a manual compare (ugh!) . Thanks, Hannah -Original Message- From: [EMAIL PROTECTED]@SUNGARD On Behalf Of Peter Barnett [EMAIL PROTECTED] Sent: Friday, August 09, 2002 11:48 AM To: Multiple recipients of list ORACLE-L Subject: Re: Unix Script Quest : Urgent ldd filename should give you the dependencies. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [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: Unix Script Quest : Urgent
Hannah, I'm no Unix guru either but in this situation I use 'truss', e.g. truss procname HTH Chris -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: 09 August 2002 16:08To: Multiple recipients of list ORACLE-LSubject: Unix Script Quest : Urgent Is there a way to captureall 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, Hannah
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: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] 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: [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). -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [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).
