Skip to Main Content

Oracle Database Discussions

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!

How to determine which patches have been applied to my DB?

Dear DBA FrankApr 18 2018 — edited Apr 20 2018

Oracle 12cR1.  My Oracle Homes are not all at the same level of patching.  PSUs have been applied to some, BPP have been applied to others.  I know I can see which patches have been applied to the Oracle Home binaries thanks to opatch lsinventory but how can I make sure that the corresponding ./datapatch -verbose was run on each of the databases of that Oracle Home?  In other words, how can I list all the patches that have been applied to an Oracle database?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 18 2018
Added on Apr 18 2018
10 comments
19,553 views