DB:11.2.0.3
OS :Linux 5
My database is in hung state now. I did the below steps
sqlplus -prelim '/as sysdba'
SQL*Plus: Release 11.2.0.3.0 Production on Thu Oct 24 08:18:17 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> oradebug setmypid
Statement processed.
SQL> oradebug unlimit
Statement processed.
SQL> oradebug hanganalyze 3
Statement processed.
SQL> oradebug hanganalyze 3
Statement processed.
SQL> oradebug tracefile_name
/oemdwlk1/oracle/diag/rdbms/eioemd1/eioemd1/trace/eioemd1_ora_14132.trc
SQL> exit
Getting the below output in trace file
Processing Oradebug command 'hanganalyze 3'
===============================================================================
HANG ANALYSIS:
ERROR: Can not perform hang analysis dump without a process
state object and a session state object.
( process=(nil), sess=(nil) )
As per oracle doc How to Collect Diagnostics for Database Hanging Issues (Doc ID 452358.1).
Note: From 11.2.0.2 onwards, hanganalyze will not produce output under a sqlplus "preliminary connection" since it requires a process state object and a session state object. If a hanganalyze is attempted, the trace will output:
HANG ANALYSIS:
ERROR: Can not perform hang analysis dump without a process state object and a session state object.
( process=(nil), sess=(nil) )
Is something i am missing or there is some different steps.
===============================================================================