,kobe317

With the UNIX kill command to terminate the process

of Oracle: ZDNet China
Friday,cheap barcelona jersey, June 27 2003 11:58 AM As you know, sometimes we need to terminate all of the Oracle processes (process) or specify a set of Oracle processes. When the database is \



When you need a UNIX server to terminate an Oracle instance (instance),kobe bryant jerseys, do the following steps:

ORACLE_SID terminate all Oracle-related processes.
with ipcs pmb command to identify all occupied RAM memory fragments.
ipcrm-m command to use the UNIX release from the occupied RAM.
only Non-AIX: use the ipcs-sa command to display the occupation marked by ipcrm s command to mark the release of the occupier of the instance.
create a single command to terminate with the hang (hung) on the Oracle database instance process is very simple. In the example below us, we use the ps command to identify the Oracle process,lebron james jerseys, then use the awk program to get the process of Oracle process ID (process ID,mlb jerseys, PID). We then entered into the UNIX process ID of the kill command into.

root> ps-ef | grep $ ORACLE_SID | \ grep-v grep | awk '{print $ 2}' | xargs-i kill -9 {}

the termination of After all the Oracle processes, we can check ipcs pmb command to clear the memory and the memory database. We first show that all the memory for the database server:

root> ipcs-pmb

IPC status 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-rw-rw-root root 31008 572 572
m 2 0x411ca945 - rw-rw-rw-root root 8192 572 584
m 4611 0x0c6629c9 - rw-r ----- root root 7216716 1346 23981
m 4 0x06347849 - rw-rw-rw-root root 77384 1346 1361

here we see that Oracle has only one ID = 24064 of the RAM memory. The following command will release the memory fragment:

root> ipcrm-m 24064

ps: ipcs command in the linux system,cheap nba jerseys, this parameter is not-b,barcelona jerseys, according shmid after removing-b with ipcrm-m is possible.
[oracle @ yjjgdb oracle] $ ipcs-pm
------ Shared Memory Creator / Last-op --------
shmid owner cpid lpid
0 ; oracle 2470 2380
32769 oracle 2470 2380
65538 ; oracle 2470 2380

can start the server after