ORA-01012 not logged on ORA-01012 没有登录

ORA-01012 not logged on
ORA-01012 没有登录


提问:
数据库的session 设置为150
而select count from v$session 才88
但是现在使用sqlplus / as sysdba进不去

sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Thu Jul 23 13:29:54 2009

Copyright  1982, 2007, Oracle.  All Rights Reserved.

Connected.
SQL> select count from v$session;
select count from v$session
*
ERROR at line 1:
ORA-01012: not logged on

alert.log没错啊?
没报错呀


回答:
sysdba连接数据库, 不能运行任何语句, 报错"ORA-01012: not logged on", 告警日志中没有报错信息
1.可能数据库后台进程数超过了数据库参数设置的最大值. 杀数据库后台进程或重启数据库
2.进程数可能超过系统用户的限制或内核限制. 检查系统日志和配置, 杀进程或重启数据库



外部链接:
ORA-01012: not logged on

ORA-01012: not logged on

Connecting to database in sql session getting this error ORA-01012: not logged on.


-fin-