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

Product Feature: DataFlow Server
Database: Oracle


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.


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


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