SQL> oradebug doc event action HANGANALYZE HANGANALYZE - Hang analyze Usage ------- HANGANALYZE( level <ub4>) Try to give in bracket. On Mon, Nov 8, 2010 at 10:18 PM, Dion Cho <ukja.dion@xxxxxxxxx> wrote: > Seems that you can't dump hanganalyze with preliminary connection(-prelim > option). > > ================================ > Dion Cho - Oracle Performance Storyteller > > http://dioncho.wordpress.com (english) > http://ukja.tistory.com (korean) > http://sites.google.com/site/otpack (tpack) > ================================ > > > > On Tue, Nov 9, 2010 at 1:12 PM, Reardon, Bruce (RTABBAY) < > Bruce.Reardon@xxxxxxxxxxxx> wrote: > >> Hi, >> We have had an Oracle instance crashing / hanging (separate email to be >> sent) and not accepting new logins - even sysdba ones. >> >> Next time it happens I'm hoping we can do a sqlplus preliminary connection >> and get a hanganalyze and / or systemstate dump. >> >> So I'm trying as per * >> http://tech.e2sn.com/oracle/troubleshooting/hang/how-to-log-on-even-when-sysdba-can-t-do-so >> *<http://tech.e2sn.com/oracle/troubleshooting/hang/how-to-log-on-even-when-sysdba-can-t-do-so>(also >> at >> *http://oradeblog.blogspot.com/2007/10/sqlplus-prelim-connection.html*<http://oradeblog.blogspot.com/2007/10/sqlplus-prelim-connection.html>, >> *http://arup.blogspot.com/2008/08/diagnosing-library-cache-latch.html*<http://arup.blogspot.com/2008/08/diagnosing-library-cache-latch.html>and >> *http://oraclue.com/2008/09/25/sqlplus-preliminary-connection/*<http://oraclue.com/2008/09/25/sqlplus-preliminary-connection/>) >> but maybe I have missed something? >> >> I'm trying this on 11.1.0.7 Standard Edition on Windows 2003 32 bit. >> >> Whilst I can get a systemstate dump to work, when I try a hanganalyze I >> get the message "Can not perform hang analysis dump without a process state >> object." in the trace file - regardless of whether I try at level 1, 3 or >> 10. >> >> Can someone suggest what I am doing wrong? >> >> The commands I am using are shown below: >> >> D:\oracle\product\11.1.0>set oracle_sid=mysid >> D:\oracle\product\11.1.0>sqlplus -prelim >> Enter user-name: sys as sysdba >> Enter password: >> SQL> oradebug setmypid >> Statement processed. >> SQL> oradebug tracefile_name >> --Path and name of trace file is shown >> SQL> oradebug dump systemstate 10 >> Statement processed. >> SQL> oradebug hanganalyze 3 >> Statement processed. >> SQL> exit >> >> The output in the trace file contains: >> >> *** 2010-11-09 13:33:34.263 >> Processing Oradebug command 'hanganalyze 3' >> >> =============================================================================== >> HANG ANALYSIS: >> >> ERROR: Can not perform hang analysis dump without a process >> state object. >> >> >> =============================================================================== >> >> Thanks, >> Bruce Reardon >> bruce.reardon@xxxxxxxxxxxx >> > > -- Thanks & Regards, Taral Desai