Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, abdul wahid.

Asked: August 23, 2017 - 10:43 pm UTC

Last updated: August 24, 2017 - 2:10 am UTC

Version: 10.2

Viewed 1000+ times

You Asked

Please advise if the below steps are correct while copying the ORACLE_HOME from one location to another.

Also advise if anything needs to be added to the below before we can start using the ORACLE_HOME.

Copy ORACLE_HOME from old location to new location

-bash-3.2$ cp -Rp /home/oracle/oracle/product/10.2.0/db_1/ /oracledb/app/oracle/product/10.2.0/

Correct the INVENTORY.XML file to reflect the new ORACLE_HOME

-bash-3.2$ cat inventory.xml
<?xml version="1.0" standalone="yes" ?>
<!-- Copyright (c) 2005 Oracle Corporation. All rights Reserved -->
<!-- Do not modify the contents of this file by hand. -->
<INVENTORY>
<VERSION_INFO>
<SAVED_WITH>10.2.0.1.0</SAVED_WITH>
<MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>
</VERSION_INFO>
<HOME_LIST>
<HOME NAME="OraDb10g_home1" LOC="/home/oracle/oracle/product/10.2.0/db_1" TYPE="O" IDX="1"/>
</HOME_LIST>
</INVENTORY>


-bash-3.2$ vi inventory.xml
<?xml version="1.0" standalone="yes" ?>
<!-- Copyright (c) 2005 Oracle Corporation. All rights Reserved -->
<!-- Do not modify the contents of this file by hand. -->
<INVENTORY>
<VERSION_INFO>
<SAVED_WITH>10.2.0.1.0</SAVED_WITH>
<MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>
</VERSION_INFO>
<HOME_LIST>
<HOME NAME="OraDb10g_home1" LOC="/oracledb/app/oracle/product/10.2.0/db_1" TYPE="O" IDX="1"/>
</HOME_LIST>
</INVENTORY>

Confirm the above action by running the below command

-bash-3.2$ opatch lsinventory
Invoking OPatch 10.2.0.1.0

Oracle interim Patch Installer version 10.2.0.1.0
Copyright (c) 2005, Oracle Corporation. All rights reserved..

Oracle Home : /oracledb/app/oracle/product/10.2.0/db_1
Central Inventory : /home/oracle/oraInventory
from : /oracledb/app/oracle/product/10.2.0/db_1/oraInst.loc
OPatch version : 10.2.0.1.0
OUI version : 10.2.0.1.0
OUI location : /oracledb/app/oracle/product/10.2.0/db_1/oui
Log file location : /oracledb/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch-2016_May_12_12-59-42-MUT_Thu.log

Lsinventory Output file location : /oracledb/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory-2016_May_12_12-59-42-MUT_Thu.txt

-----------------------------------------------------------------------------
Installed Top-level Products (1):

Oracle Database 10g 10.2.0.1.0
There are 1 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.

-----------------------------------------------------------------------------

OPatch succeeded.

Thanks

and Connor said...

You dont clone the Oracle Home solely at the OS level.

The steps are nicely outlined in the documentation here

https://docs.oracle.com/cd/E11882_01/install.112/e47689/app_cloning.htm#LADBI1362



Is this answer out of date? If it is, please let us know via a Comment

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database