149 DBMS_QOPATCH
The DBMS_QOPATCH
package provides an interface to view the installed database patches.
This chapter contains the following topics:
149.1 DBMS_QOPATCH Overview
The DBMS_QOPATCH
package provides a PLSQL/SQL interface to view the installed database patches. The interface provides all the patch information available as part of the OPATCH LSINVENTORY -XML
command. The package accesses the OUI patch inventory in real time to provide patch and meta-information.
149.2 DBMS_QOPATCH Security Model
The DBMS_QOPATCH
package is created as part of SYS schema and SYS is the only user who can execute these subprograms.
149.3 DBMS_QOPATCH Operational Notes
The following operational notes apply to DBMS_QOPATCH.
-
The package will work only if the database is
OPEN
. -
In an Oracle Real Application Clusters (RAC) environment, if the subprogram requires to fetch data from other RAC nodes it spawns a job in the other node(s) to get the data. In this case
JOB_QUEUE_PROCESSES
needs to be>0
for the package to fetch the data from other RAC nodes. -
If there is a delay in the job execution, the package returns
ORA-20008
error.
149.4 DBMS_QOPATCH Exceptions
This table lists the exceptions raised by the DBMS_QOPATCH
package.
Table 149-1 DBMS_QOPATCH Error Messages
Error Code | Description |
---|---|
|
Latest XML inventory is not loaded into table. |
|
Directory creation failed. |
|
Configuration of a job on a node failed. |
|
Job configuration failed as node is inactive. |
|
Job is not configured with given node, instance name. |
|
Number of RAC active instances and opatch jobs configured are not same. |
|
Job configuration failed as node or instance is not active. |
|
Timed out - job execution time is more than 120Secs. |
|
Job execution failed. |
|
Node is inactive and job cannot be executed. |
|
Job name is |
|
|
|
|
|
Database is not opened. |
|
Database opened as read-only. |
149.5 Summary of DBMS_QOPATCH Subprograms
This table lists and briefly describes the DBMS_QOPATCH
package subprograms.
Table 149-2 DBMS_QOPATCH Package Subprograms
Subprogram | Description |
---|---|
Checks if a patch is installed. |
|
Provides a bugs list for a patch in XML format if the patch number is given. If patch is not given then it lists all the bugs installed in all the patches in XML format. |
|
Provides the total number of installed patches in XML format |
|
Provides top level patch information for the patch (such as Patch ID, patch creation time) in the XML element |
|
Provides the list of files modified in the given patch number in XML format |
|
Returns the XML element containing the |
|
Provides list of patches installed as an XML element from the XML inventory |
|
Returns whole opatch inventory as XML instance document. |
|
Provides overlay patches for a given patch as XML element |
|
Provides prerequisite patches for a given patch as XML element |
|
Returns the style-sheet for the opatch XML inventory presentation |
|
Displays the detailed patch information from |
|
Displays the SQL patch status by querying from SQL patch registry to produce complete patch level information |
|
Provides information (such as patchID, application date, and SQL patch information) on the installed patch as XML node by querying the XML inventory |
|
Compares the current database with a list of bugs. |
|
Compares the given RAC node(s) with the instance to the present connected node with current node. The return value indicates whether the data was refreshed or not. |
|
Sets the node name and instance to get the inventory details specific to it in an Oracle Real Application Clusters (RAC) environment |
149.5.1 CHECK_PATCH_INSTALLED Function
Checks if the patch is installed.
Syntax
DBMS_QOPATCH.CHECK_PATCH_INSTALLED ( bugs IN QOPATCH_LIST); RETURN VARCHAR2;
Parameters
Table 149-3 CHECK_PATCH_INSTALLED Parameters
Parameter | Description |
---|---|
|
List of patches to be checked. |
149.5.2 GET_OPATCH_BUGS Function
This function provides a bugs list in a patch if the patch number is given. If a patch number is not given, it lists all the bugs in the specified XML format.
Syntax
DBMS_QOPATCH.GET_OPATCH_BUGS ( patchnum IN VARCHAR2 DEFAULT NULL); RETURN XMLTYPE;
Parameters
Table 149-4 GET_OPATCH_BUGS Function Parameters
Parameter | Description |
---|---|
|
Patch number |
149.5.3 GET_OPATCH_COUNT Function
This function provides the total number of installed patches in XML format.
Syntax
DBMS_QOPATCH.GET_OPATCH_COUNT ( patchnum IN VARCHAR2); RETURN XMLTYPE;
Parameters
Table 149-5 GET_OPATCH_COUNT Function Parameters
Parameter | Description |
---|---|
|
Patch number |
149.5.4 GET_OPATCH_DATA Function
This function provides top level patch information for the patch (such as Patch ID, patch creation time) in the XML element.
Syntax
DBMS_QOPATCH.GET_OPATCH_DATA ( patchnum IN VARCHAR2); RETURN XMLTYPE;
Parameters
Table 149-6 GET_OPATCH_DATA Function Parameters
Parameter | Description |
---|---|
|
Patch number |
149.5.5 GET_OPATCH_FILES Function
This function provides the list of files modified in the given patch number in XML format.
Syntax
DBMS_QOPATCH.GET_OPATCH_FILES ( patchnum IN VARCHAR2); RETURN XMLTYPE;
Parameters
Table 149-7 GET_OPATCH_FILES Function Parameters
Parameter | Description |
---|---|
|
Patch number |
149.5.6 GET_OPATCH_INSTALL_INFO Function
This function returns the XML element containing the ORACLE_HOME
details such as patch and inventory location.
Syntax
DBMS_QOPATCH.GET_OPATCH_INSTALL_INFO RETURNS XMLTYPE;
149.5.7 GET_OPATCH_LIST Function
This function provides list of patches installed as an XML element from the XML inventory.
Syntax
DBMS_QOPATCH.GET_OPATCH_LIST RETURN XMLTYPE;
149.5.8 GET_OPATCH_LSINVENTORY
This function returns whole opatch inventory as XML instance document.
Syntax
DBMS_QOPATCH.GET_OPATCH_LSINVENTORY RETURN XMLTYPE;
149.5.9 GET_OPATCH_OLAYS Function
This function provides overlay patches for a given patch as XML element.
Syntax
DBMS_QOPATCH.GET_OPATCH_OLAYS ( patchnum IN VARCHAR2); RETURN XMLTYPE;
Parameters
Table 149-8 GET_OPATCH_OLAYS Function Parameters
Parameter | Description |
---|---|
|
Patch number |
149.5.10 GET_OPATCH_PREQS Function
This function provides prerequisite patches for a given patch as XML element.
Syntax
DBMS_QOPATCH.GET_OPATCH_PREQS ( patchnum IN VARCHAR2); RETURN XMLTYPE;
Parameters
Table 149-9 GET_OPATCH_PREQS Function Parameters
Parameter | Description |
---|---|
|
Patch number |
149.5.11 GET_OPATCH_XSLT
This function returns the style-sheet for the opatch XML inventory presentation. You can use the return type of this subprogram to perform XMLTRANSFORM and the transformed result has the same appearance as opatch text output.
Syntax
DBMS_QOPATCH.GET_OPATCH_XSLT RETURN XMLTYPE;
149.5.12 GET_PATCH_DETAILS Function
Displays the detailed patch information from opatch lsinventory
.
Syntax
DBMS_QOPATCH.GET_PATCH_DETAILS ( patch IN VARCHAR2); RETURN XMLTYPE;
Parameters
Table 149-10 GET_PATCH_DETAILS Function Parameters
Parameter | Description |
---|---|
|
The patch number. |
149.5.13 GET_SQLPATCH_STATUS Procedure
This procedure displays the SQL patch status by querying from SQL patch registry to produce complete patch level information. If the patch number is given, it displays the information specific to the given SQL patch, otherwise information for all SQL patches.
Syntax
DBMS_QOPATCH.GET_SQLPATCH_STATUS ( patchnum IN VARCHAR2 DEFAULT NULL);
Parameters
Table 149-11 GET_SQLPATCH_STATUS Procedure Parameters
Parameter | Description |
---|---|
|
Patch number |
149.5.14 IS_PATCH_INSTALLED Function
This function provides information (such as patchID, application date, and SQL patch information) on the installed patch as XML node by querying the XML inventory.
Syntax
DBMS_QOPATCH.IS_PATCH_INSTALLED ( patchnum IN VARCHAR2); RETURN XMLTYPE;
Parameters
Table 149-12 IS_PATCH_INSTALLED Function Parameters
Parameter | Description |
---|---|
|
Patch number |
149.5.15 OPATCH_COMPARE_CURRENT Function
Compares the current database with a list of bugs.
Syntax
DBMS_QOPATCH.OPATCH_COMPARE_CURRENT Function ( bugs IN QOPATCH_LIST); RETURN VARCHAR2;
Parameters
Table 149-13 OPATCH_COMPARE_CURRENT Function Parameters
Parameter | Description |
---|---|
|
List of bugs to compare with the current database. |
149.5.16 OPATCH_COMPARE_NODES Function
Compares the given RAC node(s) with the instance to the present connected node with current node. The return value indicates whether the data was refreshed or not.
Syntax
DBMS_QOPATCH.OPATCH_COMPARE_NODES ( node IN VARCHAR2 DEFAULT NULL, inst IN VARCHAR2 DEFAULT NULL); RETURN VARCHAR2;
Parameters
Table 149-14 OPATCH_COMPARE_NODES Function Parameters
Parameter | Description |
---|---|
|
Node name |
|
Instance name |
149.5.17 SET_CURRENT_OPINST Procedure
This procedure sets the node name and instance to get the inventory details specific to it in an Oracle Real Application Clusters (RAC) environment.
Syntax
DBMS_QOPATCH.SET_CURRENT_OPINST ( node_name IN VARCHAR2 DEFAULT NULL, inst_name IN VARCHAR2 DEFAULT NULL);
Parameters
Table 149-15 SET_CURRENT_OPINST Procedure Parameters
Parameter | Description |
---|---|
|
Name of node |
|
Name of instance |