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.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments