Problem

When the active DB server goes down and the Veritas Cluster System does the failover to another instance of the DB, the procengine (on Integrator application) which operates the Oracle connector does not automatically reconnect to the newly activated DB environment.

We need to restart the associated HME. Is there any way to establish automatic connection to failovered DB?

In this scenario, you need to set an environment variable as follows:

EDI_ORACLE_OCI_SESSION_POOL_ENABLE=1

EDI_ORACLE_OCI_SESSION_POOL_ENABLE=1. This will enable the connection pooling and will fix the DATABASE OPEN behaviour to the correct one.

If the connection between Integrator and the database stops for any reason (database restart, network issue, timeout ..), the connector reestablishes the connection in case it was closed.

WARNING 20090303 11.55.15.37 procengine(procengine(ac_oracleSp))
Database connection has been reastablished, trying to execute method METHOD_NAME again