$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博客

system state dump when cannot connect to db instance

最新文章