Delphix Products

Expand all | Collapse all

The difference between the Source and Target version.

Jump to Best Answer
  • 1.  The difference between the Source and Target version.

    Posted 03-03-2015 08:20:00 AM
    I've already checked following information. 
    http://docs.delphix.com/display/DOCS42/Supported+Operating+Systems+and+DBMS+Versions+for+Oracle+Envi...
     The source and target must be running the same DBMS/Operating System combination (for example, Oracle 10.2.0.4 on RHEL 5.2) in order to successfully provision a VDB to the target.
     If the DBMS versions are compatible, the OS version on a target host can be different from the OS version on the source host.
    --------------------------------------

    When we apply a patch of oracle database to source environment, do we have to apply same pach to target environment?
    Oracle has various types of patches that we would like to know what we should do each patches.

    Q1) Apply a PSR to source environment
    e.g.
    Source = 11.2.0.4
    Target = 11.2.0.3

    Q2) Apply a PSU to source environment
    e.g.
    Source = 11.2.0.4.2
    Target = 11.2.0.4.1

    Q3) Apply a CPU to source environment
    e.g.
    Source = 11.2.0.4 + CPU January 2015
    Target = 11.2.0.4

    Q4) Apply a individual patch to source environment
    e.g.
    Source = 11.2.0.4 + Patch X
    Target = 11.2.0.4 


  • 2.  RE: The difference between the Source and Target version.
    Best Answer

    Posted 03-04-2015 04:39:00 PM
    Yes, the binary versions need to be identical. This is described under item 2 on the Requirements for Oracle Target hosts page:

    "There must be a version of the Oracle binaries on the target environment that is identical (same version and patch set) to the binaries for the source database on the source host. For example, if the source database is running on Oracle 11.2.0.3.4, then the target environment must have the binaries for 11.2.0.3.4 installed."

    Here's the link for the relevant target documentation:

    http://docs.delphix.com/display/DOCS42/Requirements+for+Oracle+Target+Hosts+and+Databases



  • 3.  RE: The difference between the Source and Target version.

    Posted 03-05-2015 01:12:00 AM
    Thank you for your reply.

    I understand that there must be a version of the Oracle binaries on the target environment that is identical (same version, patch set, CPU[Critical Patch Updates] and individual patch) to the binaries for the source database on the source host.