修改asm中的sys密码

直接修改报ORA-01109: database not open：

[oracle@prodb2 admin]$ . oraenvORACLE_SID = [prodb2] ? +ASM2[oracle@prodb2 admin]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.5.0 - Production on чǚϥ 7Ղ 6 02:24:48 2018Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Miningand Real Application Testing optionsSQL> SQL> SQL> alter user sys identified by admin;alter user sys identified by admin                             *ERROR at line 1:ORA-01109: database not open

10g中修改密码需要修改密码文件：

cd $GRID_HOME/dbsWINDOWS:orapwd file=/database/PWD.ora password=UNIX:orapwd file=/dbs/orapw password=

测试：

节点2修改密码：[oracle@prodb2 ~]$ cd $ORACLE_HOME/dbs[oracle@prodb2 dbs]$ orapwd file=orapw+ASM2 password=oracle force=y[oracle@prodb2 dbs]$ sqlplus sys/oracle@asm2 as sysdbaSQL*Plus: Release 10.2.0.5.0 - Production on чǚϥ 7Ղ 6 02:43:25 2018Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Miningand Real Application Testing optionsSQL> 节点1测试：[oracle@ocm1 admin]$ sqlplus sys/oracle@asm2 as sysdbaSQL*Plus: Release 10.2.0.5.0 - Production on чǚϥ 7Ղ 6 02:45:31 2018Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Miningand Real Application Testing optionsSQL> show parameter remote_login_passwordfileNAME                     TYPE           VALUE------------------------------------ ---------------------- ------------------------------remote_login_passwordfile        string         EXCLUSIVE

官方建议在修改密码前关闭asm实例，测试中未关闭，远程连接正常。

11g中修改密码相对简单：
single instance：

$ export ORACLE_SID=+ASM$ asmcmdASMCMD> passwd sysEnter old password (optional): Enter new password: ******

Cluster environment

ASMCMD> orapwusr --modify --password sysEnter password: ASMCMD> exit

参考自：
How To Change ASM SYS PASSWORD ? (文档 ID 452076.1)
How to connect to ASM instance from a remote client (Oracle Net) (文档 ID 340277.1)