Pages

Thursday, April 14, 2016

Shutdown Active Processes Prevent Shutdown Operation

Shutdown Active Processes Prevent Shutdown Operation

When shutdown immediate hanged for long, found in user dump a trace file containing messgaes

Trace file showing:

Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining
and Real Application Testing options
ORACLE_HOME = /oracle/app/product/11.1.0/db_1
...
*** 2010-03-30 09:25:58.372
*** SESSION ID:(170.15) 2010-03-30 09:25:58.372
*** CLIENT ID:() 2010-03-30 09:25:58.372
*** SERVICE NAME:(SYS$USERS) 2010-03-30 09:25:58.372
*** MODULE NAME:(sqlplus@piorovm.localdomain (TNS V1-V3)) 2010-03-30 09:25:58.372
*** ACTION NAME:() 2010-03-30 09:25:58.372
...
ksukia: Starting kill, force = 0
ksukia: killed 57 out of 57 processes.

*** 2010-03-30 09:26:03.421
ksukia: Starting kill, force = 0
ksukia: Attempt 1 to re-kill process OS PID=19840.
ksukia: Attempt 2 to re-kill process OS PID=19840..
.
.
.
$ ps -ef grep 19840
...
oracle 7426 11402 0 09:34 pts/1 00:00:00 sqlplus @a.sql
oracle 19840 7426 0 09:34 ? 00:00:00 [oracle] defunct

kill -9 19840

This process 19840 was defunct (dead) as it appeared defunct. So this could not be killed directly with kill -9, instead its parent process sqlplus was killed and shutdown immediate proceeded

kill -9 7426

No comments:

Post a Comment