Oracle Support strongly recommends using Trace File Analyzer (TFA) Collector for collecting data. TFA Collector has been included in the Autonomous Health Framework (AHF).
Reference - Document 2550798.1 Autonomous Health Framework (AHF) - Including TFA and EXAchk
This SRDC will collect the information needed to start the analysis of error ORA-600, ORA-700 or ORA-7445.
Safe Harbor Statement: Oracle will use this information to help diagnose the cause of the issue. In many cases this set of information will be sufficient for diagnosis - in some cases, additional specific diagnostic data may be required at a later stage.
Action Plan
Auto Collection Using TFA
1. Download and install the latest version of TFA using the AHF installer: Download AHF
2. Using AutoCollection:
a. Ensure that autocollection is enabled: tfactl set autocollection on
b. If AutoCollection is already enabled and an ORA-600/ORA-7445/ORA-700
is observed, the collection will be automatically created at the time of
the error and will be in the location you have defined for output.
c. If AutoCollection is not enabled and an ORA-600/ORA-7445/ORA-700 is
observed, you will need to perform the SRDC collection manually as the
oracle software owner: This lets you select an event or prompt for an
incident timestamp (YYYY-MM-DD HH24:MI:SS) to trim and collect data from
1 hour around the provided time.
ORA-600
$TFA_HOME/bin/tfactl diagcollect -srdc ora600
ORA-700
$TFA_HOME/bin/tfactl diagcollect -srdc ora7445
ORA-7445
$TFA_HOME/bin/tfactl diagcollect -srdc ora700
3. Upload the resulting zip file *exactly as it is generated* to the Service Request (SR)
For both cases, TFA collection or manual instructions:
Optional but recommended: Testcase (for reproducible issues)
To Bottom