Oracle POD_CDB_ADMIN
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 APIs for provisioning and managing PDBs within a pod in an Autonomous Database

Translated into a comprehensible language it appears that new words such as POD and previously used words that likely have a new definition such as TENANT appear to relate this and other POD_CDB objects to the new Autonomous Database. It is likely they have no relevance to other Oracle Database deployments but that supposition is unconfirmed.

If the suspicion is confirmed it is likely that Autonomous Databases are not only not serviced by SYS but are not serviced by RMAN either or, that RMAN is called using a new and different set of built-in PL/SQL packages.

The source for the two known dependent objects could not be found so a valid deployment of this package was not possible.
AUTHID DEFINER
Constants
Name Data Type Value
 Health Check Constants
CHECK_HEALTH_BASIC NUMBER 1
CHECK_HEALTH_ADVANCED NUMBER 2
 Type Definitions
MAX_BINDS NUMBER 10
BIND_NAMELEN NUMBER 16
Data Types TYPE bind_var_type IS VARRAY(MAX_BINDS) OF anydata;

TYPE bind_name_type IS VARRAY(MAX_BINDS) OF VARCHAR2(BIND_NAMELEN);
Dependencies
ANYDATA JSON_ARRAY_T JSON_ELEMENT_T
     
Documented No
Exceptions
Error Code Reason
N/A tenant_not_found
   
   
First Available Not known
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/pod_cdb_admin_spec.sql
{ORACLE_HOME}/rdbms/admin/pod_cdb_admin.plb
SQL> @?/rdbms/admin/pod_cdb_admin_spec.sql

Warning: Package created with compilation errors.

Errors for PACKAGE POD_CDB_ADMIN:

LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PL/SQL: Compilation unit analysis terminated
51/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

110/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

131/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

153/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

158/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

183/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

197/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

224/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

229/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

249/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

254/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

274/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

284/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

352/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

357/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

375/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

388/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

407/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

432/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

437/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

448/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

465/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

486/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

507/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

519/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

523/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

532/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

543/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

571/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

576/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

590/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

594/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

605/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

613/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

619/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

626/5 PLW-07203: parameter 'REPORT' may benefit from use of the NOCOPY
compiler hint

644/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

650/5 PLW-07203: parameter 'REPORT' may benefit from use of the NOCOPY
compiler hint

657/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

668/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

673/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

679/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

685/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

696/37 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

700/33 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

713/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

737/42 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

765/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

776/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

787/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

797/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

808/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

813/5 PLW-07203: parameter 'POOL_PDB_NAME' may benefit from use of the
NOCOPY compiler hint

817/5 PLW-07203: parameter 'PDB_NAME' may benefit from use of the
NOCOPY compiler hint

864/28 PLS-00201: identifier 'POD_RSRC_IINFO_ARR' must be declared
Subprograms
 
ADD_ACL_PDB (new 21c)
Add the specified access control entries for a PDB pod_cdb_admin.add_acl_pdb(
request IN  CLOB,
status  OUT CLOB);
TBD
 
BACKUP_AFTER_CREATION (new 21c)
Set up backup for PDB after creation and configures to exclude sample schema and sets up a trigger to back up this PDB during next batch PDB job pod_cdb_admin.backup_after_creation(
request IN  CLOB,
status  OUT CLOB);
Syntax Undocumented
 
BACKUP_ARCHIVELOG (new 21c)
Backup archivelogs

Overload 1
pod_cdb_admin.backup_archivelog(
run_in_sync    IN  BOOLEAN  DEFAULT FALSE,
job_id         IN  VARCHAR2 DEFAULT NULL,
job_type       IN  VARCHAR2 DEFAULT NULL,
job_subtype    IN  VARCHAR2 DEFAULT NULL,
rcvcat_connstr IN  VARCHAR2 DEFAULT NULL,
retention_days IN  NUMBER   DEFAULT 60,
debug          IN  VARCHAR2 DEFAULT NULL,
savelog        IN  BOOLEAN  DEFAULT FALSE,
tag            IN  VARCHAR2 DEFAULT NULL,
status         OUT CLOB);
exec pod_cdb_admin.backup_archivelog(retention_days => 90);
Overload 2 pod_cdb_admin.backup_archivelog(
request IN  CLOB,
status  OUT CLOB);
TBD
 
BACKUP_CDB (new 21c)
Procedure to backup a CDB

Overload 1
pod_cdb_admin.backup_cdb(
is_full_backup          IN  BOOLEAN  DEFAULT FALSE,
is_cum_incr             IN  BOOLEAN  DEFAULT FALSE,
backup_outstanding_pdbs IN  BOOLEAN  DEFAULT FALSE,
run_in_sync             IN  BOOLEAN  DEFAULT FALSE,
job_id                  IN  VARCHAR2 DEFAULT NULL,
job_type                IN  VARCHAR2 DEFAULT NULL,
job_subtype             IN  VARCHAR2 DEFAULT NULL,
rcvcat_connstr          IN  VARCHAR2 DEFAULT NULL,
retention_days          IN  NUMBER   DEFAULT 60,
debug                   IN  VARCHAR2 DEFAULT NULL,
savelog                 IN  BOOLEAN  DEFAULT FALSE,
tag                     IN  VARCHAR2 DEFAULT NULL,
restart                 IN  BOOLEAN  DEFAULT FALSE,
status                  OUT CLOB);
TBD
Overload 2 pod_cdb_admin.backup_cdb(
request IN  CLOB,
status  OUT CLOB);
TBD
 
BACKUP_MAINTENANCE (new 21c)
Executes backup maintenance activities pod_cdb_admin.backup_maintenance(
request IN  CLOB,
status  OUT CLOB);
TBD
 
BACKUP_PDB (new 21c)
Backup a PDB pod_cdb_admin.backup_pdb(
request IN  CLOB,
status  OUT CLOB);
TBD
 
BACKUP_VALIDATE (new 21c)
Backup validate pod_cdb_admin.backup_validate(
request IN  CLOB,
status  OUT CLOB);
TBD
 
CAN_BACKUP_PDB (new 21c)
Checks whether a PDB backup can be made pod_cdb_admin.can_backup_pdb(
request IN  CLOB,
status  OUT CLOB);
TBD
 
CHANGE_ADMIN_PASSWD (new 21c)
Changes the password for the admin user pod_cdb_admin.change_admin_passwd(
request IN  CLOB,
status  OUT CLOB);
TBD
 
CHANGE_ORDS_USER_PASSWD (new 21c)
Changes the password for the ORDS proxy user pod_cdb_admin.change_ords_user_passwd(
request IN  CLOB,
status  OUT CLOB);
TBD
 
CHECK_HEALTH (new 21c)
Check system health level: Either CHECK_HEALTH_BASIC or CHECK_HEALTH_ADVANCED pod_cdb_admin.check_health(
request IN  CLOB,
status  OUT CLOB);
TBD
 
CLEAR_ACL_PDB (new 21c)
Clears all access control entries for PDB pod_cdb_admin.clear_acl_pdb(
request IN  CLOB,
status  OUT CLOB);
TBD
 
CLEAR_LOG_ARCHIVE_DEST (new 21c)
Clears the archivelog destination for the refresh clone pod_cdb_admin.clear_log_archive_dest(
request IN  CLOB DEFAULT NULL,
status  OUT CLOB);
TBD
 
CLONE_TENANT (new 21c)
create a [normal/hot/refreshable] clone pod_cdb_admin.clone_tenant(
request IN  CLOB,
status  OUT CLOB);
TBD
 
CLONE_TENANT_JOB (new 21c)
Same as clone_tenant except that it is called by dbms_scheduler job

Overload 1
pod_cdb_admin.clone_tenant_job(
command_id               IN VARCHAR2,
tenant_name              IN VARCHAR2,
pdb_name                 IN VARCHAR2,
source_pdb_name          IN VARCHAR2,
source_dblink_user       IN VARCHAR2     DEFAULT NULL,
source_dblink_passwd     IN VARCHAR2     DEFAULT NULL,
source_dblink_conn       IN VARCHAR2     DEFAULT NULL,
metadata_only            IN BOOLEAN      DEFAULT FALSE,
refreshable              IN BOOLEAN      DEFAULT FALSE,
max_size                 IN VARCHAR2     DEFAULT NULL,
cpu_count                IN NUMBER       DEFAULT NULL,
rsrc_cpu_count           IN NUMBER       DEFAULT NULL,
max_pdbs                 IN NUMBER       DEFAULT 0,
admin_user               IN VARCHAR2     DEFAULT 'ADMIN',
admin_passwd             IN VARCHAR2     DEFAULT NULL,
tenant_key               IN VARCHAR2     DEFAULT NULL,
rcvcat_connstr           IN VARCHAR2     DEFAULT NULL,
is_passwd_hash           IN BOOLEAN      DEFAULT FALSE,
pool_pdb                 IN BOOLEAN      DEFAULT FALSE,
pool_tenant_name         IN VARCHAR2     DEFAULT NULL,
ace_hosts                IN json_array_t DEFAULT NULL,
ocid_cloud_database_name IN VARCHAR2     DEFAULT NULL,
ocid_tenant_name         IN VARCHAR2     DEFAULT NULL,
ocid_compartment_id      IN VARCHAR2     DEFAULT NULL,
database_name            IN VARCHAR2     DEFAULT NULL,
region                   IN VARCHAR2     DEFAULT NULL,
request_id               IN VARCHAR2     DEFAULT NULL,
extreme_availability     IN BOOLEAN      DEFAULT FALSE,
open_pdb                 IN BOOLEAN      DEFAULT TRUE);
TBD
Overload 2 pod_cdb_admin.clone_tenant_job(request IN CLOB);
TBD
 
CLOSE_TENANT (new 21c)
Close a tenant PDB

Overload 1
pod_cdb_admin.close_tenant(
tenant_name              IN  VARCHAR2,
pdb_name                 IN  VARCHAR2,
force                    IN  CHAR     DEFAULT 'N',
ocid_cloud_database_name IN  VARCHAR2 DEFAULT NULL,
ocid_tenant_name         IN  VARCHAR2 DEFAULT NULL,
ocid_compartment_id      IN  VARCHAR2 DEFAULT NULL,
status                   OUT CLOB);
TBD
Overload 2 pod_cdb_admin.close_tenant(
request IN  CLOB,
status  OUT CLOB);
TBD
 
CONFIG_POD (new 21c)
Undocumented pod_cdb_admin.config_pod(
request IN  CLOB,
status  OUT CLOB);  -- error code/status of operation
Syntax Undocumented
 
CREATE_CLEANING_JOB (new 21c)
Creates scheduler for purge pod_cdb_admin.create_cleaning_job;
exec pod_cdb_admin.create_cleaning_job;
 
CREATE_DBFS (new 21c)
Create dbfs mount points for a PDB pod_cdb_admin.create_dbfs(request IN CLOB);
Syntax Undocumented
 
CREATE_LOGSTASH_DBINFO_JOB (new 21c)
Create a job for sending database info logs pod_cdb_admin.create_logstash_dbinfo_job(request IN CLOB);
Syntax Undocumented
 
CREATE_PROGRESS_JOB (new 21c)
Creates scheduler for progress pod_cdb_admin.create_progress_job;
exec pod_cdb_admin.create_progress_job;
 
DELETE_BACKUP_CDB (new 21c)
Delete a CDB Backup pod_cdb_admin.delete_backup_cdb(
request IN  CLOB,
status  OUT CLOB);
Args:
 run_in_sync    - run job in sync mode
 rcvcat_connstr - recovery catalog connect string
 status         - status from running the operation
 
DELETE_BACKUP_PDB (new 21c)
Delete a PDB Backup pod_cdb_admin.delete_backup_pdb(
request IN  CLOB,
status  OUT CLOB);
Args:
 tenant_name    - name of the tenant for rewind
 pdb_name       - name of pdb associated with tenant
 run_in_sync    - run job in sync mode
 rcvcat_connstr - recovery catalog connect string
 status         - status from running the operation
 
DROP_UNUSED_TEMP_TBS (new 21c)
Drop an unused temp tablespaces pod_cdb_admin.drop_unused_temp_tbs(
request IN  CLOB,
status  OUT CLOB);
Args:
 pdb_name - name of pdb associated with tenant
 status   - status from running the operation
 
DROP_UNUSED_UNDO_TBS (new 21c)
Drop an unused undo tablespaces pod_cdb_admin.drop_unused_undo_tbs(
request IN  CLOB,
status  OUT CLOB);
Args:
 pdb_name - name of pdb associated with tenant
 status   - status from running the operation
 
EXECUTE_SQL (new 21c)
Executes a SQL patch for cloud operations pod_cdb_admin.execute_sql(
request IN  CLOB,
status  OUT CLOB);
Syntax Undocumented
 
GEN_PARTIAL_ARCHIVELOG (new 21c)
Generate partial archive logs pod_cdb_admin.gen_partial_archivelog(
request IN  CLOB,
status  OUT CLOB);
Args:
 job_type      - job type from WLS
 job_subtype   - job subtype from WLS
 pdbcs_connstr - pdbcs connect string
 debug         - debug information passed to script
 savelog       - TRUE if output needs to be saved as OS file
 status        - OUT status containing return code, error messages
 
GET_ACL_PDB (new 21c)
Retrieves the PDB's access control list pod_cdb_admin.get_acl_pdb(
request IN  CLOB,
status  OUT CLOB);
Args:
 tenant_name - name of the tenant to modify acl
 pdb_name    - name of pdb associated with tenant
 status      - status from running the operation
 
GET_ASYNC_JOB_STATUS (new 21c)
Returns the status of a running asynchronous job pod_cdb_admin.get_async_job_status(
request IN  CLOB,   -- command return status
status  OUT CLOB);  -- status of the running operation
Args:
 p_command_id - return status of this command
 status       - status from running the operation
 
GET_LOGGING (new 21c)
Returns logging attributes pod_cdb_admin.get_logging(
request IN  CLOB,
report  OUT CLOB);
DECLARE
 inVal  CLOB := '[{"tenant_name": "tenant1","pdb_name": "pdb_name1"}]';
 outVal CLOB;
BEGIN
  pod_cdb_admin.get_logging(inVal, outVal);
  dbms_output.put_line(outVal);
END;
/
 
GET_PDB_BACKUPS (new 21c)
Take a PDB backup pod_cdb_admin.get_pdb_backups(
request IN  CLOB,
status  OUT CLOB);
Args:
 tenant_name    - name of the tenant for backup
 pdb_name       - name of pdb associated with tenant
 start_date     - the least recent date interested
 end_date       - the most recent date interested
 rcvcat_connstr - recovery catalog connect string
 pod_dbid       - dbid of the pod
 pdb_guid       - guid of the pdb
 retention_days - retention days for backup
 status         - a list of dates when the backup is being made
 
GET_RSRC_CPU_COUNT (new 21c)
Returns the resource cpu count of a PDB on IN instance pod_cdb_admin.get_rsrc_cpu_count(
instance_id IN NUMBER,
pdb_name    IN VARCHAR2,
con_id      IN NUMBER   DEFAULT NULL)
RETURN NUMBER;
Args:
 instance_id - id of the instance on which the pdb is open
 pdb_name    - name of the pdb
 con_id      - con id of the pdb
 
KILL_JOB (new 21c)
Kills an unspecified job: No syntax provided pod_cdb_admin.kil_job(
request IN  CLOB,
status  OUT CLOB);
Syntax Undocumented
 
KILL_LONG_SESSIONS (new 21c)
Kills long running sessions pod_cdb_admin.kill_long_sessions(
request IN  CLOB,  -- array of modules to be killed
status  OUT CLOB); -- statu containing return code
Request Syntax:
[{"module": "module1","timeout_sec": 1},
 {"module": "module2",'action": "action2", "client_id": "client_id2", "tenant_name":
  "name2"},
 {..}
]
 
KILL_REMOTE_SESSIONS (new 21c)
Kills database user sessions during wallet rotation. If PDB name is null, then it is a regional wallet rotation and all
PDB DB user session under a tenant tenant_name should be cleaned. If pdb_name is not null, then it is an instance wallet rotation and the target pdb's db user session will be cleaned.
pod_cdb_admin.kill_remove_sessions(
request IN  CLOB,
status  OUT CLOB);
Args:
 tenant_name - name of the tenant
 tenant_key  - tenant key
 pdb_name    - name of the pdb
 status      - OUT status containing return code, error messages
 
MASK_PASSWD (new 21c)
Masks the "out" password field from SQL Statement pod_cdb_admin.mask_passwd(
sql_stmt IN CLOB,
delimit1 IN CLOB,
delimit2 IN CLOB)
RETURN CLOB;
Syntax Undocumented
 
OPEN_TENANT (new 21c)
Open a tenant PDB for operations

Overload 1
pod_cdb_admin.open_tenant(
tenant_name              IN  VARCHAR2,
pdb_name                 IN  VARCHAR2,
open_mode                IN  VARCHAR2 DEFAULT 'READ WRITE',
restricted               IN  CHAR     DEFAULT 'N',
cpu_count                IN  NUMBER   DEFAULT NULL,
rsrc_cpu_count           IN  NUMBER   DEFAULT NULL,
max_size                 IN  VARCHAR2 DEFAULT NULL,
ocid_cloud_database_name IN  VARCHAR2 DEFAULT NULL,
ocid_tenant_name         IN  VARCHAR2 DEFAULT NULL,
ocid_compartment_id      IN  VARCHAR2 DEFAULT NULL,
status                   OUT CLOB);
TBD
Overload 2 pod_cdb_admin.open_tenant(
request IN  CLOB,
status  OUT CLOB);
Args:
 tenant_name              - name of tenant to unprovision
 pdb_name                 - name of pdb associated with tenant
 open_mode                - mode in which PDB to be opened
 cpu_count                - configured cpu during provision
 rsrc_cpu_count           - configured rsrc cpu during provision
 max_size                 - configured max_size during provision/update
 ocid_cloud_database_name - db name generated by OCI for the PDB
 ocid_tenant_name         - same as tenant_name
 ocid_compartment_id      - OCI compartment id of the PDB
 status                   - OUT status from operation
 
PDB_CLOSE_TRIGGER_TASKS (new 21c)
List of tasks to be performed to perform a PDB close pod_cdb_admin.pdb_close_trigger_tasks(request IN CLOB);
Syntax Undocumented
 
PDB_DROP_TEMP_USERS (new 21c)
Drop dangling c##temp users pod_cdb_admin.pdb_drop_temp_users(request IN CLOB);
Syntax Undocumented
 
PDB_OPEN_TRIGGER_TASKS (new 21c)
List of tasks to be performed to perform a PDB open pod_cdb_admin.pdb_open_trigger_tasks(request IN CLOB);
Syntax Undocumented
 
POST_REWIND_PDB (new 21c)
Rewind PDB to a specific 'flashback' restore point

Overload 1
pod_cdb_admin.post_rewind_pdb(
tenant_name    IN  VARCHAR2,
pdb_name       IN  VARCHAR2,
omode          IN  VARCHAR2,
job_status     IN  VARCHAR2,
rcvcat_connstr IN  VARCHAR2 DEFAULT NULL,
status         OUT CLOB);
TBD
Overload 2 pod_cdb_admin.post_rewind_pdb(
request IN  CLOB,
status  OUT CLOB);
TBD
 
PROVISION_APPLICATION (new 21c)
Provision a new application root pod_cdb_admin.refresh_tenant(
request IN  CLOB,
status  OUT CLOB);
Args:
 tenant_name          - name of tenant which owns the app root/pdbs
 pdb_name             - name of newly provisioned app root

 source_pdb_name      - name of the source pdb from which to clone
 source_dblink_user   - (optional) user name to connect to at source db
 source_dblink_passwd - (optional) user passwd to connect to at source db
 source_dblink_conn   - (optional) connect string, if cloning over a dblink
 max_size             - (optional) max size for the PDB
 cpu_count            - cpu count for the PDB
 rsrc_cpu_count       - cpu count used to set resource parameters of the pdb
 max_tenants          - maximum possible number of pdbs under this tenant
 create_seed          - create application seed as part of provisioning?
 seed_source_info     - info about seed pdb from which to create app seed
 ace_hosts            - list of ACL
 status               - OUT status (error code and/or details)
 
PROVISION_APPLICATION_PDBS (new 21c)
Provision PDBs under an application root pod_cdb_admin.refresh_tenant(
request IN  CLOB,
status  OUT CLOB);
Syntax Undocumented
 
PROVISION_FROM_CACHE (new 21c)
Undocumented pod_cdb_admin.provision_from_cache(
pdb_name IN OUT VARCHAR2,
request  IN     CLOB)
RETURN BOOLEAN;
Syntax Undocumented
 
PROVISION_FROM_POOL (new 21c)
Undocumented pod_cdb_admin.provision_from_pool(
request       IN  CLOB,
pool_pdb_name OUT VARCHAR2)
RETURN BOOLEAN;
Syntax Undocumented
 
PROVISION_POOL_PDB (new 21c)
Invoked by pool replenishment jobs to create pool PDBs pod_cdb_admin.provision_pool_pdb(
source_pdb_name    IN VARCHAR2,   -- PDB seed
source_dblink_conn IN VARCHAR2);  -- ctrl dblink
Syntax Undocumented
 
PROVISION_TENANT (new 21c)
provision a new tenant PDB under an Application Root Container pod_cdb_admin.provision_tenant(
request IN  CLOB,
status  OUT CLOB);
Args:
 tenant_name - name of tenant which owns the newly cloned pdb
 pdb_name - name of newly cloned pdb
 source_pdb_name - name of the source pdb
 source_dblink_user - (optional) user name to connect to at source db
 source_dblink_passwd - (optional) user passwd to connect to at source db
 source_dblink_conn - connect string, if cloning over a dblink
 max_size - max size for the PDB
 cpu_count - cpu count for the PDB
 rsrc_cpu_count - cpu count used to set resource parameters of the pdb
 rcvcat_connstr - recovery catalog connect string
 ace_hosts - list of ACL
 ocid_cloud_database_name - db name generated by OCI for the PDB
 ocid_tenant_name - same as tenant_name
 ocid_compartment_id - OCI compartment id of the PDB
 database_name - database name provided by user
 region - region information
 status - OUT status/error code
 
PURGE_ASYNC_JOB (new 21c)
Purge asynchronous job table history pod_cdb_admin.purge_async_job(p_date IN DATE DEFAULT NULL);
exec pod_cdb_admin.purge_async_job(SYSDATE);
 
PUT_ERROR (new 21c)
Retrieves the current error message pod_cdb_admin.put_error(
elem             IN OUT NOCOPY json_element_t,
put_check_health IN            BOOLEAN DEFAULT TRUE);
Syntax Undocumented
 
RECOVER_SHRINK_PDB (new 21c)
Recover a failed PDB shrink pod_cdb_admin.recover_shrink_pdb(
request IN  CLOB,
status  OUT CLOB);
TBD
 
REFRESH_CLONE_POD (new 21c)
Refresh a clone pod pod_cdb_admin.refresh_clone_pod(
request IN  CLOB,
status  OUT CLOB);
TBD
 
REFRESH_TENANT (new 21c)
Performs a manual refresh of a tenant PDB pod_cdb_admin.refresh_tenant(
request IN  CLOB,
status  OUT CLOB);
TBD
 
RELOCATE_TENANT (new 21c)
Relocate a tenant PDB to the current pod pod_cdb_admin.refresh_tenant(
request IN  CLOB,
status  OUT CLOB);
TBD
 
REMOVE_ACL_PDB (new 21c)
Removes the specified access control entries for the PDB pod_cdb_admin.remove_acl_pdb(
request IN  CLOB,
status  OUT CLOB);
TBD
 
RENAME_TENANT_PDB (new 21c)
Renames a tenant PDB pod_cdb_admin.rename_tenant_pdb(
request IN  CLOB,
status  OUT CLOB);
TBD
 
REOPEN_TENANT (new 21c)
Reopen PDB tenant pod_cdb_admin.reopen_tenant(
request IN  CLOB,
status  OUT CLOB);
TBD
 
RESET_LOGGING (new 21c)
Resets logging to the default level. The default level logs warnings or greater in the table TLOG pod_cdb_admin.reset_logging(
request IN  CLOB,
status  OUT CLOB);
TBD
 
RESIZE_TENANT (new 21c)
Resize a tenant PDB

Overload 1
pod_cdb_admin.resize_tenant(
tenant_name              IN  VARCHAR2,
pdb_name                 IN  VARCHAR2,
cpu_count                IN  NUMBER   DEFAULT NULL,
rsrc_cpu_count           IN  NUMBER   DEFAULT NULL,
max_size                 IN  VARCHAR2 DEFAULT NULL,
attempt_shrink           IN  BOOLEAN  DEFAULT FALSE,
skip_close_pdbs          IN  BOOLEAN  DEFAULT FALSE,
patching                 IN  BOOLEAN  DEFAULT FALSE,
reloc_inst               IN  VARCHAR2 DEFAULT NULL,
ocid_cloud_database_name IN  VARCHAR2 DEFAULT NULL,
ocid_tenant_name         IN  VARCHAR2 DEFAULT NULL,
ocid_compartment_id      IN  VARCHAR2 DEFAULT NULL,
status                   OUT CLOB);
TBD
Overload 2 pod_cdb_admin.resize_tenant(
request IN  CLOB,
status  OUT CLOB);
TBD
 
REWIND_CDB (new 21c)
Rewind a CDB (Flashback Database equivalent) pod_cdb_admin.rewind_cdb(
request IN  CLOB,
status  OUT CLOB);
Args:
 rewind_time    - time to which to recover to
 fb_time        - 0 means use pitr, > 0 means use flashback if possible
 run_in_sync    - run job in sync mode
 job_id         - job id from WLS (unused)
 job_type       - job type from WLS
 rcvcat_connstr - recovery catalog connect string
 debug          - debug information passed to script
 savelog        - TRUE if output needs to be saved as OS file
 status         - status from running the operation
 
REWIND_PDB (new 21c)
Rewind a PDB (Flashback Database equivalent) pod_cdb_admin.rewind_pdb(
request IN  CLOB,
status  OUT CLOB);
Args:
 tenant_name              - name of the tenant for rewind
 pdb_name                 - name of pdb associated with tenant
 fb_time                  - 0 means use pitr, > 0 means use flashback if possible
 rewind_time              - Time to which to recover to
 run_in_sync              - run job in sync mode
 job_id                   - job id from WLS (unused)
 job_type                 - job type from WLS
 rcvcat_connstr           - recovery catalog connect string
 debug                    - debug information passed to script
 savelog                  - TRUE if output needs to be saved as OS file
 ocid_cloud_database_name - db name generated by OCI for the PDB
 ocid_tenant_name         - same as tenant_name
 ocid_compartment_id      - OCI compartment id of the PDB
 status                   - status from running the operation
 
REWIND_PDB_SYNC (new 21c)
Rewind a PDB (always SYNC - waits for rewind to finish) pod_cdb_admin.rewind_pdb_sync(
request IN  CLOB,
status  OUT CLOB);
Args:
 tenant_name              - name of the tenant for rewind
 pdb_name                 - name of pdb associated with tenant
 fb_time                  - 0 means use pitr, > 0 means use flashback if possible
 rewind_time              - time to which to recover to
 job_id                   - job id from WLS (unused)
 job_type                 - job type from WLS
 rcvcat_connstr           - recovery catalog connect string
 req_id                   - request id
 debug                    - debug information passed to script
 savelog                  - TRUE if output needs to be saved as OS file
 ocid_cloud_database_name - db name generated by OCI for the PDB
 ocid_tenant_name         - same as tenant_name
 ocid_compartment_id      - OCI compartment id of the PDB
 status                   - status from running the operation
 
RUN_STMT (new 21c)
Run a SQL statement, optionally with lockdown disabled pod_cdb_admin.run_stmt(
container_name   IN VARCHAR2       DEFAULT NULL,  -- container in which to run statement
sql_stmt         IN VARCHAR2,                     -- SQL statement to run.
parse_only       IN BOOLEAN        DEFAULT FALSE, -- sufficient to call dbms_sql.parse()
bind_names       IN bind_name_type DEFAULT NULL,  -- name of bind variables
bind_vals        IN bind_var_type  DEFAULT NULL,  -- values of bind variables
disable_lockdown IN BOOLEAN        DEFAULT FALSE,
mask_password    IN BOOLEAN        DEFAULT FALSE,
run_as_user      IN VARCHAR2       DEFAULT NULL);
TBD
 
SEND_LOGS_TO_LOGSTASH (new 21c)
Sends logs to logstash running on current host pod_cdb_admin.send_logs_to_logstash(
logstash_host IN VARCHAR2,
logstash_port IN INTEGER);
TBD
 
SET_ACL_PDB (new 21c)
Sets specified access control entries for PDBs pod_cdb_admin.set_acl_pdb(
request IN  CLOB,
status  OUT CLOB);
Args:
 tenant_name - name of the tenant to modify acl
 pdb_name    - name of pdb associated with tenant
 p_ace_hosts - json array of host name/ip to setup
 status      - status from running the operation
 
SET_LOGGING (new 21c)
Set logging attributes. Unset attributes that are cleared (except default values) pod_cdb_admin.set_logging(
request IN  CLOB,
status  OUT CLOB);
Args:
 tenant_name
 pdb_name
 p_level      - logging level
 p_trcfile    - write to trace file
 p_alertlog   - write to alert log
 p_stdout     - write to standard output
 p_table      - write to log table
 p_autonomous - if logging to table, do logging in autonomous txn?
 p_queue      - write to output queue?
 status       - out
 
SET_LOG_ARCHIVE_DEST (new 21c)
Sets the archivelog destination for a refresh clone pod_cdb_admin.set_log_archive_dest(
request IN  CLOB,
status  OUT CLOB);  -- OUT status containing return code, error messages
Syntax Undocumented
 
SET_SEMI_AUTONOMOUS_LOCKDOWN (new 21c)
Sets the semi autonomous lockdown profile in the PDB pod_cdb_admin.set_semi_autonomous_lockdown(
request IN  CLOB,
status  OUT CLOB);
Syntax Undocumented
 
SET_TENANT_CPU_COUNT (new 21c)
Undocumented

Overload 1
pod_cdb_admin.set_tenant_cpu_count(
tenant_name      IN VARCHAR2,
pdb_name         IN VARCHAR2,
cpu_count        IN NUMBER             DEFAULT NULL,
rsrc_cpu_count   IN NUMBER             DEFAULT NULL,
instances_cpu_in IN pod_rsrc_iinfo_arr DEFAULT NULL,
skip_close_pdbs  IN BOOLEAN            DEFAULT FALSE,
open_mode        IN VARCHAR2           DEFAULT NULL,
status           OUT CLOB);
TBD
Undocumented

Overload 2
pod_cdb_admin.set_tenant_cpu_count(
request IN  CLOB,
status  OUT CLOB);
TBD
 
SET_TENANT_KEY (new 21c)
Updates/sets tenant key: Syntax undocumented pod_cdb_admin.set_tenant_key(
request IN  CLOB,
status  OUT CLOB);
TBD
 
SHRINK_PDB (new 21c)
Shrink a PDB's size

Overload 1
pod_cdb_admin.shrink_pdb(
tenant_name IN VARCHAR2,
pdb_name    IN VARCHAR2,
max_size    IN VARCHAR2,
status      OUT CLOB);
TBD
Overload 2 pod_cdb_admin.shrink_pdb(
request IN  CLOB,
status  OUT CLOB);
TBD
 
UNPROVISION_TENANT (new 21c)
Closes a PDB and unprovision the tenant pod_cdb_admin.unprovision_tenant(
request IN  CLOB,
status  OUT CLOB);
TBD
 
UPDATE_ASYNC_JOB_PROGRESS (new 21c)
Updates asynchronous job progress pod_cdb_admin.update_async_job_progress;
exec pod_cdb_admin.update_async_job_progress;
 
UPDATE_ASYNC_JOB_STATUS (new 21c)
Update the asynchronous job status

Overload 1
pod_cdb_admin.update_async_job_status(
p_job_id     IN VARCHAR2 DEFAULT NULL,
p_command_id IN VARCHAR2,
p_job_status IN VARCHAR2,
p_err_msg    IN VARCHAR2 DEFAULT NULL,
p_api_result IN CLOB     DEFAULT NULL)
TBD
Overload 2 pod_cdb_admin.update_async_job_status(request IN CLOB);
TBD

Related Topics
Built-in Functions
Built-in Packages
Database Security
Autonomous Database
POD_CDB_ADMIN_COMMON
POD_CDB_ADMIN_HTTP
POD_CDB_ADMIN_JOB
POD_CDB_ADMIN_UTIL
What's New In 19c
What's New In 20c-21c

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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx