Accessing the Database Home Page

The Database Home page is the main database management page in Oracle Enterprise Manager Database Express (EM Express).

To access the Database Home page:

  1. Ensure that the HTTPS port for EM Express is configured.
  2. In your Web browser, enter the EM Express URL for the database or pluggable database (PDB) you want to manage:
    https://database-hostname:portnumber/em
    

    For example, if you installed the database on a host computer named mydbhost.example.com, and port number 5500 is configured as the HTTPS port number for EM Express for the database, then enter the following URL:

    https://mydbhost.example.com:5500/em
    

    If the database instance is running, then the Login page appears when you access EM Express.

    If the database instance is not running, start it. See Oracle Database Administrator's Guide for information about starting the instance.

    If port number 5501 is configured as the HTTPS port number for EM Express for the PDB you want to manage, then enter the following URL:

    https://mydbhost.example.com:5501/em
    

    If the PDB is open in read/write mode, then the Login page appears when you access EM Express.

    If the PDB is not open in read/write mode, open it in read/write mode. See Oracle Database Administrator's Guide for information about using the ALTER PLUGGABLE DATABASE statement to open a PDB in read/write mode.

  3. Log in to the database or PDB with a user account that is authorized to access EM Express. The EM_EXPRESS_BASIC and EM_EXPRESS_ALL roles are created for EM Express, and a user who has been granted at least one of these roles can log in to EM Express.

    This user initially could be SYS or SYSTEM, with the password that you specified during database installation.

    Although the SYSTEM account can be used to perform day-to-day administrative tasks, Oracle strongly recommends creating a named user account for administering the Oracle database to enable monitoring of database activity. To back up, recover, or upgrade the database, you must log in as a user with the SYSDBA privilege.

    EM Express displays the Database Home page.

  4. To return to the Database Home page after you have navigated to another EM Express page, you can:

The various sections of the Database Home page provide information about the environment and status of the database. The Status section shows basic information about the database. When the database instance is a multitenant container database (CDB), the line after the Type field in the Status section is a link that identifies the instance as a CDB and lists the number of PDBs in the CDB. Click the CDB (n PDBs) link to view the Containers page for the CDB, which shows status, performance, and resource information for the CDB containers (PDBs). The Incidents - Last 24 Hours section lists critical error alerts in the database during the last 24 hours. The SQL Monitor section warns you of long-running SQL statements that may impact the performance of your database. Then, you can use the menu options to get more detail about the problem areas, and, in some cases, to obtain recommendations for resolving the problems. These topics are discussed in Monitoring and Tuning the Database.