ORA-12592: TNS Bad Packet Error

Issue

Replication fails with the following error:

ORA-12592: TNS:bad packet

Environment

• HVR 6
• Source: Oracle Database 19c

Resolution

To troubleshoot this issue:

1. Verify that all required ports between the Oracle database and the replication server are open. Check whether firewalls, load balancers, or deep packet inspection tools are dropping or modifying packets.
2. Review the following timeout settings in the Oracle server's sqlnet.ora file and adjust the following parameters as needed:
   • SQLNET.SEND_TIMEOUT=600
   • SQLNET.EXPIRE_TIME=60
   • SQLNET.INBOUND_CONNECT_TIMEOUT=300 (increase if necessary)
3. Enable TNS KeepAlive by modifying your tnsnames.ora with ENABLE=BROKEN to maintain TCP connections during idle periods.
4. Upgrade the HVR Hub and source agent to the latest supported version of HVR. For more information, see Upgrading HVR.
5. Review the Oracle alert log and relevant network logs to identify where the packet disruption occurs.
6. Verify that the operating system account running HVR has the required network permissions.
7. If the issue persists, contact Oracle Support and provide the relevant Oracle and network logs for further diagnosis.

Cause

This issue occurs when the TNS packet flow between the Oracle database and the HVR replication server is interrupted or corrupted. Possible causes include network firewalls or load balancers dropping or altering packets, incorrect timeout settings in sqlnet.ora, TCP connections timing out during idle periods, or incompatible HVR versions.