My Oracle Support Banner

12.2: TRANSPORT_CONNECT_TIMEOUT -> Seconds Or Miliseconds? (Doc ID 2382634.1)

Last updated on SEPTEMBER 12, 2024

Applies to:

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

Goal

Regarding the following parameter:
TRANSPORT_CONNECT_TIMEOUT = n

What is the unit used in 12.2?

Conflicting information
~~~~~~~~~~~~~~~~~

a) It's specified as milliseconds in the JavaNet docs:

https://docs.oracle.com/en/database/oracle/oracle-database/12.2/jjdbc/application-continuity.html#GUID-9298BB8C-0E93-44BF-BA26-A615940C0C84
"Starting from Oracle Database 12c Release 2 (12.2.0.1), you must specify the value of the TRANSPORT_CONNECT_TIMEOUT parameter in milliseconds, instead of seconds"


b) However, specified as seconds in the SQLNet docs:

https://docs.oracle.com/en/database/oracle/oracle-database/12.2/netrf/local-naming-parameters-in-tnsnames-ora-file.html#GUID-0CE85944-98CE-4984-8B5D-A7942B30F446
"6.11.4 TRANSPORT_CONNECT_TIMEOUT
Purpose
To specify the transportation timeout duration in seconds for a client to establish an Oracle Net connection to an Oracle database."


 

Solution

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
Goal
Solution
References


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