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

原创于 2021-10-22 09:39:37 发布 · 8.9k 阅读

19 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #数据库 #database

数据库专栏收录该内容

5 篇文章

订阅专栏

博客内容描述了在尝试关闭并重启Oracle数据库时遇到的问题，包括使用'kill-9'命令无效，以及在使用'shutdown'和'startup'命令时遇到的错误。最终通过'shutdown abort'成功关闭数据库，并能正常启动。

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