Opening All the PDBs in a CDB Using EM Express

This section provides information about opening all the PDBs in a CDB using EM Express.

Note:

Before you open all the PDBs in a CDB:

  • Make sure that you want to open all the PDBs 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 PDBs. You must exercise the privilege using AS SYSDBA, AS SYSOPER, AS SYSBACKUP, or AS SYSDG, respectively, at connect time.

To open all the PDBs in a CDB:

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

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

  2. In the Containers section of the Containers page, choose Open All from the Actions menu. The Open All PDBs wizard appears and asks you to specify the open mode to use for all the PDBs (Read Write, Read Only, or Migrate), and whether you want the PDBs 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 PDBs and whether they should be opened in restricted mode or not.

    Caution:

    When you choose to open all the PDBs in a CDB, if any PDBs in the CDB are already open, they will be closed immediately, and then reopened in the open mode and restricted mode that you specified in the Open All PDBs 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.

    All the PDBs in the CDB are opened. The Confirmation box appears and advises you that all the PDBs were opened successfully. In the Containers section on the Containers page, the up arrow icon appears in the Open Mode column for all the PDBs, and if they were opened in restricted mode, a check mark appears in the Restricted column for each PDB.

See Also: