Following an upgrade to Delphix 220.127.116.11 or later, a previously functional Source / Target Oracle combination now fails in VDB Provision or Refresh, with an error message indicating the source and target versions are incompatible. An example of this event is provided below (the specific versions referenced for source and target may vary per installation, but this is expected to primarily affect Oracle 18.x and above):
"Target database version "18.104.22.168.0" is not compatible with the source version "22.214.171.124.0".
- The Delphix Engine has been upgraded to 126.96.36.199 or later.
- The Source and Target Oracle versions are 18.0 or higher.
- The Source Oracle installation version is at a higher patch release than the Target.
Applicable Delphix Versions
- Click here to view the versions of the Delphix engine to which this article applies
Major Release All Sub Releases 6.0 188.8.131.52, 184.108.40.206, 220.127.116.11, 18.104.22.168, 22.214.171.124, 126.96.36.199, 188.8.131.52
As part of a code change implemented in 184.108.40.206 and later, improvements were made to the version parsing logic which previously used the
v$version, which would always return xx.0.0.0 regardless of the patch version for Oracle versions 18 and above. Ex:
SQL> select banner from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 19c Enterprise Edition Release 220.127.116.11.0 - Production
The updated version retrieval in 18.104.22.168 and later instead queries
v$instance which provides the discrete patch level. Ex:
SQL> SELECT version_full VERSION FROM v$instance; VERSION ----------------- 22.214.171.124.0
As a result of this improvement to version parsing, the intended version restrictions for source/target compatibility became more stringent as we are now able to determine a more specific installation version for versions at or above 18.0.
Ultimately, the restriction in Provision or Refresh is working as designed, as the current product design requires the source and target to be the same RDBMS and OS version. This is mentioned in the Delphix Product Documentation:
So, although previous Engine versions allowed provisioning between source and target on different minor versions for Oracle installations at version 18 and above, this was ultimately not the intended behavior, so the more nuanced version retrieval is introducing more stringent restrictions.
There is an RFE currently under evaluation by Delphix Product Management to further relax these restrictions between versions which may be technically compatible despite the source or target running a different Oracle version. Please contact Delphix Support or your Account Team if your organization would like to be added to this request.
The following articles may provide more information or related information to this article:
- Delphix Documentation - Supported Oracle DBMS Versions and Operating Systems for Source and Target Environments