000012806 - What does Oracle Database Error mean? ORA-12592: TNS:bad packet

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 22, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000012806
Applies ToEnVision 3.x
Collecting Oracle ODBC Database Logs
IssueWhat does the following error mean? Error: ORA-12592: TNS: bad packet
Event Viewer ODBC error:  ORA-12592: TNS: bad packet error is produced
Oracle device type is found and exists in Manage Monitored Devices, however error: ORA-12592: TNS: bad packet error is produced
Cause

This usually happens when setting up a connection through a firewall.

The reason for this is when you have auditing enabled, queries or DML to the SYS.AUD$ table may trigger larger than normal TCP packets.  When these packets go through the firewall, the 'fixup' can possibly modify the packet incorrectly and cause it to be corrupted which then breaks Oracle Net.

Resolution

There are a few workarounds available.  You must evaluate and test each workaround individually based on the requirements of each environment.

Here are the 4 possible workarounds starting with the most commonly used one.

1.   Turn off database auditing

2.   If you must maintain auditing and cannot disable the 'fixup' feature, work with the network administrators to evaluate the MTU for the firewall and size the Oracle TCP packets to be below the current setting.

3.   Disable the 'fixup' feature and /or consult with the firewall vendor regarding patches/fixes to the feature.

4.   Employ alternate firewall configurations or policy settings.

Legacy Article IDa42234

Attachments

    Outcomes