搜索相关解决方案有说必须先关闭所有oracle进程再重启的:kill -9 `ps -ef|grep oracle|awk '{print $2}'`
但依然不好使,得用shutdown abort这个命令
[root@xx ~]# su - oracle
上一次登录:四 10月 21 09:14:50 CST 2021pts/0 上
[oracle@xx]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Thu Oct 21 09:34:45 2021
Copyright (c) 1982, 2013, Oracle. All rights reserved.
SQL> conn /as sysdba
Connected to an idle instance.
SQL> shutdown
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-01090: shutdown in progress - connection is not permitted
SQL> startup
ORA-01031: insufficient privileges
SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup
ORA-01012: not logged on
SQL> select count(*) from dba_objects;
select count(*) from dba_objects
*
ERROR at line 1:
ORA-01012: not logged on
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1.3395E+10 bytes
Fixed Size 2265904 bytes
Variable Size 7079988432 bytes
Database Buffers 6308233216 bytes
Redo Buffers 4759552 bytes
Database mounted.
Database opened.
SQL> exit