OBIEE 12c – WebLogic Fails to Start After Updating OPSS Password

This issue applies not only to Oracle Business Intelligence Enterprise Edition (OBIEE) 12c, but also to other 12c infrastructure. When a database OPSS user account password expires or when you update the OPSS user account with a new password, you might encounter the following error when you try to bring up the WebLogic Admin server:

Caused by: oracle.security.jps.service.policystore.PolicyStoreConnectivityException: JPS-00027: There was an internal error: java.sql.SQLException: ORA-01017: invalid username/password; logon denied

Or you may see the following error if you keep trying to connect:

Revolutionize Your Business With Generative AI

From product design and software development to virtual agents, content creation, and reporting, GenAI is transforming business. Our AI experts help you unlock GenAI’s full potential and drive growth.

Let’s Get Started

Caused by: oracle.security.jps.service.policystore.PolicyStoreConnectivityException: JPS-00027: There was an internal error: java.sql.SQLException: ORA-28000: the account is locked

Solution:
1) Database steps:

• Unlock the user account if it is locked
• Update/get the database OPSS user account password. For example, let’s assume the password is welcome1.

2) WLST steps:

• Go to <MW_HOME>/oracle_common/common/bin
• Start wlst scripting tool
• Run modifyBootStrapCredential(jpsConfigFile='<MW_HOME>/Oracle_Home/user_projects/domains/MyDomain/config/fmwconfig/jps-config-jse.xml’, username='<schema_owner>’, password='<db user password>’)
  For example:
  wls:/offline> modifyBootStrapCredential(jpsConfigFile=’C:/Oracle/Middleware/Oracle_Home/user_projects/domains/MyDomain/config/fmwconfig/jps-config-jse.xml’, username=’DEV_OPSS’,password=’welcome1′);
  wls:/offline>

3) Restart Admin server and hopefully it will start without any errors.