Pages

Saturday, May 24, 2014

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>




No comments:

Post a Comment