Adding a database installation home to an Oracle environment

When you add an environment with the Delphix Admin application, all database installation homes on it are automatically discovered. However, if a database installation home is not automatically discovered, you can add it manually to the environment.

Procedure

Login to the Delphix management application.
Click Manage.
Select Environments.
Select an Environment.
Click the Databases tab.
Click the Add dataset home button.
Enter the Installation home.
Enter the Version of the Installation Home.
Enter the Oracle base of the Installation Home.
Enter the Bits of the Oracle Home.
When finished, click Add.

Troubleshooting

If the environment user has oinstall permissions, Delphix will be able to discover the Version, Oracle Base, and Bits. If any of these fields are found to be different than those provided by the user, a fault will be raised on the repository.

Oracle version

The version can be found in the comps.xml file in $ORACLE_HOME/inventory/ContentsXML/comps.xml. Example of Oracle Home with version 12.1.0.2:

CODE

<COMP NAME="oracle.server" VER="12.1.0.2.0" 
BUILD_NUMBER="0" 
REP_VER="0.0.0.0.0" 
RELEASE="Production" 
INV_LOC="Components/oracle.server/12.1.0.2.0/1/" 
LANGS="en" XML_INV_LOC="Components21/oracle.server/12.1.0.2.0/" ACT_INST_VER="12.1.0.2.0" DEINST_VER="11.2.0.0.0" 
INSTALL_TIME="2016.Apr.14 12:42:09 PDT" 
INST_LOC="/u01/app/oracle/product/12.1.0/dbhome_1/oracle.server">

Oracle base

This can be found as a property in $ORACLE_HOME/inventory/ContentsXML/oraclehomeproperties.xml. Example of Oracle Home with Oracle Base "/u03/app/ora11202":

CODE

<PROPERTY NAME="ORACLE_BASE" VAL="/u03/app/ora11202"/>

Bits

This can be found by running

file $ORACLE_HOME/bin/rman

The output will indicate if Oracle Home is 32 bit or 64 bit.