Oracle ASM sys用户密码修改方法

Oracle ASM sys用户密码修改方法

Oracle 10g修改asm sys密码的方法是，直接修改passwd file
orapwd file=<ORACLE_HOME>/dbs/orapw<SID> password=<sys_password>

Oracle 11g修改单实例asm sys密码的方法

su - 
$ asmcmd  
ASMCMD> passwd sys  
Enter old password (optional): ******  
Enter new password: ******  

Oracle 11g修改RAC asm sys密码的方法
ASMCMD> orapwusr --modify --password sys  
Enter password: ******  
ASMCMD> exit

 

11grac执行时报错

grid@shdb1:/home/grid>asmcmd
ASMCMD> orapwusr --modify --password sys
Enter password: *****
ORA-15306: ASM password file update failed on at least one node
ORA-15321: cannot set attribute with connected clients
ASMCMD> exit

如果密码忘记，官方建议在修改密码前关闭asm实例
root@shdb1:/root>su - grid
grid@shdb1:/home/grid>cd $ORACLE_HOME/dbs
grid@shdb1:/opt/app/oracrs/grid/dbs>ls
ab_+ASM1.dat hc_+ASM1.dat init.ora
grid@shdb1:/opt/app/oracrs/grid/dbs> orapwd file='orapw+ASM1' entries=5 password=admin
grid@shdb1:/opt/app/oracrs/grid/dbs>scp orapw+ASM1 shdb2:/opt/app/oracrs/grid/dbs/orapw+ASM2
节点1:

SQL> create user asmsnmp identified by asmsnmp;

User created.

SQL> grant sysdba to asmsnmp;

Grant succeeded.

SQL> select * from v$pwfile_users;

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

SQL>

grid@shdb1:/home/grid>asmcmd
ASMCMD> orapwusr --modify --password sys

grid@shdb1:/opt/app/oracrs/grid/dbs>asmcmd
ASMCMD> orapwusr --modify --password sys
Enter password: *****
ASMCMD>

验证

su - oracle
oracle@shdb1:/home/oracle>sqlplus sys/admin@ASM as sysdba