Oracle | DBMS_INTERNAL_ROLLING Demos, Syntax, and Sample Code

Oracle DBMS_INTERNAL_ROLLING Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Utilities supporting rolling upgrades and patches

AUTHID DEFINER

Dependencies

DBMS_ROLLING_LIB	ROLLING$DIRECTIVES	ROLLING$PLAN
ROLLING$CONNECTIONS	ROLLING$EVENTS	ROLLING$STATISTICS
ROLLING$DATABASES	ROLLING$PARAMETERS	ROLLING$STATUS

Documented No

First Available 12.1

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvtrupgis.plb

Subprograms

DESTROY_META	SET_UPGRADE_FLAGS	UPSERT_DGLRDINS
INSERT_DGLRDDIR	UPDATE_DGLRDINS_PROGRESS	UPSERT_DGLRDPAR
INSERT_DGLRDEVT	UPSERT_DGLRDCON	UPSERT_DGLRDSTA
IS_IDX_UNSUPPORTED	UPSERT_DGLRDDAT	UPSERT_DGLRDSTS
IS_PLSQL_PRAGMA

DESTROY_META

Undocumented dbms_internal_rolling.destroy_meta;

exec dbms_internal_rolling.destroy_meta;

      

      PL/SQL procedure successfully completed.

INSERT_DGLRDDIR

Undocumented dbms_internal_rolling.insert_dglrddir( directid_i IN NUMBER, phase_i IN NUMBER, taskid_i IN NUMBER, feature_i IN VARCHAR2, description_i IN VARCHAR2, target_i IN NUMBER, flags_i IN VARCHAR2, opcode_i IN NUMBER, p1_i IN VARCHAR2, p2_i IN VARCHAR2, p3_i IN VARCHAR2, spare1_i IN NUMBER, spare2_i IN NUMBER, spare3_i IN VARCHAR2);

TBD

INSERT_DGLRDEVT

Undocumented dbms_internal_rolling.insert_dglrdevt( eventid_i IN NUMBER, instid_i IN NUMBER, revision_i IN NUMBER, event_time_i IN TIMESTAMP, type_i IN VARCHAR2, status_i IN NUMBER, message_i IN VARCHAR2, spare1_i IN NUMBER, spare2_i IN NUMBER, spare3_i IN VARCHAR2);

TBD

IS_IDX_UNSUPPORTED

Undocumented dbms_internal_rolling.is_idx_unsupported(is_unsupported OUT BOOLEAN);

DECLARE

       outVal BOOLEAN;

      BEGIN

        dbms_internal_rolling.is_idx_unsupported(outVal);

        IF outVal THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      F

      

      PL/SQL procedure successfully completed.

IS_PLSQL_PRAGMA (new 21c)

Undocumented dbms_internal_rolling.is_plsql_pragma(is_pragmad OUT BOOLEAN);

DECLARE

       outVal BOOLEAN;

      BEGIN

        dbms_internal_rolling.is_plsql_pragma(outVal);

        IF outVal THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      F

      

      PL/SQL procedure successfully completed.

SET_UPGRADE_FLAGS

Set the rolling upgrade flag dbms_internal_rolling.set_upgrade_flag( dgid_i IN NUMBER, flags_i IN NUMBER, value_i IN NUMBER);

TBD

UPDATE_DGLRDINS_PROGRESS

Undocumented dbms_internal_rolling.jupdate_dglrdins_progress( progress_i IN NUMBER, exec_info_i IN VARCHAR2, instid_i IN NUMBER, revision_i IN NUMBER);

TBD

UPSERT_DGLRDCON

Undocumented dbms_internal_rolling.upsert_dglrdcon( source_rdbid_i IN NUMBER, dest_rdbid_i IN NUMBER, attributes_i IN NUMBER, service_name_i IN VARCHAR2, conn_handle_i IN NUMBER, connect_time_i IN TIMESTAMP, send_time_i IN TIMESTAMP, disconnect_time_i IN TIMESTAMP, update_time_i IN TIMESTAMP, source_pid_i IN NUMBER, dest_pid_i IN NUMBER, spare1_iI IN NUMBER, spare2_i I IN NUMBER, spare3_i I IN VARCHAR2);

TBD

UPSERT_DGLRDDAT

Undocumented dbms_internal_rolling.upsert_dglrddat( rdbid_i IN NUMBER, attributes_i IN NUMBER, attributes2_i IN NUMBER, dbun_i IN VARCHAR2, dbid_i IN NUMBER, prod_rscn_i IN NUMBER, prod_rid_i IN NUMBER, prod_scn_i IN NUMBER, cons_rscn_i IN NUMBER, cons_rid_i IN NUMBER, cons_scn_i IN NUMBER, engine_status_i IN NUMBER, version_i IN VARCHAR2, redo_source_i IN NUMBER, update_time_i IN TIMESTAMP, revision_i IN NUMBER, spare1_i IN NUMBER, spare2_i IN NUMBER, spare3_i IN VARCHAR2);

TBD

UPSERT_DGLRDINS

Undocumented dbms_internal_rolling.upsert_dglrdins( instid_i IN NUMBER, batchid_i IN NUMBER, directid_i IN NUMBER, taskid_i IN NUMBER, revision_i IN NUMBER, phase_i IN NUMBER, status_i IN NUMBER, progress_i IN NUMBER, source_i IN NUMBER, target_i IN NUMBER, rflags_i IN NUMBER, opcode_i IN NUMBER, p1_i IN VARCHAR2, p2_i IN VARCHAR2, p3_i IN VARCHAR2, p4_i IN VARCHAR2, description_i IN VARCHAR2, exec_status_i IN NUMBER, exec_info_i IN VARCHAR2, exec_time_i IN TIMESTAMP, finish_time_i IN TIMESTAMP, post_status_i IN NUMBER, spare1_i IN NUMBER, spare2_i IN NUMBER, spare3_i IN VARCHAR2);

TBD

UPSERT_DGLRDPAR

Undocumented dbms_internal_rolling.upsert_dglrdpar( scope_i IN NUMBER, name_i IN VARCHAR2, id_i IN NUMBER, descrip_i IN VARCHAR2, type_i IN NUMBER, datatype_i IN NUMBER, attributes_i IN NUMBER, curval_i IN VARCHAR2, lstval_i IN VARCHAR2, defval_i IN VARCHAR2, minval_i IN NUMBER, maxval_i IN NUMBER, spare1_i IN NUMBER, spare2_i IN NUMBER, spare3_i IN VARCHAR2);

TBD

UPSERT_DGLRDSTA

Undocumented dbms_internal_rolling.upsert_dglrdsta( statid_i IN NUMBER, rdbid_i IN NUMBER, attributes_i IN NUMBER, type_i IN NUMBER, name_i IN VARCHAR2, valuestr_i IN VARCHAR2, valuenum_i IN NUMBER, valuets_i IN TIMESTAMP, valueint_i IN INTERVAL DAY TO SECOND, update_time_i IN TIMESTAMP, spare1_i IN NUMBER, spare2_i IN NUMBER, spare3_i IN VARCHAR2);

TBD

UPSERT_DGLRDSTS

Undocumented dbms_internal_rolling.upsert_dglrdsts( revision_i IN NUMBER, phase_i IN NUMBER, batchid_i IN NUMBER, status_i IN NUMBER, coordid_i IN NUMBER, oprimary_i IN NUMBER, fprimary_i IN NUMBER, pid_i IN NUMBER, instance_i IN NUMBER, dbtotal_i IN NUMBER, dbactive_i IN NUMBER, location_i IN VARCHAR2, init_time_i IN TIMESTAMP, build_time_i IN TIMESTAMP, start_time_i IN TIMESTAMP, switch_time_i IN TIMESTAMP, finish_time_i IN TIMESTAMP, last_instid_i IN NUMBER, last_batchid_i IN NUMBER, spare1_i IN NUMBER, spare2_i IN NUMBER, spare3_i IN VARCHAR2);

TBD