Creating a New PDB from the Seed Using EM Express

This section provides information about creating a new PDB from the seed (PDB$SEED) using EM Express.

Note:

Before you create a new PDB from the seed:

  • The CDB within which you want to create a PDB must exist, and EM Express must be configured to access the CDB.

  • The CDB within which you want to create a PDB must be in read/write mode.

  • The target host user must be the owner of the Oracle home that the CDB (within which you want to create the PDB) belongs to.

To create a new PDB from the seed:

  1. In EM Express, navigate to the Containers page for the CDB in which you want to create the PDB.

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

  2. In the Containers section of the Containers page, choose Create from the Actions menu. The Create PDB From Seed wizard appears.

  3. On the General page of the Create PDB From Seed wizard, supply values for these fields:

    • PDB Name: Enter the name you want to use for the PDB you are creating.

    • Username: Enter the name of the administrative user who will manage the PDB you are creating.

      The username and password that you specify on this page are used to create the administrator as a local user in the PDB and grants the PDB_DBA role locally to the administrator. By default, no privileges are granted to the PDB_DBA role. You can grant roles or privileges to the PDB_DBA role once the PDB is created.

      See Also:

      Oracle Database Security Guide for more information about the PDB_DBA role and other predefined roles in an Oracle Database installation

    • Password: Enter the password for the administrative user.

    • Confirm Password: Enter the password for the administrative user again.

    Click the right arrow button to go to the Storage page.

  4. On the Storage page, select the type of location where you want to store the datafiles for the PDB:

    • If the target CDB (in which you are creating the PDB) is enabled with Oracle Managed Files and you want to use the same, then select Use Oracle Managed Files (OMF).

    • If the target CDB does not use OMF, then specify a datafile location or accept the default specified in the Datafile Location field.

  5. Also on the Storage page, choose whether or not to enable unlimited storage for the datafiles.

    If you do not enable unlimited storage, then you must specify values for these fields:

    • Max Size: The amount of storage that can be used by all tablespaces that belong to the PDB.

    • Max Shared Temp Size: The amount of storage in the default temporary tablespace shared by all PDBs that can be used by sessions connected to the PDB.

    If no values are specified for these fields, then their values will be set to unlimited when the PDB is created.

  6. If the CDB has a current active resource plan, the Resource Limits page appears.

    Supply values for these fields, or keep the default values for the PDB you are creating:

    • Shares: Assign a new share value for this PDB, or keep the current value.

    • CPU Utilization Limit (%): Assign a new CPU utilization percentage value for this PDB, or keep the current value.

    • Parallel Server Limit (%): Assign a new parallel server utilization percentage value for this PDB, or keep the current value.

  7. Click OK.

    The PDB is created and opened in read/write mode. EM Express adds the PDB to the list of containers that appears in the Containers section on the Containers page.

After configuring an HTTPS port for EM Express for this PDB, the PDB can be managed using EM Express. Administrative users who have been granted the EM_EXPRESS_ALL role in a PDB can use EM Express to manage the PDB.

See Also:

"Configuring the HTTPS Port for EM Express" for information on configuring an HTTPS port for EM Express for a PDB