Create a Pluggable Database

This article provides the details and procedure to create a pluggable database.

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. On the DB Systems list page, select the DB system that contains the pluggable database that you want to work with. If you need help finding the list page or the DB system, see List the DB Systems.
2. On the Databases tab, select the database that contains the pluggable database that you want to work with.
3. On the database details page, select the Pluggable Databases tab.
4. Select Create.
5. In the Create pluggable database panel, enter the following values:

Basic details

• 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.

PDB admin account

• 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.

Database admin credential

• TDE wallet password of database: Enter the TDE wallet password for the source container database.

• Take a backup of the PDB immediately: You must enable auto-backup on the container database to back up a pluggable database immediately. This toggle is switched on by default if auto-backup is enabled on the container database.

  Note: If the toggle is switched off, the system displays a warning stating that the pluggable database cannot be recovered until the next daily backup has been successfully completed.

Advanced options

Expand Advanced options to provide the advanced options for this resource.

Tags

Expand Tags to provide tag details for this resource.

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.

Tip: Tags can be applied later or at any time to a resource.

Create

Select Create.

During the pluggable database creation operation, the source container database is in the ‘updating’ status.