Oracle ASM

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

By October 26, 2014 September 12th, 2016 No Comments

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

Capture1

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

 

 

  1. 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.

 

Capture2

 

SQL> grant sysdba to asmsnmp;

grant sysdba to asmsnmp

*

ERROR at line 1:

ORA-01918: user ‘ASMSNMP’ does not exist

 

Capture3

 

 

  1. 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>

 

Capture4

 

 

Leave a Reply

© 2020 ORACLE-SCN. All Rights Reserved.

error: Content is protected !!