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 |
---|---|
|
Specify the SRDC profile. |
|
Use this parameter to create a subdirectory for the resulting collection in the Oracle Trace File Analyzer repository. |
|
Use this parameter to specify an output file name. |
|
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. |
|
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 | ||
---|---|---|---|---|---|
|
Oracle ORAchk and Oracle EXAchk problems (to be run
after running with |
Local only |
No |
||
|
Collect |
Cluster-wide |
No |
||
|
ASM CRS-related problems |
Cluster-wide |
No |
||
|
ASM CRS CELL-related problems |
Cluster-wide |
No |
||
|
Problems with Access Control Lists (ACLs) |
Local only |
No |
||
|
Problems in an Oracle Advanced Queuing Environment |
Local only |
No |
||
|
Queue Monitor (QMON) problems |
Local only |
No |
||
|
Notification problems in an Oracle Advanced Queuing Environment |
Local only |
No |
||
|
Performance problems in an Oracle Advanced Queuing Environment |
Local only |
No |
||
|
Non-purged Messages in an Oracle Advanced Queuing Environment problems |
Local only |
No |
||
|
Oracle Database storage problems |
Local only |
No |
||
|
Standard information for Oracle Database auditing |
Local only |
No |
||
|
AUM: Checklist of Evidence to Supply (Doc ID 1682741.1) |
Local only |
No |
||
|
Wait Events related to Undo: Checklist of Evidence to Supply (Doc ID 1682723.1) |
Local only |
No |
||
|
Oracle Database Automatic Workload Repository (AWR) space problems |
Local only |
No |
||
|
Bequeath Connection Issues: Checklist of Evidence to Supply (Doc ID 1928047.1) |
Local only |
No |
||
|
Generic Oracle Database corruption |
Local only |
No |
||
|
Data Guard problems including Broker |
Local only |
No |
||
|
Excessive SYSAUX space is used by the Automatic Workload Repository (AWR) |
Local only |
No |
||
|
Datapatch problems |
Local only |
No |
||
|
DDL Errors: Checklist of Evidence to Supply (Doc ID 2383662.1) |
Local only |
No |
||
|
Event Monitor (EMON) problems |
Local only |
No |
||
|
Collect standard information for Advanced Queueing problems using TFA Collector (recommended) or manual steps |
Local only |
No |
||
|
Original Oracle Database Export (exp) |
Local only |
No |
||
|
Oracle Automatic Storage Management (Oracle ASM) / Database File System (DBFS) / Direct NFS / Oracle Advanced Cluster File System (Oracle ACFS) problems |
Local only |
No |
||
|
Fast Recovery Area, also known as Flash Recovery Area problems |
Local only |
No |
||
|
Oracle GoldenGate |
Local only |
No |
||
|
Oracle Database hang problems |
Local only |
No |
||
|
Oracle Database performance and hang problems |
Local only |
No |
||
|
Original Oracle Database Import (imp) |
Local only |
No |
||
|
Data Pump Import performance problems |
Local only |
No |
||
|
Oracle Database install / upgrade problems |
Local only |
No |
||
|
Oracle Database single instance shutdown problems |
Local only |
No |
||
|
Parameter Files: Checklist of Evidence to Supply (Doc ID 1914153.1) |
Local only |
No |
||
|
Create or maintain partitioned table, subpartitioned table, and index problems |
Local only |
No |
||
|
Slow |
Local only |
No |
||
|
Oracle Database patching problems |
Local only |
No |
||
|
Oracle Database performance problems |
Cluster-wide |
No |
||
|
Oracle Database performance and hang problems on FASaaS environments |
Local only |
No |
||
|
Enterprise Manager compliance related issues |
Local only |
No |
||
|
Oracle Database preupgrade problems |
Local only |
No |
||
|
Generic Process Management and Related Issues: Checklist of Evidence to Supply (Doc ID 2500734.1) |
Local only |
No |
||
|
Oracle RAC-related data collection for Oracle Clusterware and Oracle ASM problems |
Local only |
No |
||
|
Oracle RAC-related data collection for Oracle Database problems |
Local only |
No |
||
|
Oracle RAC-related performance problems |
Cluster-wide | No | ||
|
Oracle Database problems related to Resource Manager |
Local only |
No |
||
|
Recovery Manager (RMAN) problems |
Local only |
No |
||
|
System change number |
Local only |
No |
||
|
Oracle Database startup or shutdown problems |
Local only |
No |
||
|
Slow DDL: Checklist of Evidence to Supply |
Local only |
No |
||
|
Space Related Wait Events and Performance Issues : Checklist of Evidence to Supply (Doc ID 2560286.1) |
Local only |
No |
||
|
Oracle Spatial export or import problems |
Local only |
No |
||
|
Oracle Spatial installation problems |
Local only |
No |
||
|
Oracle Spatial performance problems |
Local only |
No |
||
|
Oracle Spatial upgrade problems |
Local only |
No |
||
|
Oracle Spatial usage problems |
Local only |
No |
||
|
SQL performance problems |
Local only |
No |
||
|
Database Configuration Assistant problems |
Local only |
No |
||
|
Storage structure related diagnosis |
Local only |
No |
||
|
Generic Tablespace and Segment Management: Checklist of Evidence to Supply (Doc ID 2560291.1) |
Local only |
No |
||
|
Transparent Data Encryption (TDE) problems |
Local only |
No |
||
|
Oracle Text problems |
Local only |
No |
||
|
Oracle Text installation problems - 12c. |
Local only |
No |
||
|
Oracle Text version 12.1.0.1 and later upgrade problems |
Local only |
No |
||
|
Oracle Database resource problems |
Local only |
No |
||
|
Collect standard information for Database Vault |
Local only |
No |
||
|
Oracle Database on Microsoft Windows resources: Checklist of Evidence to Supply |
Local only |
No |
||
|
OracleService on Microsoft Windows: Checklist of Evidence to Supply (Doc ID 1918781.1) |
Local only |
No |
||
|
XDB Installation or invalid object problems |
Local only |
No |
||
|
XDB installation and invalid object problems |
Local only |
No |
||
|
XDB installation and invalid object problems in 12c and above |
Local only |
No |
||
|
XDB Upgrade problems |
Local only |
No |
||
|
Collect trace/log information for Enterprise Manager Management Agent generic problems |
OMS and Agent |
No |
||
|
Enterprise Manager failures during agent patching |
OMS and Agent |
No |
||
|
Enterprise Manager 13c Agent performance problems |
Agent |
No |
||
|
Enterprise Manager Agent SSL configuration issues |
OMS and Agent |
No |
||
|
Enterprise Manager 13c Agent startup problems |
Agent |
No |
||
|
Enterprise Manager 13c Agent unreachable errors or status |
Agent |
No |
||
|
Enterprise Manager 13c Agent upload errors |
Agent |
No |
||
|
Enterprise Manager 13c Agent patch deployment problems |
OMS and Agent |
No |
||
|
Collecting diagnostic data for Enterprise Manager 13c Agent installation, upgrade, or deployment prodblems |
Agent |
No |
||
|
Enterprise Manager 13c Agent upgrade, local installation, or patching problems. |
OMS and Agent |
No |
||
|
Enterprise Manager authentication using LDAP provider issues |
OMS |
No |
||
|
Enterprise Manager Blackout Issues |
OMS and Agent |
No |
||
|
Enterprise Manager target discovery or add problems |
OMS and Agent Agent OMS and Agent OMS and Agent OMS and Agent |
No |
||
|
Enterprise Manager communication information between OMS and Agent |
OMS and Agent |
No |
||
|
Database As A Service (DBaaS): Collect trace or log information for failures during DBaaS deployment. |
OMS and remote DBaaS deployment server |
No |
||
|
Enterprise Manager debug log collection Run |
OMS or Agent |
No |
||
|
Enterprise Manager Fleet Maintenance Patching problems |
OMS and Agent |
No |
||
|
Enterprise Manager all job related issues |
OMS |
No |
||
|
Enterprise Manager general metrics page or threshold problems |
Agent |
No |
||
|
Enterprise Manager incident rules and notification issues |
OMS |
No |
||
|
Enterprise Manager OMS startup failures |
OMS |
No |
||
|
Enterprise Manager OMS Crash problems |
OMS |
No |
||
|
Enterprise Manager Java heap usage or performance problems |
OMS |
No |
||
|
Enterprise Manager OMS crash, restart or performance problems |
OMS |
No |
||
|
Enterprise Manager failures during OMS patching |
OMS |
No |
||
|
Enterprise Manager OMS SSL configuration issues |
OMS |
No |
||
|
Enterprise Manager OMS installation, upgrade, and patching |
Local only |
No |
||
|
Enterprise Manager patch plan creation problems |
OMS and Agent |
No |
||
|
Oracle Database, Listener, or ASM target is not discovered or detected by the discovery process |
Local only |
No |
||
|
Enterprise Manager tablespace usage metric problems |
Local only (on Enterprise Manager Agent target) |
No |
||
|
Enterprise Manager WebLogic Server (WLS) SSL configuration issues |
Local only |
No |
||
|
Oracle Exalogic full Exalogs data collection information |
Local only |
No |
||
|
Collect Oracle Exadata information |
Local only |
No |
||
|
Oracle Exadata: Storage software service or offload server service problems |
Local only |
No |
||
|
Oracle Exadata: Smart Scan not working problems |
Local only |
No |
||
|
Fallthrough SRDC for Oracle Database error |
Local only |
No |
||
|
Oracle GoldenGate covering both Classic and Microservices implementations. |
Local only |
No |
||
|
Oracle GoldenGate extract/replicate abends problems. |
Local only |
No |
||
|
Oracle RAC-related data collection for Oracle Clusterware problems |
Local only |
No |
||
|
Oracle RAC upgrade and patching problems |
Local only |
No |
||
|
Collect traces for the following ORA errors:
|
Local only |
No |
||
|
Other internal Oracle Database errors |
Local only |
No |
||
|
Listener errors: |
Local only |
No |
||
|
Naming service errors: |
Local only |
No |
||
|
|
ORA Errors |
Local only |
Only the following SRDCs:
|
|
|
Open Cursors problems |
Local only |
No |
||
|
|
Local only |
No |
||
|
|
Local only |
No |
||
|
Collect information for troubleshooting
|
Local only |
No |
||
|
Collect information for troubleshooting Control File
block corruption reported by error |
Local only |
No |
||
|
Data Collection for privileges and roles |
Local only |
No |
||
|
Diagnostic data collection for XDB |
Local only |
No |
||
|
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 |
---|---|
|
|
|
|
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:
-
Prompts to enter event date, time, and database name.
-
Scans the system to identify recent events in the system (up to 10).
-
Proceeds with diagnostic collection after you choose the relevant event.
-
Identifies all the required files.
-
Trims all the files where applicable.
-
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
- 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
Parent topic: Using On-Demand Diagnostic Collections