Use the kill command of UNIX to terminate all Oracle Processes

As you know, it is sometimes necessary to terminate all Oracle processes or a specified set of Oracle processes. When the database ldquo; locks rdquo, and you cannot enter

As you know, it is sometimes necessary to terminate all Oracle processes or a specified set of Oracle processes. When the database ldquo; locks rdquo, and you cannot enter

As you know, it is sometimes necessary to terminate all Oracle processes or a specified set of Oracle processes. When the database is "locked" and you cannot enter Server Manager to "gently" Terminate the database, you can use the kill command in UNIX to terminate all Oracle processes-this is one of the common uses of the kill command.

To terminate an Oracle instance on a UNIX server, perform the following steps:

Terminate all Oracle processes related to ORACLE_SID.

Use the ipcs-pmb command to identify all occupied RAM memory fragments.

Use the ipcrm-m command to release the occupied RAM memory from UNIX.

For Non-AIX only: Use the ipcs-sa command to display the occupation mark, and use the ipcrm-s command to release the occupation mark of the instance.

It is very easy to create a single command to terminate the Oracle process related to the hung database instance. In the following example, we use the ps command to identify the Oracle process, and then use the awk program to obtain the process ID (PID) of the Oracle process ). Then, we enter the process ID in the kill command of UNIX.

Root> ps-ef | grep ora _ | \
Grep-v grep | awk '{print $2}' | xargs-I kill-9 {}

After terminating all Oracle processes, we can use the ipcs-pmb command to check the occupied memory and clear the memory occupied by the database. We first show all memory usage on the database server:

Root> ipcs-pmb

Ipstatus from/dev/kmem as of Mon Sep 10 16:45:16 2001
T ID KEY MODE OWNER GROUP SEGSZ CPID LPID
Shared Memory:
M 24064 0x4cb0be18 -- rw-r ----- oracle dba 28975104 1836 23847
M 1 0x4e040002 -- rw-root 31008 572 572
M 2 0x411ca945 -- rw-root 8192 572 584
M 4611 0x0c6629c9 -- rw-r ----- root 7216716 1346
M 4 0x06347849 -- rw-root 77384 1346

Here, we can see that Oracle only has one RAM memory with ID = 24064. The following command releases the memory segment:

Root> ipcrm-m 24064