ORA-02396: exceeded maximum idle time, please connect again (4321863)

ORA-02396: exceeded maximum idle time, please connect again

Workflows using Oracle connector are failing with the following error message:

The specified SQL Server instance cannot be contacted.

Details: ORA-02396: exceeded maximum idle time, please connect again ---> Oracle.DataAccess.Client.OracleException ORA-02396: exceeded maximum idle time, please connect again.

Oracle connection times out after 15 minutes. Quick Connect is unable to re-establish the connection until Quick Connect service is restarted.

Add a custom parameter to the Oracle connection string as follows:

1. In Quick Connect Administration Conosle, navigate to the Oracle connection properties
2. Under Oracle connection properties select Advanced Properties
3. Add a new parameter named VALIDATE CONNECTION
4. Set the parameter value to true

TF00203091

Full error message recorded in QuickConnectServerHost.log: Debug --> Workflow step execution failed! Quest.QuickConnect.Server.Execution.WorkflowExecution.WorkflowStepExecutor.Execute System.ApplicationException: The specified SQL Server instance cannot be contacted. Details: ORA-02396: exceeded maximum idle time, please connect again ---> Oracle.DataAccess.Client.OracleException ORA-02396: exceeded maximum idle time, please connect again at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) at Oracle.DataAccess.Client.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at Quest.QuickConnect.Connectors.DBConnectorBase.DBConnector.GetSQLSchema(SelectQueryContainer query) at Quest.QuickConnect.Connectors.DBConnectorBase.DBConnector.SetQuery(SelectQueryContainer query) at Quest.QuickConnect.Connectors.DBConnectorBase.DBConnector.Connect(IConnectionParameterCollection connectionParameters) --- End of inner exception stack trace --- at Quest.QuickConnect.Connectors.DBConnectorBase.DBConnector.Connect(IConnectionParameterCollection connectionParameters) at Quest.QuickConnect.Server.QcConnector.Connect(IConnectionParameterCollection connectionParameters) at Quest.QuickConnect.Server.Execution.ConnectedConnectorsCache.CreateConnector(Connection connection, QcConnectorInfo connectorConfig) at Quest.QuickConnect.Server.Execution.ThreadSafeCache`2.AddItem(T