My Oracle Support Banner

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 11.1.0.6 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.

Details

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.

Actions

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.

IPS Packaging

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?

Health monitor

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

Document 750982.1 - TRM Trace Files Getting Generated in 11g Database
Document 1174105.1 - How to Run SQL Testcase Builder from ADRCI [Video]
Document 1199185.1 - ADR and symbolic links

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.

Contacts

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
Details
Actions
 Understanding Diagnosability from 11g Onwards
 Finding diagnostic information from 11g Onwards
 IPS Packaging
 Customize IPS package
 Health monitor
 ADR Purging and Retention
 Additional Diagnosability related articles
 Where to get more information
 Advisor Webcasts - Customer web events
 My Oracle Support (MOS) - Communities
Contacts
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.