Oracle JDBC (MOSC)

MOSC Banner

Identify which part duration TIMEOUT for jdbc:oracle:thin not success connect to RAC DB

edited Jul 28, 2025 7:39AM in Oracle JDBC (MOSC) 3 commentsAnswered

Dear Guru

The java program using 19.3.0 jdbc:oracle:thin encounter "java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection" found application server log. (but not found any error from listener.log) The connection string like this (DB is 19.26):

jdbc:oracle:thin:@(DESCRIPTION=(FAILOVER=ON)(CONNECT_TIMEOUT=17)(TRANSPORT_CONNECT_TIMEOUT=8) (ADDRESS_LIST=(LOAD_BALANCE=OFF) (ADDRESS=(PROTOCOL=TCP)(HOST=SCAN-PRIMARY(PORT=1521)) (ADDRESS=(PROTOCOL=TCP)(HOST=SCAN-STANDBY)(PORT=1521)) (ADDRESS=(PROTOCOL = TCP)(HOST = DRHOST)(PORT = 1521))) (CONNECT_DATA=(SERVICE_NAME=xxxSRV)))

As in-doubt the CONNECT_TIME=17 and TRANSPORT_CONNECT_TIME=8 limited to DB connection establish success, follow

"How to Trace the Network Packets Exchanged Between JDBC and the RDBMS (Doc ID1050942.1)" suggests below would produce 'sqlnet trace' like output

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center