Catalog: Oracle Toolbox: Diagnostic and Analyzer Scripts - Data Collectors - Health Checks - Tools -

• Proactive Information for All Products [Document 432.1]
• User Guides Home Page
• My Oracle Support Communities (MOSC) Home Page
• Advisor Webcasts for All Products [Document 740966.1]

Oracle Database Products (DB)

• SRDC - Collecting Diagnostics for Database / Grid Infrastructure Patch Deployment using the Enterprise Manager Patch Plan Method [Updated: 01/10/2018]
• SRDC - Required diagnostic data collection for RMAN Active Duplicate [Updated: 01/10/2018]
• SRDC - Required Diagnostic Data Collection for ORA-01578 [Updated: 01/03/2018]
• SRDC - Data Collection for Install Issues [Updated: 01/03/2018]
• SRDC - SCN Issues: Checklist of Evidence to Supply [Updated: 01/02/2018]
• SRDC - Required diagnostic data collection for RMAN-08137 or RMAN-08120 [Updated: 12/22/2017]
• SRDC - Database Upgrade Hung [Updated: 12/21/2017]
• SRDC - Diagnostic Collection for DataPump Import (IMPDP) Performance Issues [Updated: 12/20/2017]
• SRDC - Diagnostic Collection for DataPump Export Performance Issues [Updated: 12/20/2017]
• Script OLAPHCDR.SQL: OLAP Health-Checks and Diagnostics Reports [Updated: 12/19/2017]
• SRDC - How to Collect Standard Information for Oracle Database SSL Issues [Updated: 12/19/2017]
• SRDC - How to Collect Standard Information for Oracle Key Vault Server [Updated: 12/18/2017]
• SRDC - How to Collect Standard Information for ORA - 1031 /ORA -1017 during SYSDBA connections [Updated: 12/18/2017]
• TFA Collector - TFA with Database Support Tools Bundle [Updated: 12/15/2017]
• SRDC - Required diagnostic data collection for RMAN-00600 error [Updated: 12/13/2017]
• SRDC - Startup Shutdown Issues: Checklist of Evidence to Supply [Updated: 12/13/2017]
• RDA - Health Check / Validation Engine Guide [Updated: 12/12/2017]
• Remote Diagnostic Agent (RDA) - Getting Started [Updated: 12/12/2017]
• OSWatcher Analyzer User Guide [Updated: 12/11/2017]
• SRDC - EEST Solaris Exadata Node Reboot or Crash [Updated: 12/06/2017]
• SRDC EEST ODA for OAKCLI Command Line failures [Updated: 12/02/2017]
• Advanced OS Commands To Assist In Diagnosing Database Performance Problems [Updated: 11/30/2017]
• SRDC - How to Collect Diagnostics Information for ASM/ACFS Issues (including TFA) [Updated: 11/30/2017]
• SRDC - Data Collection for ORA-12545 / ORA-12535 / ORA-12170 / ORA-12537 [Updated: 11/28/2017]
• SRDC - Data Collection for Remote Connection Slow, Hanging or Timed Out [Updated: 11/28/2017]
• SRDC - Data Collection for ODP.NET : Connection Issues, ORA-12570 [Updated: 11/24/2017]
• SRDC - Data Collection for OLEDB : Common Errors [Updated: 11/23/2017]
• SRDC - EEST Exachk [Updated: 11/23/2017]
• SRDC EEST ODA Node Crash or Eviction Diagnostic Collection [Updated: 11/22/2017]
• SRDC - How to Collect Standard Information for Transparent Data Encryption (TDE) [Updated: 11/22/2017]
• SRDC - Service Request Data Collection for Grid Infrastructure and RAC Install Upgrade Patch [Updated: 11/21/2017]
• SRDC - RAC Database / Instance Administration, Management, and Maintenance [Updated: 11/21/2017]
• SRDC - Grid Infrastructure / Clusterware Administration and Management for Windows 10gR2 and 11gR1 [Updated: 11/21/2017]
• SRDC - Grid Infrastructure / Clusterware Administration and Management [Updated: 11/21/2017]
• SRDC - Grid Infrastructure / Clusterware Administration and Management for Windows [Updated: 11/21/2017]
• SRDC - How to Collect Diagnostics Information for ASM Hanging Issues [Updated: 11/21/2017]
• Script to Collect Data Guard Physical and Active Standby Diagnostic Information for Version 10g and above (Including RAC) [Updated: 11/19/2017]
• Script to Collect Data Guard Primary Site Diagnostic Information for Version 10g and Above (Including RAC). [Updated: 11/19/2017]
• Script to Collect Data Guard Logical Standby Diagnostic Information for Version 10g and Above (Including RAC) [Updated: 11/19/2017]
• SRDC - RAC Database / Instance Administration, Management, and Maintenance [Updated: 11/14/2017]
• SRDC - How to Collect Diagnostics Information for ASM Space & ORA-15041 Issues [Updated: 11/09/2017]
• SRDC - How to Collect Diagnostics Information for ASM Performance Issues [Updated: 11/09/2017]
• SRDC - Collecting the Required Information for Support to Validate & Troubleshooting ASM Diskgroup Corruptions [Updated: 11/09/2017]
• SRDC - How to Collect Diagnostics Information for ASM/ACFS Upgrade Issues [Updated: 11/09/2017]
• SRDC - Diagnostic Collection for LogMiner Performance Issues [Updated: 11/09/2017]
• SRDC - How to Collect Diagnostics Information for ASM Issues (including TFA) [Updated: 11/08/2017]
• SRDC - Required diagnostic data collection for RMAN backup [Updated: 11/01/2017]
• SRDC- Database Upgrade General [Updated: 11/01/2017]
• SRDC - Required diagnostic data collection for RMAN Restore and Recover [Updated: 10/18/2017]
• SRDC - DB on Unix- Too Many Open Files: Checklist of Evidence to Supply [Updated: 10/16/2017]
• SRDC - DB on Unix- Resources : Checklist of Evidence to Supply [Updated: 10/16/2017]
• SRDC - DB on Unix- I/O Issues : Checklist of Evidence to Supply [Updated: 10/16/2017]
• SRDC - DB on Unix- Huges Pages and Kernel Setting : Checklist of Evidence to Supply [Updated: 10/16/2017]
• SRDC - DB on Unix- Configuration : Checklist of Evidence to Supply [Updated: 10/16/2017]
• SRDC - DB on Unix - NUMA : Checklist of Evidence to Supply [Updated: 10/16/2017]
• SRDC - Diagnostic Collection for ORA-8180 and ORA-8181 WITH FLASHBACK ARCHIVE ENABLED TABLES [Updated: 10/13/2017]
• SRDC - FBDA Diagnostic Collection to Troubleshoot Flashback Data Archive Issues [Updated: 10/13/2017]
• SRDC - Required diagnostic data collection for RMAN Performance [Updated: 10/13/2017]
• SRDC - Required diagnostic data collection for RMAN maintenance [Updated: 10/13/2017]
• SRDC - Required diagnostic data collection for RMAN cross platform/version [Updated: 10/13/2017]
• SRDC - Required diagnostic data collection for RMAN duplicate [Updated: 10/13/2017]
• SRDC EEST ODA Simplified Database Performance Data Collection [Updated: 10/11/2017]
• All About the SQLT Diagnostic Tool [Updated: 10/06/2017]
• SRDC EEST ODA Basic Database Performance Data Collection [Updated: 10/05/2017]
• SRDC - ORA-4031: Checklist of Evidence to Supply [Updated: 10/02/2017]
• SRDC - Exadata: Storage Software Service Or Offload Server Service Failures [Updated: 09/29/2017]
• SRDC - Exadata: Smart Scan Wrong Result Issues [Updated: 09/26/2017]
• SRDC - Collect Data Guard Primary Database Transport Services Information [Updated: 09/26/2017]
• SRDC - Exadata: Smart Scan Not Working Issues [Updated: 09/22/2017]
• SRDC EEST ODA REPO and VM Guest Issue Basic Collection [Updated: 09/22/2017]
• SRDC EEST ODA Mandatory SR Information: HW Type, Product Version and Platform [Updated: 09/22/2017]
• SRDC - Data Collection for XDB Installation and Invalid Object for Issues 11g and Greater [Updated: 09/21/2017]
• ORA-4031 Troubleshooting Tool [Updated: 09/20/2017]
• ORA-4030 Troubleshooting Tool [Updated: 09/20/2017]
• ORA-7445 Troubleshooting Tool [Updated: 09/20/2017]
• ORA-600 Troubleshooting Tool [Updated: 09/20/2017]
• SRDC EEST ODA Generic Diagnostic Collection for Disk and Storage Issues [Updated: 09/13/2017]
• SRDC - Exadata: RAC/Clusterware Related Issues [Updated: 09/07/2017]
• SRDC - ORA-4030: Checklist of Evidence to Supply for Version 11g and Greater [Updated: 09/05/2017]
• SRDC - Required Diagnostic Data Collection for ORA-08103 [Updated: 09/01/2017]
• SRDC - Exadata: Storage Cell Related Performance Issues [Updated: 08/31/2017]
• SRDC - ORA-4031 on Shared Pool: Checklist of Evidence to Supply for Version 11g and Greater [Updated: 08/31/2017]
• SRDC - Data Collection for Protocols (HTTP, FTP, WebDAV) or Repository Issues [Updated: 08/30/2017]
• SRDC - Data Collection for Oracle Precompilers [Updated: 08/30/2017]
• SRDC - Data Collection for ODP.NET : Common Errors [Updated: 08/30/2017]
• SRDC - Data Collection for Database JVM [Updated: 08/30/2017]
• SRDC - Data Collection for PLSQL:Troubleshoot ORA-4068/ORA-4065/ORA-6508 [Updated: 08/30/2017]
• SRDC - Data Collection for PLSQL:Troubleshoot UTL_SMTP/UTL_MAIL [Updated: 08/30/2017]
• Script to capture and restore file permission in a directory (for eg. ORACLE_HOME) [Updated: 08/29/2017]
• SRDC - Collecting Diagnostic Data for Enterprise Manager Patch Plan Creation Issues [Updated: 08/25/2017]
• SRDC - Data Collection for Oracle Multitenant Issues [Updated: 08/24/2017]
• SRDC - ORA-4031: Checklist of Evidence to Supply for Version 11g and Greater [Updated: 08/23/2017]
• SRDC - Exadata: Cell/DB Node Patching And Upgrade Issues [Updated: 08/18/2017]
• SRDC - Exadata: Database/Instance/Process Hang or Spin Issues [Updated: 08/18/2017]
• SRDC - Providing Supporting Information for PL/SQL Runtime Issues [Updated: 08/17/2017]
• SRDC - Providing Supporting Information for PL/SQL Compilation Related Issues [Updated: 08/17/2017]
• SRDC - Providing Supporting Information for UTL_SMTP, UTL_MAIL, UTL_HTTP and ACL Related Issues [Updated: 08/16/2017]
• Oracle Auto Service Request (ASR) [Updated: 08/16/2017]
• SRDC - Providing Supporting Information for External Procedure Related Issues [Updated: 08/15/2017]
• SRDC - Data Collection for the RAC Database/Instance Miscellaneous Issues [Updated: 08/11/2017]
• SRDC - ORA-600 / ORA-700 / ORA-7445: Checklist of Evidence to Supply for Version 11g and Greater [Updated: 08/10/2017]
• SRDC - Grid Infrastructure / Clusterware Administration and Management for Unix [Updated: 08/03/2017]
• SRDC - Providing a Testcase for PL/SQL Issues [Updated: 07/26/2017]
• SRDC - Data Collection for Operating System Dependent Interface (OSDI) on IBM z/OS [Updated: 07/25/2017]
• SRDC - Linux on z: Platform Issues - Install Issues [Updated: 07/25/2017]
• SRDC - Required Diagnostic Data Collection For MySQL Replication Lag [Updated: 07/25/2017]
• SRDC - Required Diagnostic Data Collection For MySQL Slow Queries [Updated: 07/25/2017]
• SRDC - Required Diagnostic Data Collection For High Load in MySQL [Updated: 07/25/2017]
• SRDC - Required Diagnostic Data Collection For MySQL Intermittent Stalls [Updated: 07/25/2017]
• SRDC - Required Diagnostic Data Collection for MySQL Replication Errors [Updated: 07/25/2017]
• SRDC - Required Diagnostic Data Collection For Errors in Running MySQL Cluster Manager (MCM) Commands [Updated: 07/25/2017]
• SRDC - Required Diagnostic Data Collection for MySQL Cluster Crashes [Updated: 07/25/2017]
• SRDC - How to Collect Standard Information for Access Control Lists (ACLs) [Updated: 07/25/2017]
• SRDC - How to Collect Standard Information for a Database Hang [Updated: 07/17/2017]
• SRDC - How to Collect Diagnostics Information for ASM/ACFS Installation Issues [Updated: 07/14/2017]
• SRDC - How to Collect The Required Information For Support To Troubleshoot DBFS Issues (11.1, 11.2 & 12c). [Updated: 07/14/2017]
• SRDC - How to Collect Diagnostics Information for ASM/ACFS Generic Issues [Updated: 07/14/2017]
• SRDC - Zero Data Loss Recovery Appliance (ZDLRA) Data Collection [Updated: 07/12/2017]
• Troubleshooting Session Administration [Updated: 07/06/2017]
• SRDC - How to Collect The Required Information To Troubleshoot DBFS Issues (including TFA) [Updated: 06/26/2017]
• SRDC - Data Collection for Grid Infrastructure, Storage Management, and RAC [Updated: 06/12/2017]
• SRDC - Data Collection for Errors While Using "My Oracle Support Patch Conflict Checker Tool" [Updated: 06/12/2017]
• SRDC - Data Collection for ORA-3113/Hanging/Slow Query over DB Link Accessed from Remote Client [Updated: 05/30/2017]
• Diagnostic Methodology To Troubleshoot Performance Problems in Active Dataguard (read only standby database) Environment [Updated: 05/23/2017]
• SRDC - Providing Supporting Information for Oracle Precompiler, OCI and OCCI Runtime Issues [Updated: 05/22/2017]
• SRDC - High Undo Space Usage: Checklist of Evidence to Supply [Updated: 05/18/2017]
• SRDC - Data Collection for Generic Database Link Errors [Updated: 05/15/2017]
• SRDC - How to Collect Information for Troubleshooting an Oracle Streams Propagation Performance Issue [Updated: 05/07/2017]
• SRDC - How to Collect Information for Troubleshooting an Oracle Streams Capture Performance Issue [Updated: 05/07/2017]
• SRDC - How to Collect Information for Troubleshooting Queue Monitor (QMON) Issues [Updated: 05/07/2017]
• SRDC - How to Collect Information for Troubleshooting Streams/RMAN Related Problems [Updated: 05/07/2017]
• SRDC - How to Collect Information for Troubleshooting a Streams Capture in State 'WAITING FOR REDO' or INITIALIZING [Updated: 05/07/2017]
• SRDC - How to Collect Information for Troubleshooting an Oracle Streams Apply Performance Problem [Updated: 05/07/2017]
• SRDC - How to Collect Information for Troubleshooting an ORA-26687 Error [Updated: 05/07/2017]
• SRDC - How to Collect Information for Troubleshooting a Capture Process Stuck on Paused for Flow Control [Updated: 05/07/2017]
• SRDC - How to Collect Information for Troubleshooting Long-Running Transactions in Oracle Streams [Updated: 05/07/2017]
• SRDC - How to Collect Information for Troubleshooting a Conflict Resolution Problem [Updated: 05/07/2017]
• SRCD - How to Collect Information for Troubleshooting REQUIRED_CHECKPOINT_SCN not Moving Forward [Updated: 05/07/2017]
• SRDC - How to Collect Information for Troubleshooting Hang/Spin Issues in a Streams environment [Updated: 05/07/2017]
• SRDC - How to Collect Information for Troubleshooting an ORA-600/ORA-7445 Error in a Streams Environment [Updated: 05/07/2017]
• SRDC - How to Collect Information for Troubleshooting a Streams Problem [Updated: 05/07/2017]
• SRDC - Data Collection for ORA-3113/Hanging/Slow Query over DB Link Accessed Locally [Updated: 05/02/2017]
• SRDC - Data Collection for Parallel Execution Performance Issues [Updated: 04/26/2017]
• SRDC - How to Collect Information for Troubleshooting Messaging Gateway Issues [Updated: 04/20/2017]
• SRDC - How to Collect Information for Troubleshooting Event Monitor (EMON) Issues [Updated: 04/20/2017]
• SRDC - How to Collect Information for Troubleshooting Notification in an Advanced Queuing Environment [Updated: 04/20/2017]
• My Oracle Support Patch Conflict Checker Tool [Updated: 04/19/2017]
• SRDC - How To Collect Information For Troubleshooting Performance In An Oracle Advanced Queuing Environment [Updated: 04/18/2017]
• SRDC - How To Collect Information For Troubleshooting Enqueue/Dequeue Problems In An Oracle Advanced Queuing Environment [Updated: 04/18/2017]
• SRDC - How To Collect Information For Troubleshooting Problem In An Oracle Advanced Queuing Environment [Updated: 04/18/2017]
• SRDC - How to Collect Information for Troubleshooting Memory Leak in an Advanced Queuing Environment [Updated: 04/18/2017]
• SRDC - How to Collect Information for Troubleshooting an ORA-01405 Error in an Advanced Queuing Environment [Updated: 04/18/2017]
• SRDC - Data Collection for PLSQL:Troubleshoot UTL_HTTP [Updated: 04/13/2017]
• SRDC - How to Collect Standard Information for a Database Replay Problem [Updated: 04/12/2017]
• SRDC - How to Collect Standard Information for a Database Capture Problem [Updated: 04/12/2017]
• SRDC - Data Collection for Datapatch issues [Updated: 04/10/2017]
• SRDC - How to Collect Standard Information for a Wrong Results Problem [Updated: 04/05/2017]
• SRDC - Data Collection for the RAC Database/Instance Performance (not Hang) Issues (TFA) [Updated: 04/03/2017]
• SRDC - How to Collect Diagnostics Information for ASM Hanging Issues (including TFA) [Updated: 04/03/2017]
• SRDC - EEST ODA Node Reboot or Crash [Updated: 03/23/2017]
• SRDC - Job Configuration and Execution : Checklist of Evidence to Supply [Updated: 03/20/2017]
• SRDC - Data Collection for Generic Client Connectivity [Updated: 03/15/2017]
• SRDC - Required Diagnostic Data Collection for Alert Log Message "Corrupt block relative dba" [Updated: 02/28/2017]
• SRDC - Required Diagnostic Data Collection for ORA-00227 [Updated: 02/28/2017]
• SRDC - OPatch fails with "Can't Find Path For Shared Library: Libfl.sl " [Updated: 02/21/2017]
• SRDC - OPatch MOS Automation [Updated: 02/21/2017]
• SRDC - Data Collection for ORA-12541 TNS: No Listener [Updated: 01/25/2017]
• SRDC - Upgrade INVALID_DATA [Updated: 01/23/2017]
• SRDC - Upgrade TIMEZONE [Updated: 01/23/2017]
• SRDC - Database Upgrade for Manual Upgrade [Updated: 01/22/2017]
• SRDC - Upgrade LABEL_SECURITY_OPTION_OFF [Updated: 01/22/2017]
• SRDC - Upgrade Data Vault [Updated: 01/22/2017]
• SRDC - Database Upgrade fails if LABEL_SECURITY_OPTION is ON [Updated: 01/22/2017]
• SRDC- Data To Collect for Issues During the Removal of the Oracle OLAP Option [Updated: 01/17/2017]
• SRDC - Data To Collect for Issues During the Addition of Oracle OLAP to an Existing Instance [Updated: 01/17/2017]
• SRDC - Data To Collect for Errors Related to OLAP [Updated: 01/17/2017]
• SRDC - Data collection for Oracle Database In-Memory (DBIM) Column Store Issues [Updated: 01/10/2017]
• SRDC - EEST Enterprise Manager Issues for ODA Targets [Updated: 12/22/2016]
• SRDC - DBMS_JOB : Checklist of Evidence to Supply [Updated: 12/19/2016]
• SRDC - Autotasks and Related Issues : Checklist of Evidence to Supply [Updated: 12/19/2016]
• SRDC - Automated Maintenance Jobs, Configuration and Related Issues : Checklist of Evidence to Supply [Updated: 12/19/2016]
• SRDC - Stuck Jobs and CJQ Related Issues : Checklist of Evidence to Supply [Updated: 12/19/2016]
• SRDC - External Jobs and Related issues: Checklist of Evidence to Supply [Updated: 12/19/2016]
• SRDC - Job Configuration : Checklist of Evidence to Supply [Updated: 12/19/2016]
• SRDC - Email Notification in DBMS_SCHEDULER : Checklist of Evidence to Supply [Updated: 12/19/2016]
• SRDC - Job Execution and Related Errors: Checklist of Evidence to Supply [Updated: 12/19/2016]
• SRDC - Other Internal Error: Checklist of Evidence to Supply for Version 11g and Greater [Updated: 12/16/2016]
• SRDC - Data Collection for Oracle OCI [Updated: 12/13/2016]
• SRDC - How to Collect Standard Information for a Database Performance Problem for 11g or Greater on Unix/Linux (with Diagnostic Pack License) [Updated: 12/12/2016]
• SRDC - Diagnostic Collection for Traditional Import Issues [Updated: 12/07/2016]
• SRDC - Data Collection for Parallel Execution Wrong Result Issues [Updated: 12/07/2016]
• SRDC - Data Collection for Parallel Execution Errors and Set-up Issues [Updated: 12/07/2016]
• SRDC - Providing Supporting Information for Oracle Precompiler, OCI and OCCI Build-time Issues [Updated: 12/06/2016]
• SRDC - Providing a Testcase for Oracle Precompiler, OCI and OCCI Issues [Updated: 12/06/2016]
• SRDC - Data Collection for MSLANG: Hang/Crash/Memory Leak [Updated: 11/29/2016]
• SRDC - Providing Supporting Information for Oracle JVM Issues [Updated: 11/03/2016]
• SRDC - Providing a Testcase for Oracle JVM Issues [Updated: 11/03/2016]
• SRDC - DMU: Scanning or Conversion Phase - Checklist of Evidence to Supply [Updated: 11/02/2016]
• SRDC - DMU: Checklist of Evidence to Supply [Updated: 11/02/2016]
• SRDC - Data to Supply for ORA- Errors When Creating or Refreshing a Read Only Materialized View [Updated: 10/20/2016]