http://www.forum.askdba.org/ Forum for Oracle DBA's en Thu, 09 Feb 2012 22:16:15 +0000 http://www.forum.askdba.org/topic/database-shutdown-hangs#post-153 Wed, 02 Jun 2010 08:06:12 +0000 Anonymous 153@http://www.forum.askdba.org/ <p>If 'Shutdown Normal' hangs<br /> Symptom:</p> <p>‘Shutdown normal’ has been issued to the Oracle database, but Oracle will not shutdown.<br /> Possible Causes and Remedies:</p> <p>There are two likely causes:</p> <p> 1. ‘Shutdown Normal’ will only shutdown Oracle when there are no remaining connections to Oracle. It is likely therefore that an application still has an active session.</p> <p> Possible Remedies:<br /> * close all open sessions<br /> * or issue a ‘shutdown immediate’.<br /> 2. If using Oracle Parallel Server issuing ‘Shutdown normal’ on more than one node at a time can cause the system to hang. This is a recognised Oracle problem (Oracle 8.0.5).</p> <p> Possible remedies:<br /> * Only issue ‘Shutdown normal’ on one node at a time, and only issue it on the next node when the previous node has completed its shutting down.<br /> * Alternately, use ‘shutdown immediate’ instead. </p> 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>