Wednesday, February 15, 2017

WebLogic Admin Server Fails to Start after Updating OPSS Password

This problem affects all 12c Oracle infrastructures running on Weblogic.

While attempting to start the WebLogic Admin server after the OPSS schema password is changed, you can run across the following issue.


Caused by: oracle.security.jps.service.credstore.CredStoreException: JPS-01055: Could not create credential store instance. Reason oracle.security.jps.service.policystore.PolicyStoreException: Can not connect DB with URL [jdbc:oracle:thin:@//<HOSTNAME>:<PORT>/SERVICE NAME]

 

Caused by: oracle.security.jps.service.policystore.PolicyStoreException: Can not connect DB with URL [jdbc:oracle:thin:@//<HOSTNAME>:<PORT>/SERVICE NAME]

 

Caused by: java.sql.SQLException: ORA-01017: invalid username/password; logon denied



Solution:


Step 1: Encrypt the new password and update the encrypted password in the OPSS datasource xml file.

 

  
-bash-4.2$ cd /u01/app/oracle/admin/dev_domain/aserver/dev_domain/bin/

-bash-4.2$ . setDomainEnv.sh

-bash-4.2$ java weblogic.security.Encrypt

Password:

{AES}IBb1q1YkLlymVhJXdLdvOvJKDTDNU/7fz00IZV3scf=

 

Update the encrypted password in the below files under <Domain_home>/config/JDBC

 

        opss-datasource-jdbc.xml

        LocalSvcTblDataSource-jdbc.xml

        opss-audit-jdbc.xml

        opss-auditview-jdbc.xml

        WLSSchemaDataSource-jdbc.xml


 

Step 2: Use the Weblogic scripting tool(WLST) to update the bootstrap credential store with the correct password and username.

 

Launch WLST

 

<Oracle_home>/oracle_common/common/bin/wlst.sh

 


modifyBootStrapCredential(jpsConfigFile='<Domain_home>/config/fmwconfig/jps-config-jse.xml',username='<schema_prefix>_OPSS',password='new_password')

exit()

 

 

Step 3:

 

Start Admin Server by clearing tmp/cache.

A Comprehensive Guide to Essential `kubectl` Commands

What is kubectl ? kubectl is a command-line interface (CLI) tool that interacts with the Kubernetes API server by authenticating with the M...