[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博客

ora-01031