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


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.
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google