After In-Place Upgrade Of Oracle Home, Environment Refresh Reports Errors On Previous Oracle Home Version (KBA9349)

Issue

After performing an in-place upgrade of an existing Oracle Home, subsequent Environment Refresh jobs errors referencing the prior Oracle Home are generated.

Example of error:

Error
Failed to extract Oracle version from output of sqlplus executable.
The Delphix Engine will be unable to automatically discover Oracle installation "/users/oracle/product/12.1.0/db_1".

 Suggested Action
Verify that the correct sqlplus binary is present at Oracle home "/users/oracle/product/12.1.0/db_1" which is executable by environment user "delphix_os", and refresh the environment or manually add the installation.

Command Output
"Command: sqlplus -version
Return Value: 127
Output: /<toolkit>/scripts/bash/linux_x86/bin64/bash: sqlplus: command not found

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	6.0.0.0, 6.0.1.0, 6.0.1.1, 6.0.2.0, 6.0.2.1, 6.0.3.0, 6.0.3.1, 6.0.4.0, 6.0.4.1, 6.0.4.2, 6.0.5.0, 6.0.6.0, 6.0.6.1, 6.0.7.0, 6.0.8.0, 6.0.8.1, 6.0.9.0, 6.0.10.0, 6.0.10.1, 6.0.11.0, 6.0.12.0, 6.0.12.1, 6.0.13.0, 6.0.13.1, 6.0.14.0, 6.0.15.0
5.3	5.3.0.0, 5.3.0.1, 5.3.0.2, 5.3.0.3, 5.3.1.0, 5.3.1.1, 5.3.1.2, 5.3.2.0, 5.3.3.0, 5.3.3.1, 5.3.4.0, 5.3.5.0, 5.3.6.0, 5.3.7.0, 5.3.7.1, 5.3.8.0, 5.3.8.1, 5.3.9.0
5.2	5.2.2.0, 5.2.2.1, 5.2.3.0, 5.2.4.0, 5.2.5.0, 5.2.5.1, 5.2.6.0, 5.2.6.1
5.1	5.1.0.0, 5.1.1.0, 5.1.2.0, 5.1.3.0, 5.1.4.0, 5.1.5.0, 5.1.5.1, 5.1.6.0, 5.1.7.0, 5.1.8.0, 5.1.8.1, 5.1.9.0, 5.1.10.0
5.0	5.0.1.0, 5.0.1.1, 5.0.2.0, 5.0.2.1, 5.0.2.2, 5.0.2.3, 5.0.3.0, 5.0.3.1, 5.0.4.0, 5.0.4.1, 5.0.5.0, 5.0.5.1, 5.0.5.2, 5.0.5.3, 5.0.5.4

Resolution

This type of issue surfaces as dependent databases, such as linked dSources, have not been upgraded in the Delphix Appliance and Delphix will continue to monitor the health of the former Oracle Home.  

After the initial in-place/existing upgrade of the Oracle Home has completed and the new Oracle Home/Version has been detected by performing an Environment Refresh, upgrade each dSource using the procedure located in the Delphix Documentation under the section "Upgrading dSources after an Oracle Upgrade" and once completed, perform an additional Environment Refresh.