Oracle数据库关闭异常（ORA-01089: immediate shutdown in progress - no operations are permitted）的解决方法

现象：

SQL> shutdown immediate ORA-24324: service handle not initialized ORA-24323: value not allowed ORA-01089: immediate shutdown in progress - no operations are permitted 可能关闭的时候出现问题了，查看了一下系统进程，Oracle的进程还在

ps -ef | grep oratest

oratest 29286 1 0 Jul12 ? 00:00:26 ora_pmon_TEST oratest 29288 1 0 Jul12 ? 00:00:00 ora_psp0_TEST oratest 29290 1 0 Jul12 ? 00:00:00 ora_vktm_TEST oratest 29294 1 0 Jul12 ? 00:00:00 ora_gen0_TEST oratest 29296 1 0 Jul12 ? 00:00:00 ora_diag_TEST oratest 29298 1 0 Jul12 ? 00:00:00 ora_dbrm_TEST oratest 29300 1 0 Jul12 ? 00:26:23 ora_dia0_TEST oratest 29302 1 0 Jul12 ? 00:00:00 ora_mman_TEST oratest 29304 1 0 Jul12 ? 00:00:00 ora_dbw0_TEST oratest 29306 1 0 Jul12 ? 00:00:00 ora_lgwr_TEST oratest 29308 1 0 Jul12 ? 00:00:00 ora_ckpt_TEST oratest 29310 1 0 Jul12 ? 00:00:18 ora_smon_TEST oratest 29312 1 0 Jul12 ? 00:00:00 ora_reco_TEST 解决方法：先 shutdown abort ，再 startup ，或者 start force.

如果shutdown abort也报错：

SQL> shutdown abortORA-01031: insufficient privileges

可以多等一会儿再试