ORA-3113
Hi All,
While was troubleshooting another production issues for ORA-03135 error, i have set the following sqlnet parameters. However, this behaved very adversely and it throws ORA-03113 error on all informatica long running jobs.
CONNECT_TIMEOUT=0
SQLNET.INBOUND_CONNECT_TIMEOUT = 300
SQLNET.SEND_TIMEOUT = 300
SQLNET.RECV_TIMEOUT = 300
As per ORACLE DOC,http://docs.oracle.com/cd/B19306_01/network.102/b14213/sqlnet.htm, i see it is recommended.
Does this occurs due to fail to get complete authentication as the result database terminates connection ??
It really alarming as it affected many of critical ETL jobs, afraid whether these parameters shuld be used in PROD ?
While was troubleshooting another production issues for ORA-03135 error, i have set the following sqlnet parameters. However, this behaved very adversely and it throws ORA-03113 error on all informatica long running jobs.
CONNECT_TIMEOUT=0
SQLNET.INBOUND_CONNECT_TIMEOUT = 300
SQLNET.SEND_TIMEOUT = 300
SQLNET.RECV_TIMEOUT = 300
As per ORACLE DOC,http://docs.oracle.com/cd/B19306_01/network.102/b14213/sqlnet.htm, i see it is recommended.
Does this occurs due to fail to get complete authentication as the result database terminates connection ??
It really alarming as it affected many of critical ETL jobs, afraid whether these parameters shuld be used in PROD ?
0