Opening an Oracle Pluggable Database


Before you begin

  • An Oracle Container Database (CDB) with at least one approved Oracle Pluggable Database (PDB) currently managed by BMC Database Automation (BDA) must be available.
  • On RAC CDBs, the status of the PDB must be NORMAL and NEW, and at least one PDB on an instance is MOUNTED. If all instances of the RAC CDB are down, the opening option is not available.

To open an Oracle Pluggable Database

Note

For RAC databases, this operation will open the PDB on all instances of the RAC CDB.

  1. From the Management Console, navigate to the CDB that contains the PDB that you want to open.
  2. In the Pluggable Databases section of the Database Configuration page, click the PDB that you want to open.
  3. Select Management > Open Pluggable Database.
  4. In the General page, populate the following fields, and click Next.

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

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

  7. 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.
  8. Specify your verification preferences.
    • To continue with opening the database after the pre-verification tests have been successfully run without manual intervention, select Automatically Continue If All Tests Succeed.
    • To open 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.

  9. Click Open Oracle Pluggable Database.

    If you disabled the Automatically Continue If All Tests Succeed option, you are prompted to click Continue after the pre-verification steps are done.

    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.

    In the Oracle Pluggable Database Instances section of the Oracle Pluggable Database Information page for the CDB, the mode that you selected displays in the Open Mode column for the PDB you just opened.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*