Administering Pluggable Databases

Oracle Database Exadata Cloud Service provides APIs to administer Oracle Multitenant pluggable databases (PDBs).

The PDB administration APIs are provided using the dbaascli utility, which is part of the cloud-specific tooling included in Exadata Cloud Service. The APIs can be used interactively or programmatically, and provide a simple mechanism for performing PDB lifecycle management operations. The APIs are specifically customized for Exadata Cloud Service and operate in conjunction with the database configuration standards that are implemented in Exadata Cloud Service.

The PDB administration APIs only support databases that are not in a Data Guard configuration and use Oracle Database version 12.2.0.1, or later.

The following table outlines the supported PDB lifecycle management operations:

PDB Lifecycle Operation	dbaascli Command
Create a new PDB.	dbaascli pdb create
Delete a PDB.	dbaascli pdb delete
Create a new PDB as a clone of an existing PDB in the same container database.	dbaascli pdb local_clone
Create a new PDB as a clone of an existing PDB in another container database.	dbaascli pdb remote_clone
Open a PDB.	dbaascli pdb open
Close a PDB.	dbaascli pdb close
Rename a PDB.	dbaascli pdb rename
Modify the size limits for a PDB.	dbaascli pdb resize
Display information about a container database.	dbaascli pdb checkdb
Display status information about a PDB.	dbaascli pdb checkpdb
Display detailed information about a PDB.	dbaascli pdb info
Display status information about PDBs that are associated with a specific container database and a specific compute node.	dbaascli pdb checknode
Display Oracle Net connect string information for a PDB.	dbaascli pdb connect_string
Return network connection information for a PDB.	dbaascli pdb connect_info