Primary Note for Diagnosability - ADR and Packaging
(Doc ID 1283137.1)
Last updated on MAY 17, 2021
Applies to:Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 188.8.131.52 and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
This is the primary note intended to provide an index and reference to the most frequently used My Oracle Support Notes related to 11g diagnosability - ADR and Packaging.
Understanding Diagnosability from 11g Onwards
Diagnosabilitly is a new feature introduced in 11g to help diagnose the critical errors more efficiently. The Diagnosability feature simplifies collecting the diagnostic information and sending this information to Oracle Global Software Support. In 11g, RDBMS diagnostic data has been reorganized and is stored inside a common directory structure, the Automatic Diagnostic Repository (ADR). An ADR is a centralized directory structure where one can find trace files, alert messages, incident dumps, core files, etc. Refer to the below article that explains the ADR:
Document 422893.1 - Understanding Automatic Diagnostic Repository.
Document 453125.1 - 11g Diagnosability: Frequently Asked Questions
Finding diagnostic information from 11g Onwards
11g introduces a new initialization parameter called DIAGNOSTIC_DEST. All the diagnostic information is in the location specified for DIAGNOSTIC_DEST parameter. Refer to the below articles explaining where to find different diagnostic information:
Document 438148.1 - Finding alert.log file in 11g
Document 443536.1 - 11g How To Find Out Trace Files Relevant To A Critical Error.
A critical error reported in the database is termed as Problem. And each occurrence of the Problem is Incident. 11g Diagnosability provides tools and methods to automatically identify, collect and package the relevant diagnostic information for a problem in a simple way. This feature is called Incident Packaging Service (IPS). Below articles discuss the steps to use IPS and create a diagnostic package:
Document 411.1 - ADR Different Methods to Create IPS Package
Document 443529.1 - 11g Quick Steps to Package and Send Critical Error Diagnostic Information to Support [Video]
Document 1091653.1 - "11g Quick Steps - How to create an IPS package using Support Workbench" [Video]
Document 745960.1 - 11g How to Unpack a Package in to ADR
Document 797160.1 - Packaging Internals - IPS Finalize Package
Customize IPS package
Once you create a IPS package, you can add more files or remove files from the package before generating it. Refer to the article below:
Document 1456034.1- How to add more files to IPS package?
Running Health checks and viewing the reports are now part of Diagnosability feature in 11g:
Document 466920.1 - 11g New Feature: Health monitor
ADR Purging and Retention
Trace files, incident dumps and other diagnostic information in ADR have retention policy after which they are automatically purged. Refer to the below articles to learn more about ADR retention policies and purging:
Document 564269.1- Retention Policy for ADR
Document 975448.1 - Which Files Are Part Of SHORTP_POLICY And LONGP_POLICY In ADR?
Document 751082.1 - Adrci Purge Does Not Clear the Text-formatted Alert.Log located in the Trace Folder
Document 951022.1 -How To Purge or Delete Health Monitor Checks After DBMS_HM.RUN_CHECK ?
Additional Diagnosability related articles
Where to get more information
Advisor Webcasts - Customer web events
Webcasts are a convenient way for you to interact with professional, technical, and application experts regarding topics to help you get the most from Oracle's Global Support Services. Our support experts will present information such as troubleshooting tips, best practices, new release information and more. Archived recordings of diagnosibility related Advisor Webcasts (lang: Eng, CN, KR) can be found in:
Document 1268733.1 - Database Manageability: Diagnosibility archived Webcasts
View a schedule for upcoming WebCasts or a list of archived recordings.
My Oracle Support (MOS) - Communities
My Oracle Support Community is a multi-channel interactive community for sharing information, posting questions and answers, and providing suggestions about Oracle products, services, and related technologies. My Oracle Support Community replaces the MetaLink Forums previously accessible from the Forums tab. The name of the Diagnosibility community is Oracle Database - DB Diagnostic Repository (ADR) & Packaging and can be found here.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|Understanding Diagnosability from 11g Onwards|
|Finding diagnostic information from 11g Onwards|
|Customize IPS package|
|ADR Purging and Retention|
|Additional Diagnosability related articles|
|Where to get more information|
|Advisor Webcasts - Customer web events|
|My Oracle Support (MOS) - Communities|