Skip to main content

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




KBA# 9349



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:

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






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.



Related Articles

The following articles may provide more information or related information to this article: