system state dump when cannot connect to db instance

$ORACLE_HOME/bin/sqlplus /nolog

SQL> set _prelim on
SQL> connect / as sysdba
Prelim connection established
SQL> !ps -ef|grep pmon        
racusr2  16086     1  0 01:07 ?        00:00:00 ora_pmon_DB21
racusr   19144     1  0 01:20 ?        00:00:00 ora_pmon_DB11
racusr   20483 20473  0 01:24 pts/55   00:00:00 /bin/bash -c ps -ef|grep pmon
racusr   20485 20483  0 01:24 pts/55   00:00:00 grep pmon
crsusr   30764     1  0 00:20 ?        00:00:00 asm_pmon_+ASM1
crsusr   32543     1  0 00:21 ?        00:00:00 mdb_pmon_-MGMTDB

SQL>  oradebug setospid 19144
Oracle pid: 2, Unix process pid: 19144, image: oracle@rwsad13 (PMON)
SQL> oradebug dump hanganalyze_global 3
Statement processed.
SQL> oradebug dump systemstate_global 266
Statement processed.
SQL> oradebug dump systemstate_global 266
Statement processed.
SQL> exit



Related dump for ASM:
SQL> oradebug setmypid
Statement processed.
SQL> oradebug -G all dump systemstate 267
Statement processed.
SQL> oradebug -G all hanganalyze 10
Hang Analysis in /private2/oracle/base/diag/asm/+asm/+ASM1/trace/+ASM1_diag_8233.trc

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26611303/viewspace-1134857/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26611303/viewspace-1134857/