Oracle by Example brandingStart the Oracle Enterprise Manager Express

section 0Before You Begin

This 10-min tutorial shows you how to start Oracle Enterprise Manager Express, a Web-based interface for non-CDB and CDB Oracle database.

Select the Oracle Database release:

Background

Oracle Enterprise Manager Express enables you to perform administrative tasks such as managing user security and managing database memory and storage. You can also view performance and status information about your database. From Oracle Database 12c Release 1, the concept of multitenant environment was introduced. The multitenant architecture enables an Oracle database to function as a multitenant container database (CDB) that includes zero, one, or many customer-created pluggable databases (PDBs). A PDB is a portable collection of schemas, schema objects, and non-schema objects that appears to an Oracle Net client as a non-CDB. All Oracle databases before Oracle Database 12 were non-CDBs.

A CDB includes the following components:

  • Root

    The root, named CDB$ROOT, stores Oracle-supplied metadata and common users. An example of metadata is the source code for Oracle-supplied PL/SQL packages. A common user is a database user known in every container. A CDB has exactly one root.

  • Seed

    The seed, named PDB$SEED, is a template that you can use to create new PDBs. You cannot add objects to or modify objects in the seed. A CDB has exactly one seed.

  • PDBs

    A PDB appears to users and applications as if it were a non-CDB. For example, a PDB can contain the data and code required to support a specific application. A PDB is fully backward compatible with Oracle Database releases before Oracle Database 12c.

Each of these components is called a container. Therefore, the root is a container, the seed is a container, and each PDB is a container. Each container has a unique container ID and name within a CDB.

In this tutorial you will perform configuration steps that enable you to access Enterprise Manager Express for non-CDB, CDB and PDB and view the Database Home page for respective types of databases. 

What Do You Need?

  •  Install Oracle Database 19c 18c

section 1Start EM Express for non-CDB

Use the EM Express URL provided by DBCA when DBCA configured your non-CDB to start the EM Express. That URL includes the HTTPS port number for the non-CDB. If you do not know the HTTPS port number for the non-CDB, then follow the steps below:

  1. Open a terminal window, execute the oraenv command to set the environment variables and connect to the database orcl. 
    $ . oraenv
ORACLE_SID = [oracle] ? orcl
The Oracle base has been set to /scratch/u01/app/oracle
$ sqlplus / as sysdba

SQL*Plus: Release 18.0.0.0.0 - Production on Mon Mar 4 22:17:53 2019
Version 18.3.0.0.0

Copyright (c) 1982, 2018, Oracle.  All rights reserved.


Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jul 15 01:08:39 2019
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL>
  2. Check if the database is a non container database. 
    SQL> select name, cdb, con_id from v$database;
    NAME	  CDB	  CON_ID
--------- --- ----------
ORCL	  NO	       0
  3. Issue the SQL statement that returns the port that is configured for EM Express. 
    SQL> select instance_name, status, con_id from v$instance;
INSTANCE_NAME	 STATUS 	  CON_ID
---------------- ------------ ----------
orcl		 OPEN		       0
  4. If a port number is not returned by this statement, then you must manually configure an HTTPS port for this CDB, as described in "Configuring the HTTPs Port". 
    SQL> select dbms_xdb_config.gethttpsport() from dual;
    
DBMS_XDB_CONFIG.GETHTTPSPORT()
------------------------------
5500

    If a port number is not returned by this statement, then you must manually configure an HTTPS port for this CDB, as described in "Configuring the HTTPs Port".

section 2Start EM Express for CDB

Use the EM Express URL provided by DBCA when DBCA configured your CDB to start the EM Express. That URL includes the HTTPS port number for the CDB. If you do not know the HTTPS port number for the CDB, then follow the steps below:

  1. Open a terminal window, execute the oraenv command to set the environment variables and connect to the multitenant container database orcl. 
    $ . oraenv
ORACLE_SID = [oracle] ? orcl
The Oracle base has been set to /scratch/u01/app/oracle
$ sqlplus / as sysdba

SQL*Plus: Release 18.0.0.0.0 - Production on Mon Mar 4 22:17:53 2019
Version 18.3.0.0.0

Copyright (c) 1982, 2018, Oracle.  All rights reserved.


Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jul 15 01:08:39 2019
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0


SQL>
  2. Check if the database is a multitenant container database. 
    SQL> select name, cdb, con_id from v$database;
    NAME	  CDB	  CON_ID
--------- --- ----------
ORCL	  YES	       0
  3. Check the instance name. 
    SQL> select instance_name, status, con_id from v$instance;
INSTANCE_NAME	 STATUS 	  CON_ID
---------------- ------------ ----------
orcl		 OPEN		       0
  4. Issue the SQL statement that returns the port that is configured for EM Express. 
    SQL> select dbms_xdb_config.gethttpsport() from dual;
    
DBMS_XDB_CONFIG.GETHTTPSPORT()
------------------------------
5500

section 3Start EM Express for PDB

Use the EM Express URL provided by DBCA when DBCA configured your PDB to start the EM Express. That URL includes the HTTPS port number for the PDB. If you do not know the HTTPS port number for the PDB, then follow the steps below:

  1. Display the PDBs. 
    SQL> select con_id, name, open_mode from v$pdbs;

    CON_ID
----------
NAME
----------------------------------------------------
OPEN_MODE
----------
         2
PDB$SEED
READ ONLY

         3
ORCLPDB
READ WRITE

    CON_ID
----------
NAME
----------------------------------------------------
OPEN_MODE
----------
  2. Alter the session and set container as pdb (orclpdb in this case). 
    SQL> ALTER SESSION SET CONTAINER=orclpdb;

Session altered.
  3. Open the pluggable database (if not already open) and issue the SQL statement that returns the port that is configured for EM Express. 
    SQL> alter pluggable database orclpdb open;

Pluggable database altered.
    SQL> SELECT dbms_xdb_config.gethttpsport() from dual;

DBMS_XDB_CONFIG.GETHTTPSPORT()
------------------------------
			     0
    Note: When connected to a PDB, EM Express displays data and enables actions that apply to the PDB only.
  4. If a port number is not returned by this statement, then you must manually configure an HTTPS port for this PDB, as described in "Configuring the HTTPS Port".