How to change OID 11g database schema (ODS) password
Oracle Internet Directory (OID) is LDAP compliant directory server and stores its data ( schema -attributes/object class/access policy, users and groups) in RDBMS (Oracle Database) under schema ODS (Oracle Directory Store).
When you install Oracle Internet Directory (for OID 11g installation steps click here) it creates following directories
- MW_HOME(WebLogic Home) : This is directory under which you install WebLogic Server and Oracle Identity Management (OID).
- ORACLE_HOME(For OID) : This is directory under MW_HOME (usually Oracle_IDM1) which contains executable/library/binary for Oracle Identity Management Component (OID)
- ORACLE_INSTANCE(For OID) : This is directory (by default under MW_HOME with default name asinst_1) which contains configuration and log files.
OID schema (ODS) password is stored in wallet ($ORACLE_INSTANCE/OID/admin/oidpwdXXXX) and used by OID Middle Tier Process to connect to database. More on Oracle Wallet here
.
If you forgot ODS password and wish to change it then follow below process
1. Shutdown OID using opmnctl stopall
2. Login to OID database with sys or system account and change password
SQL> alter user ODS identified by New_PASSWORD;
3. Login to OID tier and move wallet file (password file to connect from OID tier to database) $ORACLE_INSTANCE/OID/admin/oidpwdXXXX
4. Recreate wallet using
$ORACLE_HOME/ldap/bin/oidpasswd connect=OIDDB create_wallet=true (Set ORACLE_HOME to OID ORACLE_HOME mentioned above, set ORACLE_INSTANCE environment. Make sure TNS_ADMIN is not set . If this is set then set it to $ORACLE_INSTANCE/config)
5. If you have multiple OID instances (OID running on multiple PCs) then copy wallet files to all other OID instances $ORACLE_INSTANCE/OID/admin/oidpwdXXXX
.
If you know ODS password and wish to change password then follow below process
1. Shutdown OID using opmnctl stopall
2. Login to OID tier and recreate database password for ODS schema
$ORACLE_HOME/ldap/bin/oidpasswd connect=OIDDB change_oiddb_pwd=true (Set ORACLE_HOME to OID ORACLE_HOME mentioned above, set ORACLE_INSTANCE variable. Make sure TNS_ADMIN is not set . If this is set then set it to $ORACLE_INSTANCE/config). This command will update password in database and also in wallet (OID tier)
3.If you have multiple OID instances (OID running on multiple PCs) then copy wallet files to all other OID instances $ORACLE_INSTANCE/OID/admin/oidpwdXXXX
.
References :
- 472752.1 How to Unlock/Reset Super User cn=orcladmin When the ODS’s Password Has Been Forgotten or is Unknown ? (Note* Wallet location in this note is wrong for OID 11g)
- Change ODS Password used by OID