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的密码就可以了。