App and db on single node - migration of ebs to new server

[satish]

Dear erman,

Version r12.1.3
Db 11.1.0.7

We need to migrate apps and db to single node.How to setup inventory in this case. since /etc/oraInst.loc is global location,which home it should contain either apps or db. Pls guide.

Thanks,
Satish

[ErmanArslansOracleBlog]

oraInst.loc can point to an inventory and there in that inventory we can have all the records for all the oracle home environments..

For instance;

[applmgr@ebstestdb ContentsXML]$ cat /etc/oraInst.loc
inventory_loc=/u01/app/oracle/oraInventory
inst_group=oinstall

[applmgr@ebstestdb ContentsXML]$ pwd
/u01/app/oracle/oraInventory/ContentsXML

[applmgr@ebstestdb ContentsXML]$ cat inventory.xml |grep "HOME NAME"
<HOME NAME="PROD_DB__u01_dbebs_PROD_db_tech_st_11_1_0" LOC="/u01/dbebs/PROD/db/tech_st/11.1.0" TYPE="O" IDX="1"/>
<HOME NAME="PROD_WEBOH__u01_applebs_PROD_apps_tech_st_10_1_3" LOC="/u01/applebs/PROD/apps/tech_st/10.1.3" TYPE="O" IDX="2"/>
<HOME NAME="PROD_TOOLS__u01_applebs_PROD_apps_tech_st_10_1_2" LOC="/u01/applebs/PROD/apps/tech_st/10.1.2" TYPE="O" IDX="3"/>
<HOME NAME="OraDb11g_home1" LOC="/u01/dbebs/PROD/db/tech_st/11.2.0" TYPE="O" IDX="4"/>
<HOME NAME="OraDB19Home1" LOC="/u01/dbebs/PROD/db/tech_st/19.0.0" TYPE="O" IDX="5"/>
<HOME NAME="TEST_WEBOH__u01_appltestebs_PROD_apps_tech_st_10_1_3" LOC="/u01/appltestebs/PROD/apps/tech_st/10.1.3" TYPE="O" IDX="6"/>
<HOME NAME="TEST_TOOLS__u01_appltestebs_PROD_apps_tech_st_10_1_2" LOC="/u01/appltestebs/PROD/apps/tech_st/10.1.2" TYPE="O" IDX="7"/>
<HOME NAME="TEST_WEBOH__u01_appltestebs_TEST_apps_tech_st_10_1_3" LOC="/u01/appltestebs/TEST/apps/tech_st/10.1.3" TYPE="O" IDX="8"/>
<HOME NAME="TEST_TOOLS__u01_appltestebs_TEST_apps_tech_st_10_1_2" LOC="/u01/appltestebs/TEST/apps/tech_st/10.1.2" TYPE="O" IDX="9"/>