RE: Hanganalyze not working on on Windows

From: Reardon, Bruce (RTABBAY) <"Reardon,>
Date: Wed, 10 Nov 2010 10:15:24 +1100
Message-ID: <>

Hi Yong,
Thanks for the reply and bug reference.

Whilst trying sqlplus -prelim from 10gR2 vs an 11G database, I found that you can do it with 11g sqlplus prelim connection, if the listener is running.

See below - note that the select from v$instance is just to confirm that the prelim wasn't ignored and that I didn't really have a normal connection.

D:\>set oracle_sid=
D:\>sqlplus -prelim
SQL*Plus: Release - Production on Wed Nov 10 10:12:31 2010 Copyright (c) 1982, 2008, Oracle. All rights reserved. Enter user-name: sys_at_abcd as sysdba
Enter password:
SQL> oradebug hanganalyze 1
Hang Analysis in D:\ORACLE\diag\rdbms\abcd\abcd\trace\abcd_ora_2496.trc SQL> select * from v$instance;
select * from v$instance
ERROR at line 1:
ORA-01012: not logged on
Process ID: 0
Session ID: 0 Serial number: 0

SQL> exit
Disconnected from ORACLE  

The trace file really does have a hang analysis in it.


-----Original Message-----
From: Yong Huang [] Sent: Wednesday, 10 November 2010 4:23 AM To: Reardon, Bruce (RTABBAY)
Subject: Re: Hanganalyze not working on on Windows

The problem seems to be specific to 11g, both R1 and R2, regardless platform (you can find this string "Can not perform hang analysis dump..."
in 11g oracle binary). The bug is filed against 11gR1 on Linux but with comment "Affects Platform Generic": 9579&bugProductSource=Oracle

Since session and process state objects can be created in 10g, I guess the -prelim option of sqlplus in 10g is not as lightweight as in 11g.

Yong Huang       

Received on Tue Nov 09 2010 - 17:15:24 CST

Original text of this message