11 Investigating, Reporting, and Resolving Problems

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

  Start by accessing the Database Home page in Enterprise Manager, and reviewing critical error alerts. Select an alert for which to view details. From the alert details page, go to the Problem Details page.

• Task 2 – View Problem Details

  Examine the problem details and view a list of incidents that were recorded for the problem. Display findings from any health checks that were automatically run.

• Task 3 – (Optional) Create a Service Request

  Create a service request using My Oracle Support and optionally record the service request number with the problem information. If you skip this step, then you can create a service request later, or the Support Workbench can create one for you.

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

  Invoke a guided workflow (a wizard) that automatically packages all gathered diagnostic data for a problem and uploads the data to Oracle Support Services.

• Task 5 – Track the Service Request and Implement Any Repairs

  Optionally maintain an activity log for the service request in the Support Workbench. If appropriate, run Oracle advisors to help repair SQL failures or corrupted data.

• Task 6 – Close Incidents

  Set the status for one, some, or all incidents for the problem to Closed.

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 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 to 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, then 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 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:

   • To view the details of the problem associated with the critical error alert that you are investigating, proceed with Task 2 – View Problem Details.

   • If the graphical timeline shows a large number of different problems during the 24-hour time period and you want to view a summary of all those problems, then complete these steps:

     • Click View All Problems.

       The Support Workbench Home page appears.

     • View problems and incidents as described in "Viewing Problems Using the Enterprise Manager Support Workbench".

     • Select a single problem and view problem details, as described in "Viewing Problems Using the Enterprise Manager Support Workbench".

     • Continue with Task 3 – (Optional) Create a Service Request.

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:

   • Oracle Database Administrator's Guide for information about health checks and checker findings

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, then the Support Workbench automatically creates 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 My Oracle Support.

   
   Description of the illustration problem_details_jrs.gif
   
   

   The My Oracle Support Login and Registration page appears in a new browser window.

2. Log in to My Oracle Support 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.

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.

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 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 created a service request for this problem, then select No next to Create new Service Request (SR).

   If you select Yes, then the Quick Packaging wizard creates a draft service request on your behalf. You must later log in to My Oracle Support 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 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 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.

• Adding new incidents, if they occur, to the package and reuploading the package 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.