One of our integrations has recently switched over from an Oracle 8i to an Oracle 9i server. We’ve installed the Oracle client software (no JDBC adapters used) and have noticed that when there’s a time interval of 1.5 - 2 hours, the next transaction to go to Oracle would encounter a connection timeout error. I know that when configuring a JDBC adapter, you can set a polling inverval that would check on the existing connections and keep the connection alive if needed.
Is there any similar feature when using the Oracle client software on Enterprise? I can’t find any information and believe that this polling interval is in need of adjustment on our servers.