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>

1 comment:

  1. By what means Might I Change the Oracle SYS Password? Contact to Remote DBA Services
    Is it exact to state that you are examining for romanticizing heading or support that can change your Oracle SYS watchword or fix each and every specific hiccup regarding Oracle database? In case yes, by then your interest closes here, in light of the way that we at Cognegic give complete help and course of action as for Oracle. Our gathering of authorities will work with you and give Online Oracle DB Support or Database Administration for Oracle. We can extend database gainfulness and sustainment.
    For More Info: https://cognegicsystems.com/
    Contact Number: 1-800-450-8670
    Email Address- info@cognegicsystems.com
    Company’s Address- 507 Copper Square Drive Bethel Connecticut (USA) 06801

    ReplyDelete