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.