-
Title
Connections from a host using Toad to an Oracle server via Cisco ASA firewall. -
Description
A problem occurred when maintaining connections from host using Toad for Oracle to an Oracle server via Cisco ASA Firewall. The Firewall is registering
the following error is returned on any table queried :
Toad Host (source): 1st
|
|
Cisco ASA Firewall
|
|
Cisco PIX Firewall--------------------Second Toad Test Host
|
|
Oracle Server (destination): 172.xx.xxx.xx
SQLNet connection is closed by SQLNet inspection in certain case, Issues can also be seen with ASA 8.0(4) with SQLNet inspection enabled and if there
are multiple TNS frames in one TCP segment. The following log messages are seen on the ASA: %ASA-6-302014: Teardown TCP connection...Flow closed by inspection When enabling 'debug sqlnet 255 ', you may also see the following debug message: "SQLNet: multiple TNS frame in one packet! " -
Resolution
Upgrade Cisco ASA software from version 8.0(4) to 8.0(7) or newer, or downgrade to a version prior to 8.0(3.33).