ORA-01012: not logged on

ORA-01012: not logged on

一：出现情况：

二：原因分析：

conn / as sysdba 报错ORA-01012: not logged on

发生原因：关闭数据库是shutdown 后面没有接关闭参数中的任何一个。

nomal --->所有连接都断开时才能关闭；

transactional --->等待事务结束后，主动断开连接；

immediate --->主动断开事务和连接

abort --->立刻关闭数据库，这个操作是危险的，不会同步数据，不触发检查点，回滚段直接清 空，相当于掉电，每次启动都要实例恢复。

所以，数据库关闭很慢，这时我一心急，就直接退出了sqlplus,造成Oracle文件被lock,当我再次startup时，操作失败，因为文件依然被锁定状态。报错ORA-01012: not logged on.

后来重启服务，就可以用了，看了oracle的报错解释，更让我费解。虽然问题解决了，但是生产环境是不能随便down机的，所以，这个问题待续…

三：处理方法

kill oracle 进程 或者关掉oracle

ps -ef|grep ora_dbw0_$ORACLE_SID

kill -9 pid

重新启动oracle

sqlplus sys as sysdba

startup;

[oracle@localhost ~]$ sqlplus / as sysdba;

SQL*Plus: Release 11.2.0.3.0 Production on Thu Dec 21 09:45:17 2017

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected.
ERROR:
ORA-01012: not logged on
Process ID: 0
Session ID: 0 Serial number: 0


09:45:17 SYS@orcl  SQL> startup
ORA-01012: not logged on
09:45:29 SYS@orcl  SQL> quit
Disconnected
[oracle@localhost ~]$
[oracle@localhost ~]$
[oracle@localhost ~]$
[oracle@localhost ~]$
[oracle@localhost ~]$ kill oracle
-bash: kill: oracle: arguments must be process or job IDs
[oracle@localhost ~]$ ps -ef|grep ora_dbw0_$ORACLE_SID
oracle    4619     1  0 Dec20 ?        00:00:37 ora_dbw0_orcl
oracle   11382 10996  0 09:47 pts/3    00:00:00 grep ora_dbw0_orcl
[oracle@localhost ~]$ kill -9 4619
[oracle@localhost ~]$ kill 10996
[oracle@localhost ~]$ ps -ef|grep ora_dbw0_$ORACLE_SID
oracle   11386 10996  0 09:47 pts/3    00:00:00 grep ora_dbw0_orcl
[oracle@localhost ~]$ kill 11386
-bash: kill: (11386) - No such process
[oracle@localhost ~]$ ps -ef|grep ora_dbw0_$ORACLE_SID
oracle   11390 10996  0 09:48 pts/3    00:00:00 grep ora_dbw0_orcl
[oracle@localhost ~]$ sqlplus / as sysdba;

SQL*Plus: Release 11.2.0.3.0 Production on Thu Dec 21 09:48:23 2017

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

09:48:23 SYS@orcl  SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area  770035712 bytes
Fixed Size                  1347652 bytes
Variable Size             360714172 bytes
Database Buffers          402653184 bytes
Redo Buffers                5320704 bytes
Database mounted.
ORA-01013: user requested cancel of current operation