首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > 其他数据库 >

怎么修改ASM的sys密码

2013-09-08 
如何修改ASM的sys密码SQL select INSTANCE_NAME from v$instanceINSTANCE_NAME----------------+ASMSQL

如何修改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实例,修改方法是重建密码文件

热点排行