使用 shutdown immediate 命令关闭数据库,结果报ORA-24324、ORA-24323、ORA-01089等错误

SQL> shutdown immediate;

ORA-24324: service handle not initialized

ORA-24323: value not allowed

ORA-01089: immediate shutdown in progress - no operations are permitted

于是使用shutdown abort命令来关闭数据库,结果报ORA-01031: insufficient privileges

SQL> shutdown abort
ORA-01031: insufficient privileges

解决方法:新开一个XShell客户端,重新登录数据库,然后使用shutdown abort将数据库关闭。

SQL> shutdown abort

ORACLE instance shut down.

SQL>