RE: Hanganalyze not working on 11.1.0.7 on Windows

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 11.1.0.7.0 - 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.

Regards,
Bruce

-----Original Message-----
From: Yong Huang [mailto:yong321_at_yahoo.com] Sent: Wednesday, 10 November 2010 4:23 AM To: Reardon, Bruce (RTABBAY)
Cc: oracle-l_at_freelists.org
Subject: Re: Hanganalyze not working on 11.1.0.7 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":
https://supporthtml.oracle.com/ep/faces/secure/km/BugDisplay.jspx?id=933 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       

--
http://www.freelists.org/webpage/oracle-l