Inventory - EBS upgrade 11.1.0.7 to 11.2.0.4

[satish]

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

[ErmanArslansOracleBlog]

If your 11.1.0.7 home is still there, then yes it is normal. There is a home there, and there is an inventory record there.

Send me the output after the following actions;

grep inventory_loc /etc/oraInst.loc

cd <to_the_directory_pointed_by_intentroy_loc> and do the following ls
ls -l inventory.xml

Then "cat" it and send me the output.

cat inventory.xml

[satish]

Hi erman,

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]$ls

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"/>-
</HOME_LIST>
</INVENTORY>
[oracrp@SSSTINDCPOPX02 ContentsXML]$

[ErmanArslansOracleBlog]

okay.. your 11.1.0.7 is still there. That can be removed, but I don't think it will give you any harm.
Did you continue your upgrade process without touching it? Any issues?