dbazone

Kill Oracle process from UNIX server

Posted on December 25th, 2009 in Oracle on Linux Kill Oracle process from UNIX server, terminate all Oracle processes associated with my hung database

In some scenarios , my database may be hung and as a DBA ,I have terminate all Oracle processes associated with my hung database.

Steps to kill oracle process and release memory associated by oracle server

1. Kill all Oracle processes associated with the ORACLE_SID

Executing following command we can check all oracle process associated with the database.

#  ps -ef | grep $ORACLE_SID

Executing the following powerful command , we can remove all the process associated with our database.

# ps -ef|grep $ORACLE_SID|
grep -v grep|awk ‘{print $2}’|xargs -i kill -9 {}

2. Identify all RAM memory segments associated

Check all RAM memory associated with by executing the following command.

#ipcs –pm

Release all the RAM memory segments with the following command.

#ipcrm –m

3. Check the semaphores

Check semaphores held by executing the following command.

#ipcs –sa

Release the held semaphores for the instance by executing following command.

# ipcrm –s

Killing stubborn UNIX processes

If  you  faced a situation where a process continues to display with the ps command, even after you have issued a kill -9 command against the process, then you have to follow  this special command to kill the process.The stubborn process can be killed by piping the null device (/dev/null) to the ttyname as a part of the kill command.

The following command is indispensable when killing stubborn UNIX process

cat /dev/null > /dev/ttyname kill –9 pid#

Related posts:

1. Controling jobs on UNIX systems UNIX  job monitoring and control facilities allows you to monitor...
2. Monitoring background Jobs on UNIX systems To monitor background jobs on UNIX, you can use the...
3. Killing Oracle Sessions There are different ways to kill oracle sessions From  SQL*PLUS...
4. Useful UNIX command for oracle dba 1).To find the top 10 larger files in the Directory...
5. Background jobs on Unix impact on System Performance Is your background jobs on Unix impact on System Performance?...

Related posts brought to you by Yet Another Related Posts Plugin.