Sunday, March 27, 2016

ORA-01031: insufficient privileges Could not validate ASMSNMP password

ORA-01031: insufficient privileges Could not validate ASMSNMP password

In Oracle 11gR2 grid
On one of the rac node create a asm password file and copy the file to remaining nodes of the cluster

grid@test1 bin]$ orapwd file=/u01/app/11.2.0/grid/dbs/orapw+ASM password=oracleasm

grid@test1 dbs]$ scp orapw+ASM node2:/u01/app/11.2.0/grid/dbs/

grid@test1 dbs]$ scp orapw+ASM node3:/u01/app/11.2.0/grid/dbs/

Login in to Oracle database as

export ORACLE_SID=+ASM1

export ORACLE_HOME=/u01/app/11.2.0/grid

grid@test1 bin]$ sqlplus / as sysasm

SQL>create user asmsnmp identified by oracleasm

SQL> grant sysdba to asmsnmp;

No comments:

Post a Comment