May 18, 2016

Change ASMSNMP user password in Oracle 11gr2 RAC

While creating database in RAC, at that time you need ASMSNMP password. If you forgot, then you can follow below steps to reset asmsnmp user password :

log in as grid user or export to  ORACLE ASM-HOME and SID as ASM instance if configured both grid and oracle in one user.

**************************************************
run this on any one of the node
************************************************
Conneted to:
$ sqlplus / as sysasm

SQL> select * from v$pwfile_users;

USERNAME                       SYSDB SYSOP SYSAS
------------------------------ ----- ----- -----
SYS                             TRUE   TRUE   TRUE
ASMSNMP                         TRUE   FALSE FALSE

SQL> exit

-- Connected with grid user:

$ asmcmd
ASMCMD> lspwusr
Username sysdba sysoper sysasm
     SYS   TRUE     TRUE   TRUE
 ASMSNMP   TRUE   FALSE   FALSE

ASMCMD> lspwusr
Username sysdba sysoper sysasm
     SYS   TRUE     TRUE   TRUE
 ASMSNMP   TRUE   FALSE   FALSE

ASMCMD> orapwusr
usage: orapwusr { { { --add | --modify [--password] }[--privilege {sysasm|sysdba|sysoper} ] } | --delete } user
help:  help orapwusr
ASMCMD> orapwusr --modify --password ASMSNMP
Enter password: *******

orapwusr attempts to update passwords on all nodes in a cluster. The command requires the SYSASM privilege to run. A user logged in as SYSDBA cannot change its password using this command.



1 comment:

Translate >>