Error: F_JD20DC Unexpected Oracle Error Status OCI_INVALID_HANDLE

Issue

Integrate fails with the following error:

F_JD20DC: Unexpected Oracle error status 'OCI_INVALID_HANDLE' occurred

Environment

• HVR 6
• Target: Oracle

Resolution

To resolve this issue:

1. Define the following environment variable (using the Environment action) on the target location group:
   • Name=HVR_SQL_LABEL_CACHE
   • Value=1000
2. Run Activate Replication with the Jobs and Table Enrollment options selected.

Cause

The error is triggered when Oracle reports OCI_INVALID_HANDLE. This may occur due to long-running transactions or when the SQL label handle cache is exhausted. HVR’s HVR_SQL_LABEL_CACHE defaults to 100; increasing the cache (for example, to 1000) gives the Integrate jobs more capacity to hold SQL label handles and avoids exhausting the cache.