Configure TCP KeepAlive settings

The failover design of the messaging engine relies upon the database connections that are broken when a messaging engine incarnation fails. In order for failover to occur in high availability environments, ensure that the RDBMS detects the broken connection in a timely manner and releases database locks. This task is done by configuring the TCP KeepAlive settings.

We need to have an Oracle database installed and configured on the system.

  1. Log in as a system administrator.

  2. Select the following path in the left pane:

    My Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameter.

  3. Right click in the right pane and select New > DWORD Value

  4. Enter the name as KeepAliveInterval for the new parameter.

  5. Right click this new parameter and select Modify.

  6. Select Base as Decimal and enter the value as 30000 (30000 milliseconds = 30 seconds).
  7. Similarly, add another DWORD value with name KeepAliveTime and set the value equal to 30000.

Restart the computer for the changes to take effect.

Parent topic: Oracle database performance tuning


Related tasks