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('/opt/Middleware/user_projects/domains/soa_domain')
2.3- Use cd(‘JDBCSystemResource/<OPSSDS name>/JdbcResource/<OPSSDS name>/JDBCDriverParams/NO_NAME_0’)
Where "OPSSDS name" is data source name. The data source name can be found in DOMAIN_HOME/config/jdbc/opss-jdbc.xml.
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/soa_domain/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/soa_domain/JDBCSystemResource/OPSSDS/JdbcResource/OPSSDS/JDBCDriverParams/NO_NAME_0>updateDomain()
2.6- Run exit() to exit WLST.
Example:
wls:/offline/soa_domain/JDBCSystemResource/OPSSDS/JdbcResource/OPSSDS/JDBCDriverParams/NO_NAME_0>exit()
2.7- Run exit() to exit WLST.
Example:
wls:/offline/soa_domain/JDBCSystemResource/OPSSDS/JdbcResource/OPSSDS/JDBCDriverParams/NO_NAME_0>exit()
Later:
3- Change the OPSS schema password in the database
4- The next steps are required if there is a bootstrap credential map specified in the "props.db.1" section in jps-config.xml
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='/opt/Middleware/user_projects/domains/soa_domain/config/fmwconfig/jps-config.xml', username='DEV_OPSS', password='welcome1')
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('/opt/Middleware/user_projects/domains/soa_domain')
2.3- Use cd(‘JDBCSystemResource/<OPSSDS name>/JdbcResource/<OPSSDS name>/JDBCDriverParams/NO_NAME_0’)
Where "OPSSDS name" is data source name. The data source name can be found in DOMAIN_HOME/config/jdbc/opss-jdbc.xml.
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/soa_domain/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/soa_domain/JDBCSystemResource/OPSSDS/JdbcResource/OPSSDS/JDBCDriverParams/NO_NAME_0>updateDomain()
2.6- Run exit() to exit WLST.
Example:
wls:/offline/soa_domain/JDBCSystemResource/OPSSDS/JdbcResource/OPSSDS/JDBCDriverParams/NO_NAME_0>exit()
2.7- Run exit() to exit WLST.
Example:
wls:/offline/soa_domain/JDBCSystemResource/OPSSDS/JdbcResource/OPSSDS/JDBCDriverParams/NO_NAME_0>exit()
Later:
3- Change the OPSS schema password in the database
4- The next steps are required if there is a bootstrap credential map specified in the "props.db.1" section in jps-config.xml
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='/opt/Middleware/user_projects/domains/soa_domain/config/fmwconfig/jps-config.xml', username='DEV_OPSS', password='welcome1')