**************************************** 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:
Is it same when more than one node involved? Is it same process in 12c ?
Once after resetting the password how to validate
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.
To modify the password with sqlplus, it requires connect / as sysasm. With sysdba it will fail with "insufficient privileges"
Thanks Nico. Added the login information as per your suggestion. Appreciate your feedback.
Post a Comment