Followers

Monday, April 27, 2015

How to Change the OPSS Schema Password

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')

No comments:

Post a Comment