@@@@Platform-“OnPrem”

@@@@Product-“Database”

@@@@ReleaseVersion-“26.11”

@@@@info-map-label-“Oracle Trace File Analyzer Service Request Data Collections (SRDCs)”

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 n h | 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 (<i>h</i>) or days (<i>d</i>). 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"

<blockquote>

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.

</blockquote>
-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:

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  
avs Audit Vault Server related files Cluster-wide 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  

dbexpdp

dbexpdpapi

dbexpdpperf

dbexpdptts

Oracle Data Pump Export (expdp) 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  

dbimpdp

dbimpdpperf

Oracle Data Pump Import (impdp) 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 (SCN) 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 Oracle Database Configuration Assistant (Oracle DBCA) 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 Oracle Management Service (OMS) and Agent No  
emagentpatching Enterprise Manager failures during agent patching Oracle Management Service (OMS) and Agent No  
emagentperf Enterprise Manager 13c Agent performance problems Agent No  
emagentssl Enterprise Manager Agent SSL configuration issues Oracle Management Service (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 Oracle Management Service (OMS) and Agent No  
emagtupginst Collecting diagnostic data for Enterprise Manager 13c Agent installation, upgrade, or deployment problems Agent No  
emagtupgpatch Enterprise Manager 13c Agent upgrade, local installation, or patching problems. Oracle Management Service (OMS) and Agent No  
emauthldap Enterprise Manager authentication using LDAP provider issues Oracle Management Service (OMS) No  
emblackout Enterprise Manager blackout issues Oracle Management Service (OMS) and Agent No  

emcliadd

emclusdisc

emdbsys

emgendisc

Enterprise Manager target discovery or add problems

Oracle Management Service (OMS) and Agent

Agent

Oracle Management Service (OMS) and Agent

Oracle Management Service (OMS) and Agent

No  
emcomm Enterprise Manager communication information between Oracle Management Service (OMS) and Agent Oracle Management Service (OMS) and Agent No  
emdbaasdeploy Database As A Service (DBaaS): Collect trace or log information for failures during DBaaS deployment. Oracle Management Service (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

Oracle Management Service (OMS) or Agent No  
emfleetpatching Enterprise Manager Fleet Maintenance Patching problems Oracle Management Service (OMS) and Agent No  
emjobs Enterprise Manager all job related issues Oracle Management Service (OMS) No  
emmetricalert Enterprise Manager general metrics page or threshold problems Agent No  
emnotif Enterprise Manager incident rules and notification issues Oracle Management Service (OMS) No  
emomsfailstart Enterprise Manager Oracle Management Service (OMS) start up failures Oracle Management Service (OMS) No  
emomscrash Enterprise Manager Oracle Management Service (OMS) crash problems Oracle Management Service (OMS) No  
emomsheap Enterprise Manager Java heap usage or performance problems Oracle Management Service (OMS) No  
emomshungcpu Enterprise Manager Oracle Management Service (OMS) crash, restart or performance problems Oracle Management Service (OMS) No  
emomspatching Enterprise Manager failures during Oracle Management Service (OMS) patching Oracle Management Service (OMS) No  
emomsssl Enterprise Manager Oracle Management Service (OMS) SSL configuration issues Oracle Management Service (OMS) No  
emomsupginst Enterprise Manager Oracle Management Service (OMS) installation, upgrade, and patching Local only No  
empatchplancrt Enterprise Manager patch plan creation problems Oracle Management Service (OMS) and Agent No  
emprocdisc Oracle Database, Listener, or ASM target is not discovered or detected by the discovery process Local only No  
emtbsmetric 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  
emdbperf Covers cases where the Enterprise Manager Performance Hub is slow in rendering and/or missing information Local only No  
emdbrat Enterprise Manager RAT collection issues Target replay/capture database No  
emcreds Enterprise Manager credential issues Oracle Management Service (OMS) and Agent No  
emdbpluginstatus Enterprise Manager DB plug in issues Oracle Management Service (OMS) and/or Agent No  
emdeployoms Enterprise Manager deploying additional Oracle Management Service (OMS) issues Oracle Management Service (OMS) No  
emomsmigration Enterpriser Manager Oracle Management Service (OMS) migration/cloning issues Oracle Management Service (OMS) 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.

Note: When you run the tfactl diagcollect command to query an ora-* error event, for example, tfactl diagcollect -srdc ora-600, AHF lists all ora-* error events without filtering. This is because of generic event mapping for all ORA-* error events in the srdc_dbrac.xml file.

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.

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"

For more information, see: