http://www.forum.askdba.org/ Forum for Oracle DBA's en Sat, 11 Feb 2012 12:03:14 +0000 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>