Re: Hanganalyze not working on 11.1.0.7 on Windows

Attach to some other (existing) non-background process after connecting with -prelim and run the hanganalyze then... preferably an idle one as the busy ones may be hung themselves...

--
Tanel Poder
New virtual conference!
http://tech.e2sn.com/virtual-conferences


On Tue, Nov 9, 2010 at 6:12 AM, Reardon, Bruce (RTABBAY) <
Bruce.Reardon_at_riotinto.com> 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?

>


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