How to resolve Could not validate ASMSNMP password due to following error- “ORA-01031: insufficient privileges”

Could not validate ASMSNMP password due to following error – “ORA-01031: insufficient privileges”

SOLUTION:

 

1. Go to Grid Home

[oracle@rac1 ~]$ cd $ORACLE_HOME

[oracle@rac1 grid]$ cd bin

[oracle@rac1 bin]$ pwd

/u01/app/11.2.0.3/grid/bin

 

 

2. Connect to ASM instance and check whether the user ASMSNMP exists.

[oracle@rac1 bin]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Sat May 24 08:09:49 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> conn / as sysasm

Connected.

 

 

SQL> grant sysdba to asmsnmp;

grant sysdba to asmsnmp

*

ERROR at line 1:

ORA-01918: user ‘ASMSNMP’ does not exist

 

 

 

3. Create the ASMSNMP user and grant the SYSDBA privilege to it.

SQL> create user asmsnmp identified by oracle;

User created.

SQL> grant sysdba to asmsnmp;

Grant succeeded.

SQL>