Linux下oracle 10g 中关闭数据库错误

最新推荐文章于 2022-03-14 10:14:11 发布

原创最新推荐文章于 2022-03-14 10:14:11 发布 · 678 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #数据库 #linux #service #system #sql

Linux 同时被 2 个专栏收录

13 篇文章

订阅专栏

Oracle

10 篇文章

订阅专栏

本文记录了一次不同寻常的数据库启动和关闭过程，包括遇到的错误如ORA-24324服务句柄未初始化、ORA-01089立即关闭进程中不允许操作等，并展示了如何通过abort模式关闭后成功重启数据库。

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

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>