Friday, December 30, 2011

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


Platform: Oracle 11g R2 grid

At Fist Node's $ prompt execute


$ orapwd file= $GRID_HOME /dbs/orapw+ASM1 entries=5 password=your-password


At Fist Node's $ prompt execute


$ orapwd file=$GRID_HOME/dbs/orapw+ASM2 entries=5 password=your-password


From any of the node as 11g Grid Infrastructure owner execute:


export ORACLE_SID=+ASM1

export ORACLE_HOME=/u01/app/11.2.0/grid


[grid@node1 bin]$ sqlplus / as sysasm


SQL>create user asmsnmp identified by your-password;


SQL> grant sysdba to asmsnmp;


No comments:

Post a Comment