Re: Hanganalyze not working on 11.1.0.7 on Windows
- From: Taral Desai <taral.desai@xxxxxxxxx>
- To: ukja.dion@xxxxxxxxx
- Date: Tue, 9 Nov 2010 07:45:51 -0600
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
Other related posts:
