Hang Analysis On Hung Database

I need to run the oradebug hanganalyze  when our database hangs.  I want to:
conn / as sysdba
 oradebug setmypid
 oradebug hanganalyze 3
... Wait at least 2 minutes to give time to identify process state changes.
 oradebug hanganalyze 3
... Wait at least 2 minutes to give time to identify process state changes.
 oradebug dump systemstate 266

Problem is the database hangs at the first step (conn / as sysdba)
Is there a way of getting around that?
xoxomosAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
sventhanConnect With a Mentor Commented:
You can try these 2 options ....

option1
=======
sqlplus -prelim / as sysdba

option2
========
sqlplus /nolog
set _prelim on
connect / as sysdba
0
 
sventhanCommented:
try this ...
sqlplus -prelim / as sysdba
0
 
xoxomosAuthor Commented:
Thanx
0
All Courses

From novice to tech pro — start learning today.