How to Change password for OIM, MDS, SOAINFRA, OPSS, ORASDPM schema OIM 11g R2

How to Change password for OIM, MDS, SOAINFRA, OPSS, ORASDPM schema OIM 11g R2 from Oracle

SOLUTION

Description of each of the above schema could be found in the following Document

http://docs.oracle.com/cd/E27559_01/core.1112/e28516/meta.htm

Password change for the following schema can be performed in the following ways.

1. Stop all the Managed servers and Application Server.
2. Take a back up of the entire domain and take the backup of the database.
3. Start the Application Server
4. Change the xxxx_OPSS user password.
   1. Execute the following to change the password for xxxx_OPSS:
   2. SQL> alter user xxxx_OPSS identified by <new_pwd_here>;
   3. SQL>commit;
   4. Invoke wlst (oracle_common\common\bin).
   5. Run "modifyBootStrapCredential". See Oracle Fusion Middleware Application Security Guide 11g Release 1 (11.1.1) Chapter 10 Managing the Credential Store - 10.5.4 modifyBootStrapCredentia            modifyBootStrapCredential(jpsConfigFile='<DOMAIN_NAME>/config/fmwconfig/jps-config.xml', username='<xxxx>_OPSS', password='newpassword')
5. Run the setDomainenv.sh under the domain  bin folder ( ./setDomainEnv.sh)
6. Invoke the following command:
   1.  bin/java weblogic.security.Encrypt
   2.  password: <newpassword>
   3. {AES}JHyrhOMB5hVRuDU/pV0qX86qz98ZV0xWXBSEAANA4Gs=
7. Edit the <DOMAIN_NAME>\Config\jdbc\OPSSdbs.xml file:
8. Replace the current encrypted password with the newly encrypted password value e.g.
      {AES}JHyrhOMB5hVRuDU/pV0qX86qz98ZV0xWXBSEAANA4Gs=
9. Save the file.
10. Login to Weblogic Console, Navigate to Services->Data Sources
11. Click on opss-DBDS->Connection Pool and enter the new password set to xxxx_opss in step 4.2 Save
12. Restart Application Server but do not start managed servers.
13. Connect to the database with sqlplus as system user
    1. 1. Execute the following to change the password of xxx_OIM:
       2. SQL> alter user xxx_OIM identified by <new_pwd_here>;
       3. SQL>commit
       4. Execute the following to change the password for xxx_MDS:
       5. SQL> alter user xxx_MDS identified by <new_pwd_here>;
       6. SQL>commit;
       7. Execute the following to change the password for xxx_SOAINFR
       8. SQL> alter user xxx_SOAINFRA identified by new_pwd_here>;
       9. SQL>commit
       10. Execute the following to change the password for xxx_ORASDPM:
       11. SQL> alter user xxx_ORASDPM identified by <new_pwd_here>;
       12. SQL>commit;
14. Check that the passwords have been changed, by trying to login to the database with sqlplus and the four users and the new passwords
15. Open a browser and connect to WebLogic console
16. Navigate to Services->Data Sources
    1. click on oimJMSStoreDS->Connection Pool and enter the new password set to xxx_OIM in step 13.2 above
    2. Click on oimOperationsDB->Connection Pool and enter the new password set to xxx_OIM in step 13.2 above
    3. Click on ApplicationDB->Connection Pool and enter the new password set to xxx_OIM in step 13.2 above
    4. Click on mds-oim->Connection Pool and enter the new password set to xxx_MDS in step 13.5 above
    5. Click on mds-owsm->Connection Pool and enter the new password set to xxx_MDS in step 13.5 above
    6. Click on mds-soa->Connection Pool and enter the new password set to xxx_MDS in step 13.5 above
    7. Click on EDNDataSource->Connection Pool and enter the new password set to xxx_SOAINFRA in step 13.8 above
    8. Click on EDNLocalTxDataSource->Connection Pool and enter the new password set to xxx_SOAINFRA in step 13.8 above
    9. Click on SOADataSource->Connection Pool and enter the new password set to xxx_SOAINFRA in step 13.8 above
    10. Click on SOALocalTxDataSource->Connection Pool and enter the new password set to xxx_SOAINFRA in step 13.8 above
    11. Click on OraSDPMDataSource->Connection Pool and enter the new password set to xxx_ORASDPM in step 13.11 above
17.  Change OIMAuthenticationProvider configuration:
18. In the WebLogic Administrative console, navigate to Security Realms, myrealm, and then Providers.
    1. Click OIMAuthenticationProvider
    2. Click Provider Specific.
    3. In the DBPassword field, enter the new Oracle Identity Manager database schema password
    4. Click Save to save the changes
19. Change domain credential store configuration:
    1. 19.1 Login to Enterprise Manager by using the following URL:
    2. http://ADMIN_SERVER:<PORT_NUMBER>/em
    3. 19.2 Navigate to Weblogic Domain, and then DOMAIN_NAME.
    4. 19.3 Right click navigate to Security, Credentials, and then oim.
    5. 19.4 Select OIMSchemaPassword, and click Edit.
20. In the Password field, enter the new password, and click OK
21. Restart the WLS AdminServer
22. Start the SOA/OIM managed server