Wednesday, October 09, 2013

How to change password of SYS user on ASM

 

For changing the SYS password on ASM:

In 11.2 we can use asmcmd to change the password as follows

· In single instance environment

$ asmcmd

ASMCMD> passwd sys

Enter old password (optional): ******

Enter new password: ******

· In Cluster environment

ASMCMD> orapwusr --modify --password sys

Enter password: ******

We can not change the password for ASM databases via alter user command.
The password should be the one provided when the password file was created,also REMOTE_LOGIN_PASSWORDFILE should be set to EXCLUSIVE on all instances.

If you want to change the password then you would need to recreate the password file using the orapwd utility

No comments: