Oracle Restart upgrade fails with INS-40406 – The installer detects no existing Oracle Grid Infrastructure software

While upgrading 11203 Oracle restart environment to 11204, screen 2 – Selected option – “Upgrade oracle grid infra or oracle ASM”, fails with INS-40406 – The installer detects no existing Oracle Grid Infrastructure software Error.

Untitled

Following inventory entries were present, when upgrade started.

db-xxx-01:/u01/app/oraInventory/ContentsXML>cat inventory.xml
<?xml version=”1.0″ standalone=”yes” ?>
<!– Copyright (c) 1999, 2010, Oracle. All rights reserved. –>
<!– Do not modify the contents of this file by hand. –>
<INVENTORY>
<COMPOSITEHOME_LIST>
</COMPOSITEHOME_LIST>
<VERSION_INFO>
<SAVED_WITH>11.1.0.8.0</SAVED_WITH>
<MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>
</VERSION_INFO>
<HOME_LIST>
<HOME NAME=”Ora11gR2_DB” LOC=”/u01/app/oracle/product/11.2.0.3/database” TYPE=”O” IDX=”1″/>
<HOME NAME=”Ora11gR2_GI” LOC=”/u01/app/oracle/product/11.2.0.3/grid” TYPE=”O” IDX=”2″/>
</HOME_LIST>
</INVENTORY>

To fix the issue, use following CLI

$ runInstaller -updateNodeList ORACLE_HOME=”/u01/app/oracle/product/11.2.0.3/grid” CRS=true

Typically one would use updateNodeList flag when we are using RAC. But it also worked with Oracle restart environment.

Post fix, inventory contents were as following.

db-xxx-01:/u01/app/oraInventory/ContentsXML>cat inventory.xml
<?xml version=”1.0″ standalone=”yes” ?>
<!– Copyright (c) 1999, 2011, Oracle. All rights reserved. –>
<!– Do not modify the contents of this file by hand. –>
<INVENTORY>
<VERSION_INFO>
<SAVED_WITH>11.2.0.3.0</SAVED_WITH>
<MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>
</VERSION_INFO>
<HOME_LIST>
<HOME NAME=”Ora11gR2_DB” LOC=”/u01/app/oracle/product/11.2.0.3/database” TYPE=”O” IDX=”1″/>
<HOME NAME=”Ora11gR2_GI” LOC=”/u01/app/oracle/product/11.2.0.3/grid” TYPE=”O” IDX=”2″ CRS=”true”/>
</HOME_LIST>
<COMPOSITEHOME_LIST>
</COMPOSITEHOME_LIST>
</INVENTORY>

Difference is CRS=”true” in the grid entry. Post this change GUI allowed me to proceed further and install/upgrade 11204 binaries.

Advertisements
This entry was posted in Oracle Database Upgrade, Oracle Software Inventory and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s