TB059 Slow Oracle JDBC Connections After Upgrade

Impact

The Delphix Engine uses JDBC connections to make queries for Source or Virtual Databases.  The creation of new JDBC connections to an Oracle database may take significantly longer or timeout and fail.  This can impact numerous operations including:

• Start-up or Shutdown of a Virtual Database (VDB)
• Source Database Snapshots

Contributing Factors

This problem can only occur when using one of the following Delphix Engine releases:

The problem can only occur when using Oracle databases with Delphix. The problem may occur during the following Delphix database operations:

• VDB Start/Stop

• VDB refresh jobs

• VDB rollback jobs

• VDB provision jobs

• Snapshot

• Source Enable

• Source Disable

The problem is more likely to occur on Delphix Engines with a large number of Source Databases or VDBs.

Symptoms

• Affected jobs on Oracle Databases may run more slowly than expected.
• The Verify JDBC Connecting String operation available under Manage -> Environments -> host name -> Databases may take many minutes, while a local connection to the same database may complete instantly. 
• Attempts to complete certain operations, such as provisioning a new VDB, may fail with a "Communication Error" message

Relief/Workaround

Defer upgrading to an affected software release.

Resolution

This issue is fully addressed in Delphix Engine 5.3.2.0 and later releases.

Related Articles

Not applicable