首页 » ORACLE » sqlplus ORA-01012: not logged on

sqlplus ORA-01012: not logged on

很有意思,今天又撞上了这个错误,我一直觉的应该把问题当机会,所以有我还是别人遇到问题是我会很高兴,变态!看砖!

[oracle@aix ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 – Production on Fri Jun 10 16:51:33 2011

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected.
ERROR:
ORA-01012: not logged on
SQL> host
[oracle@aix ~]$ oerr ora 1012
01012, 00000, “not logged on”
// *Cause:
// *Action:

[oracle@aix ~]$ ps -ef |grep ora_dbw0_ahjcyl
oracle   24379     1  0 16:00 ?        00:00:00 ora_dbw0_ahjcyl
oracle   25935 25801  0 16:54 pts/2    00:00:00 grep ora_dbw0_ahjcyl
[oracle@aix ~]$ kill -9 24379
[oracle@aix ~]$ ps -ef |grep ora_dbw0_ahjcyl
oracle   25938 25801  0 16:54 pts/2    00:00:00 grep ora_dbw0_ahjcyl
[oracle@aix ~]$ ora

SQL*Plus: Release 10.2.0.4.0 – Production on Fri Jun 10 16:54:28 2011

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL>

问题解决,发生的原因是刚才实例的shutdown immediate 中没反应我强置按了ctrl + c,进程没有正常结束

打赏

目前这篇文章有1条评论(Rss)评论关闭。

  1. Sylvia Abdullah | #1
    2011-12-21 at 16:22

    I found so many interesting stuff in your blog especially its discussion. From the tons of comments on your articles, I guess I am not the only one having all the enjoyment here! keep up the good work.