<<Back to DB Administration Main Page
List All Patches Applied in Oracle Database and Usages of DBMS_QOPATCH
Run opatch lsinventory from $ORACLE_HOME/OPatch to check the patches applied. This will display you the patches applied at Oracle Binary.
$opatch lsinventoryor
$opatch lsinventory -display
or
$opatch lsinventory -details
To check if the patches applied at binary level is registered in database dictionary query registry$history.
How to Find the List of Patches Loaded in Database Dictionary
11g or BeforeExecute below command directly in the database as dba to check the list of patches registered in the database
SQL> select * from sys.registry$history;
for 12c and above
SQL> select * from sys.dba_registry_sqlpatch ;
or
SQL> SELECT patch_id, version, status, bundle_id, bundle_series
FROM dba_registry_sqlpatch;
FROM dba_registry_sqlpatch;
Using dbms_qopatch to Display the List of Patches Applied to a Database
SQL> set serverout on;SQL> exec dbms_qopatch.get_sqlpatch_status;
SQL> select dbms_qopatch.GET_OPATCH_LIST from dual;
Query for any specific patch that has been applied using dbms_qopatch?
SQL> select xmltransform(dbms_qopatch.is_patch_installed('21359755'), dbms_qopatch.get_opatch_xslt) "Patch installed?" from dual;Patch installed?
-------------------------------------------------------
Patch Information:
21359755: applied on 2015-10-21T23:48:17Z
What all you can do with DBMS_QOPATCH package.
SQL> desc dbms_qopatchFUNCTION ADD_OINV_JOB RETURNS BOOLEAN Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
NNAME VARCHAR2 IN
INAME VARCHAR2 IN
PROCEDURE CONFIG_OINV_JOBS
FUNCTION DROP_OINV_JOB RETURNS BOOLEAN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
NNAME VARCHAR2 IN
INAME VARCHAR2 IN
FUNCTION GET_OPATCH_BUGS RETURNS XMLTYPE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
PNUM VARCHAR2 IN DEFAULT
FUNCTION GET_OPATCH_COUNT RETURNS XMLTYPE
FUNCTION GET_OPATCH_DATA RETURNS XMLTYPE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
PNUM VARCHAR2 IN
FUNCTION GET_OPATCH_FILES RETURNS XMLTYPE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
PNUM VARCHAR2 IN
FUNCTION GET_OPATCH_INSTALL_INFO RETURNS XMLTYPE
FUNCTION GET_OPATCH_LIST RETURNS XMLTYPE
FUNCTION GET_OPATCH_LSINVENTORY RETURNS XMLTYPE
FUNCTION GET_OPATCH_OLAYS RETURNS XMLTYPE Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
PNUM VARCHAR2 IN
FUNCTION GET_OPATCH_PREQS RETURNS XMLTYPE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
PNUM VARCHAR2 IN
FUNCTION GET_OPATCH_XSLT RETURNS XMLTYPE
FUNCTION GET_PENDING_ACTIVITY RETURNS XMLTYPE
PROCEDURE GET_SQLPATCH_STATUS
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
PNUM VARCHAR2 IN DEFAULT
FUNCTION IS_PATCH_INSTALLED RETURNS XMLTYPE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
PNUM VARCHAR2 IN
PROCEDURE OPATCH_INV_REFRESH_JOB
PROCEDURE OPATCH_RUN_JOB
FUNCTION PATCH_CONFLICT_DETECTION RETURNS XMLTYPE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
FILENAME VARCHAR2 IN
PROCEDURE REFRESH_OPATCH_DATA
PROCEDURE REPLACE_DIRS_INT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
PF_ID NUMBER IN
PROCEDURE REPLACE_LOGSCRPT_DIRS
PROCEDURE SET_CURRENT_OPINST
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
NODE_NAME VARCHAR2 IN DEFAULT
INST_NAME VARCHAR2 IN DEFAULT
PROCEDURE SET_DEBUG
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
DEBUG BOOLEAN IN
PROCEDURE SKIP_SANITY_CHECK
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SKIP BOOLEAN IN
Comments
Post a Comment