现象:
- 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 abort
ORA-01031: insufficient privileges
可以多等一会儿再试