Missing ORACLE_HOME in inventory.xml
Last weekend we were planning on installing the latest CPU patch on one of our SUN servers that held a 10.2.0.2 database instance as well as an "old" 9.2.0.7 instance. To keep the auditors happy while we go thru the process of moving our applications to all run on 10g, we decided to patch the 9.2.0.7 binaries with the CPUJUL2007 (the last one for 9.2.0.7) CPU patchset at the same time.
However when we started "opatch", it errored out basically saying the ORACLE_HOME wasn't found in the "inventory.xml" file the 9.2.0.7 binaries were looking at. When I checked the file, I found that "opatch" was right on the mark. The 10.2.0.2 home was listed but the 9.2.0.7 home wasn't.
After reading several MetaLink articles strongly advising not to edit the file manually, we gave up on patching 9.2.0.7 and only patched our 10.2.0.2 binaries.
Can someone tell me how I can get the 9.2.0.7 ORACLE_HOME back into the inventory.xml file? Would it take a complete reinstall of the binaries using the OUI to get it there?
As always, THANKS for your help!