Internal Exception: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection

TIPS: Change Database Hostname After OAM security store configured

Change Database Hostname After OAM security stored configured

Issue:

Database Hostname need to be changed after OAM security store is configured.

Info: Data source is: opss-DBDS

[EL Severe]: 2017-03-14 20:39:37.575--ServerSession(1547285287)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException

Internal Exception: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection




Error Code: 17002




JAN 07, 2020 8:39:37 PM oracle.security.jps.internal.common.config.AbstractSecurityStore getSecurityStoreVersion

WARNING: Unable to get the Version from Store returning the default. Reason: java.net.ConnectException: Connection refused.




[EL Severe]: 2020-01-20 20:39:37.978--ServerSession(1619843188)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException

Internal Exception: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection




Error Code: 17002

JAN 07, 2020 8:39:37 PM oracle.security.jps.internal.credstore.ldap.LdapCredentialStore init

WARNING: Could not create credential store instance. Reason oracle.security.jps.service.policystore.PolicyStoreConnectivityException: JPS-00027: There was an internal error: java.net.ConnectException: Connection refused

JPS-01055: Could not create credential store instance. Reason oracle.security.jps.service.policystore.PolicyStoreConnectivityException: JPS-00027: There was an internal error: java.net.ConnectException: Connection refused

Error: Diagnostics data was not saved to the credential store.

Error: Validate operation has failed.

Need to do the security configuration first!

Changes:

Login to Weblogic console and modify below connection pools

Navigate to “Services > Datasources > oamDS > Connection Pool” and modify connection details

Navigate to “Services > Datasources > opss-DBDS > Connection Pool” and modify connection details.

If weblogic console is not accessible then modify two files “oam-db-jdbc.xml and opss-jdbc.xml” under /user_projects/domains/base_domain/config/jdbc.

Login to server and navigate to below location.

/user_projects/domains/base_domain/config/fmwconfig/

Modify jps-config-jse.xml, jps-config-migration.xml and jps-config.xml  file

Modify “jdbc.url” property and update with new hostname.

Restart Admin server and managed server.

Repeat step 2 in all your cluster nodes.

Expected Error if  jps-config-jse.xml, jps-config-migration.xml and jps-config.xml  files not modified.

CHEERS !

Cassio Mariani

Disclaimer: “The postings on this site are my own and don’t necessarily represent may actual employer positions, strategies or opinions. The information here was edited  to be useful for general purpose, specific data and identifications was removed to allow reach generic audience and to be useful.”