Test Data Manager

 View Only

Javelin - Error executing Read data from Oracle DB: ORA-03135: Connection lost contact

  • 1.  Javelin - Error executing Read data from Oracle DB: ORA-03135: Connection lost contact

    Posted Oct 10, 2019 06:18 PM
    Edited by Andrew Chen Oct 10, 2019 07:44 PM

    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