Oracle | DBMS_CLOUD_ADMIN

Oracle DBMS_CLOUD_ADMIN_INTERNAL 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 Internal administrative procedures for actions in the Oracle Autonomous Cloud Database environment.

AUTHID DEFINER

Dependencies (not based on Autonomous Database)

AUDIT_UNIFIED_ENABLED_POLICIES	DBMS_ASSERT	DBMS_STANDARD
DBA_EXTENTS	DBMS_CLOUD	DBMS_SYS_ERROR
DBA_OBJECTS	DBMS_CLOUD_CAPABILITY	DBMS_SYS_SQL
DBA_REGISTRY	DBMS_SERVICE	DBMS_UTILITY
DBA_ROLES	DBMS_SESSION	GV$SESSION
DBA_USERS	DBMS_SQL	V$PDBS

Documented No

First Available 21c

Package Deployment {ORACLE_HOME}/rdbms/admin/prvt_cloud_admin_int.plb
{ORACLE_HOME}/rdbms/admin/prvt_cloud_admin_int_body.plb

-- prerequisite DBMS_CLOUD_CORE

      

      SQL> @?/rdbms/admin/prvt_cloud_admin_int.plb

      

      Session altered.

      

      SP2-0808: Package created with compilation warnings

      

      Errors for PACKAGE DBMS_CLOUD_ADMIN_INTERNAL:

      

      LINE/COL ERROR

      ------------------------------------------------------------------------

      1/1 PLW-05018: unit DBMS_CLOUD_ADMIN_INTERNAL omitted optional AUTHID

      clause; default value DEFINER used

      

      67/9 PLW-06010: keyword "NAME" used as a defined name

      68/9 PLW-06010: keyword "FORCE" used as a defined name

      92/9 PLW-06010: keyword "NAME" used as a defined name

      93/9 PLW-06010: keyword "FORCE" used as a defined name

      

      Session altered.

      

      SQL> @?/rdbms/admin/prvt_cloud_admin_int_body.plb

      

      Session altered.

      

      SP2-0810: Package Body created with compilation warnings

      

      Errors for PACKAGE BODY DBMS_CLOUD_ADMIN_INTERNAL:

      

      LINE/COL ERROR

      -------- -----------------------------------------------------------------

      191/5 PLW-07206: analysis suggests that the assignment to 'L_CUR' may be unnecessary

      

      207/9 PLW-06010: keyword "TYPE" used as a defined name

      248/3 PLW-05005: subprogram GET_CHARSET_TYPE_STR returns without value at line 276

      

      249/9 PLW-06010: keyword "TYPE" used as a defined name

      283/9 PLW-06010: keyword "NAME" used as a defined name

      284/9 PLW-06010: keyword "TYPE" used as a defined name

      285/9 PLW-06010: keyword "FORCE" used as a defined name

      347/22 PLW-07204: conversion away from column type may result in sub-optimal query plan

      

      431/14 PLW-06009: procedure "KILL_SESSIONS" OTHERS handler does not end in RAISE

      

      448/9 PLW-06010: keyword "TYPE" used as a defined name

      574/9 PLW-06010: keyword "NAME" used as a defined name

      575/9 PLW-06010: keyword "TYPE" used as a defined name

      576/9 PLW-06010: keyword "FORCE" used as a defined name

      638/14 PLW-06009: procedure "CHANGE_CHARACTER_SET_INT" OTHERS handler does 
      not end in RAISE

      

      776/9 PLW-06010: keyword "NAME" used as a defined name

      777/9 PLW-06010: keyword "FORCE" used as a defined name

      794/9 PLW-06010: keyword "NAME" used as a defined name

      795/9 PLW-06010: keyword "FORCE" used as a defined name

      

      Session altered.

Security Model Owned by SYS with no privileges granted

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

Subprograms

CHANGE_CHARACTER_SET	DV_CHANGE_AUDIT	GET_APEX_SCHEMA
CHANGE_NATIONAL_CHARACTER_SET	DV_PRECHECKS	ROTATE_ENCRYPTION_KEY
DISABLE_APP_CONT	ENABLE_APP_CONT

CHANGE_CHARACTER_SET (new 21c)

Changes the database's character set dbms_cloud_admin_internal.change_character_set( name IN VARCHAR2, force IN BOOLEAN);

SELECT parameter, value

      FROM v$nls_parameters

      WHERE parameter LIKE '%LANG%'

      ORDER BY 1;

      

      PARAMETER          VALUE

      ------------------ ---------

      NLS_DATE_LANGUAGE AMERICAN

      NLS_LANGUAGE      AMERICAN

      

      exec dbms_cloud_admin_internal.change_character_set('AMERICAN', FALSE);

CHANGE_NATIONAL_CHARACTER_SET (new 21c)

Changes the database's national character set dbms_cloud_admin_internal.change_national_character_set( name IN VARCHAR2, force IN BOOLEAN);

exec dbms_cloud_admin_internal.change_national_character_set('AL16UTF16');

DISABLE_APP_CONT (new 21c)

Undocumented dbms_cloud_admin_internal.disable_app_cont(service_name IN VARCHAR2);

exec dbms_cloud_admin_internal.disable_app_cont('PDBDEV');

DV_CHANGE_AUDIT (new 21c)

Enables or Disables Data base Vault Auditing dbms_cloud_admin_internal.dv_change_audit(enable IN BOOLEAN);

exec dbms_cloud_admin_internal.dv_change_audit(TRUE);

      exec dbms_cloud_admin_internal.dv_change_audit(FALSE);

DV_PRECHECKS (new 21c)

Undocumented dbms_cloud_admin_internal.dv_prechecks(opcode IN NUMBER);

TBD

ENABLE_APP_CONT (new 21c)

Undocumented dbms_cloud_admin_internal.enable_app_cont(service_name IN VARCHAR2);

exec dbms_cloud_admin_internal.enable_app_cont('PDBDEV')

GET_APEX_SCHEMA (new 21c)

Returns the name of an installed APEX schema, else NULL dbms_cloud_admin_internal.get_apex_schema RETURN VARCHAR2;

SELECT dbms_cloud_admin_internal.get_apex_schema

      FROM dual;

      

      GET_APEX_SCHEMA

      ----------------

ROTATE_ENCRYPTION_KEY (new 21c)

Changes the Cloud environment encryption key dbms_cloud_admin_internal.rotate_encryption_key(enc_key IN VARCHAR2);

TBD