Tuesday, March 4, 2014

Steps to change the ODS password to new value




If you want to change the ODS password to a new value, follow the below steps. 





1.    Set ORACLE_HOME to OID_ORACLE_HOME
2.    Set ORACLE_INSTANCE to asinst_home
4.      Shutdown OID using opmnctl stopall
5.    Login to OID database with sys or system account and change password
SQL>
 alter user ODS identified by New_PASSWORD;
6.    $ORACLE_HOME/ldap/bin/oidpasswd connect=OIDDB change_oiddb_pwd=true .  This command will update password in database and also in wallet
7.    If you have multiple OID , then copy wallet files to all other OID instances $ORACLE_INSTANCE/OID/admin/oidpwdXXXX

No comments:

Post a Comment