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