The Database Home page is the main database management page in Oracle Enterprise Manager Database Express (EM Express).
To access the Database Home page:
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:
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:
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.
EM_EXPRESS_ALLroles 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
SYSTEM, with the password that you specified during database installation.
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.
Click the database icon at the top left of any EM Express page:
Click the Back button for your web browser until the Database Home page appears.
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.