Oracle Database Resource Portfolio - RAC/Scalability

Key RAC/ScalabilityArticles

Best Practice Documents

The following Best Practice Documents are available:

• RAC and Oracle Clusterware Best Practices and Starter Kit (Platform Independent) [Document 810394.1]
• RAC: Frequently Asked Questions [Document 220970.1]
• Top 11 Things to do NOW to Stabilize your RAC Cluster Environment [Document 1344678.1]
• Top 11gR2 RAC Installation Issues [Document 1372375.1]
• Top 11gR2 Grid Infrastructure Upgrade Issues [Document 1366558.1]
• How to Modify Private Network Information in Oracle Clusterware [Document 283684.1]
• How to Modify Public Network Information including VIP in Oracle Clusterware [Document 276434.1]
• How to update the IP address of the SCAN VIP resources [Document 952903.1]
• Using Oracle Clusterware with Vendor Clusterware FAQ [Document 332257.1]

Best Practice Webcasts

The following Best Practice Webcasts are available:

How To Setup 12c ACFS RAC Filesystem Through EM Cloud Control 12c

Recording

.pdf

For other webcasts, refer to Document:1456176.1 Database Advisor Webcasts: Current Schedule and Archived recordings

Health Checks

• ORAchk - Oracle Configuration Audit Tool [Document 1268927.1]

Tools

• Cluster Health Monitor (CHM) FAQ [Document 1328466.1]
• TFA Collector- The Preferred Tool for Automatic or ADHOC Diagnostic Gathering Across All Cluster Nodes [Document 1513912.1]
• CRS 10gR2/ 11gR1/ 11gR2 Diagnostic Collection Guide [Document 330358.1]
• ORAchk - Oracle Configuration Audit Tool [Document 1268927.1]

Troubleshooting Assistants

• Oracle Grid Infrastructure Install [Document 1551639.2]
• Oracle Grid Infrastructure Upgrade [Document 1553630.2]
• Oracle Grid Infrastructure Patching [Document 1553605.2]

Premium Knowledge Content Notes

• Information Center: Oracle Scalability Grid Infrastructure / Clusterware and Real Application Clusters (RAC) [Document 1452965.2]
• Master Note for Real Application Clusters (RAC) Oracle Clusterware and Oracle Grid Infrastructure [Document 1096952.1]

MOS Communities

• RAC/Scalability MOS Community

Troubleshooting Documents

The following Troubleshooting Documents are available:

• Troubleshooting Clusterware Node Evictions (Reboots) [Document 1050693.1]
• Using Diagwait as a diagnostic to get more information for diagnosing Oracle Clusterware Node evictions [Document 559365.1]
• Top 5 RAC Instance Crash Issues [Document 1375405.1]
• Top 5 Issues That Cause Troubles with Scan VIP and Listeners [Document 1373350.1]
• Top 5 Database and/or Instance Performance Issues in RAC Environment [Document 1373500.1]
• Top 5 (RAC Specific) Database Management Issues With DBCA, NETCA, DBUA and Other Tools [Document 1371066.1]
• Top 5 CRS Cluster Patching Issues [Document 1372859.1]
• Top 5 issues for Instance Eviction [Document 1374110.1]
• Troubleshooting "Global Enqueue Services Deadlock detected" [Document 1443482.1]
• Troubleshooting: "log file sync" Waits [Document 1376916.1]

Oracle Database Resource Portfolio - Performance

Key Performance Articles 

Best Practice Documents

 

Best Practice Webcasts

The following Best Practice Webcasts are available:

Oracle Database Resource Manager	Recording	.pdf
How to achieve Plan Stability on 11g with SQL Plan Management (SPM)	Recording	.pdf
Best Practices: Proactive Data Collection to Troubleshoot DB Performance Issues	Recording	.pdf

For other webcasts, refer to Document:1456176.1 Database Advisor Webcasts: Current Schedule and Archived recordings

Health Checks

• SQL Tuning Health Check Script (SQLHC) [Document 1366133.1]
• SQL Tuning Health-Check Script (SQLHC) Video [Document 1455583.1]

Tools

Oracle Service Request Data Collection

• Performance Related Oracle Service Request Data Collection (SRDC) Articles [Document 1938786.1]

Tools

• Oracle Performance Diagnostic Guide (OPDG) [Document 390374.1]
• All About the SQLT Diagnostic Tool [Document 215187.1]
• Analysis of Active Session History (Ash) Online and Offline [Document 243132.1]
• OSWatcher Black Box User Guide (Includes: [Video]) [Document 301137.1]
• Performance Tuning Using Advisors and Manageability Features: AWR, ASH, ADDM and Sql Tuning Advisor [Document 276103.1]
• Automatic Workload Repository (AWR) Reports - Start Point [Document 1363422.1]
• FAQ- Statspack Complete Reference [Document 94224.1]
• Comprehensive Database Real Application Testing Diagnostic Information [Document 1287620.1]
• How To Collect 10046 Trace (SQL_TRACE) Diagnostics for Performance Issues [Document 376442.1]
• SQL_TRACE (10046), TKProf and Explain Plan - Overview Reference [Document 199081.1]

Troubleshooting Assistants

• Troubleshooting Performance Issues [Document 1543445.2]
• Diagnosing the Cause of a Slow Query [Document 1542608.2]
• SQL Performance Issues [Document 1542678.2]
• Get Assistance to understand and solve Oracle SQL issues [Document 1564632.2]
• Oracle Database ORA-00060 Errors on Single Instance (Non-RAC) Diagnosing Using Deadlock Graphs in ORA-00060 Trace Files [Document 1550091.2]
• Get Assistance to Understand and Solve Oracle Resource Manager [Document 1606825.2]

Premium Knowledge Content Notes

• Information Center: Database Performance Overview [Document 1512292.2]
• Information Center: SQL Query Performance Overview [Document 1516494.2]
• Information Center: Real Application Testing [Document 1545782.2]

MOS Communities

• Database Tuning Community
• SQL Performance Community

How-To / FAQ / Troubleshooting

• Troubleshooting Performance Issues [Document 1377446.1]
• How To Investigate Slow or Hanging Database Performance Issues [Document 1362329.1]
• Troubleshooting Query Performance Degradation - Recommended Actions [Document 742112.1]
• Troubleshooting Upgrade Related Query Performance Degradation - Recommended Actions [Document 745216.1]
• Troubleshooting a Server Upgrade Resulting in Slow Query Performance [Document 160089.1]

Troubleshooting Webcasts

The following Performance Troubleshooting Webcasts are available:

Troubleshooting DB Performance Issues with AWR	Recording	.pdf
Recovery Manager - Performance Troubleshooting	Recording	.pdf / scripts

For other webcasts, refer to  Document:1456176.1 Database Advisor Webcasts: Current Schedule and Archived recordings

Oracle Database Resource Portfolio - Support Tools

Oracle Database Resource Portfolio - Support Tools

Support Tools 

Diagnosability Framework

Since DB 11g, trace files relevant to a critical database incidents are stored in the Automatic Diagnostic Repository (ADR). Using ADRCI (ADR Command Interpreter) or the Support Workbench, customers can package the files specific to the incident via the Incident Packaging Service (IPS) . All they need is run a command to package the incident corresponding diagnostics and upload the package through My Oracle Support (MOS) to the SR. The package will include the alert log and all the relevant trace files related to the incident.

With DB 12c, improvements focus is on  first failure diagnostics for database components, not just critical issues. Notes covering changes in the major product areas will be incorporated in notes to be listed here.

• TFA RAC and DB Support Tools Bundle [Document 1594347.1]
• Benefits of TFA RAC and DB Support Tools Bundle (Video) [Document 2147819.1]
• 11g Understanding Automatic Diagnostic Repository [Document 422893.1]
• Master Note for 11g Diagnosability - ADR and Packaging [Document 1283137.1]
• ADR and Packaging [Document 1283137.1]
• 11g Quick Steps to Package and Send Critical Error Diagnostic Information to Support [Document 443529.1]
• 11g Quick Steps - How to create an IPS package using Support Workbench [Document 1091653.1]
• Demo showing usage of various diagnostic tools, inc. Support Workbench and ADRCI

Troubleshooting Tools

Troubleshooting tools provide recommendations to resolve common issues by analyzing uploaded files. When a known solution is available, the tool will display the symptoms and causes which can lead to the issue and one or more suggestions for resolving the issue.

Benefits of using the Troubleshooting Tools:

• Analyzes uploaded files to provide recommendations when a known solution is available
• Troubleshooting report can be saved for later use
• Diagnostic Guide is available
• Create SR option available which will automatically populate many of the SR fields

• ORA-600 Troubleshooting Tool Overview / Tool
• ORA-7445 Troubleshooting Tool Overview / Tool
• ORA-3137 Troubleshooting Tool Overview/ Tool
• ORA-4030 Troubleshooting Tool Overview / Tool
• ORA-4031 Troubleshooting Tool Overview / Tool
• ORA-2730x Troubleshooting Tool Overview / Tool
• RAC Node Eviction Troubleshooting Tool Overview / Tool 
• ORA-1578 Troubleshooting Tool Overview / Tool 

Troubleshooting Assistants

"Assistants" are created by Oracle Support helping you to find KM documents that will meet specified symptoms.
Instead of typing the symptoms into our Knowledge Search engine, the Assistant presents a list of symptoms to choose from for a certain topic. Once the symptom is selected, the Assistant then engages in a dialogue and presents further options to the user to select from in order to clarify the issue and/or errors.

• Oracle Database - Client / Install / Deinstall / Cloning [Document 1555012.2 ]
• Get Assistance to Understand and Solve Oracle DBCA Issues [Document 1615456.2]
• Oracle Database/Client Upgrade - Downgrade [Document 1561791.2]
• Patching Oracle Database/Client [Document 1561792.2]

• Understand and Troubleshoot Startup/Shutdown Issues [Document 1591095.2]

• Oracle Grid Infrastructure Upgrade [Document 1553630.2]
• Oracle Grid Infrastructure Install [Document 1551639.2]
• Oracle Grid Infrastructure Patching [Document 1553605.2]

• Get Assistance to understand and solve Oracle Database Server Corruptions [Document 1543698.2]
• Handling Block Corruptions in oracle7 / 8 / 8i / 9i / 10g / 11g [Document 1598103.2]

• Resolve Issues with Oracle Undo Management (ORA-01555, ORA-30036, ORA-01628, ORA-01552, etc.) [Document 1575667.2]

• ORA-00600 [729] (Interactive Guide to resolving your error)  [Document 1560220.2]
• Oracle Database Error ORA-600 [kdsgrp1] (Interactive Guide to Resolving Your Error) [Document 1569722.2]
• Oracle Database Error ORA-600 [17285] (Interactive Guide to Resolving Your Error) [Document 1612876.2]

• Get Assistance to Understand and Solve Oracle Resource Manager [Document 1606825.2]

• Oracle Database ORA-00060 Errors on Single Instance (Non-RAC) Diagnosing Using Deadlock Graphs in ORA-00060 Trace Files(Document 1550091.2)

• Database Storage [Document 1552419.2]

• Get Assistance to Understand and Troubleshoot Oracle DBMS_SCHEDULER [Document 1585228.2]

• Database Object Partitioning  [Document 1580800.2]

• Troubleshooting Performance Issues [Document 1543445.2]
• Diagnosing the Cause of a Slow Query [Document 1542608.2]
• SQL Performance Issues [Document 1542678.2]
• Get Assistance to understand and solve Oracle SQL issues [Document 1564632.2]

• Oracle Multimedia and interMedia Installation and Upgrade [Document 1614436.2]

• NLS - Custom Character set, Locale Builder, Incorrect Numbers, 'Value Too Large' Errors While Inserting Data etc [Document 1628888.2]
• Database Character set Conversion [Document 1900564.2]
• CSSCAN (Characterset Scanner)[Document 1900629.2]
• DMU (Database Migration Assistant for Unicode) Tool [Document 1900712.2]

Data Collection Tools

Data Collection tools provide an easy user interface for capturing data and helping with issue diagnosis.  

• RAC and DB Support Tools Bundle [Document 1594347.1]
• Remote Diagnostic Agent [Document 414966.1]
• Diagnostic Assistant [Document 201804.1]
• Trace File Analyzer Collector (TFA) [Document 1513912.1]
• CRS Diagnostic Data Gathering: A Summary of Common tools and their Usage [Document 783456.1]
• SQLT (SQLTXPLAIN) - Tool that helps to diagnose a SQL statement performing poorly or one that produces wrong results [Document 215187.1]

 Monitoring Tools

Monitoring Tools assist with capturing and observing performance metrics for your environment including database, operating system etc.

• RAC and DB Support Tools Bundle [Document 1594347.1]
• OS Watcher Black Box [Document 301137.1]
• Cluster Health Monitor (CHM) FAQ [Document 1328466.1]
• ORATop oratop - utility for near real-time monitoring of databases, RAC and Single Instance [Document 1500864.1]
• Procwatcher: Script to Monitor and Examine Oracle DB and Clusterware Processes [Document 459694.1]
• Lite Onboard Transaction Monitor (LTOM) [Document 352363.1]

 Health Checks / Verification

 Health Checks and Verification tools can alert you about a potential issue before the issue actually occurs.

• RAC and DB Support Tools Bundle [Document 1594347.1]
• My Oracle Support Health Check Catalog [Document 868955.1]
• ORAchk - Oracle Configuration Audit Tool [Document 1268927.1]
• High Availability Check (HA_Check) included in RACCHECK [Document 1505808.1]
• SQL Tuning Health Check (SQLHC) [Document 1366133.1]
• Procwatcher: Script to Monitor and Examine Oracle and CRS Processes [Document 459694.1]
• Cluster Verification Utility (CLUVFY) FAQ [Document 316817.1]