Tuesday, October 18, 2011

Change ASM sys password (10gR2)

In order to change an ASM instance sys password do the following :


1. Set the ORACLE_HOME and ORACLE_SID to the ASM instance
2. connect /as sysdba from sqlplus
3. If the value of the "remote_login_passwordfile" parameter in the pfile or spfile is EXCLUSIVE, you must shutdown your instance
4. RENAME or DELETE the existing password file PWD<SID>.ora( In Windows) / orapw<SID> ( in UNIX)
5. Issue the command:
WINDOWS:
orapwd file=<ORACLE_HOME>/database/PWD<SID>.ora password=<sys_password>

UNIX:
orapwd file=<ORACLE_HOME>/dbs/orapw<SID> password=<sys_password>

No comments:

Post a Comment