Oracle TCP/IP Connection Timeout…

• Set the following registry entry (or create if it does not exist):
KeepAliveTime

Key: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters
Value type: REG_DWORD – Time in milliseconds
Range: 1 – 0xFFFFFFFF
Default value: 7.200.000 (two hours)
For example this value can be set to 180000 (decimal), equals 3 minutes.

• Reboot the computer.

• Oracle SQL*Net settings the tnsnames.ora file:

Add the line “(ENABLE=BROKEN)” as shown below:

TESTDB =
(DESCRIPTION =
(ENABLE=BROKEN)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = TESTDB)
)
)

This is also useful for WinCC OA and RDB-Manager.