Opening a PDB Using EM Express

This section provides information about opening a PDB in a CDB using EM Express.

Note:

Before you open a PDB:

  • The PDB that you want to open must exist in the CDB.

  • You must have the SYSDBA, SYSOPER, SYSBACKUP, or SYSDG administrative privilege, and the privilege must be either commonly granted or locally granted in the PDB. You must exercise the privilege using AS SYSDBA, AS SYSOPER, AS SYSBACKUP, or AS SYSDG, respectively, at connect time.

To open a PDB:

  1. In EM Express, navigate to the Containers page for the CDB that contains the PDB that you want to open.

    For more information, see "Accessing the Containers Page."

  2. In the Containers section of the Containers page, click the PDB that you want to open, and then choose Open from the Actions menu. The Open PDB wizard appears and asks you to specify the open mode for the PDB (Read Write, Read Only, or Migrate), and whether you want the PDB opened in restricted mode.

    See Also:

    Oracle Database Administrator's Guide for an introduction to the open modes of PDBs

    A PDB open in unrestricted mode allows access to all users, but a PDB open in restricted mode can be accessed only by a PDB administrator.

    Choose the open mode for the PDB and whether it should be opened in restricted mode or not.

    Note:

    If you choose to open a the PDB s that is already open, it will be closed with immediate mode, and then reopened in the open mode and restricted mode that you specified in the Open PDB wizard.

    If a PDB is closed immediately, users currently connected to the PDB are disconnected, and active transactions are implicitly rolled back.

    See Oracle Database Administrator's Guide for more information about shutting down using immediate mode.

  3. Click OK.

    The PDB is opened. The Confirmation box appears and advises you that the PDB was opened successfully. In the Containers section on the Containers page, the up arrow icon appears in the Open Mode column for the PDB.