ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ora-01031

ora-01031

原创 Linux操作系统 作者:guhufeiying 时间:2011-06-16 17:12:06 0 删除 编辑
[oracle@oracle ~]$ sqlplus / as sysdba
ORA-01031: insufficient privileges


[oracle@oracle ~]$ sqlplus sys/oracle as sysdba
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL>

[oracle@oracle ~]$ oerr ora 01031
01031, 00000, "insufficient privileges"
// *Cause: An attempt was made to change the current username or password
//         without the appropriate privilege. This error also occurs if
//         attempting to install a database without the necessary operating
//         system privileges.
//         When Trusted Oracle is configure in DBMS MAC, this error may occur
//         if the user was granted the necessary privilege at a higher label
//         than the current login.
// *Action: Ask the database administrator to perform. the operation or grant
//          the required privileges.
//          For Trusted Oracle users getting this error although granted the
//          the appropriate privilege at a higher label, ask the database
//          administrator to regrant the privilege at the appropriate label.


解决方式:
1 export ORACLE_SID=XXXX
2 vi $ORACLE_HOME/network/admin/sqlnet.ora
SQLNET.AUTHENTICATION_SERVICES= (NTS)
或者
SQLNET.AUTHENTICATION_SERVICES= (ALL)
或者为空
3 vi $ORACLE_HOME/rdbms/lib/config.c 
#define SS_DBA_GRP "oracle" /*oracle改为dba*/
#define SS_OPER_GRP "oracle" /*oracle改为dba*/
  relink all

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/16546776/viewspace-700075/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 重新创建undotbs
请登录后发表评论 登录
全部评论

注册时间:2011-02-17

  • 博文量
    20
  • 访问量
    34507