Symptoms

Oracle Timeout errors (ORA-03113) when application has been idle for a period of time
 

Diagnoses

It is possible to configure the K2 Oracle service broker to check if a connection is open before using it. This information is passed through the Oracle connection string.
 

Resolution

Modify the string to add "Validate Connection=True"? For example:

Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=Server_Name)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=SERVICE_NAME)))User Id=User_IDPassword=PasswordValidate Connection=true