My Oracle Support Banner

Data Collection for Troubleshooting Oracle Clusterware (CRS or GI) And Real Application Cluster (RAC) Issues (Doc ID 289690.1)

Last updated on JANUARY 08, 2024

Applies to:

Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Information in this document applies to any platform.

Purpose

This note will be obsolete in the future, it's strongly recommended to use TFA to prune and collect files from all nodes:

Reference: note 1513912.1  TFA Collector - Tool for Enhanced Diagnostic Gathering

TFA Collector is installed in the GI HOME and comes with 11.2.0.4 GI and higher.  For GI 11.2.0.3 or lower, install the TFA Collector by referring to <note 1513912.1> for instruction on downloading and installing TFA collector.

 

 

This note lists what to collect for different type of Oracle Clusterware and Real Application Cluster issues, it's not mandatory to upload all the files to open a SR, however, it will speed up the resolution if all relevant info are uploaded.

File Formats for Data Uploaded to Oracle Support


Oracle Support requests that you upload compressed files grouped together by node and labeled as such in a standard format, such as .tar, .gz, .Z or .zip.

Older runs of diagcollection or any other files  (i.e. if diagcollection was run a few days or weeks back) may not provide current log information which can delay the resolution.

Troubleshooting Steps

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
Purpose
 File Formats for Data Uploaded to Oracle Support
Troubleshooting Steps
 1. Data Gathering for All Oracle Clusterware Issues
 2. Data Gathering for Node Reboot/Eviction
 3. Data Gathering for All Real Application Cluster Issues
 4. Data Gathering for Real Application Cluster Performance/Hang Issues
 5. Data Gathering for Oracle Clusterware Installation Issues
 5.1. Failure before executing root script:
 5.2. Failure while or after executing root script
 Appendix A. RDA
 Appendix B. OS logs
 Appendix C. systemstate and hanganalyze in RAC
References

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