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

Last updated on MARCH 09, 2023

Applies to:

Symptoms

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 org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:800) -- --at

​

org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:154) -- --... 44 common frames omitted --Caused by: java.sql.SQLRecoverableException: IO Error: Socket read timed out -- --at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:743) -- --at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:662) -- --at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32) -- --at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:560) -- --at ...DriverDataSource.getConnection(DriverDataSource.java:138) -- --at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:364) -- --at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206) -- --at ...Pool.createPoolEntry....java:476) -- --at common frames omitted --Caused by: oracle.net.ns.NetException: Socket read timed out -- --at oracle.net.ns.Packet.receive(Packet.java:350) -- --at oracle.net.ns.NSProtocolStream.negotiateConnection(NSProtocolStream.java:159) -- --at oracle.net.ns.NSProtocol.connect(NSProtocol.java:264) -- --at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1452) -- --at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:496) -- --... 65 common frames omitted --

.

All application servers were timing out.

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

Cause

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