如何修改ASM的sys密码
SQL> select INSTANCE_NAME from v$instance;INSTANCE_NAME----------------+ASMSQL> ALTER USER sys IDENTIFIED BY <new_password> REPLACE <old_password>;ALTER USER sys IDENTIFIED BY <new_password> REPLACE <old_password>*ERROR at line 1:ORA-01109: database not openThe following error also might occur:SQL> alter user sys identified by ;alter user sys identified by*ERROR at line 1:ORA-01031: insufficient privileges

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

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

关键是10g下修改sys密码需要关闭数据库实例和ASM实例，修改方法是重建密码文件