• 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.http://www.rocworks.at/wordpress/?p=465
Oracle TCP/IP Connection Timeout...
- Last update:
- 2014-07-14 09:17
- Author:
- Andreas Vogler
- Revision:
- 1.0
You can comment this FAQ