Skip Headers
Oracle® Database 2 Day DBA
11g Release 1 (11.1)

Part Number B28301-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

Investigating, Reporting, and Resolving a Problem

This section describes the typical set of tasks that you perform to investigate and report a problem (critical error), and in some cases, resolve the problem. The section begins with a roadmap that summarizes these tasks.

Note:

The workflow described in this section includes only the minimum tasks that are required to investigate, report, and in some cases, repair a problem. See Oracle Database Administrator's Guide for a more complete workflow that includes additional diagnostics-gathering activities and data customization activities that you can do before uploading the diagnostic data to Oracle Support Services. In some cases, these additional activities may result in a shorter time to problem resolution.

Roadmap: Investigating, Reporting, and Resolving a Problem

You can begin investigating a problem by starting from the Support Workbench Home page. However, the more typical workflow begins with a critical error alert on the Database Home page. This documentation provides an overview of that workflow.

Figure 11-1 illustrates the basic tasks that you complete when encountering a problem.

Figure 11-1 Workflow for Investigating, Reporting, and Resolving a Problem

Description of Figure 11-1 follows
Description of "Figure 11-1 Workflow for Investigating, Reporting, and Resolving a Problem"

The following are task descriptions. Subsequent sections provide details for each task.

Task 1 – View Critical Error Alerts in Enterprise Manager

You begin the process of investigating problems (critical errors) by reviewing critical error alerts on the Database Home page.

To view critical error alerts:

  1. Go to the Database Home page in Enterprise Manager.

    See "Accessing the Database Home Page".

  2. In the Alerts section, examine the table of alerts.

    Critical error alerts are indicated by an X in the Severity column, and the text "Incident" in the Category column.

    Note:

    You may have to click the hide/show arrowhead icon next to the Alerts heading to display the alerts table.
    Description of critical_alert_home_jrs.gif follows
    Description of the illustration critical_alert_home_jrs.gif

  3. (Optional) In the Category list, select Incident to view alerts of type Incident only.

  4. In the Message column, click the message of the critical error alert that you want investigate.

    An Incident detail or Data Failure page appears for the type of incident you selected. For example, if you clicked a message about an ORA-600 error, the Incident - Generic Internal Error page appears.

    This page displays:

    • Problem information, including the number of incidents for the problem

    • A Performance and Critical Error graphical timeline for the 24-hour time period in which the critical error occurred

    • Alert details, including severity, timestamp, and message

    • Controls that enable you to clear the alert or record a comment about it

    Description of critical_alert_perf.gif follows
    Description of the illustration critical_alert_perf.gif

  5. Review the Performance and Critical Error graphical timeline, and note any time correlation between performance issues and the critical error. Optionally clear the alert or leave a comment about it.

  6. Perform one of the following actions:

Task 2 – View Problem Details

You continue your investigation with the Problem Details page.

To view problem details:

  1. On the Incident detail or Data Failure page, click View Problem Details.

    The Problem Details page appears, showing the Incidents subpage.

  2. (Optional) To view incident details, in the Incidents subpage, select an incident, and then click View.

    The Incident Details page appears, showing the Dump Files subpage.

  3. (Optional) On the Incident Details page, click Checker Findings to view the Checker Findings subpage.

    This page displays findings from any health checks that were automatically run when the critical error was detected.

    See Also:

Task 3 – (Optional) Create a Service Request

At this point, you can create an Oracle Support service request and record the service request number with the problem information. If you choose to skip this task, the Support Workbench will automatically create a draft service request for you in Task 4.

To create a service request:

  1. On the Problem Details page, in the Investigate and Resolve section, click Go to Metalink.

    Description of problem_details_jrs.gif follows
    Description of the illustration problem_details_jrs.gif

    The OracleMetaLink Login and Registration page appears in a new browser window.

  2. Log in to OracleMetaLink and create a service request in the usual manner.

    (Optional) Remember the service request number (SR#) for the next step.

  3. (Optional) Return to the Problem Details page, and then do the following:

    1. In the Summary section, click the Edit button that is adjacent to the SR# label.

    2. In the page that opens, enter the SR#, and then click OK.

    The SR# is recorded in the Problem Details page. This is for your reference only.

Task 4 – Package and Upload Diagnostic Data to Oracle Support Services

For this task, you use the quick packaging process of the Support Workbench to package and upload the diagnostic information for the problem to Oracle Support Services. Quick packaging has a minimum of steps, organized in a guided workflow (a wizard). The wizard assists you with creating an incident package (referred to as a package) for a single problem, creating a ZIP file from the package, and uploading the file. With quick packaging, you are not able to edit or otherwise customize the diagnostic information that is uploaded. Using quick packaging is the direct, straightforward method to package and upload diagnostic data.

If you want to edit or remove sensitive data from the diagnostic information, enclose additional user files (such as application configuration files or scripts), or perform other customizations before uploading, you must use the custom packaging process. See Oracle Database Administrator's Guide for instructions. When you complete those instructions, you may continue with Task 5 – Track the Service Request and Implement Any Repairs.

Note:

The Support Workbench uses Oracle Configuration Manager to upload the diagnostic data. If Oracle Configuration Manager is not installed or properly configured, the upload may fail. In this case, a message is displayed with a request that you upload the file to Oracle Support manually. You can upload files manually with OracleMetaLink.

For more information about Oracle Configuration Manager, see Oracle Configuration Manager Installation and Administration Guide.

To package and upload diagnostic data to Oracle Support:

  1. On the Problem Details page, in the Investigate and Resolve section, click Quick Package.

    The Create New Package page of the Quick Packaging wizard appears.

    Description of quick_package_1_new.gif follows
    Description of the illustration quick_package_1_new.gif

  2. (Optional) Enter a package name and description.

  3. Fill in the remaining fields on the page. If you have already created a service request for this problem, select No next to Create new Service Request (SR).

    If you select Yes, the Quick Packaging wizard creates a draft service request on your behalf. You must later log in to OracleMetaLink and fill in the details of the service request.

  4. Click Next, and then proceed with the remaining pages of the Quick Packaging wizard.

    When the Quick Packaging wizard is complete, the package that it creates remains available in the Support Workbench. You can then modify it with custom packaging operations (such as adding new incidents) and reupload the package at a later time.

Task 5 – Track the Service Request and Implement Any Repairs

After uploading diagnostic information to Oracle Support Services, you might perform various activities to track the service request, to collect additional diagnostic information, and implement repairs. Among these activities are the following:

  • Adding an Oracle bug number to the problem information.

    To do so, on the Problem Details page, click the Edit button that is adjacent to the Bug# label. This is for your reference only.

  • Adding comments to the problem activity log.

    You may want to do this to share problem status or history information with other DBAs in your organization. For example, you could record the results of your conversations with Oracle Support.

    To add comments to the problem activity log:

    1. Go to the Problem Details page for the problem, as described in "Viewing Problems Using the Enterprise Manager Support Workbench".

    2. Click Activity Log to display the Activity Log subpage.

      Description of activity_log.gif follows
      Description of the illustration activity_log.gif

    3. In the Comment field, enter a comment, and then click Add Comment.

      Your comment is recorded in the activity log.

  • If a new incident occurs, adding them to the package and reuploading to Oracle Support Services.

    For this activity, you must use the custom packaging method described in Oracle Database Administrator's Guide.

  • Running health checks.

    See Oracle Database Administrator's Guide for information about health checks.

  • Running a suggested Oracle advisor to implement repairs.

    You can access the suggested advisor in one of the following ways:

    • Problem Details page—In the Self-Service tab of the Investigate and Resolve section

    • Support Workbench Home page—On the Checker Findings subpage

    • Incident Details page—On the Checker Findings subpage

    Table 11-1 lists the advisors that help repair critical errors.

    Table 11-1 Oracle Advisors that Help Repair Critical Errors

    Advisor Critical Errors Addressed See

    Data Recovery Advisor

    Corrupted blocks, corrupted or missing files, and other data failures

    "Performing Oracle Advised Recovery"


    SQL Repair Advisor

    SQL statement failures

    Oracle Database Administrator's Guide



Task 6 – Close Incidents

When a particular incident is no longer of interest, you can close it. By default, closed incidents are not displayed on the Problem Details page.

All incidents, whether closed or not, are purged after 30 days. You can disable purging for an incident on the Incident Details page.

To close incidents:

  1. Go to the Support Workbench Home page.

    See "Viewing Problems Using the Enterprise Manager Support Workbench".

  2. Select the desired problem, and then click View.

    The Problem Details page appears.

  3. Select the incidents to close and then click Close.

    A confirmation page appears.

  4. Enter an optional comment and then click OK.