How to Change / Move Oracle Inventory Location to another Directory?

advertisements

_____________________________________________________________________________________________________________________

The Eucharistic Miracles of the World

Step 1. Find out the oraInst.loc file location either using find command or opatch utility.
$ ./opatch lsinventory
Invoking OPatch 11.2.0.1.1


Oracle Interim Patch Installer version 11.2.0.1.1
Copyright (c) 2009, Oracle Corporation.  All rights reserved.


Oracle Home       : /u02/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 11.2.0.1.1
…..
….
….


OPatch succeeded.


Step 2: Open /etc/oraInst.loc file and copy the content of the directory to the new location. In this example oracle inventory is in /u01/app/oraInventory and I am going to copy to /home/oracle/oraInventory.
cp -iRp oraInventory /home/oracle

where –i option ask you if the directory already presnt
-R recursively copy the directory
-p option will copy the content without changing the permission and ownership.

Step 3: change the /etc/oraInst.loc content to new location and again check with opatch utility whether it is accessing the new location successfully.
vi /etc/oraInst.loc
inventory_loc=/home/oracle /oraInventory
inst_group=oinstall

$ ./opatch lsinventory
Invoking OPatch 11.2.0.1.1

Oracle Interim Patch Installer version 11.2.0.1.1
Copyright (c) 2009, Oracle Corporation.  All rights reserved.


Oracle Home       : /u02/app/oracle/product/11.2.0/db_1
Central Inventory : /home/oracle/oraInventory
   from           : /etc/oraInst.loc
…..
….
….


OPatch succeeded.

_____________________________________________________________________________________________________________________

Website Stats

0 comments:

Post a Comment

Labels

Oracle (629) Script (86) General (77) Unix (47) Blog (23) Technology (19) gadget (6) games (6) Business (3) OCI (3) SQL* Loader (3) Datapump (2)
 

acehints.com Copyright 2011-23 All Rights Reserved | Site Map | Contact | Disclaimer