* New in Oracle 12c is queryable Opatch. Oracle offers a set of tables and a PL/SQL packages to query the Oracle Inventory.Prior to Oracle 12c, it was not easy to List Oracle patches. Now from Oracle 12c and beyond, you can use the DBMS_QOPATCH package to list all patches.
* Using DBMS_QOPATCH feature, users can do:
Query what patches are installed from SQL*Plus.
Write wrapper programs to create reports and do validation checks across multiple environments.
Check patches installed on Oracle RAC nodes from a single location instead of having to log onto each one in turn.
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit