From 12c onwards, you can view the database home patch list from sql prompt itself . A new package dbms_qopatch has been introduced to accomplish this.
Few cool sub routines in this package are get_opatch_install, lsinventory, opatch_bugs etc.
SQL> set longchunksize 1000 SQL> select DBMS_QOPATCH.get_opatch_install_info() from dual DBMS_QOPATCH.GET_OPATCH_INSTALL_INFO() ----------------------------------------------------------------------- <oraclehome><uid>OracleHome-5958ed72-136c-4adc-a078-e3ec7081a6e8</uid> <targettypeid>oracle_home</targettypeid> <patchingmodel>oneoff</patchingmodel> <path>/u01/app/oracle/product/12.1.0.1/db_1</path> <targettypeid>oracle_home</targettypeid> <inventorylocation>/u01/app/oraInventory</inventorylocation> <isshared>false</isshared> </oraclehome>
Opatch lsinventory (Typically inventory.xml file)
SQL> select DBMS_QOPATCH.get_opatch_lsinventory() from dual;
DBMS_QOPATCH.GET_OPATCH_LSINVENTORY()
---------------------------------------------------------------------------
< ?xml version="1.0" encoding="US-ASCII" standalone='yes'?>
SQL> select dbms_qopatch.GET_OPATCH_BUGS from dual; As i have no patches applied on this home, no rows returned.
-Thanks
Geek DBA
Follow Me!!!