14.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 14-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 14-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"