Hang Analysis

++++++++++========================++++++++++++++++++++++++++++++

Hang Analysis

===========================

When the Database does not respod and it is not allowing to login as sysdba.

Login using sqlplus -prelim "/as sysdba" or sqlplus nologging

Run the below hang analysis command

[oracle@sec40-3]/oicappdb2/OICTEST/db/tech_st/10.2.0/admin/OICTEST_sec40-3/bdump# sqlplus -prelim "/as sysdba"

SQL*Plus: Release 10.2.0.5.0 - Production on Thu Feb 7 10:26:02 2013

Copyright (c) 1982, 2010, Oracle. All Rights Reserved.

SQL> select name from v$database;

select name from v$database

*

ERROR at line 1:

ORA-01012: not logged on

SQL> oradebug hanganalyze 3

Hang Analysis in /oicappdb2/OICTEST/db/tech_st/10.2.0/admin/OICTEST_sec40-3/udump/oictest_ora_13268.trc

SQL> oradebug setmypid

Statement processed.

SQL> oradebug dump systemstate 10

Statement processed.