"java.sql.SQLRecoverableException: IO Error: The Network Adapter Could Not Establish The Connection" After Database Upgrade And Password Change (Doc ID 2712723.1)

Last updated on APRIL 25, 2023

Applies to:

Symptoms

After the database was upgraded and the password for the application schema was changed, the next error is reported in the WebLogic log:

<The connection to the datasource using "jdbc:oracle:thin:@<HOSTNAME>:<PORT><SID>" could not be established due to the following error: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection.>
<Jul 8, 2020, 12:56:06,406 PM CDT> <Error> <Security> <BEA-000000> <[Security:090737]An exception occurred while getting connection to validate the configuration settings
java.sql.SQLException: [Security:090735]The DBMS connection was not usable
               at weblogic.security.providers.authentication.DBMSSQLAuthenticatorDelegateImpl.getManageableConnection(DBMSSQLAuthenticatorDelegateImpl.java:922)
               at weblogic.security.providers.authentication.DBMSSQLAuthenticatorDelegateImpl.validateConfiguration(DBMSSQLAuthenticatorDelegateImpl.java:153)
               at weblogic.security.providers.authentication.DBMSSQLAuthenticatorDelegateImpl.<init>(DBMSSQLAuthenticatorDelegateImpl.java:78)
               at weblogic.security.providers.authentication.DBMSAuthenticatorDelegateImpl.getInstance(DBMSAuthenticatorDelegateImpl.java:457)
               at weblogic.security.providers.authentication.DBMSAuthenticatorDelegateImpl.getInstance(DBMSAuthenticatorDelegateImpl.java:392)
               Truncated. see log file for complete stacktrace

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.