Inventory - EBS upgrade 11.1.0.7 to 11.2.0.4

Posted by satish on Sep 10, 2022; 3:15pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Inventory-EBS-upgrade-11-1-0-7-to-11-2-0-4-tp11067.html

Dear Erman,

Dear Erman,

We are in process of upgrading EBS database 11.1.0.7 to 11.2.0.4.

We have uncommented the environment file in .bash_profile and relogin to make sure no environment is set before installing 11.2.0.4

We are not using central inventory on this existing 11.1.0.7 machine.

cat /etc/oraInst.loc-->no such file or directory

We have set below variables before we install 11.2.0.4

[oracrp@SSSTINDCPOPX02 u02]$ cat a.env
export ORACLE_BASE=/u02/TEST/db/tech_st
export ORACLE_SID=SSSEBSTR
export ORACLE_HOME=/u02/TEST/db/tech_st/11.2.0------------------>
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/perl/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PERL5LIB=$ORACLE_HOME/perl/lib/5.10.:$ORACLE_HOME/perl/lib/site_perl/5.10.0

Installed 11.2.0.4 successfully and we also applied additional patches on top of 11.2.0.4

After installation:

/etc/oraInst.loc file created

[oracrp@SSSTINDCPOPX02 11.2.0]$ cat oraInst.loc
inventory_loc=/u02/TEST/oraInventory
inst_group=dba
[oracrp@SSSTINDCPOPX02 11.2.0]$

[oracrp@SSSTINDCPOPX02 u02]$ cd /u02/TEST/db/tech_st/11.2.0
[oracrp@SSSTINDCPOPX02 11.2.0]$ cat oraInst.loc
inventory_loc=/u02/TEST/oraInventory
inst_group=dba
[oracrp@SSSTINDCPOPX02 11.2.0]$

When we check in inventory,we can see below entries related to 11.1.0.7 in inventory.xml.is this normal?Please suggest

comps.xml  inventory.xml  inventory.xml123  libs.xml
[oracrp@SSSTINDCPOPX02 ContentsXML]$ cat inventory.xml
<?xml version="1.0" standalone="yes" ?>


<INVENTORY>
<COMPOSITEHOME_LIST>
</COMPOSITEHOME_LIST>
<VERSION_INFO>
   <SAVED_WITH>11.1.0.7.0</SAVED_WITH>
   <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>
</VERSION_INFO>
<HOME_LIST>
<HOME NAME="OraDb11g_home1" LOC="/u02/TEST/db/tech_st/11.2.0" TYPE="O" IDX="1"/>
<HOME NAME="SSSEBSTR_DB__u02_TEST_db_tech_st_11_1_0" LOC="/u02/TEST/db/tech_st/11.1.0" TYPE="O" IDX="2"/>--------->This one
</HOME_LIST>
</INVENTORY>
[oracrp@SSSTINDCPOPX02 ContentsXML]$



Thanks,
Satish