Oracle | DBMS_CLOUD_ADMIN

Oracle DBMS_CLOUD_ADMIN_INTERNAL Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

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_CLOUD_ADMIN	DBMS_SYS_ERROR
DBA_EXTENTS	DBMS_CLOUD_CORE	DBMS_SYS_SQL
DBA_OBJECTS	DBMS_CLOUD_INTERNAL	DBMS_UTILITY
DBA_REGISTRY	DBMS_CLOUD_MACADM	GV$SESSION
DBA_ROLES	DBMS_DB_VERSION	JSON_ELEMENT_T
DBA_USERS	DBMS_SERVICE	JSON_OBJECT_T
DBMS_ASSERT	DBMS_SQL	V$PDBS
DBMS_CLOUD	DBMS_STANDARD

Documented No

Exceptions

Error Code	Reason
ORA-20998	CHANGE CHARACTER SET capability is not enabled

First Available 21c

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

-- prerequisites

      {ORACLE_HOME}/rdbms/admin/dbms_cloud_task_catalog.sql

      {ORACLE_HOME}/rdbms/admin/dbms_cloud_task_views.sql

      {ORACLE_HOME}/rdbms/admin/prvt_cloud_body.plb

      

      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	ENABLE_APP_CONT
CHANGE_NATIONAL_CHARACTER_SET	GET_APEX_SCHEMA
DISABLE_APP_CONT	GET_ENCRYPTION_KEY_INFO
DV_CHANGE_AUDIT	ROTATE_ENCRYPTION_KEY
DV_PRECHECKS	RUN_STMT

CHANGE_CHARACTER_SET

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);

      

      PL/SQL procedure successfully completed.

CHANGE_NATIONAL_CHARACTER_SET

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', FALSE);

      *

      ORA-20998: CHANGE CHARACTER SET is not enabled

DISABLE_APP_CONT

Disable Application Continuity dbms_cloud_admin_internal.disable_app_cont(service_name IN VARCHAR2);

exec dbms_cloud_admin_internal.disable_app_cont('PDBDEV');

      

      PL/SQL procedure successfully completed.

DV_CHANGE_AUDIT

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);

      

      PL/SQL procedure successfully completed.

      

      exec dbms_cloud_admin_internal.dv_change_audit(FALSE);

      

      PL/SQL procedure successfully completed.

DV_PRECHECKS

Undocumented dbms_cloud_admin_internal.dv_prechecks(opcode IN NUMBER);

TBD

ENABLE_APP_CONT

Enable Application Continuity dbms_cloud_admin_internal.enable_app_cont(service_name IN VARCHAR2);

exec dbms_cloud_admin_internal.enable_app_cont('PDBDEV');

      

      PL/SQL procedure successfully completed.

GET_APEX_SCHEMA

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;

      

      GET_APEX_SCHEMA

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

GET_ENCRYPTION_KEY_INFO (new 23ai)

Undocumented dbms_cloud_admin_internal.get_encryption_key_info RETURN json_object_t;

DECLARE

       retVal sys.json_object_t;

      BEGIN

        retVal := dbms_cloud_admin_internal.get_encryption_key_info;

      END;

      /


      PL/SQL procedure successfully completed.

ROTATE_ENCRYPTION_KEY

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

TBD

RUN_STMT (new 23ai)

Undocumented dbms_cloud_admin_internal.run_stmt( stmt IN VARCHAR2, userid IN NUMBER, parse_only IN BOOLEAN);

TBD