Database connection is down very often
Article ID: 212273
Updated On:
Products
Issue/Introduction
The database connection is seen down very often. Tomacat logs shows:
30 mar 2021 02:21:23,877- Thread: 92 WARNING [com.vontu.enforce.domainlayer.common.database.DatabaseConnectionStatusTask] Database connection is down.
30 mar 2021 02:21:26,237- Thread: 89 SEVERE [org.springframework.scheduling.quartz.LocalDataSourceJobStore] Couldn't rollback jdbc connection. No more data to read from socket
Cause:
java.sql.SQLRecoverableException: No more data to read from socketjava.sql.SQLRecoverableException: No more data to read from socket
...
30 mar 2021 02:21:26,238- Thread: 89 SEVERE [org.quartz.core.ErrorLogger] An error occurred while scanning for the next triggers to fire.
Cause:
org.quartz.JobPersistenceException: Couldn't acquire next trigger: ORA-01092: ORACLE instance terminated. Disconnection forced
...
jdbc.dbalias.oracle-thin=@(DESCRIPTION=(CONNECT_TIMEOUT=1)(TRANSPORT_CONNECT_TIMEOUT=0)(RETRY_COUNT=0)(ADDRESS_LIST=(LOAD_BALANCE=OFF)(FAILOVER=ON)(ADDRESS=(PROTOCOL=tcp)(HOST=host1.com)(PORT=1561))(ADDRESS=(PROTOCOL=tcp)(HOST=host2.com)(PORT=1561)))(CONNECT_DATA=(SERVICE_NAME=protect)))
tnsnames.ora as below:
DTPTCL_PRO_SRV=
(DESCRIPTION=
(CONNECT_TIMEOUT=1)(TRANSPORT_CONNECT_TIMEOUT=0)(RETRY_COUNT=0)
(ADDRESS_LIST=
(LOAD_BALANCE=OFF)
(FAILOVER=ON)
(ADDRESS=(PROTOCOL=tcp)(HOST=host1.com)(PORT=1561))
(ADDRESS=(PROTOCOL=tcp)(HOST=host2.com)(PORT=1561))
)
(CONNECT_DATA=
(SERVICE_NAME=protect)))
Environment
Component : Data Loss Prevention Enforce, Oracle with RAC
Cause
The failover mechanism is turned on (FAILOVER=ON), this is not supported. CONNECT_TIMEOUT value should be adjusted, but since this option is related to the failover mechanism, there is no recommendation that Broadcom support can provide.
This would be applicable to Oracle enterprise only
Resolution
A Feature Request has been submitted
Feedback
