You can have more than one pluggable database in a pluggable database. Pluggable databases must be created one at a time, and creating a new pluggable database has no effect on existing pluggable databases in the pluggable database.

Procedure

Perform the following steps to create a pluggable database using the OCI Console:

1. From the navigation menu, select Oracle Database, and then select Oracle Base Database Service.
2. Select your Compartment. A list of DB systems is displayed.
3. On the DB systems list page, select the DB system in which you want to create the pluggable database. The DB system details page is displayed.
4. On the DB system details page, select the database in which you want to create the pluggable database. The database details page is displayed.
5. On the database details page, under Resources, select Pluggable Databases, and then select Create.
6. In the Create pluggable database panel, provide the following details:
7. PDB name: Enter a name for the pluggable database. The name must begin with an alphabetic character and can contain a maximum of 30 alphanumeric characters.
8. Unlock the PDB admin account: Optional. Switch on this toggle to specify a pluggable database admin password and configure the pluggable database to be unlocked at creation.
   • PDB admin password: Create and enter a pluggable database admin password. The password must contain:
     • A minimum of 9 and a maximum of 30 characters.
     • At least two uppercase characters.
     • At least two lowercase characters.
     • At least two special characters. The valid special characters are: underscore ( _ ), a hash sign (#), and a dash (-). You can use two of the same characters or any combination of two of the same characters.
     • At least two numeric characters (0 - 9).
   • Confirm PDB admin password: Reenter the pluggable database admin password.
9. TDE wallet password of database: Enter the TDE wallet password for the source container database.
10. Take a backup of the PDB immediately: You must enable auto-backup on the container database to back up a pluggable database immediately. This check box is checked by default if auto-backup is enabled on the container database.

    Note:

    If the check box is unchecked, the system displays a warning stating that the pluggable database cannot be recovered until the next daily backup has been successfully completed.
11. Select Show advanced options to specify advanced options for this resource.
12. In the Tags tab, you can add free-form tags or defined tags to this resource. You must have permission to use the tag namespace for defined tags. For information about using tags to manage your OCI resources, see Resource Tags. Tags can be applied later or at any time to a resource.
13. Select Create.