\u2022 Set the following registry entry (or create if it does not exist):
\nKeepAliveTime<\/p>\n
Key: HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet\\Services\\Tcpip\\Parameters
\nValue type: REG_DWORD – Time in milliseconds
\nRange: 1 – 0xFFFFFFFF
\nDefault value: 7.200.000 (two hours)
\nFor example this value can be set to 180000 (decimal), equals 3 minutes.<\/p>\n
\u2022 Reboot the computer.<\/p>\n
\u2022 Oracle SQL*Net settings the tnsnames.ora file:<\/p>\n
Add the line “(ENABLE=BROKEN)” as shown below:<\/p>\n
This is also useful for WinCC OA and RDB-Manager.<\/p>\n","protected":false},"excerpt":{"rendered":" \u2022 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. \u2022 Reboot the computer. \u2022 Oracle SQL*Net settings the tnsnames.ora … Continue reading Oracle TCP\/IP Connection Timeout…<\/span> TESTDB =
\n(DESCRIPTION =
\n(ENABLE=BROKEN)
\n(ADDRESS_LIST =
\n(ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1521))
\n)
\n(CONNECT_DATA =
\n(SERVICE_NAME = TESTDB)
\n)
\n)<\/code><\/p>\n