need a script(.ksh) to kill oracle process automatically

[mallika mahitha]

I want a unix script to kill oracle processes automatically for example who logged more than 20 hours.

[Nepomuk]

Well, you can build one. Here are a few things that might help:

• The following code will display the PIDs and elapsed running times of all processes found called <name>:
  

  ps $(pgrep <name>) -o pid=,etime=

  Leaving out the "pid=" option will give you only the time.
• You can kill a process with the PID <pid> with the command

  kill <pid>

• The test command allows you to compare values and react to the results.

That should be enough to get you started. :-)

[mallika mahitha]

this we need to do manually but i need it automatically without manual intervention daily.

[Nepomuk]

That shouldn't be a problem. Here's what I'd do:

1. Write a script that can do the job manually as described above
2. Use cron to automate the job, which means crating a crontab entry that might look something like this:
   

   # Run this job once per day at 1:15 am
   15 1 * * * /opt/scripts/killOldOracleJobs.sh

Cron is very useful so learning about crontabs is a good idea anyway.

[mallika mahitha]

but the process id (pid) need to give manually here,if we have twenty users whose log on time more than 20hours all those all users need to kill.

need to happen automatically based on the time period.

[Nepomuk]

That's what the ps-command in my first reply is for. If you know the name of the processes (e.g. "oracle"), you can find all instances of that process including the time it's been running. So, you can make a list, filter it by the times the processes have been running and then kill the various processes in a for-loop.

[numberwhun]

Just adding my .02 to this thread.

You can easily modify the ps command to grab the pid by using awk. Here is an example, that you can take and modify accordingly, that will grab the pid for the current sshd process and print it out:

ps | grep /usr/sbin/sshd | grep -v grep | awk '{ print $2 }'
 

[Nepomuk]

Or, using the syntax in my first reply, you could use

ps $(pgrep /usr/sbin/sshd) -o pid=

and get the same result without needing awk or pipes. :-P