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.
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.
Thank you...
ReplyDelete