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
Like this:
Like Loading...
Related
Published by Osama Mustafa
Osama considered as one of the leaders in Coud technology, DevOps and database in the Middle-East. I have more than ten years of experience within the industry. moreover, certfied 4x AWS , 4x Azure and 6x OCI, have also obtained database certifications for multiple providers.
In addition to having experience with Oracle database and Oracle products, such as middle-ware, OID, OAM and OIM, I have gained substantial knowledge with different databases.
Currently, I am architecting and implementing Cloud and DevOps. On top of that, I'm providing solutions for companies that allow them to implement the solutions and to follow the best practices.
View all posts by 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