Creating a single instance Oracle Pluggable Database

This topic describes how to create a single instance Oracle Pluggable Database (PDB) in a multitenant environment (for Oracle 12c databases only).

Before you begin

• A Container Database (CDB) must be available for provisioning.
• The node must meet all of the Oracle database prerequisites.
• You can also create a PDB using the bdacli command line tool. For more information, see Provisioning operations and type Oracle Pluggable Database in the Type field to filter the table.

To create a single instance Oracle Pluggable Database

1. From the Management Console, navigate to the CDB within which you want to create a PDB.
2. In the Database Configuration page, select Provision > Add Pluggable Database.

3. In the Naming page, populate the following fields, and click Next.

   Note

   If you select a template for your database, some fields in subsequent pages for this task would be pre-configured and, depending the template specification, non-editable. This allows administrators to enforce standards across the environment.

4. In the Create Mode page, select the method you want to use to create the PDB in the Create Pluggable Database From: menu and click Next.
   You can choose from the following options:
   
   • Seed mode uses a special template from Oracle when the CDB is created, which then enables you to create new PDBs within the CDB.
     If a CDB already has 252 PDBs plugged into it, then unplugging one of those enables another PDB to be plugged into that CDB.
   • Metadata mode uses Oracle metadata that was created by a previous unplugging operation and stored in an .xml file.
     The recommended location for this file is /oradata/<your initials>export.xml. Make sure the oracle user has write permissions to the selected directory.

5. In the Provisioning page, populate the following fields based on the mode you selected in Step 5 for creating the PDB, and click Next.

6. In the Configuration page, populate the following fields, and click Next.

7. In the Job Options page, specify any of the following Job options, and click Next.

8. If the Change Control page displays, populate the following fields, and click Next.

   Note

   The Change Control page appears only when change control is configured for your environment. See Configuring-change-control.

9. In the Summary page, review the provisioning information.
   To make changes, do the following:
   1. Click Go to to return to the provisioning step that you want to edit.
   2. Make your changes.
   3. Click Save and Review to return to the Summary page.
10. Specify your verification preferences.
    For additional information, see Understanding-pre-verification-tests.
    • To continue with database creation after the pre-verification tests have been successfully run without manual intervention, select Automatically Continue If All Tests Succeed.

    • To create the database without having first run the pre-verification steps, select Skip Pre-Verification Tests.

      Note

      The Skip Pre-Verification Tests option should only be used when you are certain all tests can succeed. The option skips verification and advances directly to the actual provisioning activity.

11. Click Create Oracle Pluggable Database.
    If you disabled the Automatically Continue If All Tests Succeed and Skip Pre-Verification Tests options, you are prompted to click Continue after the pre-verification steps are done.
    The database creation process begins and a progress page appears.

    Note

    If you close your browser, the operation continues. You can return to this page by using the Jobs page.

12. (Optional) Click the magnifying glass icon to view log file details.
13. Check the Results section for the Success message.
    If this procedure was not successful, see Troubleshooting-Oracle-provisioning-problems.

14. Click Done and return to the Contents view of this domain.

    Note

    Detailed current and historical information about this action can be viewed in the Jobs section of the Management Console. See Monitoring-jobs-and-viewing-job-history.