Oracle Connection timeout issue

Four Stars

Oracle Connection timeout issue

Hello,

 

I am trying to run a job that has pretty huge amount of data unloaded using an Oracle SQL. However, the job runs for 15 mins and fails giving below error

----------------------------------------------------------
Error : exceeded maximum idle time, please connect again 

----------------------------------------------------------

Is there any way we can increase the timeout period through talend ?

 

Thanks!

Moderator

Re: Oracle Connection timeout issue

Hello,

How did you set timeout for your oracle? In Listener.ora file in oracle?or something else?

Here is an article about:https://stackoverflow.com/questions/1914286/oracle-set-query-timeout

Hope it will help.

 

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.