之前正常使用的一个环境,在linux的oracle用户下使用sqlplus / as sysdba进入sysdba用户。之后服务器断电了,启动服务器之后,sqlplus / as sysdba命令报权限不足的错误。-rw-r--r-- 1 oracle oinstall 58430 Jun 7 2012 xxxx.xx
-rw-r--r-- 1 oracle oinstall 18043 Jun 7 2012 yyyy.yy
linux150 /opt/oracle> cat /etc/group | grep oinstall
oinstall:!:501:scuspls,scu08,scu04,scuzod,scu54,sysomc
linux150 /opt/oracle> cat /etc/passwd | grep oracle
oracle:x:1041:501::/opt/oracle:/usr/bin/csh
linux150 /opt/oracle> sqlplus / as sysdbaSQL*Plus: Release 11.1.0.7.0 - Production on Tue Dec 25 17:39:56 2012Copyright (c) 1982, 2008, Oracle. All rights reserved.ERROR:
ORA-01031: insufficient privilegesEnter user-name:
-rw-r--r-- 1 oracle oinstall 18043 Jun 7 2012 yyyy.yy
linux150 /opt/oracle> cat /etc/group | grep oinstall
oinstall:!:501:scuspls,scu08,scu04,scuzod,scu54,sysomc
linux150 /opt/oracle> cat /etc/passwd | grep oracle
oracle:x:1041:501::/opt/oracle:/usr/bin/csh
linux150 /opt/oracle> sqlplus / as sysdbaSQL*Plus: Release 11.1.0.7.0 - Production on Tue Dec 25 17:39:56 2012Copyright (c) 1982, 2008, Oracle. All rights reserved.ERROR:
ORA-01031: insufficient privilegesEnter user-name:
2)检查ora_dba组是否有用户:root.sh
3)/u01/app/oracle/product/10.2.0/db_1/dbs下面的alert
是否存在ORA-12640这个错误,如果有请尝试做如下修改,并重启数据库
==============================================
把sqlnet.ora中的SQLNET.AUTHENTICATION_SERVICES= (NTS) 改成
SQLNET.AUTHENTICATION_SERVICES= (NONE)