The System Management Dashboard

Overview

Cloud Control allows you to monitor multiple Oracle E-Business Suite systems from a single console and to drill down into Oracle Applications Manager where you can control, configure, troubleshoot, and maintain individual systems. Once you have registered your Oracle E-Business Suite systems, you can start using the features of Cloud Control for managing those systems.

Setting Preferred Credentials

When using the Oracle Application Management Pack for Oracle E-Business Suite, you will need to access Oracle E-Business Suite instances. You can set up credentials for these instances as a one-time setup step instead of entering them every time you need to access an instance. For more information on setting preferred credentials, see: Setting Oracle E-Business Suite Preferred Credentials.

Use the following steps to set up credentials:

  1. Within Oracle Enterprise Manager, navigate to Setup > Security.

  2. Select Preferred Credentials.

  3. Select the Set Credentials icon to set the credentials for target types "Oracle E-Business Suite Infrastructure" and "Oracle E-Business Suite".

  4. Set the values as needed in the resulting page.

The Oracle E-Business Suite Instances Page

Access the Oracle E-Business Suite Instances page by navigating to Targets menu > Oracle E-Business Suite in the Cloud Control console.

the picture is described in the document text

This page provides a list of the Oracle E-Business Suite systems that have been registered with Cloud Control. You can register a new system by clicking Add, and following the directions in the section Discovering Oracle E-Business Suite Systems with Cloud Control. You can remove an Oracle E-Business Suite system from Cloud Control by selecting the desired system in the table, and then clicking Remove. You can also edit the monitoring configuration of a system by selecting the desired system in the table, and then clicking Configure.

This page also provides you with links to additional features:

The Change Management tab, if enabled, provides you with access to Patch Manager, Customization Manager, and Setup Manager.

Pack Diagnostics

Use the Pack Diagnostics link to run diagnostic tests on the various features of the Oracle E-Business Suite management packs.

Available tests are divided into the following categories:

Running Pack Diagnostics Tests

You should run diagnostic tests on your configuration for the components of the management pack that you plan to use. The results of these tests can help you determine if your configuration is set up correctly.

Navigating the Diagnostics Dashboard

  1. Click on the Pack Diagnostics link under Related Links on the Oracle E-Business Suite instances page.

    the picture is described in the document text

  2. The resulting Diagnostics dashboard page lists any previous requests to run diagnostic tests.

    the picture is described in the document text

    Use the Search feature to search for a Diagnostics request based on your search criteria.

    Create a new request using the Create button, as described below.

    The requests table lists the following for each request:

    • Name - User-defined name of the diagnostic test request.

    • Owner - This value indicates the Enterprise Manager user who submitted the request.

      Note: Currently, only those requests submitted by the user currently logged in are shown.

    • Created Date - The date and time the request was submitted.

    • Last Updated - The date and time of the last update for the transaction.

    • Status - The status of the transaction's job. This value is a link to the Enterprise Manager Job execution summary page.

    • Delete link - Use the Delete link to delete the diagnostics test request transaction.

Creating a request to run diagnostic tests

  1. To request to run a diagnostic test, click the Create button on the Diagnostics dashboard. The Create Request page appears.

    the picture is described in the document text

    Enter the following details for your request for a diagnostic test.

    • Enter a name for your request.

    • Choose the set of tests for one of the following modules: AMP: Cloning, Setup Manager, Patch Manager, Customization Manager, or User Monitoring.

    • You have two options for logging the details.

      • All - This option logs all information regardless of whether the diagnostic test completes with success or error

      • Error - Only log details for those tests that error out.

    • For Category, choose "Generic" if you want to run the tests that pertain to the Oracle E-Business Suite target and Enterprise Manager Cloud Control, in which the test results would not depend on the Enterprise Manager user.

      Choose "User Specific" for all the tests that depend on the Enterprise Manager user who is currently logged in.

    • Optionally enter a Description.

    • Add Targets for your request using the Add button.

      Use the LOV to select your target.

      the picture is described in the document text

  2. Click the Submit button.

  3. On the main Diagnostics page, you can monitor your request.

    The Status column shows the status of your request.

    If you want to delete your request, click on the Delete icon for the request.

  4. You can click on the request's Name link to view details for the request.

    the picture is described in the document text

    From this page you can resubmit the request using the Resubmit button.

  5. Click on the Status link to drill down to details on the diagnostics job, as well as the log file with the results from the diagnostic tests.

    the picture is described in the document text

    The job execution page lists the name of the module for which the diagnostic tests are submitted; for example, "Task: Cloning".

    The "Task: Generic" step includes 2 major steps:

    • Task Diagnose: Step EMGC - This step would run all Generic tests pertaining to Enterprise Manage Cloud Control. The OMS host is listed as the target.

    • Task Diagnose: Step EBS - This step would run all the Generic tests pertaining to the Oracle E-Business Suite instance. This step would repeat if you requested the tests to run against more than one Oracle E-Business Suite target. The Oracle E-Business Suite targets are listed.

    The "Task: User Specific" step includes 2 major steps:

    • Task Diagnose: Step EMGC - This step would run all user-specific tests pertaining to Enterprise Manage Cloud Control. The OMS host is listed as the target.

    • Task Diagnose: Step EBS - This step would run all user-specific tests pertaining to the Oracle E-Business Suite instance. This step would repeat if you requested the tests to run against more than one Oracle E-Business Suite target. The Oracle E-Business Suite targets are listed.

The Oracle Applications System Home Tab

The Home tab for an individual Oracle E-Business Suite system can be reached by drilling down from the Oracle Applications page as described in the section above.

the picture is described in the document text

The Oracle Applications System home page provides an overview of the status of a single Oracle E-Business Suite system. This page is divided into the following sections:

General

the picture is described in the document text

The General section provides general status and configuration information, including:

The New Internal System Alerts, Patches Applied, Site Level Profile Options Changed, and Context Files Edited metrics are based on information periodically summarized in the Oracle E-Business Suite database by the Oracle Applications Manager Dashboard Collection concurrent program. This program is controlled through the Preferences global link in Oracle Applications Manager. If this program has been disabled in the Oracle E-Business Suite system for some reason, then these metrics will not be updated.

Activity Summary

the picture is described in the document text

The activity summary provides an overview of system activity for the last 24 hours including:

Services

the picture is described in the document text

Using the Service Level Management feature with Enterprise Manager Cloud Control, Oracle E-Business Suite middle tier components can be monitored for their availability and performance. The middle tier components, being the infrastructure for Oracle E-Business Suite, are monitored not only for their key processes but also for all the other components on which they are dependent.

The Oracle Applications Service is defined by the following:

The following table provides details of the core service/component that’s being monitored as part of the infrastructure service and also the key components on which the core service is dependent.

Service Core Service / Component Monitored Key Components
Concurrent Processing Service Internal Concurrent Manager
  • Database Instance

  • Applications Listener

Forms Application Service OC4J Forms Server
  • Oracle HTTP Server

  • Database Instance

Self Service Application Service OC4J (Oracle Application Framework)
  • Oracle HTTP Server

  • Database Instance

Workflow Service
  • Workflow Agent Listener

  • Workflow Background Engine

  • Workflow Notification Mailer

  • Oracle Concurrent Manager

  • Database Instance

  • Applications Listener

Application Node Status

the picture is described in the document text

The Application Node Status provides a summary of the availability statuses of various components such as Forms, Applications Listener, Application Server and Database Instance. The availability status information is summarized at the node level. The host details such as host name, platform and the host status are available for each component.

Incidents and Related Incidents

the picture is described in the document text

The Incidents section provides an overview of any incidents posted by Oracle Enterprise Manager for targets that have become unavailable, or for metrics that have exceeded specified thresholds. The Incidents table shows incidents specifically for the Oracle E-Business Suite system target.

The Related Incidents table shows incidents for all targets that were registered as members of the Oracle E-Business Suite system but being monitored separately outside the pack.

You can drill down to view the details of an incident by clicking on the corresponding name in the Metric column. You can drill down to the related target's home page by drilling down on the Target Name. To define a metric threshold for incidents, click the Edit Metric Thresholds link under Related Links at the bottom of the page. For more information on metrics and incidents, please refer to the Enterprise Manager Cloud Control documentation.

The Oracle Applications System Performance Tab

The Oracle Applications System Performance tab consolidates key usage and performance indicators for the system in general, and for each tier of the system. You can change views using the View list. Four views are provided:

Each view provides a set of charts. You can control the period of time depicted by the charts using the View Data list.

The Oracle Applications System Activity View

the picture is described in the document text

The Oracle Applications System view provides an overview of key system-wide metrics. This view contains the following three charts:

The Applications Server View

the picture is described in the document text

The Applications Server view shows key middle tier usage and performance metrics for the Oracle Applications system. This view provides the following three charts:

The Database View

the picture is described in the document text

The Database tier view shows usage and performance metrics for the Oracle Applications system database and its hosts. This view provides the following three charts:

JVM Usage

The JVM usage summary can be accessed from the Performance tab using the link under the heading Forms/Web.

the picture is described in the document text

The JVM usage information is available across all the multiple nodes. The following metrics are collected as part of the JVM Usage:

For Release 12 systems, in order to enable collection of the data for Application Modules, AOL/J Connection, and Cache Components columns, please ensure that you have set up the monitoring configuration for each "oacore" OC4J target as follows:

  1. For each "oacore" OC4J target click on the name link. The oacore OC4J targets are named in <context_name>.<hostname>_oacore format and are parent targets of each JVM target.

  2. On the home page of the oacore OC4J target, click on "Monitoring Configuration" link under the Related Links section.

  3. Enter the OC4J administrator username and password for the "oacore" OC4J in the "Username for Basic authorization" the "Password for Basic authorization" fields respectively. Please refer to the note below to determine the values for these fields.

  4. Click on OK to save the information.

Note: The OC4J administrator username by default is "oc4jadmin" and is specified in the system-jazn-data.xml file under the $INST_TOP/ora/10.1.3/j2ee/oacore/config directory. The oc4jadmin password by default is set to a randomized value during installation and will need to be reset as in the following example:

For both Release 11i and Release 12, ensure that the Application Server passwords are set as well, because Oracle Enterprise Manager expects these passwords to be set for metrics collection for the JVM targets.

Drill down to Oracle Applications Manager

The System Performance tab provides seamless integration to performance pages within Oracle Applications Manager (OAM). You can use the links provided to access the performance metrics within OAM.

The Oracle Applications System Administration Tab

The Oracle Applications System Administration tab provides seamless integration with all the administrative activities within Oracle Applications Manager (OAM). Click on the icon in the "Administer" column to navigate to a feature's OAM administrative page.

Configuration reports of the middle-tier components can be accessed from this page using the icons in the "Report" column.

the picture is described in the document text

This section describes the various configuration reports accessible from the Administration page.

Note: On the entire configuration reports page, you can perform the following actions:

View Configuration

The Oracle E-Business Suite system configuration can be accessed from the Administration tab. Click on the icon in the Report column for System Overview.

System Overview

the picture is described in the document text

The System Overview provides configuration data using the Enterprise Manager Cloud Control Configuration Browser.

Patch Information

Navigate to Patch Information using the icon in the Report column for Patch Information.

the picture is described in the document text

The Patch Information view provides information about all the patches that have been applied to the Oracle E-Business Suite system.

Custom Objects

Navigate to Custom Objects using the icon in the Report column for Custom Objects.

the picture is described in the document text

In the custom objects view you can see all the Oracle E-Business Suite customizations.

View Oracle E-Business Suite Context Files

The Oracle E-Business Suite applications context files can be accessed from the Administration tab.

To view the context file for the application tier, expand "Application Nodes" in the table, then click the icon in the Report column for "APPL-TOP Context".

the picture is described in the document text

Next click on the appropriate context file name to view the context file.

the picture is described in the document text

To view the context file for the database tier, click the icon in the Report column for "Database Context".

the picture is described in the document text

Next select the appropriate context file name to view the context file.

the picture is described in the document text

View Host Configuration

The host configuration details can be accessed from the Administration tab. Expand the "Hosts" heading to view a listing of individual hosts; then for each host, click on the icon under the Report column to view its details.

You can view the configuration information of the hardware, operating system, Oracle software (such as Java Runtime Environment or the Oracle database product) and OS-registered software.

the picture is described in the document text

View Concurrent Processing Configuration

The Concurrent Processing configuration details can be accessed from the Administration tab.

the picture is described in the document text

You can view the configuration information for the concurrent processing component of the Oracle E-Business Suite system. The information shown includes:

View Oracle Workflow Configuration

The configuration information for the Oracle Workflow component of the Oracle E-Business Suite system is available from the Administration tab.

the picture is described in the document text

Included configuration information is shown for the following components:

Search Patches Applied/Search Patchset Info

You can search for Oracle E-Business Suite patch/patchset information from the Administration tab.

You can search for patch information by Target Name, Applied Patch ID, or Patch Number.

the picture is described in the document text

You can search for patchset information by Target Name, Application Short Name, or Application Name.

the picture is described in the document text

Compare Information (One to One)

For all the configuration reports you have viewed in the earlier sections, you can perform a one-to-one comparison of the report with that of another instance or the same report that was saved previously.

  1. Click the Compare button within the configuration report.

  2. Choose the configuration report from another instance or from a "Saved Configurations" of the current system and click the Compare button.

  3. The comparison results are shown.

Compare Information (One to Many)

You can also compare a configuration report to other reports for multiple instances in a single request.

  1. To compare configuration with multiple other configurations, click the Compare to Multiple button within the configuration report.

    By default the latest configuration information for the system is used for comparison. However, you can choose information from another saved configuration (with an earlier timestamp).

  2. Select all the Oracle E-Business Suite systems whose configuration information needs to be compared with the first (selected in the earlier step). Any number of Oracle E-Business Suite systems can be added for comparison. By default, their latest configuration information is utilized; however, a saved "snapshot" can also be used.

  3. You can schedule the comparison to begin immediately or on a future date (also an option to choose a convenient time zone is available). This comparison job can also be repeated and options for the same are available in this page.

  4. Complete the comparison job by reviewing the details that you had provided.

  5. View the result summary of the comparison job done across multiple instances.

  6. Click the Different link to view the actual differences between configurations.

The Oracle Applications System Maintenance Tab

The Oracle Applications Maintenance tab provides information on maintenance activities for the Oracle E-Business Suite system, particularly in the areas of patching and cloning.

the picture is described in the document text

The Maintenance tab is divided into the three sections:

The Oracle Applications System Diagnostics Tab

the picture is described in the document text

The Diagnostics tab provides summary results of Diagnostic Test execution within the system.

The Diagnostics Dashboard shows the execution statistics of diagnostic tests across all applications as well as for a specific application.

Navigation: From the Oracle E-Business Suite instance's Application Management Pack Dashboard, navigate to the Diagnostics subtab.

The dashboard has two charts, one pie chart and a bar chart. These charts allow you to select the application for which the statistics is needed. By default statistics across all applications is displayed.

It is a possible to see the statistics for last month, last week, or last 24 hours.

The Execution Statistics pie chart shows the success, failure, and warning rates of diagnostics tests depending on the selection of application.

The Top Failed Tests bar chart shows the top five failed tests in terms of percentage of failure. By default tests across all applications is shown. You can see the top failed tests under a specific application by selecting it.

Links are provided to open the associated Oracle E-Business Suite instance in a separate window and open up the Oracle Diagnostics pages in Oracle E-Business Suite.

The Oracle Applications System User Monitoring Tab

The User Monitoring tab enables you to link a database session to an Oracle E-Business Suite user session. In this way you can link a performance issue in a database session to activity done by that Oracle E-Business Suite user. The User Monitoring feature checks three entities: Concurrent Programs requests, Forms sessions, and Oracle Application Framework sessions to see if it can find a match for the database session ID.

Note: If the database session is triggered by something else, this system will not be able to capture it. This is a limitation.

Setup Steps for User Monitoring

User Monitoring requires additional setup steps. On the OMS side:

Additional setup steps required on the Oracle E-Business Suite side are:

  1. For the above Oracle E-Business Suite user, assign "LCM_EM_CLIENT" responsibility.

  2. Form sessions can be monitored only when the site-level profile Sign-On:Audit Level is set to 'FORM'. The internal name for this profile is 'SIGNONAUDIT:LEVEL'.

Diagnostic Tests for User Monitoring

You can run diagnostic tests on your system for user monitoring. These tests can be accessed from the Diagnostics dashboard, available from the Pack Diagnostics link on the Oracle Applications page. For more information on running diagnostic tests, see: Running Pack Diagnostics Tests.

The following tables list tests for user monitoring.

Generic Diagnostic Tests for User Monitoring
Step Test Group
Description Notes/Expected Results/Corrective Measures
EBS CheckIOPatches for <Release> Verify that certain patches have been applied on the Oracle E-Business Suite target. Note that this step may change, depending on the Oracle E-Business Suite release (for example, Release 11i, 12.0, and so on). The list of patches is contained in an XML file that might be modified to include or exclude recommended patches.
EBS CheckRESTHealth Checks if "Rest Ping" is working properly. Rest Ping is a Ping Service, called using REST framework. The Ping Service tries to ping Oracle E-Business Suite instance and this should return a “SUCCESS”. User monitoring is heavily dependent on this framework. If the test fails, normally it gives the message why it failed. Refer to the emoms.log for additional information.
EBS Summary A summary of all of the diagnostic tests that have been executed, in the following groups: Successful, Failed, With Warning, Aborted, and Total.  
User-Specific Diagnostic Tests for User Monitoring
Step Test Group Description Notes/Expected Results/Corrective Measures
EBS CheckEBSProfile Check if the Oracle E-Business Suite profile is properly set. User Monitoring functionality displays a user's form related activities. To show this information, a user's system profile code “SIGNONAUDIT:LEVEL” must be set to FORM. This checks if the profile value is set to FORM. Verify that the credentials supplied are valid for the "E-Business Suite Applications Login" username/password, found in the in "E-Business Suite" Target Type in Preferred Credentials. Verify that the user specified in the "E-Business Suite Applications Login" section has their "SIGNONAUDIT:LEVEL" profile set to "FORM".
EBS CheckEBSRole Verify if the EM User (that is, the user executing the diagnostic test) has the required responsibility to execute User Monitoring Functionality. The responsibility is LCM_EM_CLIENT, and must be attached to the Oracle E-Business Suite user in the Oracle E-Business Suite Applications Login Preferred Credentials. Verify that the credentials supplied are valid for the "E-Business Suite Applications Login" username/password, found in the in "E-Business Suite" Target Type in Preferred Credentials. Verify that the user specified in the "E-Business Suite Applications Login" section has been assigned the "LCM_EM_CLIENT" responsibility.
EBS CheckEBSGlobalCred Check Oracle E-Business Suite preferred credentials This test verifies if the "E-Business Suite Applications Login" username and password exists and, if so, are valid for a particular instance. Verify that the credentials supplied are valid for the "E-Business Suite Applications Login" username/password, found in the in "E-Business Suite" Target Type in Preferred Credentials.
EBS Summary A summary of all of the diagnostic tests that have been executed, in the following groups: Successful, Failed, With Warning, Aborted, and Total.  

User Monitoring Dashboard

Navigate to the User Monitoring dashboard from the Oracle E-Business Suite instance's User Monitoring subtab.

The dashboard has four bar charts of database sessions (triggered by APPS user only)

the picture is described in the document text

The level of detail shown in the bar graphs is controlled by properties set in the Preferences page:

You can drill down from the legend to see the details of the session. If the Oracle E-Business Suite user information is available, the Oracle E-Business Suite session details will be shown with further drilldown to the database session details. If the Oracle E-Business Suite user information is not available, you can drill down to the database session details. The charts are derived by monitoring session history for the last 15 minutes. This interval is configurable by setting the value for Sampling Interval for User Monitoring in the Preferences page. The maximum value allowed is 60. You can navigate to the Preferences page from the main Oracle E-Business Suite Instances page, under Related Links.

Note: If you make changes to the Preferences settings, , the changes will take at least fifteen (15) minutes to take effect. If you want the changes to take effect immediately, restart the OMS.

Search Applications User Sessions

You can search for Oracle E-Business Suite user sessions from the User Monitoring subtab.

The link to this search feature is available in the dashboard itself.

The Configuration Topology Page

The Configuration Topology page for Oracle E-Business Suite lists the dependencies between the infrastructure services, the key system components, and other services that define their availability. Upon service failure, the potential causes of failure, as identified by Root Cause Analysis, are highlighted in the topology view. In the Topology tab, you can view dependent relationships between services and systems.

Navigate to the Topology page from the Target menu > Configuration > Topology.

the picture is described in the document text

The Configuration Topology page shows the infrastructure service Topology view of the Oracle E-Business Suite system. The icons represent each service and the lines connecting them show their dependencies. This view allows administrators to identify the root cause of a problem much more quickly compared to a tabular representation of the same information.

See the Oracle Enterprise Management Lifecycle Management Administrator's Guide for more information on the Configuration Topology Viewer.