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