Skip to main content

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:

Oracle - Guide to Oracle Cloud: 5 Steps to Ensure a Successful Move to the Cloud
Guide to Oracle Cloud: 5 Steps to Ensure a Successful Move to the Cloud

Explore key considerations, integrating the cloud with legacy applications and challenges of current cloud implementations.

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.

 

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

  1. sergio aguirre coronado

    I am getting the next issue, is this correct?

    oracle.security.opss.internal.runtime.ServiceContextManagerImpl getContext
    WARNING: Bootstrap services are used by OPSS internally and clients should never need to directly read/write bootstrap credentials. If required, use Wlst or configuration management interfaces.

    I am still with the issue.

Leave a Reply

Your email address will not be published. Required fields are marked *

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

Raghu Syama

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

Follow Us
TwitterLinkedinFacebookYoutubeInstagram