解决oracle异常ORA-01012: not logged on

搜索相关解决方案有说必须先关闭所有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