oam 11.1.2.2.0 chaning OPSS database users password procedure

1)opss-DBDS (DB datasource) needs to be updated: 
--------------------------------- 
Navigate to the Data Source pool 
Weblogic Console > Services > Data Source > opss-DBDS > Connection Pool > Change Password. 

2) Stop all the admin servers.

3) this needs to be run in offline mode.
Run modifyBootStrapCredential(jpsConfigFile='./jps-config.xml', username='<schema_owner>', password='<db user password>')

Example:
modifyBootStrapCredential(jpsConfigFile='/<MW_HOME>/user_projects/domains/mydomain/config/fmwconfig/jps-config.xml', username='DEV_OPSS', password='password1')


below is the oracle recommended way of changing OPSS schema password


1- Take a back up of the opss-jdbc.xml  file
2- Change the password in the wls console, save changes.
3- Stop all WLS servers
OR
1- Stop all WLS servers
2- Change the DATA source password with WLST (offline)
2.1- Run  $MW_HOME/oracle_common/common/bin/wlst.sh to set the wlst environment.
2.2- Use the readDomain WLST command to read the configuration of the domain in offline mode,
wls:/offline>readDomain (‘<WLS_DOMAIN_HOME_PATH>’)

Example:
wls:/offline> readDomain('/refresh/home/Middleware/user_projects/domains/IDMDomain')

2.3- Use cd(‘JDBCSystemResource/<OPSSDS name>/JdbcResource/<OPSSDS name>/JDBCDriverParams/NO_NAME_0’)

Example
wls:/offline>cd(‘JDBCSystemResource/OPSSDS/JdbcResource/OPSSDS/JDBCDriverParams/NO_NAME_0’)

2.4- The WLST set(‘<parameter_name>’,’<parameter_value>’) is used to change a parameter offline. To change the password ,  set(‘PasswordEncrypted’,’<password_value>’)

Example:
wls:/offline/IDMDomain/JDBCSystemResource/OPSSDS/JdbcResource/OPSSDS/JDBCDriverParams/NO_NAME_0>set('PasswordEncrypted','welcome2')

2.5- After all the changes to the parameters are done, the updateDomain() command needs to run to save them to the domain configuration:
Example:
wls:/offline/IDMDomain/JDBCSystemResource/OPSSDS/JdbcResource/OPSSDS/JDBCDriverParams/NO_NAME_0>updateDomain()

2.6- Run  exit() to exit WLST.
Example:
wls:/offline/IDMDomain/JDBCSystemResource/OPSSDS/JdbcResource/OPSSDS/JDBCDriverParams/NO_NAME_0>exit()

2.7- Run exit() to exit WLST.
Example:
wls:/offline/IDMDomain/JDBCSystemResource/OPSSDS/JdbcResource/OPSSDS/JDBCDriverParams/NO_NAME_0>exit()

Later:
3- Change the OPSS schema password in the database
4- Go to the oracle_common\common\bin>wlst.sh
5- Run modifyBootStrapCredential(jpsConfigFile='./jps-config.xml', username='<schema_owner>', password='<db user password>')

Example:
modifyBootStrapCredential(jpsConfigFile='/<MW_HOME>/user_projects/domains/mydomain/config/fmwconfig/jps-config.xml', username='DEV_OPSS', password='welcome1')