Qlik Replicate and Oracle source endpoint: error 'ORA-12592: TNS:bad packet'

[john_wang]

The Oracle source endpoint occasionally encounters an error during the CDC stage. 

The error message in task log file:

[SOURCE_CAPTURE ]T: OCI error 'ORA-12592: TNS:bad packet' [1022307] (oradcdc_bfileapi.c:312)

The issue specifically arises during the CDC stage; The problem is irrelevant to the Oracle instant client version, and it's not a timeout issue (parameter SQLNET.SEND_TIMEOUT).

Cause:

Oracle SQLNet packet inspection feature in Firewall (sometimes called as Advanced SQL feature in Firewalls) has been causing the TNS bad packet ORA-12592 error. 

Internal Investigation ID(s):

#00156619, QB-26584

Environment:

• Qlik Replicate All versions
• Oracle All versions

Qlik Replicate