Oracle DBMS_SQLPATCH
Version 12.1.0.2

General Information
Library Note Morgan's Library Page Header
The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.2 to 12.2.0.1. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Also important ... there are rumors on the web about SPARC and Solaris being discontinued. Welcome to the age of fake news. There is absolutely not a byte of truth to these irresponsible rumors.
Purpose Undocumented support utility supporting SQL patching.
AUTHID DEFINER
Constants
Name Data Type Value
version NUMBER 1
Dependencies
DBA_REGISTRY_SQLPATCH DBMS_REGISTRY XMLTYPE
DBMS_OUTPUT DBMS_STANDARD XQSEQUENCE
DBMS_QOPATCH V$INSTANCE  
Documented No
First Available 12.1.0.2
Security Model Owned by SYS with no privileges granted.
Source {ORACLE_HOME}/rdbms/admin/dbmssqlpatch.sql
catdwgrd.sql
Subprograms
 
INSTALL_FILE
 For the current patch and mode under consideration, determines if the file should be run. Returns the name of the file to be run, which will either be the supplied input file (prefixed with top_directory supplied during initialisze) or dbms_registry.nothing_script if the file does not need to be run. dbms_sqlpatch.install_file(sql_file IN VARCHAR2) RETURN VARCHAR2;
TBD
 
PATCH_FINALIZE
Performs any finalization necessary for the current patch. This includes clearing the package state and updating the SQL registry dbms_sqlpatch.patch_finalize;
exec dbms_sqlpatch.patch_finalize;
 
PATCH_INITIALIZE
Performs any initialization necessary for the given patch, including the initial insert to the SQL registry dbms_sqlpatch.patch_initialize(
p_patch_id      IN NUMBER,
p_patch_uid     IN NUMBER,
p_flags         IN VARCHAR2,
p_description   IN VARCHAR2,
p_action        IN VARCHAR2,
p_logfile       IN VARCHAR2,
p_bundle_series IN VARCHAR2 DEFAULT NULL);
TBD
 
SESSION_INITIALIZE
Performs session initialization. Must be called before patch_initialize dbms_sqlpatch.session_initialize(
p_oh    IN VARCHAR2,
p_force IN BOOLEAN := FALSE,
p_debug IN BOOLEAN := FALSE);
DECLARE
 xRet XMLTYPE;
BEGIN
  xRet := dbms_sqlpatch.sql_registry_state;
  dbms_sqlpatch.session_initialize(USER);
END;
/
 
SQL_REGISTRY_STATE
Performs session initialization. Must be called before patch_initialize dbms_sqlpatch.sql_registry_state RETURN XMLType;
SELECT dbms_sqlpatch.sql_registry_state
FROM dual;

SQL_REGISTRY_STATE
------------------------------
<sql_registry_state>
<!-- Non bundle patches -->

<!-- Bundle patches -->
</sql_registry_state>
 
VERIFY_QUERYABLE_INVENTORY
Tests the queryable inventory functionality. If QI is working properly, then the string 'OK' is returned, otherwise any errors are returned. dbms_sqlpatch.verify_queryable_inventory RETURN VARCHAR2;
SELECT dbms_sqlpatch.verify_queryable_inventory
FROM dual;

VERIFY_QUERYABLE_INVENTORY
---------------------------
OK

Related Topics
DBMS_INTERNAL_ROLLING
DBMS_QOPATCH
DBMS_ROLLING
Packages
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved