直接修改报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=<ORACLE_HOME>/database/PWD<SID>.ora password=<sys_password>UNIX:orapwd file=<ORACLE_HOME>/dbs/orapw<SID> password=<sys_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)