Could not validate ASMSNMP password due to following error- "ORA-01031: insufficient privileges"



Could notvalidate ASMSNMP password due to following error- "ORA-01031: insufficientprivileges"

这个是安装RAC之DBCA这个步骤报错

其实密码是对的

解决如下：

先确保oracle组是否正确，还有/etc/hosts是不是对的

[oracle@rac01]$ id
uid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),503(asmadmin)

这里asmadmin是sysasm的，这里应该是asmdba，而不是sysadmin。

用root用户，修改oracle的用户组

[root@rac01 ~]# usermod -G oinstall,dba,asmdba oracle

[root@rac01 ~]# id oracle
uid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),504(asmdba)

如果以上都没问题，问题还是没解决，就用以下方法：

How to resolve Could not validate ASMSNMP password due tofollowing error- "ORA-01031: insufficient privileges"
Oracle 11g R2 grid
goto grid home /bin    

#  cd/u01/11.2.0.3/grid/bin/          cd/u01/11.2.0.3/grid/dbs/
[grid@rac01 bin]$ orapwd file= cd /u01/11.2.0.3/grid/dbs/orapw+ASMpassword=123456
[grid@rac01 dbs]$ scp orapw+ASM  rac02:/u01/11.2.0.3/grid/dbs/

Login in to Oracle database as
export ORACLE_SID=+ASM1
export ORACLE_HOME=/u01/11.2.0.3/grid/
[grid@rac01 bin]$ sqlplus / as sysasm
SQL>create user asmsnmp identified 123456;
SQL> grant sysdba to asmsnmp;

 

然后再验证asmsnmp的密码就可以了。