Resolving a Hung Database not able to login with sysdba -prelim option

Resolving a Hung Database not able to login with sysdba

If database is not connected then use :

sqlplus -prelim  “/ as sysdba”

execute the oradebug hanganalyze command to analyze a hung database

SQL> oradebug hanganalyze 3
Statement processed.
SQL>

Oracle RAC environment, specify the oradebug hanganalyze command:

SQL> oradebug setinst all
SQL> oradebug -g def hanganalyze 3

Note: You can repeat the oradebug hanganalyze command a couple of times to generate dump files for varying process states.

You can get a systemstate dump from a non-RAC system by executing the following set of commands.

SQL> oradebug setmypid
Statement processed.
SQL> oradebug dump systemstate 266
Statement processed.

In RAC:

SQL> oradebug setmypid
SQL> oradebug unlimit
SQL> oradebug -g all dump systemstate 266

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.