如何修改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
关键是10g下修改sys密码需要关闭数据库实例和ASM实例,修改方法是重建密码文件