Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 207
  • Last Modified:

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?
0
xoxomos
Asked:
xoxomos
  • 2
1 Solution
 
sventhanCommented:
try this ...
sqlplus -prelim / as sysdba
0
 
sventhanCommented:
You can try these 2 options ....

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

option2
========
sqlplus /nolog
set _prelim on
connect / as sysdba
0
 
xoxomosAuthor Commented:
Thanx
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now