oracle 11g管理篇

Task 1 – View Critical Error Alerts in Enterprise Manager......................................................9-13 Task 2 –View Problem Details.......................................................................................................9-14 Task 3 – (Optional) Gather Additional Diagnostic Information..............................................9-14 Task 4 – (Optional) Create a Service Request..............................................................................9-14 Task 5 – Package and Upload Diagnostic Data to Oracle Support..........................................9-15 Task 6 – Track the Service Request and Implement Any Repairs............................................9-16 Task 7 – Close Incidents.................................................................................................................9-17 Viewing Problems with the Enterprise Manager Support Workbench......................................9-18 Creating a User-Reported Problem....................................................................................................9-19 Viewing the Alert Log..........................................................................................................................9-20 Finding Trace Files................................................................................................................................9-21 Running Health Checks with Health Monitor................................................................................9-21 About Health Monitor....................................................................................................................9-22 Running Health Checks Manually...............................................................................................9-23 Viewing Checker Reports..............................................................................................................9-24 Health Monitor Views....................................................................................................................9-27 Health Check Parameters Reference............................................................................................9-28 Repairing SQL Failures with the SQL Repair Advisor.................................................................9-28 About the SQL Repair Advisor.....................................................................................................9-29 Running the SQL Repair Advisor.................................................................................................9-29 Viewing, Disabling, or Removing a SQL Patch..........................................................................9-30 Repairing Data Corruptions with the Data Recovery Advisor....................................................9-31 Creating, Editing, and Uploading Custom Incident Packages.....................................................9-32 About Incident Packages................................................................................................................9-33 Packaging and Uploading Problems with Custom Packaging................................................9-35 Viewing and Modifying Incident Packages................................................................................9-39 Creating, Editing, and Uploading Correlated Packages...........................................................9-45 Deleting Correlated Packages.......................................................................................................9-45 Setting Incident Packaging Preferences.......................................................................................9-46 10Managing Oracle Enterprise Manager Database Control

Database Control Overview................................................................................................................10-1 Understanding the Enterprise Manager Directories..................................................................10-1 Configuring Database Control During and After Installation....................................................10-3 Overview of Configuration Options............................................................................................10-3 Configuring Database Control During Installation...................................................................10-4 Configuring Database Control with DBCA................................................................................10-4 Configuring Database Control Using EMCA.............................................................................10-5 Using an Input File for EMCA Parameters...............................................................................10-10 Specifying the Ports Used by Database Control.......................................................................10-11 Using EMCA With Oracle RAC..................................................................................................10-12 Administering Database Control.....................................................................................................10-15 Starting and Stopping the Database Control Process..............................................................10-15 Accessing the Database Home Page...........................................................................................10-16 Creating Database Control Administrative Users....................................................................10-17 Granting Access to Database Control for Non-Administrative Users..................................10-18 Setting Database Control Preferences........................................................................................10-18

ix