Resolve 'ORA-12571: TNS: packet writer failure' error while running Sagent plan

Product Feature: DataFlow Server
Database: Oracle

Issue

While running a Sagent plan which processes the transaction data and loads it onto Oracle table, 'ORA-12571: TNS: packet writer failure' error is encountered.

Cause

This could be caused due to other (for example Anti-Virus) application interfering with Oracle operation.

Resolution

UPDATED: April 24, 2018
Possible resolution is to increase 'SQLNET.EXPIRE_TIME' and 'DB_BLOCK_SIZE' parameters on database.