This topic describes how to add a database installation home.
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 Admin application using Delphix Admin credentials.
- Click Manage.
- Select Environments.
- Click Databases.
- Click the green Plus icon next to Add Dataset Home.
- 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 the Check icon.
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:
<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":
<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 the Oracle Home is 32 bit or 64 bit.