Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Determine Patch Level

996766Mar 18 2013 — edited Mar 19 2013
HI All,
I would like some advice on how I can determine the patch level of an 11gR2 database home. The basic chain of events is as follows:

* Oracle RAC 11.2.0.3.2 is installed onto a two node cluster. The grid infrastructure is running, with 5 different ASM disk groups. The database software is installed, but no database has yet been created.

* Oracle Patch 14727347 ( GI patch 11.2.0.3.5, including database PSU 11.2.0.3.5 ) is installed. The patch is installed according to 'Case 1', which allows for the patching of both the GI and DB home together. NO ORACLE_HOME is specified on the command line, however the environment is set to the GI HOME. The patch appears to have gone on without any problems.

* When I change to the GI home, and run opatch lsinventory, I can see that the 11.2.0.3.5 patch has been applied to both GI and DB homes

* When I change to the DB home (and I have to do this by exporting ORACLE_HOME, since no database has yet been created), and run opatch from the DB home, the results say that both GI and DB home are still at 11.2.0.3.2.

My question is why does opatch, when run from different homes, now reports two different versions of software? How do I know which is correct?

Any help will be greatly appreciated.

Thanks
Gavin
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 16 2013
Added on Mar 18 2013
3 comments
2,471 views