9.3.3.4 tfactl diagcollect -srdc

Use the tfactl diagcollect -srdc command to run a Service Request Data Collection (SRDC).

Syntax

tfactl diagcollect -srdc srdc_profile 
[-tag tagname] 
[-z filename] 
[-last nh|d | -from time -to time | -for date] 
-database database

Parameters

Each option must be prefixed with a minus sign (-).

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.

SRDC Profiles

SRDC Profile	Description
listener_services	Collects data for listener services errors: TNS-12514 / TNS-12516 / TNS-12518 / TNS-12519 / TNS-12520 / TNS-12528.
naming_services	Collects data for naming services errors: ORA-12514 / ORA-12528.
ORA-00020	Collects data regarding maximum number of processes exceeded.
ORA-00060, ORA-00600	Collects data for internal errors.
ORA-00700	Collects data for soft internal error.
ORA-01031	Collects standard information for ORA-1031 / ORA-1017 during SYSDBA connections
ORA-01555	Collects data for Oracle Database Snapshot too old error.
ORA-01578	Collects data for NOLOGGING ORA-1578 / ORA-26040 DBV-00201.
ORA-01628	Collects data for Oracle Database Snapshot too old error.
ORA-04030	Collects data for OS process private memory was exhausted error.
ORA-04031	Collects data for More shared memory is needed in the shared/streams pool. error.
ORA-07445	Collects data for Exception encountered, core dump. error.
ORA-08102	Collects data for ORA error ORA-08102.
ORA-08103	Collects data for ORA error ORA-08103.
ORA-27300	Collects data for OS system dependent operation: open failed with status: (status). error.
ORA-27301	Collects data for OS failure message: (message). error.
ORA-27302	Collects data for Failure occurred at: (module). error.
ORA-30036	Collects data for Oracle Database Unable to extend Undo Tablespace error.
dbasm	Collects data for Oracle Database storage problems.
dbaudit	Collects standard information for Oracle Database auditing.
dbawrspace	Collects data for Oracle Database Automatic Workload Repository (AWR) space problems.
dbexp	Collects information for troubleshooting original Export (exp) related problems.
dbexpdp	Collects data for Data Pump Export generic issues.
dbexpdpapi	Collects data for Data Pump Export API Issues.
dbexpdpperf	Collects data for Data Pump Export performance issues.
dbexpdptts	Collects data to supply for Transportable Tablespace Data Pump and original EXPORT, IMPORT.
dbfs	Collects data for dbfs issues.
dbggclassicmode	Collects data for Oracle GoldenGate Classic Mode issues.
dbggintegratedmode	Collects data for Oracle GoldenGate Extract / Replicat abends problems.
dbimp	Collects data for troubleshooting original Import (imp) releated problems.
dbimpdp	Collects data for Data Pump Import generic issues.
dbimpdpperf	Collects data for Data Pump Import performance issues.
dbinstall	Collects data for Oracle Database install / upgrade problems.
dbpartition	Collects data for Create / maintain partitioned / subpartitioned table / index problems.
dbpartitionperf	Collects data for slow Create / Alter / Drop commands against partitioned table / index problems.
dbpatchconflict	Collects data for Oracle Database patch conflict problems.
dbpatchinstall	Collects data for Oracle Database patch install problems.
dbperf	Collects data for Oracle Database performance problems.
dbpreupgrade	Collects data for Oracle Database preupgrade problems.
dbrman	Collects data for RMAN related issues, such as backup, maintenance, restore and recover, RMAN-08137, or RMAN-08120.
dbrman600	Collects data for RMAN-00600 error (My Oracle Support note 2045195.1).
dbrmanperf	Collects data for RMAN Performance error (My Oracle Support note 1671509.1).
dbscn	Collects data for Oracle Database SCN problems.
dbshutdown	Collects data for single instance Oracle Database shutdown problems.
dbsqlperf	Collects data for an SQL performance problem using Oracle Trace File Analyzer Collector.
dbstartup	Collects data for single instance Oracle Database startup problems.
dbtde	Collects data for Transparent Data Encryption (TDE) (My Oracle Support note 1905607.1)
dbunixresources	Collects data for Oracle Database issues related to operating system resources.
dbupgrade	Collects data for Oracle Database upgrade problems.
dbxdb	Collects data Oracle Database XDB installation and invalid object problems.
dnfs	Collects data for DNFS problems.
emagentperf	Collects data for Enterprise Manager Agent performance issues.
emcliadd	Collects data for Enterprise Manager errors while adding an Oracle Database, a listener, or an ASM target using Enterprise Manager command-line.
emclusdisc	Collects data for cluster target, cluster (RAC) Oracle Database, or an ASM target is not discovered issue.
emdbsys	Collects data for Enterprise Manager Oracle Database system target is not discovered, detected, removed, or renamed correctly issue.
emdebugoff	Collects data for unsetting Enterprise Manager debug.
emdebugon	Collects data for setting Enterprise Manager debug.
emgendisc	Collects data for Enterprise Manager generic error while discovering, or removing an Oracle Database, a listener, or an ASM target.
emmetricalert	Collects data for Enterprise Manager metric events not raised and general metric alert related issues.
emomscrash	Collects for all Enterprise Manager OMS crash or restart performance issues.
emomsheap	Collects data for Enterprise Manager OMS heap usage alert performance issues.
emomshungcpu	Collects data for Enterprise Manager OMS hung or high CPU usage performance issues.
emprocdisc	Collects data for Enterprise Manager Oracle Database, listener, or an ASM target is not discovered or detected by the discovery process issues.
emrestartoms	Collects data for Enterprise Manager restart OMS crash problems.
emtbsmetric	Collects data for Enterprise Manager Tablespace space used metric issues.
esexalogic	Collects data for Oracle Exalogic Full Exalogs problems.
ggintegratedmodenodb	Collects data for Oracle GoldenGate Extract/Replicat abends problems.
internalerror	Collects data for all other types of internal Oracle Database errors.