My Oracle application is slow. "Packet dropped - TCP sequence out of order"

Description

This article provides troubleshooting steps to resolve packets of Application Oracle being dropped on the SonicWall firewall due to drop code "Packet dropped - TCP sequence out of order".

Packet capture shows the following:
 
TCP Packet Header 
TCP Flags = [ACK,PSH,], Src=[1521], Dst=[xxxxx], Checksum=0x2e9a 
Application Header 
Oracle 
Value:[2] 
DROPPED, Drop Code: xxx(Packet dropped - TCP sequence out of order)

Resolution for SonicOS 7.X

This release includes significant user interface changes and many new features that are different from the SonicOS 6.5 and earlier firmware. The below resolution is for customers using SonicOS 7.X firmware.


  1. Login to the SonicWall Management GUI.
  2. Click NETWORK in the top navigation menu.
  3. Navigate to Firewall | Advanced | DYNAMIC PORTS
  4. If "Enable support for Oracle (SQLNet)" is enabled, disable it:

    Image
  5. Click Accept at bottom to save the configuration and test again.


If the issue persists, please contact SonicWall Support.


Resolution for SonicOS 6.5

This release includes significant user interface changes and many new features that are different from the SonicOS 6.2 and earlier firmware. The below resolution is for customers using SonicOS 6.5 firmware.


  1. Login to the SonicWall Management GUI.
  2. Click Manage in the top navigation menu.
  3. Navigate to Firewall Settings | Advanced Settings | Dynamic Ports
  4. If "Enable support for Oracle (SQLNet)" is enabled, disable it:

Image

   5. Click Accept to save the configuration and test again.


If the issue persists, please contact SonicWall Support.

Related Articles

  • How can I configure NAT over VPN in a Site to Site VPN?
    Read More
  • GVC 2FA Not Working on NSA 2700 (Gen7)
    Read More
  • Enforce Default Browser for SAML Authentication in NetExtender 10.3.4
    Read More
not finding your answers?