Oracle Health Check Collections Manager Application provides an option to display data based on the select lists like Business Units, Systems, and Data for last periods of time.

All these select lists are global within the application and options available on starting of each tab.

• Business Unit

• System

• Data interval

Displays systems and their statuses, and recent activities of all users who has permission to access the application.

• Displays systems and their statuses in graphs with color coded green, orange, and red based on check results (passed, warning, and failed).

• The Home tab provides an option to display the data based on select lists like Business Units and Data for last periods of time. There is also an option to filter the most failed/warned checks and recent collections based on system name.

• The Most Failed Checks region displays information for the most frequently failed checks for all collections for the time period, Business Unit, or System selected, and displays the check name, fail count. There is a similar region for most warned checks.

• The Recent Collections region displays brief information about recently uploaded collections based on time frame, Overall score with Fail, Warning, and Pass counts and a Status flag. Recent collections are automatically compared to the last collection from the same system, whenever it occurred, if there is one.

  Status Flags are color-coded green, orange, or red based on the comparison between the recent collection and the last collection, if any.

  • GREEN: There is no difference at all between the two collections or one or more findings from the last collection improved from WARNING or FAIL to PASS or there was no earlier collection to compare with.

  • ORANGE: There were one or more regressions between the last collection and the most recent on a given system. In other words some findings transitioned in a negative way, for example, PASS to WARNING.

  • RED: There were one or more regressions between the last collection and the most recent on a given system. In other words some findings transitioned in a negative way, for example, PASS to FAIL.

• Recent Activity in User Range shows recent activities by all users across all collections specific to the access role granted the user.

  • DBA role users can see everything that happens in the systems assigned to them.

  • DBA Manager role users can see everything within their Business Unit and the systems assigned to them.

  • Admin role user can see everything when there is a collection data uploaded in to the application.

Figure 3-75 Home Tab

Description of "Figure 3-75 Home Tab"

Displays incidence information for each collection, and collection score for failed, warning, and failed checks.

• Displays all collections and allows you to filter the list of collections based on Business units and System. You can also filter based on Status flag. The list is also inherently filtered to those collections the user has access to, based on their assigned role.

• Displays incident information for each collection indicated by Delta (Δ) color coded red, blue, and green based on ticket status. Click the delta symbol to raise a new ticket or alter the ticket for an entire collection.

  • RED (No Incident ticket exists): Click to create a new incident ticket for the collection or individual checks.

  • BLUE (An open Incident ticket exists): Click to open the incident ticket for editing.

  • GREEN (A closed Incident ticket exists): Click opens the closed incident ticket for viewing.

• Collection Score is calculated based on failed, warning, and passed checks.

  If a user raised a ticket for the collection, resolved the issues and the ticket is closed signifying the issues have all been resolved, then Oracle Health Check Collections Manager changes the collection score to 100%.

  If a user raised a ticket for an individual check and if it is closed signifying that the finding has been resolved, then Oracle Health Check Collections Manager changes the status of the check as PASS and recalculates the collection score.

  Collection Score is derived using following formula.

  • Every check has 10 points.

  • Failure deducts 10 points.

  • Warning deducts 5 points.

  • Info deducts 3 points.

• A More Info link next to a collection indicates that the collection was manually uploaded into the application.

• Click the linked collection name in the list to load the collection in the Browse tab.

Figure 3-76 Collections Tab

Description of "Figure 3-76 Collections Tab"

Enables you to list individual checks based on filters set.

• Set filters once the list of checks is created.

• Create and alter incident tickets for individual audit check findings similar to as described in the Collections tab.

• Select checks to ignore and to undo previously ignored checks. Select the check box beside the audit check and click Ignore Selected. Oracle Health Check Collections Manager marks them as FAIL-IGNORED, indicating that the check had failed but is ignored.

  Oracle Health Check Collections Manager ignores the checks for the entire level based on the level selected for ignoring.

  To ignore selected failed checks, you must choose the ignore type from the following list:

  • Ignore from collection

  • Ignore from system

  • Ignore from a business unit

  • Ignore from all business units

    Note:

    The domain for ignoring checks is within the role assigned to the user.

  All ignored checks are listed under the Ignored Checks tab. If needed, undo ignore.

  To undo the selected Ignored checks, consider the type from the following list:

  • Undo ignore from collection

  • Undo ignore from system

  • Undo ignore from business unit

  • Undo ignore from all business units

    Note:

    The domain for undoing ignored checks is within the role assigned to the user.

Figure 3-77 Browse Sub Tab

Description of "Figure 3-77 Browse Sub Tab"

Compare tab enables you to compare audit check results and patch results.

• Compare Audit check Results

  • Compare the audit check findings from two different collections based on Business Unit, System, DB Version and Platform. The collections available for comparison are limited to filters set.

  • Compare collections from the same or different systems.

• Compare Patch Results

  • Compare installed Oracle patches from two different collections. The comparison displays the difference between the two collections based on patch results.

Figure 3-78 Compare Sub Tab - Audit Checks Diff

Description of "Figure 3-78 Compare Sub Tab - Audit Checks Diff"

Figure 3-79 Compare Sub Tab - Patch Results Diff

Description of "Figure 3-79 Compare Sub Tab - Patch Results Diff"

Provides a graphical representation of database checks, instance checks, home path checks, and system health checks.

• Provides a printable view option to print the graphical summary of system collection

• Displays separate graphical summary view for database checks, instance checks, and home path checks breakup based on check type and check status in collection

• Displays system health check details based on status and check type in collection

Figure 3-80 Report View Tab - Summary

Description of "Figure 3-80 Report View Tab - Summary"

Figure 3-81 Report View Tab - Details

Description of "Figure 3-81 Report View Tab - Details"

Provides an interface to manually upload a collection into Oracle Health Check Collections Manager Application and provides a list of uploaded collections and file details.

These manually uploaded collections are unzipped and their data imported into the framework as if they had been uploaded at runtime when the tool was run. Therefore, even if the tool is not configured for automatic upload into the Oracle Health Check Collections Manager Application, you can always upload collections manually.

Figure 3-82 Upload Collections Sub Tab

Description of "Figure 3-82 Upload Collections Sub Tab"

The Incidents tab gives you a complete system for tracking support incidents.

• Specify contact details of each customer, products and categories, and then set up values to limit status codes, severity, and urgency attributes for an incident

• Raise a new ticket by clicking the Delta (Δ) symbol. Oracle Health Check Collections Manager displays the delta symbol only in the Collections and Browse tabs

• The Browse tab enables you to create a new ticket on individual checks

• The Collections tab enables you to create a single ticket for entire the collection

• Delta (Δ) symbol is color coded red, blue, and green based on the ticket status

  • RED (No Incident ticket exists): Initiates the process to create a new incident ticket for the collection or individual checks

  • BLUE (An open Incident ticket exists): Opens the incident ticket for editing

  • GREEN (A closed Incident ticket exists): Opens the closed incident ticket for viewing

• Track the progress of the ticket in an update area of the ticket, or add attachments and links to the incident

• Use tags to classify incidents and use the resulting tag cloud in your reports

• Incident access and management happen only within your access control range

Figure 3-83 Incidents Tab

Description of "Figure 3-83 Incidents Tab"

• Incidents Tab
  Create or edit incident tickets for individual checks or for an entire collection.

User-defined checks are checks written, tested, verified, and maintained by you that are specific to your environment.

1. Click Analytics > User Defined Checks (or alternatively, Administration > Add New User Defined Checks to skip to step 3).

   Figure 3-84 User Defined Checks

   
   Description of "Figure 3-84 User Defined Checks"
2. Select Add New Check.
3. Select OS Check or SQL Check as Audit Check Type.

   This choice decides how your check logic is coded. Operation System checks use a system command to determine the check status. SQL checks run an SQL statement to determine the check status.

   Figure 3-85 User Defined Checks Tab - Audit Check Type

   
   Description of "Figure 3-85 User Defined Checks Tab - Audit Check Type"

   Once you have selected an Audit Check Type, Oracle Health Check Collections Manager updates the applicable fields.

   Any time during authoring, click the question mark next to a field to see help documentation specific to that field.

   OS and SQL commands are supported. Running user defined checks as root is NOT supported.

   Figure 3-86 User Defined Checks Tab - Audit Check Type - OS Check

   
   Description of "Figure 3-86 User Defined Checks Tab - Audit Check Type - OS Check"

   Once a check is created, it is listed in the Available Audit Checks section.

   You can create checks and each can be filtered using the filters on this page.

   Figure 3-87 User Defined Checks Tab - Available Audit Checks

   
   Description of "Figure 3-87 User Defined Checks Tab - Available Audit Checks"
4. Click the Generate XML.

   On the right, find a link to download the generated user_defined_checks.xml file.

   All the checks that have been authored and have not been placed on hold are included in the XML file when generated. Placing checks on hold is equivalent to a logical delete. If a problem is discovered with a check or the logic has not been perfected, it can be placed on hold to keep it from being included in the XML file until it is production ready. The hold can be removed to include it in the XML file next time it is generated.

   Download the user_defined_checks.xml file and save it into the same directory as Oracle Orachk and Oracle Exachk tools. Oracle Orachk and Oracle Exachk run the user-defined checks the next time they run.

   Figure 3-88 User Defined Checks Tab - Download User Defined Checks

   
   Description of "Figure 3-88 User Defined Checks Tab - Download User Defined Checks"

   Alternatively, to run only the user-defined checks use the profile user_defined_checks. When this option is used, then the user-defined checks are the only checks run. The User Defined Checks section is the only one with results displayed in the report.

   orachk –profile user_defined_checks

   exachk –profile user_defined_checks

   To omit the user-defined checks at runtime, use the –excludeprofileoption.

   orachk –excludeprofile user_defined_checks

   exachk –excludeprofile user_defined_checks