Oracle数据库关闭异常（ORA-01089: immediate shutdown in progr

发布时间：2020-12-12 16:07:13 所属栏目：百科来源：网络整理

导读：现象： SQL shutdown immediateORA-24324: service handle not initializedORA-24323: value not allowedORA-01089: immediate shutdown in progress - no operations are permitted 可能关闭的时候出现问题了，查看了一下系统进程，Oracle的进程还在 ps -ef

现象：

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

可以多等一会儿再试

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!