关闭RAC中一个实例卡死

SQL>shutdown immediate


后台日志显示：

Fri Aug 10 14:56:16 2018

Active call for process 43909332 user 'oracle' program 'oracle@scodb01 (TNS V1-V3)'

Active call for process 46006466 user 'oracle' program 'oracle@scodb01 (TNS V1-V3)'

Active call for process 37224684 user 'oracle' program 'oracle@scodb01 (TNS V1-V3)'

Active call for process 17760398 user 'oracle' program 'oracle@scodb01 (TNS V1-V3)'

Active call for process 23855332 user 'oracle' program 'oracle@scodb01 (TNS V1-V3)'

Active call for process 24248536 user 'oracle' program 'oracle@scodb01 (TNS V1-V3)'

Active call for process 40566828 user 'oracle' program 'oracle@scodb01 (TNS V1-V3)'

Active call for process 21168160 user 'oracle' program 'oracle@scodb01 (TNS V1-V3)'

SHUTDOWN: waiting for active calls to complete.


此时，数据库实例关闭夯住。下面KILL 所有上面显示的PID号；


# su - oracle

/home/oracle> ps -ef|grep 43909332

oracle 43909332 1 0 Jan 20 - 0:24 oraclescodb1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

/home/oracle> kill -9 43909332

/home/oracle> kill -946006466

/home/oracle> kill -937224684

/home/oracle> kill -917760398

/home/oracle> kill -923855332

/home/oracle> kill -924248536

/home/oracle> kill -940566828

/home/oracle> kill -921168160


杀完进程后，后台日志继续执行关闭操作，直至成功关闭，解决。