My Oracle Support Banner

Application Connectivity Performance Issues When Connecting to Database Through Scan Listeners. (Doc ID 2932747.1)

Last updated on MARCH 09, 2023

Applies to:

Oracle Net Services - Version and later
Information in this document applies to any platform.


Customer was facing connectivity issue between Application hosts and DB Servers going through Scan Listeners.

The error that was seen in their JDBC logs are the following.

message_type: ERR msg: SpringApplication.class 2023-02-01 05:46:26,555 ERROR[org.springframework.boot.SpringApplication,THREAD=main,] Application run failed org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'dataSourceScriptDatabaseInitializer' defined in class path resource [org/springframework/boot/autoconfigure/sql/init/DataSourceInitializationConfiguration.class]: Unsatisfied dependency expressed through method 'dataSourceScriptDatabaseInitializer' parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class path resource [com/mastercard/platformservices/connectors/oracle/OracleDatabaseConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [javax.sql.DataSource]: Factory method 'dataSource' threw exception; nested exception is ... $PoolInitializationException: Failed to initialize pool: IO Error: Socket read timed out -- --at -- --at -- --... 44 common frames omitted --Caused by: java.sql.SQLRecoverableException: IO Error: Socket read timed out -- --at oracle.jdbc.driver.T4CConnection.logon( -- --at oracle.jdbc.driver.PhysicalConnection.connect( -- --at oracle.jdbc.driver.T4CDriverExtension.getConnection( -- --at oracle.jdbc.driver.OracleDriver.connect( -- --at ...DriverDataSource.getConnection( -- --at com.zaxxer.hikari.pool.PoolBase.newConnection( -- --at com.zaxxer.hikari.pool.PoolBase.newPoolEntry( -- --at -- --at common frames omitted --Caused by: Socket read timed out -- --at -- --at -- --at -- --at oracle.jdbc.driver.T4CConnection.connect( -- --at oracle.jdbc.driver.T4CConnection.logon( -- --... 65 common frames omitted --


All application servers were timing out.

TNSPING to the database was slow even on the database server itself.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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