The difference between the Source and Target version.

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
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 
Photo of An agent

An agent

  • 170 Points 100 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of Anthony Checkas

Anthony Checkas, Employee

  • 110 Points 100 badge 2x thumb
Official Response
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