Again !!! Oracle 12c Under test , every time i tested it i discover new features, while i am testing today i found new folder under $ORACLE_HOME called QOPatch , for the first time when i opened this folder i only found two files,
Check the https://support.oracle.com note :
Oracle Database 12.1 : FAQ on Queryable Patch Inventory [ID 1530108.1]
from the name you can see it’s retrieve information using query, and to use query you have to get access to SQL Plus, this features allow you access to the OPatch information from within the database. This Package called DBMS_QOPATCH
Some of Attribute to use with this package :
- GET_OPATCH_INSTALL_INFO
- SET_CURRENT_OPINST
- GET_OPATCH_LIST
- IS_PATCH_INSTALLED
- GET_OPATCH_DATA
- GET_OPATCH_BUGS
- GET_OPATCH_FILES
- GET_OPATCH_COUNT
- GET_OPATCH_PREQS
- GET_OPATCH_OLAYS
- PATCH_CONFLICT_DETECTION
- GET_PENDING_ACTIVITY
- GET_OPATCH_XSLT
- GET_OPATCH_LSINVENTORY
- GET_SQLPATCH_STATUS
Since this function used to get Opatch information within database then you have to access to SQL Plus
Check the below examples :
SQL> select dbms_qopatch.get_opatch_lsinventory() from dual;
DBMS_QOPATCH.GET_OPATCH_LSINVENTORY()
——————————————————————————–
Another Examples :
SQL> select dbms_qopatch.GET_PENDING_ACTIVITY() from dual;
DBMS_QOPATCH.GET_PENDING_ACTIVITY()
——————————————————————————–
My Database still fresh and not patch yet So you will not find that much of information
Thank you
Osama mustafa
Very nice Osama. Im ready to install it in my VMs, what I missing is free time..lol…nice post!
LikeLike
24/24 Hours of testing this is only on Database level , Advance level such as Upgrade and Grid , nice features
LikeLike