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