problem with database connection
Posted: Mon Nov 26, 2007 6:46 pm
Hi,
I have a sequence of jobs which run daily starting from 8 PM till 1 AM.
My job is aborting daily at around 11 PM to 12 PM and it throws one of the following errors.
"ORA-03135: connection lost contact"
"ORA-03114: not connected to ORACLE"
This happens after the job has started loading data and fails in the middle. This problem usually happens with jobs which have low rows/sec. (around 150 as my jobs have 5-6 references and 2-3 transformers) and it also happens with jobs which have 1000 rows/sec.
I have already raised a case with Oracle support on this. I need to know if there is some setting in datastage which may cause this problem or if I am doing something wrong.
The source, target and reference all are the same Oracle 10g database.
The dba also says that there are no timeout parameters set which means that a connection willnot timeout automatically. I also tried opening a connection to the database in the server through sqlplus and left it open. It didnt timeout for 5 days until I closed it myself.
Please let me know the resolution if anyone has faced this problem before.
Any suggestion would be greatly appreciated.
I have a sequence of jobs which run daily starting from 8 PM till 1 AM.
My job is aborting daily at around 11 PM to 12 PM and it throws one of the following errors.
"ORA-03135: connection lost contact"
"ORA-03114: not connected to ORACLE"
This happens after the job has started loading data and fails in the middle. This problem usually happens with jobs which have low rows/sec. (around 150 as my jobs have 5-6 references and 2-3 transformers) and it also happens with jobs which have 1000 rows/sec.
I have already raised a case with Oracle support on this. I need to know if there is some setting in datastage which may cause this problem or if I am doing something wrong.
The source, target and reference all are the same Oracle 10g database.
The dba also says that there are no timeout parameters set which means that a connection willnot timeout automatically. I also tried opening a connection to the database in the server through sqlplus and left it open. It didnt timeout for 5 days until I closed it myself.
Please let me know the resolution if anyone has faced this problem before.
Any suggestion would be greatly appreciated.