If TCP / IP Keepalive is set too long, then after the Pirmary unexpected DOWN machine, the Partially Filled ArchiveD log on Standby cannot be normalized, and will report ORA-332 errors.
Modify the TCP / IP KeepAlive value of the operating system.
The following summarizes the method of modifying the TCP / IP KeepAlive value in several operating systems.
Problem description: ==================== How to Implement Solaris TCP / IP Keepalive Mechanism.
To Change The Keepalive Interval On Solaris Servers You Have To Use The Maintenance Command NDD.
It is not possible to configure this information in the / etc / system file To find out the current value of the TCP / IP keepalive interval use the following command:. Ndd / dev / tcp tcp_keepalive_interval The value returned is in units of milliseconds, eg .% Forpalive_interval 7200000 Which in this case. To change this value you use ndd with the '-set' flag, eg: # ndd -set / dev / tcp_keepalive_interval 1200000
Problem description: ==================================================================================================================================================================================================================================================================== ======= It is important to implement the Windows NT TCP / IP KeepAlive mechanism to prevent dead sessions from accumulating when SQL * Net / Net8 Dead Connection Detection [SQLNET.EXPIRE_TIME] is set to zero or unset in the SQLNET. ORA file.
Solution Description: ===================== To Implement The Windows NT TCP / IP Keepalive Mechanism, Click: Start> Run> Regedit.exe in The Registry, Navigate To : HKEY_LOCAL_MACHINE / SYSTEM / CurrentControlSet / Services / Tcpip / Parameters Edit - Add value: KeepAliveTime (REG_DWORD) Decimal -> 180000 (for example = 3 minutes) The parameter will not be present the first time you modify the parameter, so you will need To add it. The default value is 2 hours.problem description: =========================== How to Implement Linux TCP / IP Keepalive Mechanism.
Modify / proc / sys / net / ipv4 / tcp_keepalive_time # echo 120> / proc / sys / net / ipv4 / tcp_keepalive_time
