DSXchange

Hi,

We are receiving "ORA-03135 Oracle Connection Lost" error daily in our production environment. This happens in jobs that uses ORACLE OCI stage. This also happens between a specific time and on the same job daily.

Datastage has been installed in Windows server and an Oracle client is also installed in the same server. Oracle Server (Oracle 10g) is on UNIX machine. We have checked the parameters set in Oracle DB

PROFILE - RESOURCE_NAME - RESOURCE LIMIT

DEFAULT - IDLE_TIME - KERNEL UNLIMITED
DEFAULT - CONNECT_TIME - KERNEL UNLIMITED

Should I suspect the ODBC driver? or the network itself. There are two ODBC drivers installed in DS Server
a) Ascential Oracle - Version 5
b) Oracle in OraClient 10g_home1 - Version 10

I'm not sure if OraOCI stage uses the Ascential Oracle driver or Oracle in Oraclient10g driver.

Please let me know on how to run a trace on driver.

Thanks in Advance,
Mani

ORA-03135: connection lost contact
Cause: 1) Server unexpectedly terminated or was forced to terminate. 2) Server timed out the connection.
Action: 1) Check if the server session was terminated. 2) Check if the timeout parameters are set properly in sqlnet.ora.

Your DBA should be able to trace the connection. Suspect either the network or a client/database setting.

ps. The OCI stage does not use ODBC nor is 'Oracle in OraClient' ODBC. It is a native connection over sqlnet.