Oracle | DBMS_CLOUD_ADMIN

Oracle DBMS_CLOUD_ADMIN_INTERNAL Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

Purpose Undocumented

AUTHID DEFINER

Dependencies

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

Security Model Owned by SYS with no privileges granted

Undocumented {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.

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