1. User’s Guide
  2. Collecting Diagnostic Data and Triaging, Diagnosing, and Resolving Issues
  3. Using On-Demand Diagnostic Collections
  4. Oracle Trace File Analyzer Service Request Data Collections (SRDCs)

8.6 Oracle Trace File Analyzer Service Request Data Collections (SRDCs)

Oracle Trace File Analyzer Service Request Data Collections (SRDCs) enable you to quickly collect the right diagnostic data.

To perform Service Request Data Collections:

$ tfactl diagcollect -srdc srdc_name

Running the command trims and collects all important log files updated in the past n hours across the whole cluster. The default number of hours for log collection varies from SRDC to SRDC. You can change the diagcollect timeframe with the –last n h|d option.

Oracle Support often asks you to run a Service Request Data Collection (SRDC). The SRDC depends on the type of problem that you experienced. An SRDC is a series of many data gathering instructions aimed at diagnosing your problem. Collecting the SRDC manually can be difficult with many different steps required.

Oracle Trace File Analyzer can run SRDC collections with a single command:

$ tfactl diagcollect 
[-srdc srdc_profile] 
[–sr sr_number]
[-tag tagname] 
[-z filename] 
[-last nh|d | -from time -to time | -for date] 
[-database database]
Option Description

[-srdc srdc_profile]

Specify the SRDC profile.

-tag description

Use this parameter to create a subdirectory for the resulting collection in the Oracle Trace File Analyzer repository.

-z file_name

Use this parameter to specify an output file name.

[-last nh|d | -from time -to time | -for date]

  • Specify the -last parameter to collect files that have relevant data for the past specific number of hours (h) or days (d). By default, using the command with this parameter also trims files that are large and shows files only from the specified interval.

    You can also use -since, which has the same functionality as -last. This option is included for backward compatibility.

  • Specify the -from and -to parameters (you must use these two parameters together) to collect files that have relevant data during a specific time interval, and trim data before this time where files are large.

    Supported time formats:

    "Mon/dd/yyyy hh:mm:ss"

    "yyyy-mm-dd hh:mm:ss"

    "yyyy-mm-ddThh:mm:ss"

    "yyyy-mm-dd"

  • Specify the -for parameter to collect files that have relevant data for the date specified. The files tfactl collects will have timestamps in between which the time you specify after -for is included. No data trimming is done for this option.

    Supported time formats:

    "Mon/dd/yyyy"

    "yyyy-mm-dd"

Note:

If you specify both date and time, then you must enclose both the values in double quotation marks (""). If you specify only the date or the time, then you do not have to enclose the single value in quotation marks.

-database database

Specify the name of the database.

Note:

To upload collections to the SR as part of diag collection:

If you have already set MOS configuration using the tfactl setupmos command, then you can use the -sr option along with the diag collection command. Note that tfactl setupmos is supported only in versions earlier than 20.2.

If you have not set MOS configuration using the tfactl setupmos command, then set up MOS configuration using the new generic command, ahfctl setupload -name mos -type https and follow the instructions.

For example: tfactl diagcollect -srdc srdc_type –sr sr_number

To run SRDCs, use one of the Oracle privileged user accounts:

  • ORACLE_HOME owner

  • GRID_HOME owner

Table 8-3 One Command Service Request Data Collections

Available SRDCs Type of Problem Collection Scope Auto Collection

ahf

Oracle ORAchk and Oracle EXAchk problems (to be run after running with -debug)

Local only

No

crs

Collect crs traces

Cluster-wide

No

crsasm

ASM CRS-related problems

Cluster-wide

No

crsasmcell

ASM CRS CELL-related problems

Cluster-wide

No

dbacl

Problems with Access Control Lists (ACLs)

Local only

No

dbaqgen

Problems in an Oracle Advanced Queuing Environment

Local only

No

dbaqmon

Queue Monitor (QMON) problems

Local only

No

dbaqnotify

Notification problems in an Oracle Advanced Queuing Environment

Local only

No

dbaqperf

Performance problems in an Oracle Advanced Queuing Environment

Local only

No

dbaqpurge

Non-purged Messages in an Oracle Advanced Queuing Environment problems

Local only

No

dbasm

Oracle Database storage problems

Local only

No

dbaudit

Standard information for Oracle Database auditing

Local only

No

dbaum

AUM: Checklist of Evidence to Supply (Doc ID 1682741.1)

Local only

No

dbaumwaitevents

Wait Events related to Undo: Checklist of Evidence to Supply (Doc ID 1682723.1)

Local only

No

dbawrspace

Oracle Database Automatic Workload Repository (AWR) space problems

Local only

No

dbbeqconnection

Bequeath Connection Issues: Checklist of Evidence to Supply (Doc ID 1928047.1)

Local only

No

dbcorrupt

Generic Oracle Database corruption

Local only

No

dbdataguard

Data Guard problems including Broker

Local only

No

dbawrspace

Excessive SYSAUX space is used by the Automatic Workload Repository (AWR)

Local only

No

dbdatapatch

Datapatch problems

Local only

No

dbddlerrors

DDL Errors: Checklist of Evidence to Supply (Doc ID 2383662.1)

Local only

No

dbemon

Event Monitor (EMON) problems

Local only

No

dbenqdeq

Collect standard information for Advanced Queueing problems using TFA Collector (recommended) or manual steps

Local only

No

dbexp

dbexpdp

dbexpdpapi

dbexpdpperf

dbexpdptts

Original Oracle Database Export (exp)

Local only

No

dbfs

Oracle Automatic Storage Management (Oracle ASM) / Database File System (DBFS) / Direct NFS / Oracle Advanced Cluster File System (Oracle ACFS) problems

Local only

No

dbfra

Fast Recovery Area, also known as Flash Recovery Area problems

Local only

No

dbggclassicmode

dbggintegratedmode

Oracle GoldenGate

Local only

No

dbhang

Oracle Database hang problems

Local only

No

dbhangperflite

Oracle Database performance and hang problems

Local only

No

dbimp

dbimpdp

dbimpdpperf

Original Oracle Database Import (imp)

Local only

No

dbimpdpperf

Data Pump Import performance problems

Local only

No

dbinstall

dbupgrade

dbpreupgrade

Oracle Database install / upgrade problems

Local only

No

dbparameters

Oracle Database single instance shutdown problems

Local only

No

dbparameterfiles

Parameter Files: Checklist of Evidence to Supply (Doc ID 1914153.1)

Local only

No

dbpartition

Create or maintain partitioned table, subpartitioned table, and index problems

Local only

No

dbpartitionperf

Slow Create, Alter, or Drop commands against partitioned table or index

Local only

No

dbpatchinstall

dbpatchconflict

Oracle Database patching problems

Local only

No

dbperf

Oracle Database performance problems

Cluster-wide

No

dbperf_and_hang

Oracle Database performance and hang problems on FASaaS environments

Local only

No

dbplugincompliance

Enterprise Manager compliance related issues

Local only

No

dbpreupgrade

Oracle Database preupgrade problems

Local only

No

dbprocmgmt

Generic Process Management and Related Issues: Checklist of Evidence to Supply (Doc ID 2500734.1)

Local only

No

dbrac

Oracle RAC-related data collection for Oracle Clusterware and Oracle ASM problems

Local only

No

dbracinst

Oracle RAC-related data collection for Oracle Database problems

Local only

No

dbracperf

Oracle RAC-related performance problems

 Cluster-wide No

dbresmgr

Oracle Database problems related to Resource Manager

Local only

No

dbrman

dbrmanperf

Recovery Manager (RMAN) problems

Local only

No

dbscn

System change number

Local only

No

dbshutdown

dbstartup

Oracle Database startup or shutdown problems

Local only

No

dbslowddl

Slow DDL: Checklist of Evidence to Supply

Local only

No

dbspacewait

Space Related Wait Events and Performance Issues : Checklist of Evidence to Supply (Doc ID 2560286.1)

Local only

No

dbspatialexportimport

Oracle Spatial export or import problems

Local only

No

dbspatialinstall

Oracle Spatial installation problems

Local only

No

dbspatialperf

Oracle Spatial performance problems

Local only

No

dbspatialupgrade

Oracle Spatial upgrade problems

Local only

No

dbspatialusage

Oracle Spatial usage problems

Local only

No

dbsqlperf

SQL performance problems

Local only

No

dbstandalonedbca

Database Configuration Assistant problems

Local only

No

dbstoragestructuregeneric

Storage structure related diagnosis

Local only

No

dbtablespacegeneric

Generic Tablespace and Segment Management: Checklist of Evidence to Supply (Doc ID 2560291.1)

Local only

No

dbtde

Transparent Data Encryption (TDE) problems

Local only

No

dbtextindex

Oracle Text problems

Local only

No

dbtextissue

Oracle Text installation problems - 12c.

Local only

No

dbtextupgrade

dbtextinstall

Oracle Text version 12.1.0.1 and later upgrade problems

Local only

No

dbunixresources

Oracle Database resource problems

Local only

No

dbvault

Collect standard information for Database Vault

Local only

No

dbwindowsresources

Oracle Database on Microsoft Windows resources: Checklist of Evidence to Supply

Local only

No

dbwinservice

OracleService on Microsoft Windows: Checklist of Evidence to Supply (Doc ID 1918781.1)

Local only

No

dbxdb

XDB Installation or invalid object problems

Local only

No

dbxdbgeneric

XDB installation and invalid object problems

Local only

No

dbxdbupgrade

XDB installation and invalid object problems in 12c and above

Local only

No

dnfs

XDB Upgrade problems

Local only

No

emagentgeneric

Collect trace/log information for Enterprise Manager Management Agent generic problems

OMS and Agent

No

emagentpatching

Enterprise Manager failures during agent patching

OMS and Agent

No

emagentperf

Enterprise Manager 13c Agent performance problems

Agent

No

emagentssl

Enterprise Manager Agent SSL configuration issues

OMS and Agent

No

emagentstartup

Enterprise Manager 13c Agent startup problems

Agent

No

emagentunreach

Enterprise Manager 13c Agent unreachable errors or status

Agent

No

emagentupload

Enterprise Manager 13c Agent upload errors

Agent

No

emagtpatchdeploy

Enterprise Manager 13c Agent patch deployment problems

OMS and Agent

No

emagtupginst

Collecting diagnostic data for Enterprise Manager 13c Agent installation, upgrade, or deployment prodblems

Agent

No

emagtupgpatch

Enterprise Manager 13c Agent upgrade, local installation, or patching problems.

OMS and Agent

No

emauthldap

Enterprise Manager authentication using LDAP provider issues

OMS

No

emblackout

Enterprise Manager Blackout Issues

OMS and Agent

No

emcliadd

emclusdisc

emdbsys

emgendisc

emprocdisc

Enterprise Manager target discovery or add problems

OMS and Agent

Agent

OMS and Agent

OMS and Agent

OMS and Agent

No

emcomm

Enterprise Manager communication information between OMS and Agent

OMS and Agent

No

emdbaasdeploy

Database As A Service (DBaaS): Collect trace or log information for failures during DBaaS deployment.

OMS and remote DBaaS deployment server

No

emdebugon

emdebugoff

Enterprise Manager debug log collection

Run emdebugon, reproduce the problem then run emdebugoff, which disables debug again and collects debug logs

OMS or Agent

No

emfleetpatching

Enterprise Manager Fleet Maintenance Patching problems

OMS and Agent

No

emjobs

Enterprise Manager all job related issues

OMS

No

emmetricalert

Enterprise Manager general metrics page or threshold problems

Agent

No

emnotif

Enterprise Manager incident rules and notification issues

OMS

No

emomsfailstart

Enterprise Manager OMS startup failures

OMS

No

emomscrash

Enterprise Manager OMS Crash problems

OMS

No

emomsheap

Enterprise Manager Java heap usage or performance problems

OMS

No

emomshungcpu

Enterprise Manager OMS crash, restart or performance problems

OMS

No

emomspatching

Enterprise Manager failures during OMS patching

OMS

No

emomsssl

Enterprise Manager OMS SSL configuration issues

OMS

No

emomsupginst

Enterprise Manager OMS installation, upgrade, and patching

Local only

No

empatchplancrt

Enterprise Manager patch plan creation problems

OMS and Agent

No

emprocdisc

Oracle Database, Listener, or ASM target is not discovered or detected by the discovery process

Local only

No

emtbsmetrics

Enterprise Manager tablespace usage metric problems

Local only (on Enterprise Manager Agent target)

No

emwlsssl

Enterprise Manager WebLogic Server (WLS) SSL configuration issues

Local only

No

esexalogic

Oracle Exalogic full Exalogs data collection information

Local only

No

exadata

Collect Oracle Exadata information

Local only

No

exservice

Oracle Exadata: Storage software service or offload server service problems

Local only

No

exsmartscan

Oracle Exadata: Smart Scan not working problems

Local only

No

generic

Fallthrough SRDC for Oracle Database error

Local only

No

gg_abend

Oracle GoldenGate covering both Classic and Microservices implementations.

Local only

No

ggintegratedmodenodb

Oracle GoldenGate extract/replicate abends problems.

Local only

No

gridinfra

Oracle RAC-related data collection for Oracle Clusterware problems

Local only

No

gridinfrainst

Oracle RAC upgrade and patching problems

Local only

No

instterm
Collect traces for the following ORA errors:
  • ORA-00469
  • ORA-00470
  • ORA-00480
  • ORA-00490
  • ORA-00491
  • ORA-00492
  • ORA-00493
  • ORA-00495
  • ORA-00496
  • ORA-00497
  • ORA-00498

Local only

No

internalerror

Other internal Oracle Database errors

Local only

No

listener_services

Listener errors: TNS-12516 / TNS-12518 / TNS-12519 / TNS-12520

Local only

No

naming_services

Naming service errors: TNS-12154 / TNS-12528

Local only

No

ORA-00020

ORA-00060

ORA-00494

ORA-00600

ORA-00700

ORA-01031

ORA-01555

ORA-01578

ORA-01628

ORA-03137

ORA-04020

ORA-04021

ORA-04030

ORA-04023

ORA-04031

ORA-04063

ORA-07445

ORA-08102

ORA-08103

ORA-22924

ORA-27300

ORA-27301

ORA-27302

ORA-30036

ORA Errors

Local only
Only the following SRDCs:
  • ORA-00600
  • ORA-04030
  • ORA-04031
  • ORA-04021
  • ORA-07445
  • ORA-01578

ORA-01000

Open Cursors problems

Local only

No

ORA-00018

ORA-00018 or sessions parameter problems

Local only

No

ORA-12751

ORA-12751 collection errors

Local only

No

ORA-25319

Collect information for troubleshooting ORA-25319 error in an Advanced Queuing Environment

ORA-25319 problems in an Oracle Advanced Queuing Environment

Local only

No

ORA-00227

Collect information for troubleshooting Control File block corruption reported by error ORA-00227

Local only

No

privsroles

Data Collection for privileges and roles

Local only

No

xdb600

Diagnostic data collection for XDB ORA-00600 and ORA-07445 internal rrror issues using TFA Collector

Local only

No

zlgeneric

Zero Data Loss Recovery Appliance (ZDLRA) problems

Local only

No

For more information about SRDCs, run tfactl diagcollect –srdc -help.

The types of information that the SRDCs collect varies for each type, for example, the following table lists and describes what the SRDCs collect for each type.

Table 8-4 SRDC collections

Command What gets collected

$ tfactl diagcollect –srdc ORA-04031

  • Incident Packaging Service (IPS) package

  • Patch listing

  • Automatic Workload Repository (AWR) report

  • Memory information

$ tfactl diagcollect –srdc dbperf

  • Automatic Database Diagnostic Monitor (ADDM) report

  • Automatic Workload Repository (AWR) for good period and problem period

  • Automatic Workload Repository (AWR) Compare Period report

  • Active Session History (ASH) report for good and problem period

  • OSWatcher

  • Incident Packaging Service (IPS) package (if there are any errors during problem period)

  • Oracle ORAchk (performance-related checks)

Oracle Trace File Analyzer prompts you to enter the information required based on the SRDC type.

For example, when you run ORA-4031 SRDC: 

$ tfactl diagcollect –srdc ORA-04031

Oracle Trace File Analyzer:

  1. Prompts to enter event date, time, and database name.

  2. Scans the system to identify recent events in the system (up to 10).

  3. Proceeds with diagnostic collection after you choose the relevant event.

  4. Identifies all the required files.

  5. Trims all the files where applicable.

  6. Packages all data in a zip file ready to provide to support.

You can also run an SRDC collection in non-interactive silent mode. Provide all the required parameters up front as follows:

$ tfactl diagcollect –srdc srdc_type -database db -from "date time" -to "date time"

Related Topics

Parent topic: Using On-Demand Diagnostic Collections