Skip Headers

Oracle Application Management Pack for Oracle E-Business Suite User's Guide
Release 4.0
Part Number E18709-01
Go to Table of Contents
Contents
Go to previous page
Previous
Go to next page
Next

The System Management Dashboard

Using the Grid Control Pages to Manage Oracle E-Business Suite

Grid 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 Grid Control for managing those systems.

Enabling the Oracle Applications Subtab

The Oracle Application Management Pack for Oracle E-Business Suite provides a new Oracle Applications subtab under the Targets tab of Grid Control. You can enable or disable this subtab, depending on your preferences. By default, this new subtab is enabled only for the SYSMAN user.

the picture is described in the document text

To enable the subtab:

  1. Click on the global Preferences link in Grid Control.

  2. Select Target Subtabs from the menu on the left of the page.

  3. Choose Oracle Applications from the Available Target Subtabs list.

  4. Click Move to move your selection to the Selected Target Subtabs list.

Setting Up 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.

Use the following steps to set up credentials:

  1. Within Oracle Enterprise Manager, select the Preferences global link.

  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 Applications Page

Access the Oracle Applications page by clicking on the Oracle Applications subtab under the Targets tab in Grid Control.

the picture is described in the document text

This page provides an overview of the Oracle E-Business Suite systems that have been registered with Grid Control. You can register a new system by clicking Add, and following the directions in the section Discovering Oracle E-Business Suite Systems with Grid Control. You can remove an Oracle E-Business Suite system from Grid 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.

The Oracle Applications page summarizes the status of each Oracle E-Business Suite system that has been registered with Grid Control. For each system, the page also provides a set of metrics that summarize aspects of system usage and performance. You can drill down on the Oracle E-Business Suite system Name to access the home page for that system. You can also drill down on any summary metric to view the historical values of that metric.

This page also provides you with links to additional features:

Also, you can click on the Change Management tab to access the features of the Oracle Application Change Management Pack for Oracle E-Business Suite.

Configure Table Columns (Configure Summary Metrics)

You can configure the summary metrics that are displayed in the Oracle Applications page by clicking on the Customize Table Columns link.

Use the shuttle control to select the summary metric columns that you would like to appear in the Oracle Applications page.

the picture is described in the document text

Descriptions of the available "summary" metric columns can be found in the next section.

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:

Related Topics

Oracle Application Change Management Pack for Oracle E-Business Suite User's Guide

Running Pack Diagnostics Tests

Navigating the Diagnostics Dashboard

  1. Click on the Pack Diagnostics link under Related Links on the Oracle Applications 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:

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.

  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:

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

The Oracle Applications System Home Page

The home page for an individual Oracle Applications system can be reached by drilling down from the Oracle Applications page as described in the section above. You can also reach the home page by drilling down on the desired Oracle Applications system target in the All Targets page and in other pages of Grid Control.

the picture is described in the document text

The Oracle Applications System home page provides an overview of the status of a single Oracle Applications 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 Applications 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 Applications 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 Grid Control, Oracle Applications middle tier components can be monitored for their availability and performance. The middle tier components, being the infrastructure for Oracle Applications, are monitored not only for their key processes but also for all the other components on which they are dependent.

The Oracle Applications Infrastructure 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.

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

Alerts and Related Alerts

the picture is described in the document text

The Alerts section provides an overview of the Alerts posted by Oracle Enterprise Manager for targets that have become unavailable, or for metrics that have exceeded specified thresholds. The Alerts table shows alerts specifically for the Oracle Applications system target.

The Related Alerts table shows alerts for all targets that were registered as members of the Oracle Applications system but being monitored separately outside the pack.

You can drill down to view the details of an alert 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 an alert metric threshold for alerting, click the Edit Metric Thresholds link under Related Links at the bottom of the page. For more information on metrics and alerts, please see the Enterprise Manager 10g Grid Control documentation.

Related Links

Related Links include:

Most of these links and their features are described in the Oracle Enterprise Manager documentation.

The Configured Components page lists each component, its status, number of alerts, and component type. You can drill down to more details on each component, its status, and alerts using the links provided.

The Oracle Applications Manager (OAM) link opens a new browser window for OAM in the Oracle E-Business Suite; OAM is described in the Oracle E-Business Suite System Administrator's Guide Documentation Set.

The Oracle Applications System Performance Page

The Oracle Applications System Performance page pulls together 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 Oracle Application System JVM usage summary can be viewed from the Performance page. Click the JVM Usage link available 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 install and will need to be reset as follows:

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 Oracle Applications System Performance page 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 Page

The Oracle Applications System Administration page 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 "Reports" 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 Reports column for System Overview.

System Overview

the picture is described in the document text

The System Overview view is broken into three sections:

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

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 select the appropriate context file and click Related Details button 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 and click the Related Details button 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 configuration information that can be viewed is:

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

Configuration information is shown for the following components:

Search Patch / Patchset Information

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 Page

The Oracle Applications Maintenance page provides access to the Oracle Application maintenance activities particularly in the areas of patching and cloning.

the picture is described in the document text

The Maintenance page is divided into the three sections:

The Oracle Applications System Diagnostics Page

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

the picture is described in the document text

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 allows 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 show 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 Page

The User Monitoring page 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 Applications login user, assign "LCM_EM_CLIENT" responsibility.

  2. Form sessions can be monitored only when the following site-level profile is set to 'FORM': Profile Name - Sign-On:Audit Level, Profile Code - 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
Task Step
Description Notes/Expected Results/Corrective Measures
EBS CheckIOPatches for 11i 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
Task Step
Description Notes/Expected Results/Corrective Measures
EMGC None None  
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 "Applications Login" username/password, found in the in "E-Business Suite" Target Type in Preferred Credentials. Verify that the user specified in the "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 "Applications Login" username/password, found in the in "E-Business Suite" Target Type in Preferred Credentials. Verify that the user specified in the "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 "Applications Login" username and password exists and, if so, are valid for a particular instance. Verify that the credentials supplied are valid for the "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 count in the bar chart is configurable by setting the property um_dashboard_no_of_rows in the "amp.properties" configuration file with the maximum limit as 10. The legend of the graph shows the name of the Oracle E-Business Suite user for the corresponding session in the graph. If Oracle E-Business Suite user is not available, the database SID itself is shown in the legend.

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 property um_session_sampling_interval in the amp.properties file. The maximum value allowed is 60.

Note: If you make changes to the configuration file "amp.properties", 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 Oracle Applications System Topology Page

Note: This page is available for Oracle E-Business Suite Release 12 only.

In addition, the topology view is available only with Internet Explorer 5.5 or later on Windows.

The Oracle Application System Topology page 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 page, you can view dependent relationships between services and systems.

the picture is described in the document text

The Topology page shows the infrastructure service Topology view of the Oracle Application 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.

Links to related features are also on this page, including: