Category Archives: EM

Oracle Enterprise Manager – Overview

Oracle Enterprise Manager is a management application for all Oracle database products deployed both in your data center and Oracle Cloud components. Enterprise Manger is highly integrated into Oracle products and thus provides a high level of control and visibility with very little impact to component performance.     The capability of Enterprise Manger has dramatically increased over time, allowing for the control of applications, database, middleware, and hardware systems provided by Oracle Corporation.

 

Larry Catt

OCP

EM Express 12c Opening Page

Oracle EM Express Opening Page provides the ability to view a snapshot of current database instance.  This article covers the general layout of EM Express Opening Page and its functional usage.

 

  1. Logon the EM Express as an administrative user.   In this case we will use the URL:  https://10.30.15.63:5500/em.   This indicates the EM Express is installed on server 10.30.15.63, listening on port 5500 (which is the default).  NOTE:  You may receive a certificate warning but select continue to site option.   Enter your sysdba credentials at the sign in page and mark the check box as sysdba, normally this is the user name and password you used to create the database.

  1. The initial page will give you a summary of the current setup and state of the oracle database EM Express is attached to.

  1. There are six drop down views which can be minimized: Status, Performance, Incidents, Resources, Running Jobs, and SQL Monitor

 

  1. Status drop down give the general information about the database being monitored.

  1. Performance drop down give the current activity on the database instance by Activity Class or Services.

  1. Incidents drop down give all errors and warning that have occurred for administrative review.

  1. Resources drop down give a snap shot of the resources currently being used by the database instance.

  1. Running Jobs drop down give lists all jobs currently executing in the database.

  1. SQL Monitor drop down give the currently executing SQL statements against the database instance.

 

This article summarized the feature and use of the Opening Page of Oracle 12c EM Express.

 

Larry Catt

OCP

EM Express 12c Configuration Page

Oracle EM Express Configuration Page provides the ability to administrate the initialization parameters of an instance or multiple instances in a RAC configuration; view the memory configuration and usage; usage of various features; and database properties.  This article covers the general layout of EM Express Configuration Page and its functional usage.

 

  1. Logon the EM Express as an administrative user.   In this case we will use the URL:  https://10.30.15.63:5500/em.   This indicates the EM Express is installed on server 10.30.15.63, listening on port 5500 (which is the default).  NOTE:  You may receive a certificate warning but select continue to site option.   Enter your sysdba credentials at the sign in page and mark the check box as sysdba, normally this is the user name and password you used to create the database.

  1. From the top level drop down memory you have four options: Configuration, Storage, Security and Performance.
  2. Configuration drop down give the four options: Initialization Parameters, Memory, Database Feature Usage, and Current Database Properties.                                                                                                                                                             
  3. Initialization Parameters lists all current instance parameters and SPFILE parameters. From this page you can adjust most parameters.                                                                
  4. Memory option gives more details of memory usage that currently exists and allows the administrator a visual prospective of current environment.                         
  5. Database Feature Usage lists the features of database used by a user or application. This allows the administrator the ability to focus on features which may present a performance problem.         
  6. Current Database Properties lists the value of all database property variables. However this view does not give the ability to update this values.                                                               

 

 

 

This article summarized the feature and use of the Configuration Page of Oracle 12c EM Express.

 

Larry Catt

OCP

EM Express 12c Configuration Page

Oracle EM Express Configuration Page provides the ability to administrate the initialization parameters of an instance or multiple instances in a RAC configuration; view the memory configuration and usage; usage of various features; and database properties.  This article covers the general layout of EM Express Configuration Page and its functional usage.

 

  1. Logon the EM Express as an administrative user.   In this case we will use the URL:  https://10.30.15.63:5500/em.   This indicates the EM Express is installed on server 10.30.15.63, listening on port 5500 (which is the default).  NOTE:  You may receive a certificate warning but select continue to site option.   Enter your sysdba credentials at the sign in page and mark the check box as sysdba, normally this is the user name and password you used to create the database.

 

EM Express 12c

Oracle EM Express is an administrative console for the Oracle 12c database and is normally installed and configured via the Database Configuration Assistant (DBCA).   It uses the internal structures of an Oracle database for monitoring and administration and SQL*Net for communication, which greatly reduces the load on database being administered.   EM Express runs against most web-browsers with Flash plug-in installed.  EM Express is not designed to administrate multiple oracle databases and natively only connects to a single oracle database.   It is part of the oracle enterprise license package, however functions like SQL tuning page will result in additional licensing charges.  EM Express is extremely useful in relieving the administrative burden of a single database installation.

EM Express 12c Storage Page

Oracle EM Express Storage Page provides the ability to administrate the storage requirements of an Oracle database.  This article covers the general layout of EM Express Storage Page and its functional usage.

 

  1. Logon the EM Express as an administrative user.   In this case we will use the URL:  https://10.30.15.63:5500/em.   This indicates the EM Express is installed on server 10.30.15.63, listening on port 5500 (which is the default).  NOTE:  You may receive a certificate warning but select continue to site option.   Enter your sysdba credentials at the sign in page and mark the check box as sysdba, normally this is the user name and password you used to create the database.

  1. From the top level drop down memory you have four options: Configuration, Storage, Security and Performance.

  1. The Storage drop down give five database storage options: Tablespaces, Undo Management, Redo Log Groups, Archive Logs, and Control Files.

  1. The Tablespaces option allows you to view tablespace space, add/drop datafiles and modify storage parameters.

  1. The Undo Management option allows you to view undo statistics and switch undo tablespaces.

  1. The Redo Log Groups option allows you to view existing redo log groups and their statistics and add new groups.

  1. The Archive Logs option allows you to view archive log data.                       
  2. The Control Files option you to view current control files data and create backup copies of controlfiles.

 

This article summarized the feature and use of the Storage Page of Oracle 12c EM Express.

 

Larry Catt

OCP

EM Express 12c Security Page

Oracle EM Express Security Page provides the ability to administrate the Users, Roles, and Profile requirements of an Oracle database.  This article covers the general layout of EM Express Security Page and its functional usage.

 

  1. Logon the EM Express as an administrative user.   In this case we will use the URL:  https://10.30.15.63:5500/em.   This indicates the EM Express is installed on server 10.30.15.63, listening on port 5500 (which is the default).  NOTE:  You may receive a certificate warning but select continue to site option.   Enter your sysdba credentials at the sign in page and mark the check box as sysdba, normally this is the user name and password you used to create the database.

  1. From the top level drop down memory you have four options: Configuration, Storage, Security and Performance.

  1. The Security drop down you have the options: Users, Roles, and Profiles.

  1. The Users option allows you to view all users of the database, add/drop users, modify the permissions of a user and perform any maintenance tasks to a user account.

  1. The Roles option allows you to view all defined database roles, add/drop roles, add permissions to roles, and perform any maintenance tasks to existing roles.

  1. The Profiles option allows you to view all defined profiles of the database, add/drop profiles, modify profile parameters and perform any additional profile administration required.

 

This article summarized the feature and use of the Security Page of Oracle 12c EM Express.

 

Larry Catt

OCP

EM Express 12c Performance Page

EM Express 12c Performance Page

 

Oracle EM Express Performance Page provides the ability to administrate the Users, Roles, and Profile requirements of an Oracle database.  This article covers the general layout of EM Express Performance Page and its functional usage.

 

  1. Logon the EM Express as an administrative user.   In this case we will use the URL:  https://10.30.15.63:5500/em.   This indicates the EM Express is installed on server 10.30.15.63, listening on port 5500 (which is the default).  NOTE:  You may receive a certificate warning but select continue to site option.   Enter your sysdba credentials at the sign in page and mark the check box as sysdba, normally this is the user name and password you used to create the database.

  1. From the top level drop down memory you have four options: Configuration, Storage, Security and Performance.

  1. The Performance option allows access to view performance of the database via the Performance Hub and perform performance optimization via the SQL Tuning Advisor.

  1. The Performance Hub option allows you to view the performance of your database based on multiple criteria and via a Summary, Activity, Workload, Monitored SQL, ADDM views. This can provide insight into the optimization of your instance and database configurations.

  1. The SQL Tuning Advisor option allows you to tune individual SQL statements and monitor executing SQL within the database. NOTE:   This option requires additional Tuning Pack license.

This article summarized the feature and use of the Performance Page of Oracle 12c EM Express.

 

Larry Catt

OCP