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 (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

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:

• https://support.oracle.com/rs?type=doc&id=1918781.1
• https://support.oracle.com/rs?type=doc&id=2560291.1
• https://support.oracle.com/rs?type=doc&id=2560286.1
• https://support.oracle.com/rs?type=doc&id=2500734.1
• https://support.oracle.com/rs?type=doc&id=1914153.1
• https://support.oracle.com/rs?type=doc&id=2383662.1
• https://support.oracle.com/rs?type=doc&id=1682741.1
• https://support.oracle.com/rs?type=doc&id=1682723.1
• https://support.oracle.com/rs?type=doc&id=1928047.1