Friday, July 11, 2014

How to reset the Password for ASMSNMP user in an ASM instance?


**************************************** Step By Step Procedure ******************************************************

Well Resetting the password for ASMSNMP user is same as of any other oracle user.

Here we will see 2 methods to achieve it.

#########################################
# 1) Using Alter User Command
#########################################

Set ASM Environment and Login to the instance as "sysasm" privilege and reset password like below.
SQL> Alter user asmsnmp identified by welcome123;
User altered.

=====================================================================================================================

#########################################
# 2) Using ASMCMD Prompt
#########################################

We can modify the password for ASMSNMP user using asmcmd command "orapwusr"

orapwusr --modify --password asmsnmp

[oracle@host01 ~]$ asmcmd -p
ASMCMD [+] > lspwusr
Username sysdba sysoper sysasm
     SYS   TRUE    TRUE   TRUE
 ASMSNMP   TRUE   FALSE  FALSE
ASMCMD [+] >

ASMCMD [+] > orapwusr --modify --password asmsnmp
Enter password: **********
ASMCMD [+] > 

=====================================================================================================================
 Comments Are Always welcome
=====================================================================================================================

5 comments:

Anonymous said...

Is it same when more than one node involved? Is it same process in 12c ?

Anonymous said...

Once after resetting the password how to validate

Sri said...

The method is same independent of the number of nodes. I'm not sure in 12c but i'm expecting it will work in same method.

When you asmca or dbca and registering database in OEM you may validate it.

nico said...

To modify the password with sqlplus, it requires connect / as sysasm. With sysdba it will fail with "insufficient privileges"

Sri said...

Thanks Nico. Added the login information as per your suggestion. Appreciate your feedback.