If you have a long running Informatica job that for some reason fails with an Oracle ORA-02396 Connection idle timeout error, it might have been due to the idle_time setting in the Oracle DB. Informatica opens up all the DB connections at the very start of the session, and when it does get to the thread to start reading rows from the open connection, the connection could have been dropped.
To fix this, the IDLE_TIME for the profile needs to be upped. You can set it to unlimited, but your DBAs might lift an eyebrow.
No comments:
Post a Comment