Getting Started with Oracle Enterprise Manager Express

Overview

Purpose

This tutorial introduces you to Oracle Enterprise Manager Express, a Web-based interface for managing an Oracle database.

Time to Complete

Approximately 30 minutes

Introduction

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. In Oracle Database 12c Release 1, the concept of multitenant environment has been 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 nonschema 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.

Software Requirements

The following is a list of software requirements:

  • Oracle Database 12c

Prerequisites

Before starting this tutorial, you should:

  • Have installed Oracle Database 12c.

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

  2. Check if the database is a non container database.

  3. Check instance name.

  4. Issue the SQL statement that returns the port that is configured for EM Express.

  5. 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".

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

  2. Check if the database is a multitenant container database.

  3. Check the instance name.

  4. Issue the SQL statement that returns the port that is configured for EM Express.

     
    5. Note: When connected to the root, EM Express displays data and enables actions that apply to the entire CDB.

  5. 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".

Starting 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 pluggable Databases.
  2. Alter the session and set container as pdb (pdborcl in this case).
  3. Issue the SQL statement that returns the port that is configured for EM Express.
    4. 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".

Configuring the HTTPS Port

You can access Enterprise Manager Database Express using the URL that was displayed during installation. In case you want to use a different port or manually configure an HTTPS port, you need to configure the port using the dynamic protocol registration method. After the HTTPS port is configured, you use it to access Enterprise Manager Express.

Configuring the HTTPS Port for non-CDB

The default port used is 5500. In this case, you will configure Enterprise Manager Database Express to run on port 5501.

  1. Open a terminal window and execute the oraenv command to set the environment variables.

  2. Verify that the listener is started by executing the lsnrctl status command.

  3. Log in to SQL*Plus as the SYSDBA user and verify that the DISPATCHERS parameter in the initialization parameter file includes the PROTOCOL=TCP attribute.

  4. Execute the DBMS_XDB.setHTTPSPort procedure to set the HTTPS port for Enterprise Manager Express.

Configuring the HTTPS Port for CDB and PDB

The default port used is 5500. In this case you will configure Enterprise Manager Database Express for CDB to run on port 5501 and for PDB to run on 5502.

  1. Open a terminal window and execute the oraenv command to set the environment variables.

  2. Verify that the listener is started by executing the lsnrctl status command.

    alt description here

  3. Log in to SQL*Plus as the SYSDBA user and verify that the DISPATCHERS parameter in the initialization parameter file includes the PROTOCOL=TCP attribute.

  4. Execute the DBMS_XDB_CONFIG.SETHTTPSPORT procedure to set the HTTPS port for EM Express for a CDB.

  5. Execute the DBMS_XDB_CONFIG.SETHTTPSPORT procedure to set the HTTPS port for EM Express for a PDB.

Accessing the Database Home Page

The Database Home page is the main database management page in Enterprise Manager Database Express.

Accessing non-CDB homepage

  1. In your Web browser, enter the URL to access Enterprise Manager: https://database-hostname:portnumber/em.

          Note: You will receive a Secure Connection Failed message on first access after installation and you need to add a security exception.

  1. Log in to Enterprise Manager Database Express with an authorized user account such as SYSTEM. Enter the username and password in the appropriate fields. Click Login.

  2. The Database Home page is displayed. Continue with other tutorials in the series or log out of Enterprise Manager Database Express.

Accessing CDB and PDB Home Page

    Accessing CDB Home Page

    1. In your Web browser enter the URL to access Enterprise Manager: https://database-hostname:portnumber/em.

      Note: You will receive a Secure Connection Failed message on first access after installation and you need to add a security exception.

    2. Log in to Enterprise Manager Database Express with an authorized user account such as SYSTEM. Enter the username and password in the appropriate fields. Click Login.

    3. The Database Home page is displayed. Continue with other tutorials in the series or log out of Enterprise Manager Database Express.

    Accessing PDB Home page

    To Manage your Pluggable Database, you can access EM Express. In this case, your Pluggable Database is pdborcl. Perform the following steps:

    1. In your Web browser enter the URL to access Enterprise Manager: https://database-hostname:portnumber/em.

      Note: You will receive a Secure Connection Failed message on first access after installation and you need to add a security exception.

    2. Log in to Enterprise Manager Database Express with an authorized user account such as SYSTEM. Enter the username and password in the appropriate fields. Click Login.

    3. The Database Home page is displayed.

Summary

In this tutorial, you learned how to:

  • Start EM Express for non-CDB, CDB, and PDB
  • Configure the HTTPS port for Enterprise Manager Database Express
  • Log in to Enterprise Manager Database Express
  • Access the Database Home page

Resources

  • Oracle Database 2 Day DBA 12c Release 2 (12.1.0.2)

Credits

  • Lead Curriculum Developer: Veerabhadra Rao Putrevu
  • Original Curriculum Developers: Donna Keesling, Salome Clement
  • Other Contributors: Bert Rich

To navigate this Oracle by Example tutorial, note the following:

Topic List:
Click a topic to navigate to that section.
Expand All Topics:
Click the button to show or hide the details for the sections. By default, all topics are collapsed.
Hide All Images:
Click the button to show or hide the screenshots. By default, all images are displayed.
Print:
Click the button to print the content. The content that is currently displayed or hidden is printed.

To navigate to a particular section in this tutorial, select the topic from the list.