1.2 Getting Started with Oracle Enterprise Manager Express

«« Previous
Next »»

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

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

Getting Started with Oracle Enterprise Manager Express

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

Getting Started with Oracle Enterprise Manager Express

3. Check instance name.

Getting Started with Oracle Enterprise Manager Express

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

Getting Started with Oracle Enterprise Manager 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".

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

Getting Started with Oracle Enterprise Manager Express

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

Getting Started with Oracle Enterprise Manager Express

3. Check the instance name.

Getting Started with Oracle Enterprise Manager Express

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

Getting Started with Oracle Enterprise Manager Express

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

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

Getting Started with Oracle Enterprise Manager Express

2. Alter the session and set container as pdb (pdborcl in this case).

Getting Started with Oracle Enterprise Manager Express

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

Getting Started with Oracle Enterprise Manager Express

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

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

Getting Started with Oracle Enterprise Manager Express

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

Getting Started with Oracle Enterprise Manager Express

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.

Getting Started with Oracle Enterprise Manager Express

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

Getting Started with Oracle 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.

Getting Started with Oracle Enterprise Manager Express

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

Getting Started with Oracle Enterprise Manager Express

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.

Getting Started with Oracle Enterprise Manager Express

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

Getting Started with Oracle Enterprise Manager Express

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

Getting Started with Oracle Enterprise Manager Express

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

Getting Started with Oracle Enterprise Manager Express

 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.

Getting Started with Oracle Enterprise Manager Express

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

Getting Started with Oracle Enterprise Manager 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.

Getting Started with Oracle Enterprise Manager Express

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.

Getting Started with Oracle Enterprise Manager Express

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

Getting Started with Oracle Enterprise Manager 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.

Getting Started with Oracle Enterprise Manager Express

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.

Getting Started with Oracle Enterprise Manager Express

3. The Database Home page is displayed.

Getting Started with Oracle Enterprise Manager Express

«« Previous
Next »»