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-5958ed72-136c-4adc-a078-e3ec7081a6e8 oracle_home oneoff /u01/app/oracle/product/12.1.0.1/db_1 oracle_home /u01/app/oraInventory […]
Follow Me!!!