Q
Manage Learn to apply best practices and optimize your operations.

Upgrading HPUX Oracle

I want to upgrade my HPUX Oracle 9.2.0.3 ORACLE_HOME to 9.2.0.5. The problem is when I run the OUI (version 10.1.0.2) it doesn't find the ORACLE_HOME and lists the database install under 'Independant Products'.

Is there anyway of reinstating the ORACLE_HOME information into the oraInventory files? Or will I have to uninstall/reinstall the base product?

I have not found any way to repair the oraInventory when it gets corrupted unless you have an identical set of installations on another system that uses the exact same file layout (same platform, same patches, etc.). Without that, I think you're left with reinstalling. You may want to consider this alternate approach:

  • Back up your current oraInventory (incase this plan fails)
  • Remove/rename the oraInventory directory
  • Install 9.2.0.x and the 9.2.0.5 patchset to a new ORACLE_HOME
  • upgrade your database by shutting it (9.2.0.3) down, changing that database's ORACLE_HOME to the new ORACLE_HOME you installed (9.2.0.5) and following the upgrade steps (catpatch.sql, etc.)
  • Remove the 9.2.0.3 ORACLE_HOME using operating system commands since it is no longer registered in any oraInventory

That may get you to your desired end result without having to reinstall very much and also will minimize the downtime to the database.

Dig Deeper on Oracle database installation, upgrades and patches

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close