http://www.forum.askdba.org/ AskDBA.org Forum » Topic: Database shutdown hangs. en Fri, 30 Jul 2010 08:55:21 +0000 http://www.forum.askdba.org/topic/database-shutdown-hangs#post-123 Wed, 20 Jan 2010 14:42:21 +0000 Saurabh Sood 123@http://www.forum.askdba.org/ <p>Hi Pratheep,</p> <p>Processes with status "D" cannot be killed at all. They are in "D" status because they are sleeping and waiting for a resource like "Kernel lock" etc. which they will never get.</p> <p>If you are seeing these ospid in v$process they will not allow "shutdown immediate" or "shutdown abort".</p> <p>The only way to remove such processes is to "reboot" server.</p> <p>These processes cannot be traced down.</p> <p>Check If you can apply Dead Connection detection (DCD) to avoid such situations in future.</p> <p>Cheers!!! </p> http://www.forum.askdba.org/topic/database-shutdown-hangs#post-122 Wed, 20 Jan 2010 04:25:12 +0000 pratheep 122@http://www.forum.askdba.org/ <p>Hi,</p> <p>One of my production database shutdown process hangs every planned shutdown. (Both shutdown immediate and abort options). </p> <p>Database version &amp; OS : 10.2.0.4 on SuSe Linux 10 SP2, All the latest patches, cpus installed.</p> <p>Some of the active database server process are preventing the database from shutdown. I tried to kill the process from OS root user also. But the process are not closing. When I check ps command the process are in 'D' state (uninterruptable sleep). For the particular pid, strace command also stuck. As I verified in v$session before shutdown immediate there is no active sessions or jobs in database. But above mentioned "D" state pid's are exist in v$process.<br /> Please suggest me, how to find the history of the process.? like when it is hanged/which session id/which sql statement caused that..?</p> <p>Thank you all,<br /> Pratheep </p>