Oracle

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:

Data Intelligence - The Future of Big Data
The Future of Big Data

With some guidance, you can craft a data platform that is right for your organization’s needs and gets the most return from your data capital.

Get the Guide

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.

 

About the Author

Raghu is the Senior Technical Architect of Perficient's National Oracle Business Intelligence Practice. He has extensive experience in architecting, designing, developing, and delivering enterprise software solutions, and commercial software products from concept to market. His area of expertise includes application programming, SOA, microservices, integrations, cloud and BI implementation. He has worked for several fortune 500 companies in his career and successfully led several projects from inception to completion by maintaining high quality standards. He has experience working with cross-cultural teams ensuring optimal utilization of resources. He has several certifications across multiple technologies from Oracle, AWS, Microsoft, and Redhat.

More from this Author

Thoughts on “OBIEE 12c – WebLogic Fails to Start After Updating OPSS Password”

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Subscribe to the Weekly Blog Digest:

Sign Up