RE: Hanganalyze not working on 11.1.0.7 on Windows
- From: "Reardon, Bruce (RTABBAY)" <Bruce.Reardon@xxxxxxxxxxxx>
- To: Yong Huang <yong321@xxxxxxxxx>
- Date: Wed, 10 Nov 2010 10:15:24 +1100
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 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@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@xxxxxxxxx]
Sent: Wednesday, 10 November 2010 4:23 AM
To: Reardon, Bruce (RTABBAY)
Cc: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
