Monday, October 5, 2009

Attach Oracle Home

Attach Oracle Home:

First copy oracle sofware binaries from one server to another server using unix command tar etc.. .After copying that binaries

you must first set your ORACLE_HOME environment variable to the new directory you just copied over. for example , the ORACLE_HOME variable for the solution is set to /apps/oracle/product/10.2.0/db_1 .Next change your dircetory to the oui/bin subdirectory.

cd $ORACLE_HOME/oui/bin

From the oui/bin directory,execute the runInstaller commands as shown here to attach the new oracle home to oraInventory:

./runInstaller -silent -attachHome -invPtrLoc /etc/oraInst.loc \

ORACLE_HOME=/apps/oracle/product/10.2.0/db_1 ORACLE_HOME_NAME='ora10ghome3'

upon successfull attach of the OracleHome you will receive message stating that AttachHome was successful

The invPtrLoc parameter specifies the fully qualified file name that contains location of the oraInventory. the oraInst.loc file is located in the /etc directory in the Linux Operating system and look like this

inventory_loc=/apps/oracle/oraIventory

inst_group=oinstall

What is oraInventory ?

oraInventory is repository(directory) which store/records oracle software products & their ORACLE_HOME location on a machine.

No comments: