Hi all,
We are in urgent need of solving this: Error executing Read data from Oracle DB: ORA-03135: Connection lost contact.
This is the error from Javelin log:
2019-10-10 12:28:33 - Connecting to database...
2019-10-10 12:28:34 - Error executing Read data from Oracle DB: ORA-03135: Connection lost contact
We have developed a Javelin Flow script to perform Oracle bulk copy, and it is working fine with most Oracle DB except one.
After long troubleshooting and comparing the DB Servers settings, we found that this is the cause for the error:
SQLNET.EXPIRE_TIME=10
SQLNET.ENCRYPTION_SERVER=REQUIRED
SQLNET.ENCRYPTION_TYPES_SERVER=(AES256,AES192,AES128,RC4_128,3DES168)
Due to some rules and requirement for this particular DB server, we are not allow to remove this security setting.
Does anyone know what to do or set using the OracleActivity or OracleBulkCopyActivity? Can someone tell us how these tool blocks works?
We are able to connect to this "secured" DB via SQL Developer or SQL Plus successfully and ran queries. It is only when we use Javelin Flow, and get this error ORA-03135.
Thanks,
Andrew