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.
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.
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]
- 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]
- 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]
- 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]
- 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 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]
0 comments :
Post a Comment
Note: Only a member of this blog may post a comment.