今天打开数据库,用SQLPLUS连接上后就出现:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
重起OS也不行,想SHUTDOWN就说NOT LOGGED ON,
想STARTUP也是一样,NOT LOGGED ON
真是见鬼啊,请大家帮忙!
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
重起OS也不行,想SHUTDOWN就说NOT LOGGED ON,
想STARTUP也是一样,NOT LOGGED ON
真是见鬼啊,请大家帮忙!
NOT LOGGED ON指的是你在用startup或shutdown之前首先得用connect internal连库的。
eg:
c:>svrmgrl
svrmgrl>connect internal
svrmgrl>startup force
Connected.
SVRMGR> shutdown immediate
ORA-01012: not logged on
SVRMGR> connect system/manager
ORA-01033: ORACLE initialization or shutdown in progress
SVRMGR> connect internal/oracle
Connected.
SVRMGR> select sysdate from dual;
select sysdate from dual
*
ORA-01012: not logged on
SVRMGR>
不管怎么样,执行操作就是not logged on,我肯定早就登陆了。
SQL> connect internal/oracle
ERROR:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not existSQL> shutdown
ORA-01012: not logged on
SQL>