Hi Bruce, 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@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? >