ORA-24324: service handle not initialized 错误

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

weixin_33768481

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

阅读量218

点赞数

文章标签：数据库

原文链接：https://my.oschina.net/shootercn/blog/52135

版权

为什么80%的码农都做不了架构师？>>>

下面的是网上找到的，做个参考

-----------------------------------------------------------------------------

一次奇怪的数据库启动和关闭经历。

SQL> conn / as sysdba
Connected to an idle instance.

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> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 2499805184 bytes
Fixed Size                  1262368 bytes
Variable Size            1073745120 bytes
Database Buffers         1409286144 bytes
Redo Buffers               15511552 bytes
staDatabase mounted.

Database opened.
SQL> SQL>
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>

shutdown immediate 目前无法正常关闭，可能还存在问题

转载于:https://my.oschina.net/shootercn/blog/52135