oracle异常关闭，启动：ORA-24324: service handle not initialized

最新推荐文章于 2022-06-01 14:54:43 发布

前功尽弃

最新推荐文章于 2022-06-01 14:54:43 发布

阅读量2.9w

点赞数 5

CC 4.0 BY-SA版权

分类专栏：数据库文章标签： oracle ORA-24324 ORA-01041 ORA-01089

本文链接：https://blog.youkuaiyun.com/qq_24755999/article/details/78562451

数据库专栏收录该内容

4 篇文章

订阅专栏

本文介绍了Oracle数据库在异常关闭后，尝试重新启动时遇到的问题及解决步骤。具体表现为启动时出现ORA-24324等错误，通过sysdba权限强制关闭并重新启动解决了问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

oracle关闭异常，再次启动时错误信息如下：

SQL> shutdown immediate;
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-01089: immediate shutdown in progress - no operations are permitted
SQL> startup mount;
ORA-01031: insufficient privileges

SQL> conn xxx;  
Enter password: 
ERROR:
ORA-01089: immediate shutdown in progress - no operations are permitted
Process ID: 0
Session ID: 0 Serial number: 0


Warning: You are no longer connected to ORACLE.

解决办法：

[oracle@localhost ~]$ sqlplus / as sysdba;

SQL*Plus: Release 11.2.0.4.0 Production on Fri Nov 17 15:44:52 2017

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected.
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 2438529024 bytes
Fixed Size          2255672 bytes
Variable Size         671089864 bytes
Database Buffers     1744830464 bytes
Redo Buffers           20353024 bytes
Database mounted.
Database opened.