ORA-03135: connection lost contact - on many PROD DBs
Hi All,
We see many of various production databases are connecting to various applications based on integrated application .
Observed that all these application processes are failing with following error, for example : Informatica ETL jobs, Cognos and CRM Application jobs running with various database on different servers
ORA-03135: connection lost contact
We have already checked whether this is due to firewall issue, but found no issues with firewall or network.
This appears to be long running jobs where connection remains open for long time and it dies/lost....
Can somebody throw light on this issue, how do we troubleshoot and find the root cause of this issue.
We see many of various production databases are connecting to various applications based on integrated application .
Observed that all these application processes are failing with following error, for example : Informatica ETL jobs, Cognos and CRM Application jobs running with various database on different servers
ORA-03135: connection lost contact
We have already checked whether this is due to firewall issue, but found no issues with firewall or network.
This appears to be long running jobs where connection remains open for long time and it dies/lost....
Can somebody throw light on this issue, how do we troubleshoot and find the root cause of this issue.
0