未完全关闭数据库导致ORA-01012: not logged的解决

在启动oracle服务的时候报了如下错：

SQL> startup
ORA-01012: not logged on

网上资料讲是没有正常关闭，解决方法是kill相关进程。

[root@localhost admin]# ps -ef|grep ora_dbw0
oracle     2245      1  0 21:01 ?        00:00:00 ora_dbw0_orcl
root       2729   1722  0 21:08 pts/1    00:00:00 grep --color=auto ora_dbw0

查找到ora_dbw0进程id为2245

[root@localhost admin]# kill -9 2245

再次启动解决问题，一定要重新登录才生效，直接在原来登录的命令行中输入startup是无效的，一定要如下：

-bash-4.2$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon Sep 24 21:09:57 2018

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

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1068937216 bytes
Fixed Size		    2220200 bytes
Variable Size		  616566616 bytes
Database Buffers	  444596224 bytes
Redo Buffers		    5554176 bytes
ORA-00205: error in identifying control file, check alert log for more info