Using On-Demand Diagnostic Collections

<!DOCTYPE html SYSTEM "about:legacy-compat"> <html xml:lang="en-us" lang="en-us"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <meta name="DC.Type" content="topic"> <meta name="DC.Title" content="Using On-Demand Diagnostic Collections"> <meta name="abstract" content="Run Oracle Trace File Analyzer on demand using tfactl command-line tool."> <meta name="description" content="Run Oracle Trace File Analyzer on demand using tfactl command-line tool."> <meta name="DC.subject" content="on-demand diagnostic collection, system and cluster summary, investigate logs, tools bundle, TFA SRDCs, diagnostic upload, trace levels, TFACTL, commands, tfactl dbglevel, profile_name, active, set, unset, view, create, drop, modify, describe, lsprofiles, lsmodules, lscomponents, lsres, getstate, module, dependency, dependency_type, timeout, debugstate, includeunset, includetrace, collection period, Oracle Trace File Analyzer, on-demand diagnostic collections, custom collections, specific events, maxfilecollectionsize, specific nodes, specific components, specific directories, changing the collection name, copying zip files, trimming files, silent collection, collecting core files, IPS packages"> <meta name="keywords" content="on-demand diagnostic collection, system and cluster summary, investigate logs, tools bundle, TFA SRDCs, diagnostic upload, trace levels, TFACTL, commands, tfactl dbglevel, profile_name, active, set, unset, view, create, drop, modify, describe, lsprofiles, lsmodules, lscomponents, lsres, getstate, module, dependency, dependency_type, timeout, debugstate, includeunset, includetrace, collection period, Oracle Trace File Analyzer, on-demand diagnostic collections, custom collections, specific events, maxfilecollectionsize, specific nodes, specific components, specific directories, changing the collection name, copying zip files, trimming files, silent collection, collecting core files, IPS packages"> <meta name="DC.Relation" scheme="URI" content="diag-data-collection.html#GUID-6963137B-43CA-43C1-83E3-7F9614706B84"> <meta name="DC.Relation" scheme="URI" content="ondemand-diagnostic-collection.html#GUID-53891145-A0B1-4AA3-A560-2CD3C9EE1065"> <meta name="DC.Relation" scheme="URI" content="ondemand-diagnostic-collection.html#GUID-CA919197-728E-486B-B8B4-5865A18125C6"> <meta name="DC.Relation" scheme="URI" content="ondemand-diagnostic-collection.html#GUID-B35603EE-90AD-4E9C-AA18-DA565EA4DC4B"> <meta name="DC.Relation" scheme="URI" content="ondemand-diagnostic-collection.html#GUID-ECAB7936-8E48-4141-91F8-634DB19BE390"> <meta name="DC.Relation" scheme="URI" content="ondemand-diagnostic-collection.html#GUID-34C415D3-D4E1-4AED-AF7A-E31CB92CD9D1"> <meta name="DC.Relation" scheme="URI" content="ondemand-diagnostic-collection.html#GUID-F8381A7A-E2F7-442C-AED0-3FEEF4129125"> <meta name="DC.Relation" scheme="URI" content="ondemand-diagnostic-collection.html#GUID-EC9B013E-CFB5-430C-A827-315304FB219B"> <meta name="DC.Relation" scheme="URI" content="ondemand-diagnostic-collection.html#GUID-940A4DD7-80E8-4DAA-9BAD-571D13428DFC"> <meta name="DC.Relation" scheme="URI" content="ondemand-diagnostic-collection.html#GUID-E4A2492E-A123-480A-B954-57898DBCE8BE"> <meta name="DC.Relation" scheme="URI" content="ondemand-diagnostic-collection.html#GUID-1552A78B-9E9F-41C9-8DF4-DED1056D28A9"> <meta name="DC.Relation" scheme="URI" content="ondemand-diagnostic-collection.html#GUID-6D95E3ED-1488-4199-A834-E491AC3B6DA4"> <meta name="DC.Contributor" content="Aparna Kamath"> <meta name="DC.Contributor" content="Mark Bauer"> <meta name="DC.Contributor" content="Richard Strohm"> <meta name="DC.Creator" content="Aarya Joshi"> <meta name="DC.Creator" content="Alex Wu"> <meta name="DC.Creator" content="Amar Gorla"> <meta name="DC.Creator" content="Anand Pandey"> <meta name="DC.Creator" content="Arjun Upadhyay"> <meta name="DC.Creator" content="Ashwinee Khaladkar"> <meta name="DC.Creator" content="Barry Gleeson"> <meta name="DC.Creator" content="Bill Burton"> <meta name="DC.Creator" content="Bob Caldwell"> <meta name="DC.Creator" content="Bryan Vongray"> <meta name="DC.Creator" content="Carol Colrain"> <meta name="DC.Creator" content="Chandrabhushan Nagur"> <meta name="DC.Creator" content="Christian Diaz"> <meta name="DC.Creator" content="Damian Garcia"> <meta name="DC.Creator" content="Daniel Semler"> <meta name="DC.Creator" content="Daniel Torres"> <meta name="DC.Creator" content="Deepak Tayade"> <meta name="DC.Creator" content="Erick Mendoza"> <meta name="DC.Creator" content="Gareth Chapman"> <meta name="DC.Creator" content="Girdhari Ghantiyala"> <meta name="DC.Creator" content="Guldeep Sahu"> <meta name="DC.Creator" content="Hairong Qin"> <meta name="DC.Creator" content="Harish Rajora"> <meta name="DC.Creator" content="Itzel Velazquez"> <meta name="DC.Creator" content="Jorge Flores"> <meta name="DC.Creator" content="Jose Tovany"> <meta name="DC.Creator" content="Juan Carlos Perez Castellanos"> <meta name="DC.Creator" content="Juan Manuel Sanchez"> <meta name="DC.Creator" content="Juigil Kishore"> <meta name="DC.Creator" content="Kamakshi Sethi"> <meta name="DC.Creator" content="Kavitha Dhanasekar"> <meta name="DC.Creator" content="Leela Kumaraswamy Lakkana"> <meta name="DC.Creator" content="Luis Rocholl"> <meta name="DC.Creator" content="Luis Trujillo"> <meta name="DC.Creator" content="Macharapu Prasanth"> <meta name="DC.Creator" content="Manuel Antonio Garcia Chang"> <meta name="DC.Creator" content="Maximiliano Catalan"> <meta name="DC.Creator" content="Nikhil Nischal"> <meta name="DC.Creator" content="Nishith Khandelwal"> <meta name="DC.Creator" content="Pallavi Kamath"> <meta name="DC.Creator" content="Pedro Cornejo"> <meta name="DC.Creator" content="Pradeep Ganesh Bhandarkar"> <meta name="DC.Creator" content="Praveen Kumar"> <meta name="DC.Creator" content="Rajeev Chaurasia"> <meta name="DC.Creator" content="Ravi Ranjan"> <meta name="DC.Creator" content="Raziel Zavaleta"> <meta name="DC.Creator" content="Refugio Cornejo"> <meta name="DC.Creator" content="Rishabh Vishwakarma"> <meta name="DC.Creator" content="Rohit Juyal"> <meta name="DC.Creator" content="Sarahi Partida"> <meta name="DC.Creator" content="Shirdivas Dharmabhotla"> <meta name="DC.Creator" content="Srishti Bhatia"> <meta name="DC.Creator" content="Thomas Herter"> <meta name="DC.Creator" content="Troy Anthony"> <meta name="DC.Creator" content="Vaishakha R"> <meta name="DC.Creator" content="Vern Wagman"> <meta name="DC.Creator" content="Wataru Miyoshi"> <meta name="DC.Creator" content="Nirmal Kumar"> <meta name="DC.Publisher" content="November2024"> <meta name="DC.Format" content="XHTML"> <meta name="DC.Identifier" content="GUID-89D19AFB-0230-49AD-8C90-7B4E77A36174"> <meta name="DC.Language" content="en-US"> <meta name="viewport" content="width=device-width, initial-scale=1"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="abstract" content="Run Oracle Trace File Analyzer on demand using tfactl command-line tool."> <meta name="description" content="Run Oracle Trace File Analyzer on demand using tfactl command-line tool."> <title>Using On-Demand Diagnostic Collections</title> <meta property="og:site_name" content="Oracle Help Center"> <meta property="og:title" content> <meta property="og:description" content="Run Oracle Trace File Analyzer on demand using tfactl command-line tool."> <link rel="stylesheet" href="/sp_common/book-template/ohc-book-template/css/book.css"> <link rel="shortcut icon" href="/sp_common/book-template/ohc-common/img/favicon.ico"> <meta name="application-name" content> <meta name="generator" content="DITA Open Toolkit version 1.8.5 (Mode = doc)"> <meta name="plugin" content="SP_docbuilder HTML plugin release 18.2.2"> <link rel="alternate" href="oracle-autonomous-health-framework-users-guide.pdf" title="PDF File" type="application/pdf"> <link rel="schema.dcterms" href="http://purl.org/dc/terms/"> <meta name="dcterms.created" content="2024-11-08T16:43:07-08:00"> <meta name="dcterms.dateCopyrighted" content="2016, 2024"> <meta name="dcterms.category" content="engineered-systems"> <meta name="dcterms.identifier" content="F19065-73"> <meta name="dcterms.product" content="en/engineered-systems/health-diagnostics/autonomous-health-framework"> <link rel="prev" href="automatic-diagnostic-collection.html" title="Previous" type="text/html"> <link rel="next" href="purpose-cluster-health-advisor.html" title="Next" type="text/html"> <script> document.write('<style type="text/css">'); document.write('body > .noscript, body > .noscript ~ * { visibility: hidden; }'); document.write('</style>'); </script> <script data-main="/sp_common/book-template/ohc-book-template/js/book-config" src="/sp_common/book-template/requirejs/require.js"></script> <script> if (window.require === undefined) { document.write('<script data-main="sp_common/book-template/ohc-book-template/js/book-config" src="sp_common/book-template/requirejs/require.js"><\/script>'); document.write('<link href="sp_common/book-template/ohc-book-template/css/book.css" rel="stylesheet"/>'); } </script> <script type="application/json" id="ssot-metadata">{"primary":{"category":{"short_name":"engineered-systems","element_name":"Engineered Systems","display_in_url":true},"suite":{"short_name":"not-applicable","element_name":"Not Applicable","display_in_url":false},"product_group":{"short_name":"health-diagnostics","element_name":"Health Diagnostics","display_in_url":true},"product":{"short_name":"autonomous-health-framework","element_name":"Autonomous Health Framework","display_in_url":true},"release":{"short_name":"latest","element_name":"Latest Release","display_in_url":false}}}</script> <meta name="dcterms.title" content="Oracle Autonomous Health Framework User's Guide"> <meta name="dcterms.isVersionOf" content="AHFUG"> <meta name="dcterms.release" content="Latest Release"> <script type="application/ld+json"> {"@context":"https://schema.org","@type":"WebPage","name":"Using On-Demand Diagnostic Collections","description":"Run Oracle Trace File Analyzer on demand using tfactl command-line tool.","datePublished":"2019-10-17 CST","dateModified":"2024-11-08 CST"} </script> <script>window.ohcglobal || document.write('<script src="/en/dcommon/js/global.js">\x3C/script>')</script></head> <body> <div class="noscript alert alert-danger text-center" role="alert"> <a href="automatic-diagnostic-collection.html" class="pull-left"><span class="glyphicon glyphicon-chevron-left" aria-hidden="true"></span>Previous</a> <a href="purpose-cluster-health-advisor.html" class="pull-right">Next<span class="glyphicon glyphicon-chevron-right" aria-hidden="true"></span></a> <span class="fa fa-exclamation-triangle" aria-hidden="true"></span> JavaScript must be enabled to correctly display this content </div> <article> <header> <ol class="breadcrumb" vocab="http://schema.org/" typeof="BreadcrumbList"> <li property="itemListElement" typeof="ListItem"><a href="index.html" property="item" typeof="WebPage"><span property="name"></span></a></li> <li property="itemListElement" typeof="ListItem"><a href="diag-data-collection.html" property="item" typeof="WebPage"><span property="name">Collect Diagnostic Data</span></a></li> <li class="active" property="itemListElement" typeof="ListItem">Using On-Demand Diagnostic Collections</li> </ol> <a id="GUID-89D19AFB-0230-49AD-8C90-7B4E77A36174" name="GUID-89D19AFB-0230-49AD-8C90-7B4E77A36174"></a> <h2 id="AHFUG-GUID-89D19AFB-0230-49AD-8C90-7B4E77A36174" class="sect2"><span class="enumeration_section">4.3 </span>Using On-Demand Diagnostic Collections </h2> </header> <div class="ind"> <div> <p>Run Oracle Trace File Analyzer on demand using <code class="codeph">tfactl</code> command-line tool. </p> </div> <div> <ul class="ullinks"> <li class="ulchildlink"><a href="ondemand-diagnostic-collection.html#GUID-53891145-A0B1-4AA3-A560-2CD3C9EE1065">Collecting Diagnostics and Analyzing Logs On-Demand</a><br>The <code class="codeph">tfactl</code> command uses a combination of different Oracle Database support tools when it performs analysis. </li> <li class="ulchildlink"><a href="ondemand-diagnostic-collection.html#GUID-CA919197-728E-486B-B8B4-5865A18125C6">Viewing System and Cluster Summary</a><br>The summary command gives you a real-time report of system and cluster status. </li> <li class="ulchildlink"><a href="ondemand-diagnostic-collection.html#GUID-B35603EE-90AD-4E9C-AA18-DA565EA4DC4B">Investigating Logs for Errors</a><br>Use Oracle Trace File Analyzer to analyze all of your logs across your cluster to identify recent errors. </li> <li class="ulchildlink"><a href="ondemand-diagnostic-collection.html#GUID-ECAB7936-8E48-4141-91F8-634DB19BE390">Analyzing Logs Using the Oracle Database Support Tools</a><br>The Oracle Database support tools bundle is available only when you download Oracle Trace File Analyzer from My Oracle Support note 2550798.1. </li> <li class="ulchildlink"><a href="ondemand-diagnostic-collection.html#GUID-34C415D3-D4E1-4AED-AF7A-E31CB92CD9D1">Searching Oracle Trace File Analyzer Metadata</a><br>You can search all metadata stored in the Oracle Trace File Analyzer index using <code class="codeph">tfactl search -showdatatypes|-json [json_details]</code>. </li> <li class="ulchildlink"><a href="ondemand-diagnostic-collection.html#GUID-F8381A7A-E2F7-442C-AED0-3FEEF4129125">Oracle Trace File Analyzer Service Request Data Collections (SRDCs)</a><br>Oracle Trace File Analyzer Service Request Data Collections (SRDCs) enable you to quickly collect the right diagnostic data. </li> <li class="ulchildlink"><a href="ondemand-diagnostic-collection.html#GUID-EC9B013E-CFB5-430C-A827-315304FB219B">Diagnostic Upload</a><br>Diagnostic upload eliminates the need for different set of commands to upload Oracle ORAchk, Oracle EXAchk, and Oracle Trace File Analyzer diagnostic collections to AHF Service, database, and Oracle Support. </li> <li class="ulchildlink"><a href="ondemand-diagnostic-collection.html#GUID-940A4DD7-80E8-4DAA-9BAD-571D13428DFC">Changing Oracle Grid Infrastructure Trace Levels</a><br>Enable trace levels to collect enough diagnostics to diagnose the cause of the problem. </li> <li class="ulchildlink"><a href="ondemand-diagnostic-collection.html#GUID-E4A2492E-A123-480A-B954-57898DBCE8BE">Performing Custom Collections</a><br>Use the custom collection options to change the diagnostic collections from the default. </li> <li class="ulchildlink"><a href="ondemand-diagnostic-collection.html#GUID-1552A78B-9E9F-41C9-8DF4-DED1056D28A9">Limit the Maximum Amount of Memory Used by Oracle Trace File Analyzer</a><br>You can now limit the amount of memory used by Oracle Trace File Analyzer. </li> <li class="ulchildlink"><a href="ondemand-diagnostic-collection.html#GUID-6D95E3ED-1488-4199-A834-E491AC3B6DA4">Limit Oracle Trace File Analyzer's CPU Usage</a><br>On Linux the CPU usage of Oracle Trace File Analyzer can be limited with the command <code class="codeph">ahfctl setresourcelimit [-value <span class="variable" translate="no">value</span>]</code></li> </ul> <div class="familylinks"> <div class="parentlink"> <p><strong>Parent topic:</strong> <a href="diag-data-collection.html#GUID-6963137B-43CA-43C1-83E3-7F9614706B84">Collect Diagnostic Data</a></p> </div> </div> </div> <div class="sect2"><a id="GUID-53891145-A0B1-4AA3-A560-2CD3C9EE1065" name="GUID-53891145-A0B1-4AA3-A560-2CD3C9EE1065"></a><h3 id="AHFUG-GUID-53891145-A0B1-4AA3-A560-2CD3C9EE1065" class="sect3"><span class="enumeration_section">4.3.1 </span>Collecting Diagnostics and Analyzing Logs On-Demand </h3> <div> <p>The <code class="codeph">tfactl</code> command uses a combination of different Oracle Database support tools when it performs analysis. </p> <p>The <code class="codeph">tfactl</code> command enables you to access Oracle Database support tools using common syntax. Using common syntax hides the complexity of the syntax differences between the tools. </p> <p>Use the Oracle Trace File Analyzer tools to perform analysis and resolve problems. If you need more help, then use the <code class="codeph">tfactl</code> command to collect diagnostics for Oracle Support. </p> <p>Oracle Trace File Analyzer does the following:</p> <ul style="list-style-type: disc;"> <li> <p>Collects all relevant log data from a time of your choosing.</p> </li> <li> <p>Trims log files to collect only what is necessary for diagnosis.</p> </li> <li> <p>Packages all diagnostics on the node where <code class="codeph">tfactl</code> was run from. </p> </li> </ul> <div class="p"> <div class="figure" id="GUID-53891145-A0B1-4AA3-A560-2CD3C9EE1065__GUID-82F397DA-EFC3-4288-889F-91B340800533"> <p class="titleinfigure">Figure 4-4 On-Demand Collections</p><img height="562" width="1231" src="img/tfa-demand-collections-18c.png" alt="Description of Figure 4-4 follows" title="Description of Figure 4-4 follows" longdesc="img_text/tfa-demand-collections-18c.html"><br><a href="img_text/tfa-demand-collections-18c.html">Description of "Figure 4-4 On-Demand Collections"</a></div>  </div> </div> <div> <div class="familylinks"> <div class="parentlink"> <p><strong>Parent topic:</strong> <a href="ondemand-diagnostic-collection.html#GUID-89D19AFB-0230-49AD-8C90-7B4E77A36174" title="Run Oracle Trace File Analyzer on demand using tfactl command-line tool.">Using On-Demand Diagnostic Collections</a></p> </div> </div> </div> </div> <div class="sect2"><a id="GUID-CA919197-728E-486B-B8B4-5865A18125C6" name="GUID-CA919197-728E-486B-B8B4-5865A18125C6"></a><h3 id="AHFUG-GUID-CA919197-728E-486B-B8B4-5865A18125C6" class="sect3"><span class="enumeration_section">4.3.2 </span>Viewing System and Cluster Summary </h3> <div> <p>The summary command gives you a real-time report of system and cluster status.</p> <div class="section"> <p class="subhead2" id="GUID-CA919197-728E-486B-B8B4-5865A18125C6__GUID-2ECC7C8A-0245-4884-89DC-08C8694C6874">Syntax</p> <p><code class="codeph">tfactl summary [options]</code></p> <div class="p">For more help use:<pre class="pre codeblock"><code>tfactl summary -help</code></pre></div> </div>  </div> <div> <div class="familylinks"> <div class="parentlink"> <p><strong>Parent topic:</strong> <a href="ondemand-diagnostic-collection.html#GUID-89D19AFB-0230-49AD-8C90-7B4E77A36174" title="Run Oracle Trace File Analyzer on demand using tfactl command-line tool.">Using On-Demand Diagnostic Collections</a></p> </div> </div> </div> </div> <div class="sect2"><a id="GUID-B35603EE-90AD-4E9C-AA18-DA565EA4DC4B" name="GUID-B35603EE-90AD-4E9C-AA18-DA565EA4DC4B"></a><h3 id="AHFUG-GUID-B35603EE-90AD-4E9C-AA18-DA565EA4DC4B" class="sect3"><span class="enumeration_section">4.3.3 </span>Investigating Logs for Errors </h3> <div> <p>Use Oracle Trace File Analyzer to analyze all of your logs across your cluster to identify recent errors.</p> <ol> <li class="stepexpand"><span>To find all errors in the last one day:</span><div><pre class="pre codeblock"><code>$ tfactl analyze –last 1d</code></pre></div> </li> <li class="stepexpand"><span>To find all errors over a specified duration:</span><div><pre class="pre codeblock"><code>$ tfactl analyze –last 18h</code></pre></div> </li> <li class="stepexpand"><span>To find all occurrences of a specific error on any node, for example, to report <code class="codeph">ORA-00600</code> errors:</span><div><pre class="pre codeblock"><code>$ tfactl analyze -search “ora-00600" -last 8h</code></pre></div> </li> </ol> </div> <div> <div class="relinfo"> <p><strong>Related Topics</strong></p> <ul> <li><a href="tfactl-summary.html#GUID-6017A94F-E65E-4121-B5B8-6D71EE48DCDD" title="Use the tfactl summary command to view the summary of Oracle Trace File Analyzer deployment.">tfactl summary</a></li> <li><a href="tfactl-analyze.html#GUID-F8D3E8E6-7C50-41E4-A9D8-F15C8E6839F8" title="Use the tfactl analyze command to obtain analysis of your system by parsing the database, Oracle Automatic Storage Management (Oracle ASM), and Oracle Grid Infrastructure alert logs, system message logs, OSWatcher Top, and OSWatcher Slabinfo files.">tfactl analyze</a></li> </ul> </div> <div class="familylinks"> <div class="parentlink"> <p><strong>Parent topic:</strong> <a href="ondemand-diagnostic-collection.html#GUID-89D19AFB-0230-49AD-8C90-7B4E77A36174" title="Run Oracle Trace File Analyzer on demand using tfactl command-line tool.">Using On-Demand Diagnostic Collections</a></p> </div> </div> </div> </div> <div class="sect2"><a id="GUID-ECAB7936-8E48-4141-91F8-634DB19BE390" name="GUID-ECAB7936-8E48-4141-91F8-634DB19BE390"></a><h3 id="AHFUG-GUID-ECAB7936-8E48-4141-91F8-634DB19BE390" class="sect3"><span class="enumeration_section">4.3.4 </span>Analyzing Logs Using the Oracle Database Support Tools </h3> <div> <p>The Oracle Database support tools bundle is available only when you download Oracle Trace File Analyzer from My Oracle Support note 2550798.1.</p> <p>Oracle Trace File Analyzer with Oracle Database support tools bundle includes the following tools:</p> <div class="tblformal" id="GUID-ECAB7936-8E48-4141-91F8-634DB19BE390__GUID-17B5A047-9CF7-4292-877B-012192F67993"> <p class="titleintable">Table 4-5 Tools Included in Linux and UNIX</p> <table cellpadding="4" cellspacing="0" class="Formal" title="Tools Included in Linux and UNIX" summary="This table lists and describes tools included in Linux and UNIX." frame="hsides" border="1" rules="rows"> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" width="20%" id="d64263e991">Tool</th> <th align="left" valign="bottom" width="20%" id="d64263e993">Description</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e997" headers="d64263e991 "> <p><code class="codeph">orachk</code> or <code class="codeph">exachk</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e997 d64263e993 "> <p>Provides health checks for the Oracle stack.</p> <p>Oracle Autonomous Health Framework installs either Oracle EXAchk for engineered systems or Oracle ORAchk for all non-engineered systems.</p> <p>For more information, see My Oracle Support notes 1070954.1 and 2550798.1.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e1012" headers="d64263e991 "> <p><code class="codeph">oswatcher (oswbb)</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e1012 d64263e993 "> <p>Collects and archives operating system metrics. These metrics are useful for instance or node evictions and performance Issues.</p> <p>For more information, see My Oracle Support note 301137.1.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e1022" headers="d64263e991 "> <p><code class="codeph">procwatcher (prw)</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e1022 d64263e993 "> <p>Automates and captures database performance diagnostics and session level hang information.</p> <p>For more information, see My Oracle Support note 459694.1.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e1032" headers="d64263e991 "> <p><code class="codeph">oratop</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e1032 d64263e993 "> <p>Provides near real-time database monitoring.</p> <p>For more information, see My Oracle Support note 1500864.1.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e1042" headers="d64263e991 "> <p><code class="codeph">alertsummary</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e1042 d64263e993 "> <p>Provides summary of events for one or more database or Oracle ASM alert files from all nodes.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e1050" headers="d64263e991 "> <p><code class="codeph">ls</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e1050 d64263e993 "> <p>Lists all files that Oracle Trace File Analyzer knows about for a given file name pattern across all nodes.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e1058" headers="d64263e991 "> <p><code class="codeph">pstack</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e1058 d64263e993 "> <p>Generates the process stack for the specified processes across all nodes.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e1066" headers="d64263e991 "> <p><code class="codeph">grep</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e1066 d64263e993 "> <p>Searches for a given string in the alert or trace files with a specified database.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e1074" headers="d64263e991 "> <p><code class="codeph">summary</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e1074 d64263e993 "> <p>Provides high-level summary of the configuration.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e1082" headers="d64263e991 "> <p><code class="codeph">vi</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e1082 d64263e993 "> <p>Opens alert or trace files for viewing a given database and file name pattern in the <code class="codeph">vi</code> editor. </p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e1093" headers="d64263e991 "> <p><code class="codeph">tail</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e1093 d64263e993 "> <p>Runs a tail on an alert or trace files for a given database and file name pattern.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e1102" headers="d64263e991 "> <p><code class="codeph">param</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e1102 d64263e993 "> <p>Shows all database and operating system parameters that match a specified pattern.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e1110" headers="d64263e991 "> <p><code class="codeph">dbglevel</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e1110 d64263e993 "> <p>Sets and unsets multiple Oracle Clusterware trace levels with one command.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e1118" headers="d64263e991 "> <p><code class="codeph">history</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e1118 d64263e993 "> <p>Shows the shell history for the <code class="codeph">tfactl</code> shell. </p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e1129" headers="d64263e991 "> <p><code class="codeph">changes</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e1129 d64263e993 "> <p>Reports changes in the system setup over a given time period. The report includes database parameters, operating system parameters, and the patches that are applied.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e1137" headers="d64263e991 "> <p><code class="codeph">calog</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e1137 d64263e993 "> <p>Reports major events from the cluster event log.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e1145" headers="d64263e991 "> <p><code class="codeph">events</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e1145 d64263e993 "> <p>Reports warnings and errors in the logs.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e1153" headers="d64263e991 "> <p><code class="codeph">managelogs</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e1153 d64263e993 "> <p>Shows disk space usage and purges Automatic Diagnostic Repository (ADR) log and trace files.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e1161" headers="d64263e991 "> <p><code class="codeph">ps</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e1161 d64263e993 "> <p>Finds processes.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e1169" headers="d64263e991 "> <p><code class="codeph">triage</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e1169 d64263e993 "> <p>Summarizes <code class="codeph">oswatcher</code> or <code class="codeph">exawatcher</code> data. </p> </td> </tr> </tbody> </table> </div>  <div class="tblformal" id="GUID-ECAB7936-8E48-4141-91F8-634DB19BE390__GUID-B4392490-E12D-453E-BEED-636FAE3911A0"> <p class="titleintable">Table 4-6 Tools Included in Microsoft Windows</p> <table cellpadding="4" cellspacing="0" class="Formal" title="Tools Included in Microsoft Windows" summary="This table lists and describes tools included in Microsoft Windows." frame="hsides" border="1" rules="rows"> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" width="20%" id="d64263e1192">Tool</th> <th align="left" valign="bottom" width="20%" id="d64263e1194">Description</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e1198" headers="d64263e1192 "> <p><code class="codeph">calog</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e1198 d64263e1194 "> <p>Reports major events from the cluster event log.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e1206" headers="d64263e1192 "> <p><code class="codeph">changes</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e1206 d64263e1194 "> <p>Reports changes in the system setup over a given time period. The report includes database parameters, operating system parameters, and patches applied.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e1214" headers="d64263e1192 "> <p><code class="codeph">dir</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e1214 d64263e1194 "> <p>Lists all files Oracle Trace File Analyzer knows about for a given file name pattern across all nodes.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e1222" headers="d64263e1192 "> <p><code class="codeph">events</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e1222 d64263e1194 "> <p>Reports warnings and errors seen in the logs.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e1230" headers="d64263e1192 "> <p><code class="codeph">findstr</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e1230 d64263e1194 "> <p>Searches for a given string in the alert or trace files with a specified database.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e1238" headers="d64263e1192 "> <p><code class="codeph">history</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e1238 d64263e1194 "> <p>Shows the shell history for the <code class="codeph">tfactl</code> shell. </p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e1249" headers="d64263e1192 "> <p><code class="codeph">managelogs</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e1249 d64263e1194 "> <p>Shows disk space usage and purges ADR log and trace files.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e1257" headers="d64263e1192 "> <p><code class="codeph">notepad</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e1257 d64263e1194 "> <p>Opens alert or trace files for viewing a given database and file name pattern in the <code class="codeph">notepad</code> editor. </p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e1268" headers="d64263e1192 "> <p><code class="codeph">param</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e1268 d64263e1194 "> <p>Shows all database and operating system parameters that match a specified pattern.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e1276" headers="d64263e1192 "> <p><code class="codeph">summary</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e1276 d64263e1194 "> <p>Provides high-level summary of the configuration.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e1284" headers="d64263e1192 "> <p><code class="codeph">tasklist</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e1284 d64263e1194 "> <p>Finds processes.</p> </td> </tr> </tbody> </table> </div>  <p>To verify which tools you have installed:</p><pre class="pre codeblock"><code>$ tfactl toolstatus</code></pre><p>You can run each tool using <code class="codeph">tfactl</code> either in command line or shell mode. To run a tool from the command line: </p><pre class="pre codeblock"><code>$ tfactl run <code class="codeph">tool</code></code></pre><p>The following example shows how to use <code class="codeph">tfactl</code> in shell mode. Running the command starts <code class="codeph">tfactl</code>, connects to the database <span class="variable" translate="no">MyDB</span>, and then runs <code class="codeph">oratop</code>: </p><pre class="pre codeblock"><code>$ tfactl tfactl > database MyDB MyDB tfactl > oratop</code></pre></div> <div> <div class="relinfo"> <p><strong>Related Topics</strong></p> <ul> <li><a href="https://support.oracle.com/rs?type=doc&id=2550798.1" target="_blank">https://support.oracle.com/rs?type=doc&id=2550798.1</a></li> <li><a href="https://support.oracle.com/rs?type=doc&id=1070954.1" target="_blank">https://support.oracle.com/rs?type=doc&id=1070954.1</a></li> <li><a href="https://support.oracle.com/rs?type=doc&id=301137.1" target="_blank">https://support.oracle.com/rs?type=doc&id=301137.1</a></li> <li><a href="https://support.oracle.com/rs?type=doc&id=1500864.1" target="_blank">https://support.oracle.com/rs?type=doc&id=1500864.1</a></li> <li><a href="https://support.oracle.com/rs?type=doc&id=215187.1" target="_blank">https://support.oracle.com/rs?type=doc&id=215187.1</a></li> </ul> </div> <div class="familylinks"> <div class="parentlink"> <p><strong>Parent topic:</strong> <a href="ondemand-diagnostic-collection.html#GUID-89D19AFB-0230-49AD-8C90-7B4E77A36174" title="Run Oracle Trace File Analyzer on demand using tfactl command-line tool.">Using On-Demand Diagnostic Collections</a></p> </div> </div> </div> </div> <div class="sect2"><a id="GUID-34C415D3-D4E1-4AED-AF7A-E31CB92CD9D1" name="GUID-34C415D3-D4E1-4AED-AF7A-E31CB92CD9D1"></a><h3 id="AHFUG-GUID-34C415D3-D4E1-4AED-AF7A-E31CB92CD9D1" class="sect3"><span class="enumeration_section">4.3.5 </span>Searching Oracle Trace File Analyzer Metadata </h3> <div> <p>You can search all metadata stored in the Oracle Trace File Analyzer index using <code class="codeph">tfactl search -showdatatypes|-json [json_details]</code>. </p> <p>You can search for all events for a particular Oracle Database between certain dates.</p> <div class="p">For example, on Linux systems:<pre class="pre codeblock"><code>tfactl search -json '{ "data_type":"event", "content":"oracle", "database":"rac11g", "from":"01/20/2017 00:00:00", "to":"12/20/2018 00:00:00" }'</code></pre></div> <div class="p">For example, on Linux and Windows systems:<pre class="pre codeblock"><code>tfactl search -json "{ \"data_type\":\"event\", \"content\":\"oracle\", \"database\":\"rac11g\", \"from\":\"01/20/2017 00:00:00\", \"to\":\"12/20/2018 00:00:00\" }"</code></pre></div> <p>To list all index events on Linux, AIX, and Solaris systems: <code class="codeph">tfactl search -json '{"data_type":"event"}'</code></p> <p>To list all index events on Windows systems: <code class="codeph">tfactl search -json "{\"data_type\":\"event\"}"</code></p> <p>To list all available datatypes: <code class="codeph">tfactl search -showdatatypes</code></p> </div> <div> <div class="familylinks"> <div class="parentlink"> <p><strong>Parent topic:</strong> <a href="ondemand-diagnostic-collection.html#GUID-89D19AFB-0230-49AD-8C90-7B4E77A36174" title="Run Oracle Trace File Analyzer on demand using tfactl command-line tool.">Using On-Demand Diagnostic Collections</a></p> </div> </div> </div> </div> <div class="sect2"><a id="GUID-F8381A7A-E2F7-442C-AED0-3FEEF4129125" name="GUID-F8381A7A-E2F7-442C-AED0-3FEEF4129125"></a><h3 id="AHFUG-GUID-F8381A7A-E2F7-442C-AED0-3FEEF4129125" class="sect3"><span class="enumeration_section">4.3.6 </span>Oracle Trace File Analyzer Service Request Data Collections (SRDCs) </h3> <div> <p>Oracle Trace File Analyzer Service Request Data Collections (SRDCs) enable you to quickly collect the right diagnostic data.</p> <p>To perform Service Request Data Collections:</p><pre class="pre codeblock"><code>$ tfactl diagcollect -srdc <span class="variable" translate="no">srdc_name</span></code></pre><p>Running the command trims and collects all important log files updated in the past <span class="variable" translate="no">n</span> hours across the whole cluster. The default number of hours for log collection varies from SRDC to SRDC. You can change the <code class="codeph">diagcollect</code> timeframe with the <code class="codeph">–last <span class="variable" translate="no">n</span> h|d</code> option. </p> <p>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.</p> <p>Oracle Trace File Analyzer can run SRDC collections with a single command:</p> <div class="p"> <pre class="pre codeblock"><code>$ tfactl diagcollect [-srdc <span class="variable" translate="no">srdc_profile</span>] [–sr <span class="variable" translate="no">sr_number</span>] [-tag <span class="variable" translate="no">tagname</span>] [-z <span class="variable" translate="no">filename</span>] [-last <span class="variable" translate="no">n</span><span class="variable" translate="no">h</span>|<span class="variable" translate="no">d</span> | -from <span class="variable" translate="no">time</span> -to <span class="variable" translate="no">time</span> | -for <span class="variable" translate="no">date</span>] [-database <span class="variable" translate="no">database</span>]</code></pre> </div> <div class="tblformal" id="GUID-F8381A7A-E2F7-442C-AED0-3FEEF4129125__GUID-7F806C29-5776-45C5-99C1-E4DD9DB8FB29"> <table cellpadding="4" cellspacing="0" class="Formal" title summary="This table lists and describes tfactl diagcollect -srdc command
 options." frame="hsides" border="1" rules="rows"> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" width="20%" id="d64263e1755">Option</th> <th align="left" valign="bottom" width="20%" id="d64263e1757">Description</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e1761" headers="d64263e1755 "> <p><code class="codeph">[-srdc <span class="variable" translate="no">srdc_profile</span>]</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e1761 d64263e1757 "> <p>Specify the SRDC profile.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e1776" headers="d64263e1755 "> <p><code class="codeph">-tag <span class="variable" translate="no">description</span></code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e1776 d64263e1757 "> <p>Use this parameter to create a subdirectory for the resulting collection in the Oracle Trace File Analyzer repository.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e1790" headers="d64263e1755 "> <p><code class="codeph">-z <span class="variable" translate="no">file_name</span></code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e1790 d64263e1757 "> <p>Use this parameter to specify an output file name.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e1804" headers="d64263e1755 "> <p><code class="codeph">[-last <span class="variable" translate="no">n</span><span class="variable" translate="no">h</span>|<span class="variable" translate="no">d</span> | -from <span class="variable" translate="no">time</span> -to <span class="variable" translate="no">time</span> | -for <span class="variable" translate="no">date</span>]</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e1804 d64263e1757 "> <div class="p"> <ul style="list-style-type: disc;" id="GUID-F8381A7A-E2F7-442C-AED0-3FEEF4129125__UL_KSR_WTY_MMB"> <li> <p>Specify the <code class="codeph">-last</code> parameter to collect files that have relevant data for the past specific number of hours (<span class="variable" translate="no">h</span>) or days (<span class="variable" translate="no">d</span>). By default, using the command with this parameter also trims files that are large and shows files only from the specified interval. </p> <p>You can also use <code class="codeph">-since</code>, which has the same functionality as <code class="codeph">-last</code>. This option is included for backward compatibility. </p> </li> <li> <p>Specify the <code class="codeph">-from</code> and <code class="codeph">-to</code> 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. </p> <p>Supported time formats:</p> <p><code class="codeph">"Mon/dd/yyyy hh:mm:ss"</code></p> <p><code class="codeph">"yyyy-mm-dd hh:mm:ss"</code></p> <p><code class="codeph">"yyyy-mm-ddThh:mm:ss"</code></p> <p><code class="codeph">"yyyy-mm-dd"</code></p> </li> <li> <p>Specify the <code class="codeph">-for</code> parameter to collect files that have relevant data for the date specified. The files <code class="codeph">tfactl</code> collects will have timestamps in between which the time you specify after <code class="codeph">-for</code> is included. No data trimming is done for this option. </p> <p>Supported time formats:</p> <p><code class="codeph">"Mon/dd/yyyy"</code></p> <p><code class="codeph">"yyyy-mm-dd"</code></p> </li> </ul> </div> <div class="p"> <div class="infoboxnote" id="GUID-F8381A7A-E2F7-442C-AED0-3FEEF4129125__GUID-088CFD36-B285-4A5D-BEE3-3D58A35E5E1D"> <p class="notep1">Note:</p> <p>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.</p> </div> </div> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e1923" headers="d64263e1755 "> <p><code class="codeph">-database <span class="variable" translate="no">database</span></code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e1923 d64263e1757 "> <p>Specify the name of the database.</p> </td> </tr> </tbody> </table> </div>  <div class="infoboxnote" id="GUID-F8381A7A-E2F7-442C-AED0-3FEEF4129125__GUID-D6216DDC-4187-4CFA-97E9-CACDE0593D76"> <p class="notep1">Note:</p> <p>To upload collections to the SR as part of diag collection:</p> <p>If you have already set MOS configuration using the <code class="codeph">tfactl setupmos</code> command, then you can use the <code class="codeph">-sr</code> option along with the diag collection command. Note that <code class="codeph">tfactl setupmos</code> is supported only in versions earlier than 20.2. </p> <p>If you have not set MOS configuration using the <code class="codeph">tfactl setupmos</code> command, then set up MOS configuration using the new generic command, <code class="codeph">ahfctl setupload -name mos -type https</code> and follow the instructions. </p> <p>For example: <code class="codeph">tfactl diagcollect -srdc <span class="variable" translate="no">srdc_type</span> –sr <span class="variable" translate="no">sr_number</span></code></p> </div> <p>To run SRDCs, use one of the Oracle privileged user accounts:</p> <ul style="list-style-type: disc;"> <li><code class="codeph">ORACLE_HOME</code> owner </li> <li><code class="codeph">GRID_HOME</code> owner </li> </ul> <div class="tblformal" id="GUID-F8381A7A-E2F7-442C-AED0-3FEEF4129125__GUID-47A50EC2-C409-490D-9EB4-8F73526093B2"> <p class="titleintable">Table 4-7 One Command Service Request Data Collections</p> <table cellpadding="4" cellspacing="0" class="Formal" title="One Command Service Request Data Collections" summary="This table lists and describes one command Service Request Data Collections (SRDC)." frame="hsides" border="1" rules="rows"> <thead> <tr align="left" valign="top"> <th colspan="2" align="left" valign="bottom" id="d64263e1997">Available SRDCs</th> <th colspan="2" align="left" valign="bottom" id="d64263e1999">Type of Problem</th> <th align="left" valign="bottom" width="20%" id="d64263e2001">Collection Scope</th> <th align="left" valign="bottom" width="20%" id="d64263e2003">Auto Collection</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e2007" headers="d64263e1997 "> <p><code class="codeph">ahf</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e2007 d64263e1999 "> <p><span>Oracle Orachk</span> and <span>Oracle Exachk</span> problems (to be run after running with <code class="codeph">-debug</code>) </p> </td> <td align="left" valign="top" width="20%" headers="d64263e2007 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2007 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e2037" headers="d64263e1997 "> <p><code class="codeph">avs</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e2037 d64263e1999 "> <p>Audit Vault Server related files</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2037 d64263e2001 "> <p>Cluster-wide</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2037 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e2051" headers="d64263e1997 "> <p><code class="codeph">crs</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e2051 d64263e1999 "> <p>Collect <code class="codeph">crs</code> traces </p> </td> <td align="left" valign="top" width="20%" headers="d64263e2051 d64263e2001 "> <p>Cluster-wide</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2051 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e2076" headers="d64263e1997 "> <p><code class="codeph">crsasm</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e2076 d64263e1999 "> <p>ASM CRS-related problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2076 d64263e2001 "> <p>Cluster-wide</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2076 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e2098" headers="d64263e1997 "> <p><code class="codeph">crsasmcell</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e2098 d64263e1999 "> <p>ASM CRS CELL-related problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2098 d64263e2001 "> <p>Cluster-wide</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2098 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e2120" headers="d64263e1997 "> <p><code class="codeph">dbacl</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e2120 d64263e1999 "> <p>Problems with Access Control Lists (ACLs)</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2120 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2120 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e2142" headers="d64263e1997 "> <p><code class="codeph">dbaqgen</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e2142 d64263e1999 "> <p>Problems in an Oracle Advanced Queuing environment</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2142 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2142 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e2164" headers="d64263e1997 "> <p><code class="codeph">dbaqmon</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e2164 d64263e1999 "> <p>Queue Monitor (QMON) problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2164 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2164 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e2186" headers="d64263e1997 "> <p><code class="codeph">dbaqnotify</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e2186 d64263e1999 "> <p>Notification problems in an Oracle Advanced Queuing environment</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2186 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2186 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e2208" headers="d64263e1997 "> <p><code class="codeph">dbaqperf</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e2208 d64263e1999 "> <p>Performance problems in an Oracle Advanced Queuing environment</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2208 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2208 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e2230" headers="d64263e1997 "> <p><code class="codeph">dbaqpurge</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e2230 d64263e1999 "> <p>Non-purged messages in an Oracle Advanced Queuing environment problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2230 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2230 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e2253" headers="d64263e1997 "> <p><code class="codeph">dbasm</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e2253 d64263e1999 "> <p>Oracle Database storage problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2253 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2253 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e2275" headers="d64263e1997 "> <p><code class="codeph">dbaudit</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e2275 d64263e1999 "> <p>Standard information for Oracle Database auditing</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2275 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2275 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e2297" headers="d64263e1997 "> <p><code class="codeph">dbaum</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e2297 d64263e1999 "> <p>AUM: Checklist of Evidence to Supply (Doc ID 1682741.1)</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2297 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2297 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e2319" headers="d64263e1997 "> <p><code class="codeph">dbaumwaitevents</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e2319 d64263e1999 "> <p>Wait Events related to Undo: Checklist of Evidence to Supply (Doc ID 1682723.1)</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2319 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2319 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e2341" headers="d64263e1997 "> <p><code class="codeph">dbawrspace</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e2341 d64263e1999 "> <p>Oracle Database Automatic Workload Repository (AWR) space problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2341 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2341 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e2363" headers="d64263e1997 "> <p><code class="codeph">dbbeqconnection</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e2363 d64263e1999 "> <p>Bequeath Connection Issues: Checklist of Evidence to Supply (Doc ID 1928047.1)</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2363 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2363 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e2385" headers="d64263e1997 "> <p><code class="codeph">dbcorrupt</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e2385 d64263e1999 "> <p>Generic Oracle Database corruption</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2385 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2385 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e2407" headers="d64263e1997 "> <p><code class="codeph">dbdataguard</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e2407 d64263e1999 "> <p>Data Guard problems including Broker</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2407 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2407 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e2429" headers="d64263e1997 "> <p><code class="codeph">dbawrspace</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e2429 d64263e1999 "> <p>Excessive SYSAUX space is used by the Automatic Workload Repository (AWR)</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2429 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2429 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e2451" headers="d64263e1997 "> <p><code class="codeph">dbdatapatch</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e2451 d64263e1999 "> <p>Datapatch problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2451 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2451 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e2473" headers="d64263e1997 "> <p><code class="codeph">dbddlerrors</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e2473 d64263e1999 "> <p>DDL Errors: Checklist of Evidence to Supply (Doc ID 2383662.1)</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2473 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2473 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e2496" headers="d64263e1997 "> <p><code class="codeph">dbemon</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e2496 d64263e1999 "> <p>Event Monitor (EMON) problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2496 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2496 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e2518" headers="d64263e1997 "> <p><code class="codeph">dbenqdeq</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e2518 d64263e1999 "> <p>Collect standard information for Advanced Queueing problems using TFA Collector (recommended) or manual steps</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2518 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2518 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e2540" headers="d64263e1997 "> <p><code class="codeph">dbexpdp</code></p> <p><code class="codeph">dbexpdpapi</code></p> <p><code class="codeph">dbexpdpperf</code></p> <p><code class="codeph">dbexpdptts</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e2540 d64263e1999 "> <p>Oracle Data Pump Export (<code class="codeph">expdp</code>) </p> </td> <td align="left" valign="top" width="20%" headers="d64263e2540 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2540 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e2577" headers="d64263e1997 "> <p><code class="codeph">dbfs</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e2577 d64263e1999 "> <p>Oracle Automatic Storage Management (Oracle ASM) / Database File System (DBFS) / Direct NFS / Oracle Advanced Cluster File System (Oracle ACFS) problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2577 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2577 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e2599" headers="d64263e1997 "> <p><code class="codeph">dbfra</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e2599 d64263e1999 "> <p>Fast Recovery Area, also known as Flash Recovery Area problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2599 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2599 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e2621" headers="d64263e1997 "> <p><code class="codeph">dbggclassicmode</code></p> <p><code class="codeph">dbggintegratedmode</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e2621 d64263e1999 "> <p>Oracle GoldenGate</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2621 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2621 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e2647" headers="d64263e1997 "> <p><code class="codeph">dbhang</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e2647 d64263e1999 "> <p>Oracle Database hang problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2647 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2647 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e2669" headers="d64263e1997 "> <p><code class="codeph">dbhangperflite</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e2669 d64263e1999 "> <p>Oracle Database performance and hang problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2669 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2669 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e2691" headers="d64263e1997 "> <p><code class="codeph">dbimpdp</code></p> <p><code class="codeph">dbimpdpperf</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e2691 d64263e1999 "> <p>Oracle Data Pump Import (<code class="codeph">impdp</code>) </p> </td> <td align="left" valign="top" width="20%" headers="d64263e2691 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2691 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e2720" headers="d64263e1997 "> <p><code class="codeph">dbimpdpperf</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e2720 d64263e1999 "> <p>Data Pump Import performance problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2720 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2720 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e2742" headers="d64263e1997 "> <p><code class="codeph">dbinstall</code></p> <p><code class="codeph">dbupgrade</code></p> <p><code class="codeph">dbpreupgrade</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e2742 d64263e1999 "> <p>Oracle Database install / upgrade problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2742 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2742 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e2773" headers="d64263e1997 "> <p><code class="codeph">dbparameters</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e2773 d64263e1999 "> <p>Oracle Database single instance shutdown problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2773 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2773 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e2795" headers="d64263e1997 "> <p><code class="codeph">dbparameterfiles</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e2795 d64263e1999 "> <p>Parameter Files: Checklist of Evidence to Supply (Doc ID 1914153.1)</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2795 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2795 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e2817" headers="d64263e1997 "> <p><code class="codeph">dbpartition</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e2817 d64263e1999 "> <p>Create or maintain partitioned table, subpartitioned table, and index problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2817 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2817 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e2839" headers="d64263e1997 "> <p><code class="codeph">dbpartitionperf</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e2839 d64263e1999 "> <p>Slow <code class="codeph">Create</code>, <code class="codeph">Alter</code>, or <code class="codeph">Drop</code> commands against partitioned table or index </p> </td> <td align="left" valign="top" width="20%" headers="d64263e2839 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2839 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e2870" headers="d64263e1997 "> <p><code class="codeph">dbpatchinstall</code></p> <p><code class="codeph">dbpatchconflict</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e2870 d64263e1999 "> <p>Oracle Database patching problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2870 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2870 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e2896" headers="d64263e1997 "> <p><code class="codeph">dbperf</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e2896 d64263e1999 "> <p>Oracle Database performance problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2896 d64263e2001 "> <p>Cluster-wide</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2896 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e2918" headers="d64263e1997 "> <p><code class="codeph">dbperf_and_hang</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e2918 d64263e1999 "> <p>Oracle Database performance and hang problems on FASaaS environments</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2918 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2918 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e2940" headers="d64263e1997 "> <p><code class="codeph">dbplugincompliance</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e2940 d64263e1999 "> <p>Enterprise Manager compliance related issues</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2940 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2940 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e2962" headers="d64263e1997 "> <p><code class="codeph">dbpreupgrade</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e2962 d64263e1999 "> <p>Oracle Database preupgrade problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2962 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2962 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e2984" headers="d64263e1997 "> <p><code class="codeph">dbprocmgmt</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e2984 d64263e1999 "> <p>Generic Process Management and Related Issues: Checklist of Evidence to Supply (Doc ID 2500734.1)</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2984 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e2984 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e3006" headers="d64263e1997 "> <p><code class="codeph">dbrac</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e3006 d64263e1999 "> <p>Oracle RAC-related data collection for Oracle Clusterware and Oracle ASM problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3006 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3006 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e3029" headers="d64263e1997 "> <p><code class="codeph">dbracinst</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e3029 d64263e1999 "> <p>Oracle RAC-related data collection for Oracle Database problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3029 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3029 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e3051" headers="d64263e1997 "> <p><code class="codeph">dbracperf</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e3051 d64263e1999 "> <p>Oracle RAC-related performance problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3051 d64263e2001 ">Cluster-wide</td> <td align="left" valign="top" width="20%" headers="d64263e3051 d64263e2003 ">No</td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e3067" headers="d64263e1997 "> <p><code class="codeph">dbresmgr</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e3067 d64263e1999 "> <p>Oracle Database problems related to Resource Manager</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3067 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3067 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e3089" headers="d64263e1997 "> <p><code class="codeph">dbrman</code></p> <p><code class="codeph">dbrmanperf</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e3089 d64263e1999 "> <p>Recovery Manager (RMAN) problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3089 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3089 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e3115" headers="d64263e1997 "> <p><code class="codeph">dbscn</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e3115 d64263e1999 "> <p>System Change Number (SCN)</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3115 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3115 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e3137" headers="d64263e1997 "> <p><code class="codeph">dbshutdown</code></p> <p><code class="codeph">dbstartup</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e3137 d64263e1999 "> <p>Oracle Database startup or shutdown problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3137 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3137 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e3163" headers="d64263e1997 "> <p><code class="codeph">dbslowddl</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e3163 d64263e1999 "> <p>Slow DDL: Checklist of Evidence to Supply</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3163 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3163 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e3185" headers="d64263e1997 "> <p><code class="codeph">dbspacewait</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e3185 d64263e1999 "> <p>Space Related Wait Events and Performance Issues : Checklist of Evidence to Supply (Doc ID 2560286.1)</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3185 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3185 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e3207" headers="d64263e1997 "> <p><code class="codeph">dbspatialexportimport</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e3207 d64263e1999 "> <p>Oracle Spatial export or import problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3207 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3207 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e3229" headers="d64263e1997 "> <p><code class="codeph">dbspatialinstall</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e3229 d64263e1999 "> <p>Oracle Spatial installation problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3229 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3229 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e3251" headers="d64263e1997 "> <p><code class="codeph">dbspatialperf</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e3251 d64263e1999 "> <p>Oracle Spatial performance problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3251 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3251 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e3274" headers="d64263e1997 "> <p><code class="codeph">dbspatialupgrade</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e3274 d64263e1999 "> <p>Oracle Spatial upgrade problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3274 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3274 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e3296" headers="d64263e1997 "> <p><code class="codeph">dbspatialusage</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e3296 d64263e1999 "> <p>Oracle Spatial usage problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3296 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3296 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e3318" headers="d64263e1997 "> <p><code class="codeph">dbsqlperf</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e3318 d64263e1999 "> <p>SQL performance problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3318 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3318 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e3340" headers="d64263e1997 "> <p><code class="codeph">dbstandalonedbca</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e3340 d64263e1999 "> <p>Oracle Database Configuration Assistant (Oracle DBCA) problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3340 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3340 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e3362" headers="d64263e1997 "> <p><code class="codeph">dbstoragestructuregeneric</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e3362 d64263e1999 "> <p>Storage structure related diagnosis</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3362 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3362 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e3384" headers="d64263e1997 "> <p><code class="codeph">dbtablespacegeneric</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e3384 d64263e1999 "> <p>Generic Tablespace and Segment Management: Checklist of Evidence to Supply (Doc ID 2560291.1)</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3384 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3384 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e3406" headers="d64263e1997 "> <p><code class="codeph">dbtde</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e3406 d64263e1999 "> <p>Transparent Data Encryption (TDE) problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3406 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3406 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e3428" headers="d64263e1997 "> <p><code class="codeph">dbtextindex</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e3428 d64263e1999 "> <p>Oracle Text problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3428 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3428 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e3450" headers="d64263e1997 "> <p><code class="codeph">dbtextissue</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e3450 d64263e1999 "> <p>Oracle Text installation problems - 12c.</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3450 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3450 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e3472" headers="d64263e1997 "> <p><code class="codeph">dbtextupgrade</code></p> <p><code class="codeph">dbtextinstall</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e3472 d64263e1999 "> <p>Oracle Text version 12.1.0.1 and later upgrade problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3472 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3472 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e3498" headers="d64263e1997 "> <p><code class="codeph">dbunixresources</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e3498 d64263e1999 "> <p>Oracle Database resource problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3498 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3498 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e3521" headers="d64263e1997 "> <p><code class="codeph">dbvault</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e3521 d64263e1999 "> <p>Collect standard information for Database Vault</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3521 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3521 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e3543" headers="d64263e1997 "> <p><code class="codeph">dbwindowsresources</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e3543 d64263e1999 "> <p>Oracle Database on Microsoft Windows resources: Checklist of Evidence to Supply</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3543 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3543 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e3565" headers="d64263e1997 "> <p><code class="codeph">dbwinservice</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e3565 d64263e1999 "> <p>OracleService on Microsoft Windows: Checklist of Evidence to Supply (Doc ID 1918781.1)</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3565 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3565 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e3587" headers="d64263e1997 "> <p><code class="codeph">dbxdb</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e3587 d64263e1999 "> <p>XDB installation or invalid object problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3587 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3587 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e3609" headers="d64263e1997 "> <p><code class="codeph">dbxdbgeneric</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e3609 d64263e1999 "> <p>XDB installation and invalid object problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3609 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3609 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e3631" headers="d64263e1997 "> <p><code class="codeph">dbxdbupgrade</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e3631 d64263e1999 "> <p>XDB installation and invalid object problems in 12c and above</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3631 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3631 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e3653" headers="d64263e1997 "> <p><code class="codeph">dnfs</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e3653 d64263e1999 "> <p>XDB upgrade problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3653 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3653 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e3675" headers="d64263e1997 "> <p><code class="codeph">emagentgeneric</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e3675 d64263e1999 "> <p>Collect trace/log information for Enterprise Manager Management Agent generic problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3675 d64263e2001 "> <p>Oracle Management Service (OMS) and Agent</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3675 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e3697" headers="d64263e1997 "> <p><code class="codeph">emagentpatching</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e3697 d64263e1999 "> <p>Enterprise Manager failures during agent patching</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3697 d64263e2001 "> <p>Oracle Management Service (OMS) and Agent</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3697 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e3719" headers="d64263e1997 "> <p><code class="codeph">emagentperf</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e3719 d64263e1999 "> <p>Enterprise Manager 13c Agent performance problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3719 d64263e2001 "> <p>Agent</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3719 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e3741" headers="d64263e1997 "> <p><code class="codeph">emagentssl</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e3741 d64263e1999 "> <p>Enterprise Manager Agent SSL configuration issues </p> </td> <td align="left" valign="top" width="20%" headers="d64263e3741 d64263e2001 "> <p>Oracle Management Service (OMS) and Agent</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3741 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e3764" headers="d64263e1997 "> <p><code class="codeph">emagentstartup</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e3764 d64263e1999 "> <p>Enterprise Manager 13c Agent startup problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3764 d64263e2001 "> <p>Agent</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3764 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e3786" headers="d64263e1997 "> <p><code class="codeph">emagentunreach</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e3786 d64263e1999 "> <p>Enterprise Manager 13c Agent unreachable errors or status</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3786 d64263e2001 "> <p>Agent</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3786 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e3808" headers="d64263e1997 "> <p><code class="codeph">emagentupload</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e3808 d64263e1999 "> <p>Enterprise Manager 13c Agent upload errors</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3808 d64263e2001 "> <p>Agent</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3808 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e3830" headers="d64263e1997 "> <p><code class="codeph">emagtpatchdeploy</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e3830 d64263e1999 "> <p>Enterprise Manager 13c Agent patch deployment problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3830 d64263e2001 "> <p>Oracle Management Service (OMS) and Agent</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3830 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e3852" headers="d64263e1997 "> <p><code class="codeph">emagtupginst</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e3852 d64263e1999 "> <p>Collecting diagnostic data for Enterprise Manager 13c Agent installation, upgrade, or deployment problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3852 d64263e2001 "> <p>Agent</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3852 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e3874" headers="d64263e1997 "> <p><code class="codeph">emagtupgpatch</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e3874 d64263e1999 "> <p>Enterprise Manager 13c Agent upgrade, local installation, or patching problems.</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3874 d64263e2001 "> <p>Oracle Management Service (OMS) and Agent</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3874 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e3896" headers="d64263e1997 "> <p><code class="codeph">emauthldap</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e3896 d64263e1999 "> <p>Enterprise Manager authentication using LDAP provider issues</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3896 d64263e2001 "> <p>Oracle Management Service (OMS)</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3896 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e3918" headers="d64263e1997 "> <p><code class="codeph">emblackout</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e3918 d64263e1999 "> <p>Enterprise Manager blackout issues</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3918 d64263e2001 "> <p>Oracle Management Service (OMS) and Agent</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3918 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e3940" headers="d64263e1997 "> <p><code class="codeph">emcliadd</code></p> <p><code class="codeph">emclusdisc</code></p> <p><code class="codeph">emdbsys</code></p> <p><code class="codeph">emgendisc</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e3940 d64263e1999 "> <p>Enterprise Manager target discovery or add problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3940 d64263e2001 "> <p>Oracle Management Service (OMS) and Agent</p> <p>Agent</p> <p>Oracle Management Service (OMS) and Agent</p> <p>Oracle Management Service (OMS) and Agent</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3940 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e3983" headers="d64263e1997 "> <p><code class="codeph">emcomm</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e3983 d64263e1999 "> <p>Enterprise Manager communication information between Oracle Management Service (OMS) and Agent</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3983 d64263e2001 "> <p>Oracle Management Service (OMS) and Agent</p> </td> <td align="left" valign="top" width="20%" headers="d64263e3983 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e4005" headers="d64263e1997 "> <p><code class="codeph">emdbaasdeploy</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e4005 d64263e1999 "> <p>Database As A Service (DBaaS): Collect trace or log information for failures during DBaaS deployment.</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4005 d64263e2001 "> <p>Oracle Management Service (OMS) and remote DBaaS deployment server</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4005 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e4028" headers="d64263e1997 "> <p><code class="codeph">emdebugon</code></p> <p><code class="codeph">emdebugoff</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e4028 d64263e1999 "> <p>Enterprise Manager debug log collection</p> <p>Run <code class="codeph">emdebugon</code>, reproduce the problem then run <code class="codeph">emdebugoff</code>, which disables debug again and collects debug logs </p> </td> <td align="left" valign="top" width="20%" headers="d64263e4028 d64263e2001 "> <p>Oracle Management Service (OMS) or Agent</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4028 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e4063" headers="d64263e1997 "> <p><code class="codeph">emfleetpatching</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e4063 d64263e1999 "> <p>Enterprise Manager Fleet Maintenance Patching problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4063 d64263e2001 "> <p>Oracle Management Service (OMS) and Agent</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4063 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e4085" headers="d64263e1997 "> <p><code class="codeph">emjobs</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e4085 d64263e1999 "> <p>Enterprise Manager all job related issues</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4085 d64263e2001 "> <p>Oracle Management Service (OMS)</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4085 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e4107" headers="d64263e1997 "> <p><code class="codeph">emmetricalert</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e4107 d64263e1999 "> <p>Enterprise Manager general metrics page or threshold problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4107 d64263e2001 "> <p>Agent</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4107 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e4129" headers="d64263e1997 "> <p><code class="codeph">emnotif</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e4129 d64263e1999 "> <p>Enterprise Manager incident rules and notification issues</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4129 d64263e2001 "> <p>Oracle Management Service (OMS)</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4129 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e4151" headers="d64263e1997 "> <p><code class="codeph">emomsfailstart</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e4151 d64263e1999 "> <p>Enterprise Manager Oracle Management Service (OMS) startup failures</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4151 d64263e2001 "> <p>Oracle Management Service (OMS)</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4151 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e4173" headers="d64263e1997 "> <p><code class="codeph">emomscrash</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e4173 d64263e1999 "> <p>Enterprise Manager Oracle Management Service (OMS) crash problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4173 d64263e2001 "> <p>Oracle Management Service (OMS)</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4173 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e4195" headers="d64263e1997 "> <p><code class="codeph">emomsheap</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e4195 d64263e1999 "> <p>Enterprise Manager Java heap usage or performance problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4195 d64263e2001 "> <p>Oracle Management Service (OMS)</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4195 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e4217" headers="d64263e1997 "> <p><code class="codeph">emomshungcpu</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e4217 d64263e1999 "> <p>Enterprise Manager Oracle Management Service (OMS) crash, restart or performance problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4217 d64263e2001 "> <p>Oracle Management Service (OMS)</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4217 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e4239" headers="d64263e1997 "> <p><code class="codeph">emomspatching</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e4239 d64263e1999 "> <p>Enterprise Manager failures during Oracle Management Service (OMS) patching </p> </td> <td align="left" valign="top" width="20%" headers="d64263e4239 d64263e2001 "> <p>Oracle Management Service (OMS)</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4239 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e4261" headers="d64263e1997 "> <p><code class="codeph">emomsssl</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e4261 d64263e1999 "> <p>Enterprise Manager Oracle Management Service (OMS) SSL configuration issues </p> </td> <td align="left" valign="top" width="20%" headers="d64263e4261 d64263e2001 "> <p>Oracle Management Service (OMS)</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4261 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e4284" headers="d64263e1997 "> <p><code class="codeph">emomsupginst</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e4284 d64263e1999 "> <p>Enterprise Manager Oracle Management Service (OMS) installation, upgrade, and patching </p> </td> <td align="left" valign="top" width="20%" headers="d64263e4284 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4284 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e4306" headers="d64263e1997 "> <p><code class="codeph">empatchplancrt</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e4306 d64263e1999 "> <p>Enterprise Manager patch plan creation problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4306 d64263e2001 "> <p>Oracle Management Service (OMS) and Agent</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4306 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e4328" headers="d64263e1997 "> <p><code class="codeph">emprocdisc</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e4328 d64263e1999 "> <p>Oracle Database, Listener, or ASM target is not discovered or detected by the discovery process</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4328 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4328 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e4350" headers="d64263e1997 "> <p><code class="codeph">emtbsmetric</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e4350 d64263e1999 "> <p>Enterprise Manager tablespace usage metric problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4350 d64263e2001 "> <p>Local only (on Enterprise Manager Agent target)</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4350 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e4372" headers="d64263e1997 "> <p><code class="codeph">emwlsssl</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e4372 d64263e1999 "> <p>Enterprise Manager WebLogic Server (WLS) SSL configuration issues</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4372 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4372 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e4394" headers="d64263e1997 "> <p><code class="codeph">emdbrat</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e4394 d64263e1999 "> <p>Enterprise Manager RAT collection issues</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4394 d64263e2001 "> <p>Target replay/capture database</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4394 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e4416" headers="d64263e1997 "> <p><code class="codeph">emcreds</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e4416 d64263e1999 "> <p>Enterprise Manager credential issues</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4416 d64263e2001 "> <p>Oracle Management Service (OMS) and Agent</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4416 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e4438" headers="d64263e1997 "> <p><code class="codeph">emdbpluginstatus</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e4438 d64263e1999 "> <p>Enterprise Manager DB plugin issues</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4438 d64263e2001 "> <p>Oracle Management Service (OMS) and/or Agent</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4438 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e4460" headers="d64263e1997 "> <p><code class="codeph">emdeployoms</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e4460 d64263e1999 "> <p>Enterprise Manager deploying additional Oracle Management Service (OMS) issues</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4460 d64263e2001 "> <p>Oracle Management Service (OMS)</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4460 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e4482" headers="d64263e1997 "> <p><code class="codeph">emomsmigration</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e4482 d64263e1999 "> <p>Enterpriser Manager Oracle Management Service (OMS) migration/cloning issues</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4482 d64263e2001 "> <p>Oracle Management Service (OMS)</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4482 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e4504" headers="d64263e1997 "> <p><code class="codeph">esexalogic</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e4504 d64263e1999 "> <p>Oracle Exalogic full Exalogs data collection information</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4504 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4504 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e4527" headers="d64263e1997 "> <p><code class="codeph">exadata</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e4527 d64263e1999 "> <p>Collect Oracle Exadata information</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4527 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4527 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e4549" headers="d64263e1997 "> <p><code class="codeph">exservice</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e4549 d64263e1999 "> <p>Oracle Exadata: Storage software service or offload server service problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4549 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4549 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e4571" headers="d64263e1997 "> <p><code class="codeph">exsmartscan</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e4571 d64263e1999 "> <p>Oracle Exadata: Smart Scan not working problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4571 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4571 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e4593" headers="d64263e1997 "> <p><code class="codeph">generic</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e4593 d64263e1999 "> <p>Fallthrough SRDC for Oracle Database error</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4593 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4593 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e4615" headers="d64263e1997 "> <p><code class="codeph">gg_abend</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e4615 d64263e1999 "> <p>Oracle GoldenGate covering both classic and microservices implementations</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4615 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4615 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e4637" headers="d64263e1997 "> <p><code class="codeph">ggintegratedmodenodb</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e4637 d64263e1999 "> <p>Oracle GoldenGate extract/replicate abends problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4637 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4637 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e4659" headers="d64263e1997 "> <p><code class="codeph">gridinfra</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e4659 d64263e1999 "> <p>Oracle RAC-related data collection for Oracle Clusterware problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4659 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4659 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e4681" headers="d64263e1997 "> <p><code class="codeph">gridinfrainst</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e4681 d64263e1999 "> <p>Oracle RAC upgrade and patching problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4681 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4681 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e4703" headers="d64263e1997 "> <p><code class="codeph">instterm</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e4703 d64263e1999 "> <div class="p">Collect traces for the following ORA errors: <ul style="list-style-type: disc;" id="GUID-F8381A7A-E2F7-442C-AED0-3FEEF4129125__UL_C1Y_PTT_3SB"> <li><code class="codeph">ORA-00469</code></li> <li><code class="codeph">ORA-00470</code></li> <li><code class="codeph">ORA-00480</code></li> <li><code class="codeph">ORA-00490</code></li> <li><code class="codeph">ORA-00491</code></li> <li><code class="codeph">ORA-00492</code></li> <li><code class="codeph">ORA-00493</code></li> <li><code class="codeph">ORA-00495</code></li> <li><code class="codeph">ORA-00496</code></li> <li><code class="codeph">ORA-00497</code></li> <li><code class="codeph">ORA-00498</code></li> </ul> </div> </td> <td align="left" valign="top" width="20%" headers="d64263e4703 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4703 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e4759" headers="d64263e1997 "> <p><code class="codeph">internalerror</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e4759 d64263e1999 "> <p>Other internal Oracle Database errors</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4759 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4759 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e4781" headers="d64263e1997 "> <p><code class="codeph">listener_services</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e4781 d64263e1999 "> <p>Listener errors: <code class="codeph">TNS-12516</code> / <code class="codeph">TNS-12518</code> / <code class="codeph">TNS-12519</code> / <code class="codeph">TNS-12520</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e4781 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4781 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e4815" headers="d64263e1997 "> <p><code class="codeph">naming_services</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e4815 d64263e1999 "> <p>Naming service errors: <code class="codeph">TNS-12154</code> / <code class="codeph">TNS-12528</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e4815 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4815 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e4842" headers="d64263e1997 "> <p><code class="codeph">ORA-00020</code></p> <p><code class="codeph">ORA-00060</code></p> <p><code class="codeph">ORA-00494</code></p> <p><code class="codeph">ORA-00600</code></p> <p><code class="codeph">ORA-00700</code></p> <p><code class="codeph">ORA-01031</code></p> <p><code class="codeph">ORA-01555</code></p> <p><code class="codeph">ORA-01578</code></p> <p><code class="codeph">ORA-01628</code></p> <p><code class="codeph">ORA-03137</code></p> <p><code class="codeph">ORA-04020</code></p> <p><code class="codeph">ORA-04021</code></p> <p><code class="codeph">ORA-04030</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e4842 d64263e1997 "> <p><code class="codeph">ORA-04023</code></p> <p><code class="codeph">ORA-04031</code></p> <p><code class="codeph">ORA-04063</code></p> <p><code class="codeph">ORA-07445</code></p> <p><code class="codeph">ORA-08102</code></p> <p><code class="codeph">ORA-08103</code></p> <p><code class="codeph">ORA-22924</code></p> <p><code class="codeph">ORA-27300</code></p> <p><code class="codeph">ORA-27301</code></p> <p><code class="codeph">ORA-27302</code></p> <p><code class="codeph">ORA-30036</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e4842 d64263e1999 "> <p>ORA Errors</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4842 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4842 d64263e2003 "> <div class="p">Only the following SRDCs: <ul style="list-style-type: disc;" id="GUID-F8381A7A-E2F7-442C-AED0-3FEEF4129125__UL_MDB_ZDC_KNB"> <li><code class="codeph">ORA-00600</code></li> <li><code class="codeph">ORA-04030</code></li> <li><code class="codeph">ORA-04031</code></li> <li><code class="codeph">ORA-04021</code></li> <li><code class="codeph">ORA-07445</code></li> <li><code class="codeph">ORA-01578</code></li> </ul> </div> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e4980" headers="d64263e1997 "> <p><code class="codeph">ORA-01000</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e4980 d64263e1999 "> <p>Open Cursors problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4980 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e4980 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e5002" headers="d64263e1997 "> <p><code class="codeph">ORA-00018</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e5002 d64263e1999 "> <p><code class="codeph">ORA-00018</code> or sessions parameter problems </p> </td> <td align="left" valign="top" width="20%" headers="d64263e5002 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e5002 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e5026" headers="d64263e1997 "> <p><code class="codeph">ORA-12751</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e5026 d64263e1999 "> <p><code class="codeph">ORA-12751</code> collection errors </p> </td> <td align="left" valign="top" width="20%" headers="d64263e5026 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e5026 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e5050" headers="d64263e1997 "> <p><code class="codeph">ORA-25319</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e5050 d64263e1999 "> <p>Collect information for troubleshooting <code class="codeph">ORA-25319</code> error in an Advanced Queuing Environment </p> <p><code class="codeph">ORA-25319</code> problems in an Oracle Advanced Queuing Environment </p> </td> <td align="left" valign="top" width="20%" headers="d64263e5050 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e5050 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e5080" headers="d64263e1997 "> <p><code class="codeph">ORA-00227</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e5080 d64263e1999 "> <p>Collect information for troubleshooting Control File block corruption reported by error <code class="codeph">ORA-00227</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e5080 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e5080 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e5104" headers="d64263e1997 "> <p><code class="codeph">privsroles</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e5104 d64263e1999 "> <p>Data Collection for privileges and roles</p> </td> <td align="left" valign="top" width="20%" headers="d64263e5104 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e5104 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e5126" headers="d64263e1997 "> <p><code class="codeph">xdb600</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e5126 d64263e1999 "> <p>Diagnostic data collection for XDB <code class="codeph">ORA-00600</code> and <code class="codeph">ORA-07445</code> internal rrror issues using TFA Collector </p> </td> <td align="left" valign="top" width="20%" headers="d64263e5126 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e5126 d64263e2003 "> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td colspan="2" align="left" valign="top" id="d64263e5154" headers="d64263e1997 "> <p><code class="codeph">zlgeneric</code></p> </td> <td colspan="2" align="left" valign="top" headers="d64263e5154 d64263e1999 "> <p>Zero Data Loss Recovery Appliance (ZDLRA) problems</p> </td> <td align="left" valign="top" width="20%" headers="d64263e5154 d64263e2001 "> <p>Local only</p> </td> <td align="left" valign="top" width="20%" headers="d64263e5154 d64263e2003 "> <p>No</p> </td> </tr> </tbody> </table> </div>  <p>For more information about SRDCs, run <code class="codeph">tfactl diagcollect –srdc -help</code>. </p> <div class="infoboxnote" id="GUID-F8381A7A-E2F7-442C-AED0-3FEEF4129125__GUID-9A485F5E-6443-47EA-8809-12967C04F066"> <p class="notep1">Note:</p>When you run the <code class="codeph">tfactl diagcollect</code> command to query an <code class="codeph">ora-*</code> error event, for example, <code class="codeph">tfactl diagcollect -srdc ora-600</code>, AHF lists all <code class="codeph">ora-*</code> error events without filtering. This is because of generic event mapping for all <code class="codeph">ORA-*</code> error events in the <code>srdc_dbrac.xml</code> file. </div> <p>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.</p> <div class="tblformal" id="GUID-F8381A7A-E2F7-442C-AED0-3FEEF4129125__GUID-ABE85FAA-49C8-4FCB-941C-488269D8AF4B"> <p class="titleintable">Table 4-8 SRDC collections</p> <table cellpadding="4" cellspacing="0" class="Formal" title="SRDC collections" summary="This table lists and describes what the SRDCs collect varies for each type." frame="hsides" border="1" rules="rows"> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="d64263e5214">Command</th> <th align="left" valign="bottom" id="d64263e5216">What gets collected</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" valign="top" id="d64263e5220" headers="d64263e5214 "> <p><code class="codeph">$ tfactl diagcollect –srdc ORA-04031</code></p> </td> <td align="left" valign="top" headers="d64263e5220 d64263e5216 "> <ul style="list-style-type: disc;"> <li>Incident Packaging Service (IPS) package</li> <li>Patch listing</li> <li>Automatic Workload Repository (AWR) report</li> <li>Memory information</li> </ul> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" id="d64263e5235" headers="d64263e5214 "> <p><code class="codeph">$ tfactl diagcollect –srdc dbperf</code></p> </td> <td align="left" valign="top" headers="d64263e5235 d64263e5216 "> <ul style="list-style-type: disc;"> <li>Automatic Database Diagnostic Monitor (ADDM) report</li> <li>Automatic Workload Repository (AWR) for good period and problem period</li> <li>Automatic Workload Repository (AWR) Compare Period report</li> <li>Active Session History (ASH) report for good and problem period</li> <li>OSWatcher</li> <li>Incident Packaging Service (IPS) package (if there are any errors during problem period)</li> <li>Oracle ORAchk (performance-related checks)</li> </ul> </td> </tr> </tbody> </table> </div>  <p>Oracle Trace File Analyzer prompts you to enter the information required based on the SRDC type.</p> <p>For example, when you run <code class="codeph">ORA-4031</code> SRDC: </p><pre class="pre codeblock"><code>$ tfactl diagcollect –srdc ORA-04031</code></pre><p>Oracle Trace File Analyzer:</p> <ol> <li>Prompts to enter event date, time, and database name.</li> <li>Scans the system to identify recent events in the system (up to 10).</li> <li>Proceeds with diagnostic collection after you choose the relevant event.</li> <li>Identifies all the required files.</li> <li>Trims all the files where applicable.</li> <li>Packages all data in a zip file ready to provide to support.</li> </ol> <p>You can also run an SRDC collection in non-interactive silent mode. Provide all the required parameters up front as follows:</p><pre class="pre codeblock"><code>$ tfactl diagcollect –srdc <span class="variable" translate="no">srdc_type</span> -database <span class="variable" translate="no">db</span> -from "<span class="variable" translate="no">date</span> <span class="variable" translate="no">time</span>" -to "<span class="variable" translate="no">date</span> <span class="variable" translate="no">time</span>"</code></pre></div> <div> <div class="relinfo"> <p><strong>Related Topics</strong></p> <ul> <li><a href="https://support.oracle.com/rs?type=doc&id=1918781.1" target="_blank">https://support.oracle.com/rs?type=doc&id=1918781.1</a></li> <li><a href="https://support.oracle.com/rs?type=doc&id=2560291.1" target="_blank">https://support.oracle.com/rs?type=doc&id=2560291.1</a></li> <li><a href="https://support.oracle.com/rs?type=doc&id=2560286.1" target="_blank">https://support.oracle.com/rs?type=doc&id=2560286.1</a></li> <li><a href="https://support.oracle.com/rs?type=doc&id=2500734.1" target="_blank">https://support.oracle.com/rs?type=doc&id=2500734.1</a></li> <li><a href="https://support.oracle.com/rs?type=doc&id=1914153.1" target="_blank">https://support.oracle.com/rs?type=doc&id=1914153.1</a></li> <li><a href="https://support.oracle.com/rs?type=doc&id=2383662.1" target="_blank">https://support.oracle.com/rs?type=doc&id=2383662.1</a></li> <li><a href="https://support.oracle.com/rs?type=doc&id=1682741.1" target="_blank">https://support.oracle.com/rs?type=doc&id=1682741.1</a></li> <li><a href="https://support.oracle.com/rs?type=doc&id=1682723.1" target="_blank">https://support.oracle.com/rs?type=doc&id=1682723.1</a></li> <li><a href="https://support.oracle.com/rs?type=doc&id=1928047.1" target="_blank">https://support.oracle.com/rs?type=doc&id=1928047.1</a></li> </ul> </div> <div class="familylinks"> <div class="parentlink"> <p><strong>Parent topic:</strong> <a href="ondemand-diagnostic-collection.html#GUID-89D19AFB-0230-49AD-8C90-7B4E77A36174" title="Run Oracle Trace File Analyzer on demand using tfactl command-line tool.">Using On-Demand Diagnostic Collections</a></p> </div> </div> </div> </div> <div class="sect2"><a id="GUID-EC9B013E-CFB5-430C-A827-315304FB219B" name="GUID-EC9B013E-CFB5-430C-A827-315304FB219B"></a><h3 id="AHFUG-GUID-EC9B013E-CFB5-430C-A827-315304FB219B" class="sect3"><span class="enumeration_section">4.3.7 </span>Diagnostic Upload </h3> <div> <p>Diagnostic upload eliminates the need for different set of commands to upload Oracle ORAchk, Oracle EXAchk, and Oracle Trace File Analyzer diagnostic collections to AHF Service, database, and Oracle Support.</p> <p>Diagnostic upload enables you to manage configurations of different types of uploads in a generic way. Through <code class="codeph">ahfctl</code> command-line interface, you use generic upload commands to set, get, unset, and check configurations. Configurations are uniquely identified using configuration name so that you can pass the configuration name in command-line to perform upload and other operations. </p> <p>AHF synchronizes the configuration automatically across the cluster nodes. If you find any sync issues, then run the <code class="codeph">tfactl syncahfconfig -c</code> command to sync configuration across the cluster nodes. </p> <div class="p">Diagnostic upload supports multiple operating system users to run the diagnostic upload commands if you install AHF as <code class="codeph">root</code>. If you install AHF as a non-root user, then you cannot benefit from the multiple operating system users support. <div class="infoboxnote" id="GUID-EC9B013E-CFB5-430C-A827-315304FB219B__GUID-E09FAAB2-340B-4E91-A7F7-3FC10150968C"> <p class="notep1">Note:</p>Currently not supported on Microsoft Windows. </div> </div> <p>Currently, AHF supports HTTP, SQLNET, and SFTP types or protocols, or end points. Following sections list the parameters or arguments supported by different end points while setting the configuration.</p> <div class="section"> <p class="subhead2" id="GUID-EC9B013E-CFB5-430C-A827-315304FB219B__GUID-1C17830C-FA50-4F7F-9098-6B97975CEDCD">HTTP</p> <p><span class="bold">Set Parameters:</span> <code class="codeph">url</code>, <code class="codeph">user</code>, <code class="codeph">password</code>, <code class="codeph">proxy</code>, <code class="codeph">noauth</code>, <code class="codeph">https_token</code>, <code class="codeph">header</code>, <code class="codeph">secure</code>, and <code class="codeph">storetype</code></p> <p><span class="bold">Upload Parameters:</span> <code class="codeph">id</code>, <code class="codeph">file</code>, and <code class="codeph">https_token</code></p> </div>  <div class="section"> <p class="subhead2" id="GUID-EC9B013E-CFB5-430C-A827-315304FB219B__GUID-65A32E12-5730-496A-9CCE-398166B04A33">SQLNET</p> <p><span class="bold">Set Parameters:</span> <code class="codeph">user</code>, <code class="codeph">password</code>, <code class="codeph">connectstring</code>, and <code class="codeph">uploadtable</code></p> <p><span class="bold">Upload Parameters:</span> <code class="codeph">file</code></p> </div>  <div class="section"> <p class="subhead2" id="GUID-EC9B013E-CFB5-430C-A827-315304FB219B__GUID-3F7FEA63-6E23-4C0A-9AD7-F8A7786482E8">SFTP</p> <p><span class="bold">Set Parameters:</span> <code class="codeph">server</code>, <code class="codeph">user</code>, and <code class="codeph">password</code></p> <p><span class="bold">Upload Parameters:</span> (optional) <code class="codeph">id</code> and <code class="codeph">file</code></p> </div>  <div class="section"> <p class="subhead2" id="GUID-EC9B013E-CFB5-430C-A827-315304FB219B__GUID-34AC9548-3B4F-4B5C-A6C0-3D313AC906C2">Parameters or arguments Supported by Different Endpoints</p> <div class="tblformal" id="GUID-EC9B013E-CFB5-430C-A827-315304FB219B__TABLE_PBZ_52R_YLB"> <p class="titleintable">Table 4-9 Parameters or Arguments Supported by Different Endpoints</p> <table cellpadding="4" cellspacing="0" class="Formal" title="Parameters or Arguments
 Supported by Different Endpoints" summary="The following table lists parameters or arguments supported by
 different endpoints." frame="hsides" border="1" rules="rows"> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" width="0%" id="d64263e5639">Parameter</th> <th align="left" valign="bottom" width="0%" id="d64263e5641">Description</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" valign="top" width="0%" id="d64263e5645" headers="d64263e5639 "> <p><code class="codeph">url</code></p> </td> <td align="left" valign="top" width="0%" headers="d64263e5645 d64263e5641 "> <p>The target URL to upload files in case of HTTPS type. For example, <span class="variable" translate="no">https://samplehost.com</span>. </p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="0%" id="d64263e5660" headers="d64263e5639 "> <p><code class="codeph">server</code></p> </td> <td align="left" valign="top" width="0%" headers="d64263e5660 d64263e5641 "> <p>The name of the server to which you want to upload files. For example, <span class="variable" translate="no">sftpserver.domain.com</span>. </p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="0%" id="d64263e5675" headers="d64263e5639 "> <p><code class="codeph">user</code></p> </td> <td align="left" valign="top" width="0%" headers="d64263e5675 d64263e5641 "> <p>The user who has the privileges to access the endpoint. For example, <span class="variable" translate="no">upload.user@example.com</span>. </p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="0%" id="d64263e5690" headers="d64263e5639 "> <p><code class="codeph">password</code></p> </td> <td align="left" valign="top" width="0%" headers="d64263e5690 d64263e5641 ">Password of the user.</td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="0%" id="d64263e5699" headers="d64263e5639 "> <p><code class="codeph">proxy</code></p> </td> <td align="left" valign="top" width="0%" headers="d64263e5699 d64263e5641 "> <p>The URL of the proxy server. For example, <span class="variable" translate="no">www.example.com:80</span>. </p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="0%" id="d64263e5714" headers="d64263e5639 "> <p><code class="codeph">id</code></p> </td> <td align="left" valign="top" width="0%" headers="d64263e5714 d64263e5641 "> <p>The location or target where you want to upload your files to.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="0%" id="d64263e5726" headers="d64263e5639 "> <p><code class="codeph">file</code></p> </td> <td align="left" valign="top" width="0%" headers="d64263e5726 d64263e5641 "> <p>The name of the file to upload.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="0%" id="d64263e5738" headers="d64263e5639 "> <p><code class="codeph">noauth</code></p> </td> <td align="left" valign="top" width="0%" headers="d64263e5738 d64263e5641 "> <p>Specify <code class="codeph">true</code> and <code class="codeph">false</code>. Default value is <code class="codeph">false</code>. </p> <p>If <code class="codeph">noauth</code> is set to <code class="codeph">true</code>, then HTTPS upload will skip authentication. </p> <p>For example, upload files to PAR, Pre Authenticated URL where no user/password authentication is required.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="0%" id="d64263e5771" headers="d64263e5639 "> <p><code class="codeph">https_token</code></p> </td> <td align="left" valign="top" width="0%" headers="d64263e5771 d64263e5641 "> <p>Any static header values while configuring. For example, set auth tokens while configuring the HTTPS end point.</p> <p>For example, <code class="codeph">ahfctl setupload -name config -type https -https_token 'abc:13'</code>. </p> <p>You can also pass dynamic headers at upload time by passing the <code class="codeph">-https_token headers</code> command option to <code class="codeph">tfactl upload</code> command. </p> <p>For example: <code class="codeph">-H 'X-TFA-REQUESTID: 1'</code>. </p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="0%" id="d64263e5804" headers="d64263e5639 "> <p><code class="codeph">header</code></p> </td> <td align="left" valign="top" width="0%" headers="d64263e5804 d64263e5641 "> <p>Stores the <code class="codeph">executionId</code> in the <code class="codeph">ahf.properties</code> file. </p> <p>For example, to set the header:<code class="codeph">ahfctl setupload -name a1 -type https -header X-TFA-HEADERS:executionId=aeldb1db01_2020.06.16_19.20.55.15336025</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="0%" id="d64263e5827" headers="d64263e5639 "> <p><code class="codeph">secure</code></p> </td> <td align="left" valign="top" width="0%" headers="d64263e5827 d64263e5641 "> <p>Specify <code class="codeph">true</code> or <code class="codeph">false</code>. Default value is <code class="codeph">true</code>. Specifying the secure value checks for certificates. </p> <p>If <code class="codeph">secure</code> is set to <code class="codeph">false</code>, then the <code class="codeph">upload</code> command will run an unsecure upload. </p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="0%" id="d64263e5861" headers="d64263e5639 "> <p><code class="codeph">connectstring</code></p> </td> <td align="left" valign="top" width="0%" headers="d64263e5861 d64263e5641 "> <p>The database connect string to log in to the database where you want to upload files.</p> <p>For example, <code class="codeph">(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = host)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = orcl)))</code>. </p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="0%" id="d64263e5879" headers="d64263e5639 "> <p><code class="codeph">uploadtable</code></p> </td> <td align="left" valign="top" width="0%" headers="d64263e5879 d64263e5641 "> <p>Specify the name of the table where you want to upload files as <code class="codeph">BLOB</code> type. </p> <p>For example, for uploading Oracle ORAchk collections to the Collection Manager it is set to <code class="codeph">RCA13_DOCS</code>. </p> </td> </tr> </tbody> </table> </div>  </div>  <div class="example" id="GUID-EC9B013E-CFB5-430C-A827-315304FB219B__GUID-C475BD4C-FC5B-4E0D-BD69-EEDF38E5E697"> <p class="titleinexample">Example 4-2 Diagnostic Upload Examples To upload files to My Oracle Support</p> <div class="p"><span class="bold">To setup MOS configuration:</span><pre class="pre codeblock"><code>ahfctl setupload -name mos -type https Enter mos.https.user: user_id Enter mos.https.password: ######## Enter mos.https.url: https://transport.oracle.com/upload/issue Upload configuration set for: mos type: https user: user_id password: ######## url: https://transport.oracle.com/upload/issue</code></pre></div> <div class="p"><span class="bold">To set proxy:</span><pre class="pre codeblock"><code>ahfctl setupload -name mos -type https -proxy www-proxy.example.com:80</code></pre></div> <div class="p">Single-line command:<pre class="pre codeblock"><code>ahfctl setupload -name mos -type https -user <span class="variable" translate="no">user_id</span> -url https://transport.oracle.com/upload/issue -proxy www-proxy.example.com:80</code></pre><div class="infoboxnote" id="GUID-EC9B013E-CFB5-430C-A827-315304FB219B__GUID-DDD3E553-326F-4B7F-A4AD-753BD908C1C2"> <p class="notep1">Note:</p>Instead of <code class="codeph">mos</code>, you can specify any configuration name of your choice. </div> </div> <div class="p"><span class="bold">To upload collections or files to MOS:</span> There are multiple ways you can upload files to MOS after configuring MOS. <ul style="list-style-type: disc;" id="GUID-EC9B013E-CFB5-430C-A827-315304FB219B__UL_XJN_4SN_GMB"> <li>Upload files as part of Oracle Trace File Analyzer diagnostic collection:<pre class="pre codeblock"><code>tfactl diagcollect -last 1h -upload mos -id 3-23104325631</code></pre></li> <li>Upload files standalone:<pre class="pre codeblock"><code>tfactl upload -name mos -id 3-23104325631 -file /tmp/generated.zip</code></pre></li> <li>Backward compatibility or upload using <code class="codeph">-sr</code> flag with <code class="codeph">diagcollcet</code> command:<pre class="pre codeblock"><code>tfactl diagcollect -last 1h -sr 3-23104325631</code></pre><div class="infoboxnote" id="GUID-EC9B013E-CFB5-430C-A827-315304FB219B__GUID-74604C6C-6427-4527-BF88-84E055E0B86B"> <p class="notep1">Note:</p> <p>In this case, upload configuration name should be <code class="codeph">mos</code> as internally Oracle Trace File Analyzer looks for this name. It works even if MOS configuration is set using the <code class="codeph">tfactl setupmos</code> command in versions earlier than 20.2. </p> </div> </li> </ul> </div> </div>  <div class="example" id="GUID-EC9B013E-CFB5-430C-A827-315304FB219B__GUID-CD2B3F81-9692-4F9B-85E7-D3A05F8A1C3A"> <p class="titleinexample">Example 4-3 Uploading a File Using SFTP</p> <pre class="pre codeblock"><code>ahfctl upload -name sftp1 -file test_sftp_upload.log Upload for: sftp1 Uploading file using pexpect sftp> put test_sftp_upload.log put test_sftp_upload.log Uploading test_sftp_upload.log to /root/test_sftp_upload.log test_sftp_upload.log 100% 17 0.0KB/s 00:00 sftp> quit type: sftp file: test_sftp_upload.log Upload completed successfully</code></pre> </div>  <div class="example" id="GUID-EC9B013E-CFB5-430C-A827-315304FB219B__GUID-07B2C480-5D6E-41AC-9D13-740D2A73CA0F"> <p class="titleinexample">Example 4-4 Diagnostic Upload Examples</p> <div class="p">To set configuration parameters for the specified configuration name and SQLNET configuration type:<pre class="pre codeblock"><code>ahfctl setupload -name <span class="variable" translate="no">mysqlnetconfig</span> -type <code class="codeph"><span class="variable" translate="no">sqlnet</span></code></code></pre><pre class="pre codeblock"><code>[root@myserver1]# ahfctl setupload -name mysqlnetconfig -type sqlnet Enter mysqlnetconfig.sqlnet.user: testuser Enter mysqlnetconfig.sqlnet.password: ######## Enter mysqlnetconfig.sqlnet.connectstring: (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = testhost)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = testservice))) Enter mysqlnetconfig.sqlnet.uploadtable: RCA13_DOCS Upload configuration set for: mysqlnetconfig type: sqlnet user: testuser password: ######## connectstring: (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = testhost)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = testservice))) uploadtable: RCA13_DOCS</code></pre></div> <div class="p">To set individual parameters for the specified configuration name and SQLNET configuration type:<pre class="pre codeblock"><code>ahfctl setupload -name <span class="variable" translate="no">mysqlnetconfig2</span> -type <code class="codeph"><span class="variable" translate="no">sqlnet</span></code> -user <span class="variable" translate="no">user_name@example.com</span></code></pre></div> <div class="p">This omits the <code class="codeph">-password</code> option and therefore reports:<pre class="oac_no_warn" dir="ltr">Database upload parameter(s) successfully stored. AHF will not upload collections into the database until the following parameters are also set: ['password', 'connectstring', 'uploadtable']</pre></div> <div class="p">When you specify the <code class="codeph">-user</code> command option, <code class="codeph">ahfctl</code> does NOT prompt for the other required parameters so you must explicitly specify them at the command line as follows: <pre class="pre codeblock"><code>ahfctl setupload -type sqlnet -name orachkcm -user <span class="variable" translate="no">testuser</span> -password -connectstring <span class="variable" translate="no">sqlnet connect string</span> -uploadtable RCA13_DOCS</code></pre></div> <p>The <code class="codeph">-password</code> command option DOES NOT take any arguments. When specified, <code class="codeph">ahfctl</code> prompts you to provide the password for the user you specified using the <code class="codeph">-user</code> command option. </p> <div class="p">To get the list of all configured names in the <code>AHF.properties</code> file:<pre class="pre codeblock"><code>ahfctl getupload</code></pre><pre class="pre codeblock"><code># ahfctl getupload Upload configurations available: 1. mysftpconfig 2. myhttpsconfig 3. mysqlnetconfig</code></pre></div> <div class="p">To get all configuration parameters for the specified configuration name:<pre class="pre codeblock"><code>ahfctl getupload -name <span class="variable" translate="no">mysftpconfig</span></code></pre><pre class="pre codeblock"><code># ahfctl getupload -name mysftpconfig Upload configuration get for: mysftpconfig type: sftp user: testuser1@example.com password: ######### server: sftphost.example.com</code></pre></div> <div class="p">To get individual parameter for the specified configuration name:<pre class="pre codeblock"><code>ahfctl getupload -name <span class="variable" translate="no">mysftpconfig</span> -user</code></pre><pre class="pre codeblock"><code>[root@myserver1]# ahfctl getupload -name mysftpconfig -user Upload configuration get for: mysftpconfig type: sftp user: testuser1@example.com</code></pre></div> <div class="p">To check or validate configuration of the specified configuration name:<pre class="pre codeblock"><code>ahfctl checkupload -name <span class="variable" translate="no">mysftpconfig</span></code></pre><pre class="pre codeblock"><code># ahfctl checkupload -name mysftpconfig -type sftp Upload configuration check for: mysftpconfig Parameters are configured correctly to upload files to sftp end point mysftpconfig</code></pre></div> <div class="p">To upload to target using the configuration name specified:<pre class="pre codeblock"><code>tfactl upload -name <span class="variable" translate="no">mysftpconfig</span> -id <span class="variable" translate="no">30676598</span> -file <code><span class="variable" translate="no">/tmp/temp.txt</span></code></code></pre><pre class="pre codeblock"><code># tfactl upload -name mysftpconfig -id 30676598 -file /tmp/filename.txt Upload for: mysftpconfig type: sftp file: /tmp/filename.txt id: 30676598 Upload completed successfully.</code></pre></div> <div class="p">To unset individual parameter of the specified configuration name:<pre class="pre codeblock"><code>ahfctl unsetupload -name <span class="variable" translate="no">mysftpconfig</span> -user</code></pre><pre class="pre codeblock"><code># ahfctl unsetupload -name mysftpconfig -user Upload configuration successfully unset for: mysftpconfig</code></pre></div> <div class="p">To unset all parameters of the specified configuration name:<pre class="pre codeblock"><code>ahfctl unsetupload -name <span class="variable" translate="no">mysftpconfig</span> -all</code></pre><pre class="pre codeblock"><code># ahfctl unsetupload -name mysftpconfig -all Upload configuration successfully unset for: mysftpconfig</code></pre></div> <div class="p">To auto upload generated zip file to the database using Oracle ORAchk:<pre class="pre codeblock"><code>exachk -showpass -localonly -check <span class="variable" translate="no">BF7AE780E1252F69E0431EC0E50AE447</span></code></pre><pre class="pre codeblock"><code># exachk -showpass -localonly -check BF7AE780E1252F69E0431EC0E50AE447 Orachk.zip successfully uploaded to RCA13_DOCS table</code></pre></div> <div class="p">To auto upload generated zip file to MOS using <code class="codeph">tfactl diagcollect</code>:<pre class="pre codeblock"><code>$ tfactl diagcollect -since 1h -upload mos -id <span class="variable" translate="no">3-123456789</span></code></pre></div> <div class="p">To upload generated zip to the database with the configurations set by AHF with the specified database config name:<pre class="pre codeblock"><code>exachk -showpass -localonly -check <span class="variable" translate="no">BF7AE780E1252F69E0431EC0E50AE447</span> -db_config_name <span class="variable" translate="no">user_dbconf</span></code></pre><pre class="pre codeblock"><code># exachk -showpass -localonly -check BF7AE780E1252F69E0431EC0E50AE447 -db_config_name user_dbconf Orachk.zip successfully uploaded to RCA13_DOCS table</code></pre></div> </div>  </div> <div> <div class="relinfo"> <p><strong>Related Topics</strong></p> <ul> <li><a href="tfactl-setupload.html#GUID-D1C52DFA-39A5-4336-93B8-B8C9092A9B32" title="Use the tfactl setupload command to set upload parameters.">tfactl setupload</a></li> <li><a href="tfactl-getupload.html#GUID-20F8AE26-BAA1-488A-BA8D-91CBF41F886A" title="Use the tfactl getupload command to fetch the details of configured upload parameters.">tfactl getupload</a></li> <li><a href="tfactl-unsetupload.html#GUID-61F1611B-4C76-4884-BD97-5D38D8CB6014" title="Use the tfactl unsetupload command to unset the configured upload parameters.">tfactl unsetupload</a></li> <li><a href="tfactl-checkupload.html#GUID-57D0BC90-A5EB-4225-B21C-C8B51217C460" title="Use the tfactl checkupload command to validate the configured upload parameters.">tfactl checkupload</a></li> <li><a href="tfactl-upload.html#GUID-6620DDE7-9C39-473C-B5BF-63E9E3BE2EAF" title="Use the tfactl upload command to upload collections or files on demand.">tfactl upload</a></li> </ul> </div> <div class="familylinks"> <div class="parentlink"> <p><strong>Parent topic:</strong> <a href="ondemand-diagnostic-collection.html#GUID-89D19AFB-0230-49AD-8C90-7B4E77A36174" title="Run Oracle Trace File Analyzer on demand using tfactl command-line tool.">Using On-Demand Diagnostic Collections</a></p> </div> </div> </div> </div> <div class="sect2"><a id="GUID-940A4DD7-80E8-4DAA-9BAD-571D13428DFC" name="GUID-940A4DD7-80E8-4DAA-9BAD-571D13428DFC"></a><h3 id="AHFUG-GUID-940A4DD7-80E8-4DAA-9BAD-571D13428DFC" class="sect3"><span class="enumeration_section">4.3.8 </span>Changing Oracle Grid Infrastructure Trace Levels </h3> <div> <p>Enable trace levels to collect enough diagnostics to diagnose the cause of the problem.</p> <div class="section"> <p>Oracle Support asks you to enable certain trace levels when reproducing a problem. You can enable and then disable the trace levels. Use the <code class="codeph">dbglevel</code> option to set the trace level. You can find the required trace level settings grouped by problem trace profiles. </p> </div>  <div class="section"> <p class="subhead2" id="GUID-940A4DD7-80E8-4DAA-9BAD-571D13428DFC__GUID-F941DDC9-7074-4131-8674-8F1568E7E73E">To set trace levels:</p> </div>  <ol> <li class="stepexpand"><span>To set a trace profile:</span><div> <div class="p"><pre class="pre codeblock"><code>tfactl dbglevel –set <span class="variable" translate="no">profile</span></code></pre></div> </div> </li> <li class="stepexpand"><span>To list all available profiles:</span><div> <div class="p"><pre class="pre codeblock"><code>tfactl dbglevel –help</code></pre></div> </div> </li> </ol> </div> <div> <ul class="ullinks"> <li class="ulchildlink"><a href="ondemand-diagnostic-collection.html#GUID-62A5DD88-ACAC-4F7F-B673-F1EAB5356313">tfactl dbglevel</a><br>Use the <code class="codeph">tfactl dbglevel</code> command to set Oracle Grid Infrastructure trace levels. </li> </ul> <div class="familylinks"> <div class="parentlink"> <p><strong>Parent topic:</strong> <a href="ondemand-diagnostic-collection.html#GUID-89D19AFB-0230-49AD-8C90-7B4E77A36174" title="Run Oracle Trace File Analyzer on demand using tfactl command-line tool.">Using On-Demand Diagnostic Collections</a></p> </div> </div> </div> <div class="sect3"><a id="GUID-62A5DD88-ACAC-4F7F-B673-F1EAB5356313" name="GUID-62A5DD88-ACAC-4F7F-B673-F1EAB5356313"></a><h4 id="AHFUG-GUID-62A5DD88-ACAC-4F7F-B673-F1EAB5356313" class="sect4"><span class="enumeration_section">4.3.8.1 </span>tfactl dbglevel </h4> <div> <p>Use the <code class="codeph">tfactl dbglevel</code> command to set Oracle Grid Infrastructure trace levels. </p> <div class="section"> <div class="infoboxnote" id="GUID-62A5DD88-ACAC-4F7F-B673-F1EAB5356313__GUID-6DB59E28-440D-4499-B228-95933C0D86A0"> <p class="notep1">Note:</p>The <code class="codeph">tfactl dbglevel</code> is set to be deprecated by early 2025. Please ensure to transition away from this feature and adopt an alternative solution before the deprecation deadline. </div> </div>  <div class="section"> <p class="subhead3" id="GUID-62A5DD88-ACAC-4F7F-B673-F1EAB5356313__GUID-5C2AE8FC-0F24-4C0F-8A2B-39DD7AF8D4F9">Syntax</p><pre class="pre codeblock"><code>tfactl [run] dbglevel [ {-set|-unset} <span class="variable" translate="no">profile_name</span> -dependency [<span class="variable" translate="no">dep1</span>,<span class="variable" translate="no">dep2</span>,...|all] -dependency_type [<span class="variable" translate="no">type1</span>,<span class="variable" translate="no">type2</span>,<span class="variable" translate="no">type3</span>,...|all] | {-view|-drop} <span class="variable" translate="no">profile_name</span> | -lsprofiles | -lsmodules | -lscomponents [module_name] | -lsres | -create <span class="variable" translate="no">profile_name</span> [ -desc <span class="variable" translate="no">description</span> | [-includeunset] [-includetrace] | -debugstate | -timeout <span class="variable" translate="no">time</span> ] | -modify <span class="variable" translate="no">profile_name</span> [-includeunset] [-includetrace] | -getstate [ -module <span class="variable" translate="no">module_name</span> ] | -active [profile_name] | -describe [profile_name] ] ]</code></pre></div>  <div class="section"> <p class="subhead3" id="GUID-62A5DD88-ACAC-4F7F-B673-F1EAB5356313__GUID-DE6C0F59-8F0C-4356-BD46-19F3DDC018DB">Parameters</p> <div class="tblformal" id="GUID-62A5DD88-ACAC-4F7F-B673-F1EAB5356313__GUID-0675992D-D5DA-4DCC-9C92-173E28FBC2E6"> <p class="titleintable">Table 4-10 tfactl dbglevel Command Parameters</p> <table cellpadding="4" cellspacing="0" class="Formal" title="tfactl dbglevel Command Parameters" summary="This table lists and describes tfactl dbglevel command parameters." frame="hsides" border="1" rules="rows"> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" width="20%" id="d64263e6678">Parameter</th> <th align="left" valign="bottom" width="20%" id="d64263e6680">Description</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e6684" headers="d64263e6678 "> <p><code class="codeph">profile_name</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e6684 d64263e6680 "> <p>Specify the name of the profile.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e6692" headers="d64263e6678 "> <p><code class="codeph">active</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e6692 d64263e6680 "> <p>Displays the list of active profiles.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e6700" headers="d64263e6678 "> <p><code class="codeph">set</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e6700 d64263e6680 "> <p>Sets the trace or log levels for the profile specified.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e6708" headers="d64263e6678 "> <p><code class="codeph">unset</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e6708 d64263e6680 "> <p>Unsets the trace or log levels for the profile specified.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e6716" headers="d64263e6678 "> <p><code class="codeph">view</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e6716 d64263e6680 "> <p>Displays the trace or log entries for the profile specified.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e6724" headers="d64263e6678 "> <p><code class="codeph">create</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e6724 d64263e6680 "> <p>Creates a profile.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e6732" headers="d64263e6678 "> <p><code class="codeph">drop</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e6732 d64263e6680 "> <p>Drops the profile specified.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e6740" headers="d64263e6678 "> <p><code class="codeph">modify</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e6740 d64263e6680 "> <p>Modifies the profile specified.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e6748" headers="d64263e6678 "> <p><code class="codeph">describe</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e6748 d64263e6680 "> <p>Describes the profiles specified.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e6756" headers="d64263e6678 "> <p><code class="codeph">lsprofiles</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e6756 d64263e6680 "> <p>Lists all the available profiles.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e6764" headers="d64263e6678 "> <p><code class="codeph">lsmodules</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e6764 d64263e6680 "> <p>Lists all the discovered Oracle Clusterware modules.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e6773" headers="d64263e6678 "> <p><code class="codeph">lscomponents</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e6773 d64263e6680 "> <p>Lists all the components associated with the Oracle Clusterware module.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e6781" headers="d64263e6678 "> <p><code class="codeph">lsres</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e6781 d64263e6680 "> <p>Lists all the discovered Oracle Clusterware resources.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e6789" headers="d64263e6678 "> <p><code class="codeph">getstate</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e6789 d64263e6680 "> <p>Displays the current trace or log levels for the Oracle Clusterware components or resources.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e6797" headers="d64263e6678 "> <p><code class="codeph">module</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e6797 d64263e6680 "> <p>Specify the Oracle Clusterware module.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e6805" headers="d64263e6678 "> <p><code class="codeph">dependency</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e6805 d64263e6680 "> <p>Specify the dependencies to consider, start, or stop dependencies, or both.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e6813" headers="d64263e6678 "> <p><code class="codeph">dependency_type</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e6813 d64263e6680 "> <p>Specify the type of dependencies to be consider.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e6821" headers="d64263e6678 "> <p><code class="codeph">debugstate</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e6821 d64263e6680 "> <p>Generates a System State Dump for all the available levels.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e6829" headers="d64263e6678 "> <p><code class="codeph">includeunset</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e6829 d64263e6680 "> <p>Adds or modifies an unset value for the Oracle Clusterware components or resources.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e6837" headers="d64263e6678 "> <p><code class="codeph">includetrace</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e6837 d64263e6680 "> <p>Adds or modifies a trace value for the Oracle Clusterware components.</p> </td> </tr> </tbody> </table> </div>  <div class="infoboxnotewarn" id="GUID-62A5DD88-ACAC-4F7F-B673-F1EAB5356313__GUID-F3FCE914-E08B-4C93-B8F7-BC8C9A2448B8"> <p class="notep1">WARNING:</p>Set the profiles only at the direction of Oracle Support. </div> </div>  </div> <div> <div class="familylinks"> <div class="parentlink"> <p><strong>Parent topic:</strong> <a href="ondemand-diagnostic-collection.html#GUID-940A4DD7-80E8-4DAA-9BAD-571D13428DFC" title="Enable trace levels to collect enough diagnostics to diagnose the cause of the problem.">Changing Oracle Grid Infrastructure Trace Levels</a></p> </div> </div> </div> </div> </div> <div class="sect2"><a id="GUID-E4A2492E-A123-480A-B954-57898DBCE8BE" name="GUID-E4A2492E-A123-480A-B954-57898DBCE8BE"></a><h3 id="AHFUG-GUID-E4A2492E-A123-480A-B954-57898DBCE8BE" class="sect3"><span class="enumeration_section">4.3.9 </span>Performing Custom Collections </h3> <div> <p>Use the custom collection options to change the diagnostic collections from the default.</p> </div> <div> <ul class="ullinks"> <li class="ulchildlink"><a href="ondemand-diagnostic-collection.html#GUID-F7669F99-4930-4B81-9A3F-D9A47E17CDDB">Adjusting the Diagnostic Data Collection Period</a><br>Oracle Trace File Analyzer trims and collects any important logs updated in the past one hour. </li> <li class="ulchildlink"><a href="ondemand-diagnostic-collection.html#GUID-21A7A6A1-7589-425B-9327-49BB69DE84F3">Collecting for Specific Events</a><br>Perform default diagnostic collection or choose an event from the list of recent incidents to collect diagnostic data for that event alone. </li> <li class="ulchildlink"><a href="ondemand-diagnostic-collection.html#GUID-E59870F2-324D-47D3-B615-0A19AFC1661C">Excluding Large Files from Diagnostic Collection</a><br>Prevent excessively large files from delaying or stalling collections. </li> <li class="ulchildlink"><a href="ondemand-diagnostic-collection.html#GUID-0EEA807B-5785-484E-ACF9-2C14291A0AB3">Collecting from Specific Nodes</a><br></li> <li class="ulchildlink"><a href="ondemand-diagnostic-collection.html#GUID-0FA3F135-C73E-444B-94FF-A2185D65E681">Collecting from Specific Components</a><br></li> <li class="ulchildlink"><a href="ondemand-diagnostic-collection.html#GUID-37F704DD-6A3E-4337-B089-4A21D30B978E">Collecting from Specific Directories</a><br></li> <li class="ulchildlink"><a href="ondemand-diagnostic-collection.html#GUID-8AF18492-233A-4DB6-B116-6889798B4594">Changing the Collection Name</a><br></li> <li class="ulchildlink"><a href="ondemand-diagnostic-collection.html#GUID-7ACBBD2D-3F93-439D-A71A-5A5D69AD7D02">Preventing Copying Zip Files and Trimming Files</a><br></li> <li class="ulchildlink"><a href="ondemand-diagnostic-collection.html#GUID-7CA0360B-9996-43D3-B334-81DD5C470ACE">Performing Silent Collection</a><br></li> <li class="ulchildlink"><a href="ondemand-diagnostic-collection.html#GUID-E97E09E7-E069-4162-BA2B-65738BE85E55">Collecting Core Files</a><br></li> <li class="ulchildlink"><a href="ondemand-diagnostic-collection.html#GUID-465A4E00-3A13-4FBA-8255-0AF98AF7B66E">Collecting Incident Packaging Service (IPS) Packages</a><br>Incident Packaging Service packages details of problems stored by Oracle Database in ADR for later diagnosis. </li> </ul> <div class="familylinks"> <div class="parentlink"> <p><strong>Parent topic:</strong> <a href="ondemand-diagnostic-collection.html#GUID-89D19AFB-0230-49AD-8C90-7B4E77A36174" title="Run Oracle Trace File Analyzer on demand using tfactl command-line tool.">Using On-Demand Diagnostic Collections</a></p> </div> </div> </div> <div class="sect3"><a id="GUID-F7669F99-4930-4B81-9A3F-D9A47E17CDDB" name="GUID-F7669F99-4930-4B81-9A3F-D9A47E17CDDB"></a><h4 id="AHFUG-GUID-F7669F99-4930-4B81-9A3F-D9A47E17CDDB" class="sect4"><span class="enumeration_section">4.3.9.1 </span>Adjusting the Diagnostic Data Collection Period </h4> <div> <p>Oracle Trace File Analyzer trims and collects any important logs updated in the past one hour.</p> <p>If you know that you only want logs for a smaller window, then you can cut this collection period. Cutting the collection period helps you make collections as small and quick as possible.</p> <p>There are four different ways you can specify the period for collection:</p> <div class="tblformal" id="GUID-F7669F99-4930-4B81-9A3F-D9A47E17CDDB__GUID-FBC0853B-A040-402F-9A60-D99EFDAC7B6E"> <p class="titleintable">Table 4-11 Ways to Specify the Collection Period</p> <table cellpadding="4" cellspacing="0" class="Formal" title="Ways to Specify the Collection Period" summary="This table describes ways to specify the collection period." frame="hsides" border="1" rules="rows"> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" width="20%" id="d64263e7259">Command</th> <th align="left" valign="bottom" width="20%" id="d64263e7261">Description</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e7265" headers="d64263e7259 "> <p><code class="codeph">tfactl diagcollect -last <span class="variable" translate="no">n</span> h|d</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e7265 d64263e7261 "> <p>Collects since the previous <span class="variable" translate="no">n</span> hours or days. </p> <ul style="list-style-type: disc;" id="GUID-F7669F99-4930-4B81-9A3F-D9A47E17CDDB__UL_YNV_BK5_QMB"> <li>Number of days must be less than or equal to 7</li> <li>Number of hours must be less than or equal to 168</li> </ul> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e7285" headers="d64263e7259 "> <p><code class="codeph">tfactl diagcollect -from “<span class="variable" translate="no">yyyy-mm-dd</span>”</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e7285 d64263e7261 "> <p>Collects from the date and optionally time specified.</p> <p>Valid date and time formats:</p> <p><code class="codeph">"Mon/dd/yyyy hh:mm:ss"</code></p> <p><code class="codeph">"yyyy-mm-dd hh:mm:ss"</code></p> <p><code class="codeph">"yyyy-mm-ddThh:mm:ss"</code></p> <p><code class="codeph">"yyyy-mm-dd"</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e7310" headers="d64263e7259 "> <p><code class="codeph">tfactl diagcollect –from "<span class="variable" translate="no">yyyy-mm-dd</span>" -to "<span class="variable" translate="no">yyyy-mm-dd</span>"</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e7310 d64263e7261 "> <p>Collects between the date and optionally time specified.</p> <p>Valid date and time formats:</p> <p><code class="codeph">"Mon/dd/yyyy hh:mm:ss"</code></p> <p><code class="codeph">"yyyy-mm-dd hh:mm:ss"</code></p> <p><code class="codeph">"yyyy-mm-ddThh:mm:ss"</code></p> <p><code class="codeph">"yyyy-mm-dd"</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e7338" headers="d64263e7259 "> <p><code class="codeph">tfactl diagcollect -for “<span class="variable" translate="no">yyyy-mm-dd</span>”</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e7338 d64263e7261 "> <p>Collects for the specified date.</p> <p>Valid date formats:</p> <p><code class="codeph">"Mon/dd/yyyy"</code></p> <p><code class="codeph">"yyyy-mm-dd"</code></p> </td> </tr> </tbody> </table> </div>  </div> <div> <div class="familylinks"> <div class="parentlink"> <p><strong>Parent topic:</strong> <a href="ondemand-diagnostic-collection.html#GUID-E4A2492E-A123-480A-B954-57898DBCE8BE" title="Use the custom collection options to change the diagnostic collections from the default.">Performing Custom Collections</a></p> </div> </div> </div> </div> <div class="sect3"><a id="GUID-21A7A6A1-7589-425B-9327-49BB69DE84F3" name="GUID-21A7A6A1-7589-425B-9327-49BB69DE84F3"></a><h4 id="AHFUG-GUID-21A7A6A1-7589-425B-9327-49BB69DE84F3" class="sect4"><span class="enumeration_section">4.3.9.2 </span>Collecting for Specific Events </h4> <div> <p>Perform default diagnostic collection or choose an event from the list of recent incidents to collect diagnostic data for that event alone.</p> <div class="section"> <p>Choose to run:</p> <ul style="list-style-type: disc;" id="GUID-21A7A6A1-7589-425B-9327-49BB69DE84F3__UL_RD2_PZY_ZGB"> <li>A diagnostic collection for a specific recent event</li> <li>A default time range diagnostic collection</li> </ul> </div>  <div class="section"> <p class="subhead3" id="GUID-21A7A6A1-7589-425B-9327-49BB69DE84F3__GUID-BD3D694A-29E4-41CE-9D65-622505F6B6E1">To collect for specific events:</p> </div>  <ol> <li class="stepexpand"><span>To run a default diagnostic collection:</span><div> <div class="p"><pre class="pre codeblock"><code>tfactl diagcollect</code></pre></div> <div class="p">For example:<pre class="pre codeblock"><code>$ tfactl diagcollect Choose the event you want to perform a diagnostic collection for: 1. Mar/12/2019 16:08:20 [ db.orcl.orcl ] ORA-04030: out of process memory when trying to allocate 2. Mar/12/2019 16:08:18 [ db.orcl.orcl ] ORA-04031: unable to allocate 8 bytes of shared memory 3. Mar/12/2019 16:08:16 [ db.orcl.orcl ] ORA-00494: enqueue held for too long more than seconds by osid 4. Mar/12/2019 16:08:14 [ db.orcl.orcl ] ORA-29709: Communication failure with Cluster Synchronization 5. Mar/12/2019 16:08:04 [ db.orcl.orcl ] ORA-29702: error occurred in Cluster Group Service operation 6. Mar/12/2019 16:07:59 [ db.orcl.orcl ] ORA-32701: Possible hangs up to hang ID= detected 7. Mar/12/2019 16:07:51 [ db.orcl.orcl ] ORA-07445: exception encountered: core dump [] [] [] [] [] [] 8. Mar/12/2019 16:07:49 [ db.orcl.orcl ] ORA-00700: soft internal error, arguments: [700], [], [],[] 9. Mar/11/2019 22:02:19 [ db.oradb.oradb ] DIA0 Critical Database Process Blocked: Hang ID 1 blocks 5 sessions 10. Default diagnostic collection, for no specific event Please choose the event : 1-10 [] 10 By default TFA will collect diagnostics for the last 12 hours. This can result in large collections For more targeted collections enter the time of the incident, otherwise hit <RETURN> to collect for the last 12 hours [YYYY-MM-DD HH24:MI:SS,<RETURN>=Collect for last 12 hours] : Collecting data for the last 12 hours for all components... Collecting data for all nodes Collection Id : 20190312163846node1 Detailed Logging at : /scratch/app/product/19c/tfa/repository/collection_Tue_Mar_12_16_38_47_PDT_2019_node_all/diagcollect_20190312163846_node1.log 2019/03/12 16:38:50 PDT : NOTE : Any file or directory name containing the string .com will be renamed to replace .com with dotcom 2019/03/12 16:38:50 PDT : Collection Name : tfa_Tue_Mar_12_16_38_47_PDT_2019.zip 2019/03/12 16:38:50 PDT : Collecting diagnostics from hosts : [node1] 2019/03/12 16:38:50 PDT : Scanning of files for Collection in progress... 2019/03/12 16:38:50 PDT : Collecting additional diagnostic information... 2019/03/12 16:38:55 PDT : Getting list of files satisfying time range [03/12/2019 04:38:50 PDT, 03/12/2019 16:38:55 PDT] 2019/03/12 16:39:02 PDT : Collecting ADR incident files... 2019/03/12 16:39:06 PDT : Completed collection of additional diagnostic information... 2019/03/12 16:39:07 PDT : Completed Local Collection .------------------------------------. | Collection Summary | +----------+-----------+------+------+ | Host | Status | Size | Time | +----------+-----------+------+------+ | node1 | Completed | 21MB | 17s | | '----------+-----------+------+------' Logs are being collected to: /scratch/app/product/19c/tfa/repository/collection_Tue_Mar_12_16_38_47_PDT_2019_node_all /scratch/app/product/19c/tfa/repository/collection_Tue_Mar_12_16_38_47_PDT_2019_node_all/node1.tfa_Tue_Mar_12_16_38_47_PDT_2019.zip</code></pre><pre class="pre codeblock"><code>$ tfactl diagcollect Choose the event you want to perform a diagnostic collection for: 1. Mar/12/2019 16:08:20 [ db.orcl.orcl ] ORA-04030: out of process memory when trying to allocate 2. Mar/12/2019 16:08:18 [ db.orcl.orcl ] ORA-04031: unable to allocate 8 bytes of shared memory 3. Mar/12/2019 16:08:16 [ db.orcl.orcl ] ORA-00494: enqueue held for too long more than seconds by osid 4. Mar/12/2019 16:08:14 [ db.orcl.orcl ] ORA-29709: Communication failure with Cluster Synchronization 5. Mar/12/2019 16:08:04 [ db.orcl.orcl ] ORA-29702: error occurred in Cluster Group Service operation 6. Mar/12/2019 16:07:59 [ db.orcl.orcl ] ORA-32701: Possible hangs up to hang ID= detected 7. Mar/12/2019 16:07:51 [ db.orcl.orcl ] ORA-07445: exception encountered: core dump [] [] [] [] [] [] 8. Mar/12/2019 16:07:49 [ db.orcl.orcl ] ORA-00700: soft internal error, arguments: [700], [], [],[] 9. Mar/11/2019 22:02:19 [ db.oradb.oradb ] DIA0 Critical Database Process Blocked: Hang ID 1 blocks 5 sessions 10. Default diagnostic collection, for no specific event Please choose the event : 1-10 [] 1 User root does not have permissions to run SRDC 'ora4030' for database 'orcl'.</code></pre></div> </div> </li> <li class="stepexpand"><span>To run a diagnostic collection for a specific event that does not have an SRDC:</span><div> <div class="p"><pre class="pre codeblock"><code>tfactl diagcollect</code></pre></div> <div class="p">For example:<pre class="pre codeblock"><code>$ tfactl diagcollect Choose the event you want to perform a diagnostic collection for: 1. Mar/12/2019 16:08:20 [ db.orcl.orcl ] ORA-04030: out of process memory when trying to allocate 2. Mar/12/2019 16:08:18 [ db.orcl.orcl ] ORA-04031: unable to allocate 8 bytes of shared memory 3. Mar/12/2019 16:08:16 [ db.orcl.orcl ] ORA-00494: enqueue held for too long more than seconds by osid 4. Mar/12/2019 16:08:14 [ db.orcl.orcl ] ORA-29709: Communication failure with Cluster Synchronization 5. Mar/12/2019 16:08:04 [ db.orcl.orcl ] ORA-29702: error occurred in Cluster Group Service operation 6. Mar/12/2019 16:07:59 [ db.orcl.orcl ] ORA-32701: Possible hangs up to hang ID= detected 7. Mar/12/2019 16:07:51 [ db.orcl.orcl ] ORA-07445: exception encountered: core dump [] [] [] [] [] [] 8. Mar/12/2019 16:07:49 [ db.orcl.orcl ] ORA-00700: soft internal error, arguments: [700], [], [],[] 9. Mar/11/2019 22:02:19 [ db.oradb.oradb ] DIA0 Critical Database Process Blocked: Hang ID 1 blocks 5 sessions 10. Default diagnostic collection, for no specific event Please choose the event : 1-10 [] 9 Collecting data for all nodes Scanning files from mar/11/2019 18:02:19 to mar/11/2019 23:02:19 Collection Id : 20190312162708node1 Detailed Logging at : /scratch/app/product/19c/tfa/repository/collection_Tue_Mar_12_16_27_09_PDT_2019_node_all/diagcollect_20190312162708_node1.log 2019/03/12 16:27:12 PDT : NOTE : Any file or directory name containing the string .com will be renamed to replace .com with dotcom 2019/03/12 16:27:12 PDT : Collection Name : tfa_Tue_Mar_12_16_27_09_PDT_2019.zip 2019/03/12 16:27:12 PDT : Collecting diagnostics from hosts : [node1] 2019/03/12 16:27:12 PDT : Scanning of files for Collection in progress... 2019/03/12 16:27:12 PDT : Collecting additional diagnostic information... 2019/03/12 16:27:17 PDT : Getting list of files satisfying time range [03/11/2019 18:02:19 PDT, 03/11/2019 23:02:19 PDT] 2019/03/12 16:27:23 PDT : Collecting ADR incident files... 2019/03/12 16:27:28 PDT : Completed collection of additional diagnostic information... 2019/03/12 16:27:33 PDT : Completed Local Collection .------------------------------------. | Collection Summary | +----------+-----------+------+------+ | Host | Status | Size | Time | +----------+-----------+------+------+ | node1 | Completed | 10MB | 21s | '----------+-----------+------+------' Logs are being collected to: /scratch/app/product/19c/tfa/repository/collection_Tue_Mar_12_16_27_09_PDT_2019_node_all /scratch/app/product/19c/tfa/repository/collection_Tue_Mar_12_16_27_09_PDT_2019_node_all/node1.tfa_Tue_Mar_12_16_27_09_PDT_2019.zip</code></pre></div> </div> </li> <li class="stepexpand"><span>To run a diagnostic collection for a specific event that has an SRDC:</span><div> <div class="infoboxnote" id="GUID-21A7A6A1-7589-425B-9327-49BB69DE84F3__GUID-FD0F0DFA-E48C-4AA7-8B78-FE55FC5ACAC7"> <p class="notep1">Note:</p>When choosing an SRDC the user running the collection needs to be in the <code class="codeph">dba</code> group of the database chosen in the event. </div> </div> <div> <div class="p"><pre class="pre codeblock"><code>tfactl diagcollect</code></pre></div> <div class="p">For example:<pre class="pre codeblock"><code>$ tfactl diagcollect Choose the event you want to perform a diagnostic collection for: 1. Mar/12/2019 16:08:20 [ db.orcl.orcl ] ORA-04030: out of process memory when trying to allocate 2. Mar/12/2019 16:08:18 [ db.orcl.orcl ] ORA-04031: unable to allocate 8 bytes of shared memory 3. Mar/12/2019 16:08:16 [ db.orcl.orcl ] ORA-00494: enqueue held for too long more than seconds by osid 4. Mar/12/2019 16:08:14 [ db.orcl.orcl ] ORA-29709: Communication failure with Cluster Synchronization 5. Mar/12/2019 16:08:04 [ db.orcl.orcl ] ORA-29702: error occurred in Cluster Group Service operation 6. Mar/12/2019 16:07:59 [ db.orcl.orcl ] ORA-32701: Possible hangs up to hang ID= detected 7. Mar/12/2019 16:07:51 [ db.orcl.orcl ] ORA-07445: exception encountered: core dump [] [] [] [] [] [] 8. Mar/12/2019 16:07:49 [ db.orcl.orcl ] ORA-00700: soft internal error, arguments: [700], [], [],[] 9. Mar/11/2019 22:02:19 [ db.oradb.oradb ] DIA0 Critical Database Process Blocked: Hang ID 1 blocks 5 sessions 10. Default diagnostic collection, for no specific event Please choose the event : 1-10 [] 1 Scripts to be run by this srdc: srdc_db_sid_memorysizes_10glower.sql srdc_db_sid_memorysizes_11gplus.sql ipspack Components included in this srdc: OS DATABASE CHMOS Collecting data for local node(s) Scanning files from Mar/12/2019 14:08:20 to Mar/12/2019 18:08:20 WARNING: End time entered is after the current system time. Collection Id : 20190312163524node1 Detailed Logging at : /scratch/app/product/19c/tfa/repository/srdc_ora4030_collection_Tue_Mar_12_16_35_25_PDT_2019_node_local/diagcollect_20190312163524_node1.log 2019/03/12 16:35:30 PDT : NOTE : Any file or directory name containing the string .com will be renamed to replace .com with dotcom 2019/03/12 16:35:30 PDT : Collection Name : tfa_srdc_ora4030_Tue_Mar_12_16_35_25_PDT_2019.zip 2019/03/12 16:35:30 PDT : Scanning of files for Collection in progress... 2019/03/12 16:35:30 PDT : Collecting additional diagnostic information... 2019/03/12 16:35:35 PDT : Getting list of files satisfying time range [03/12/2019 14:08:20 PDT, 03/12/2019 16:35:30 PDT] 2019/03/12 16:35:49 PDT : Collecting ADR incident files... 2019/03/12 16:35:52 PDT : Completed collection of additional diagnostic information... 2019/03/12 16:35:54 PDT : Completed Local Collection .-------------------------------------. | Collection Summary | +----------+-----------+-------+------+ | Host | Status | Size | Time | +----------+-----------+-------+------+ | node1 | Completed | 2.9MB | 24s | '----------+-----------+-------+------' Logs are being collected to: /scratch/app/product/19c/tfa/repository/srdc_ora4030_collection_Tue_Mar_12_16_35_25_PDT_2019_node_local /scratch/app/product/19c/tfa/repository/srdc_ora4030_collection_Tue_Mar_12_16_35_25_PDT_2019_node_local/node1.tfa_srdc_ora4030_Tue_Mar_12_16_35_25_PDT_2019.zip</code></pre></div> </div> </li> </ol> </div> <div> <div class="familylinks"> <div class="parentlink"> <p><strong>Parent topic:</strong> <a href="ondemand-diagnostic-collection.html#GUID-E4A2492E-A123-480A-B954-57898DBCE8BE" title="Use the custom collection options to change the diagnostic collections from the default.">Performing Custom Collections</a></p> </div> </div> </div> </div> <div class="sect3"><a id="GUID-E59870F2-324D-47D3-B615-0A19AFC1661C" name="GUID-E59870F2-324D-47D3-B615-0A19AFC1661C"></a><h4 id="AHFUG-GUID-E59870F2-324D-47D3-B615-0A19AFC1661C" class="sect4"><span class="enumeration_section">4.3.9.3 </span>Excluding Large Files from Diagnostic Collection </h4> <div> <p>Prevent excessively large files from delaying or stalling collections.</p> <div class="section"> <p>Run the <code class="codeph">tfactl set <span class="variable" translate="no">maxfilecollectionsize</span></code> for the diagnostic collection command to consider only the last 200 KB for the files that are larger than the size specified. </p> </div>  <ol> <li class="stepexpand"><span>To set the maximum file size:</span><div><pre class="pre codeblock"><code>tfactl set maxfilecollectionsize=<span class="variable" translate="no">size_in_MB</span></code></pre></div> </li> <li class="stepexpand"><span>To collect diagnostic data:</span><div><pre class="pre codeblock"><code>tfactl diagcollect</code></pre></div> </li> </ol> </div> <div> <div class="familylinks"> <div class="parentlink"> <p><strong>Parent topic:</strong> <a href="ondemand-diagnostic-collection.html#GUID-E4A2492E-A123-480A-B954-57898DBCE8BE" title="Use the custom collection options to change the diagnostic collections from the default.">Performing Custom Collections</a></p> </div> </div> </div> </div> <div class="sect3"><a id="GUID-0EEA807B-5785-484E-ACF9-2C14291A0AB3" name="GUID-0EEA807B-5785-484E-ACF9-2C14291A0AB3"></a><h4 id="AHFUG-GUID-0EEA807B-5785-484E-ACF9-2C14291A0AB3" class="sect4"><span class="enumeration_section">4.3.9.4 </span>Collecting from Specific Nodes </h4> <div> <p></p> <div class="section"> <p class="subhead3" id="GUID-0EEA807B-5785-484E-ACF9-2C14291A0AB3__GUID-BD3D694A-29E4-41CE-9D65-622505F6B6E1">To collect from specific nodes:</p> </div>  <ol class="single-step"> <li class="stepexpand"><span>To collect from specific nodes:</span><div> <div class="p"><pre class="pre codeblock"><code>tfactl diagcollect –node <span class="variable" translate="no">list of nodes</span></code></pre></div> <div class="p">For example:<pre class="pre codeblock"><code>$ tfactl diagcollect -last 1d -node myserver65</code></pre></div> </div> </li> </ol> </div> <div> <div class="relinfo"> <p><strong>Related Topics</strong></p> <ul> <li><a href="tfactl-diagcollect.html#GUID-4A06751C-9081-4158-88CB-EFBC77A797A0" title="Use the tfactl diagcollect command to perform on-demand diagnostic collection.">tfactl diagcollect</a></li> </ul> </div> <div class="familylinks"> <div class="parentlink"> <p><strong>Parent topic:</strong> <a href="ondemand-diagnostic-collection.html#GUID-E4A2492E-A123-480A-B954-57898DBCE8BE" title="Use the custom collection options to change the diagnostic collections from the default.">Performing Custom Collections</a></p> </div> </div> </div> </div> <div class="sect3"><a id="GUID-0FA3F135-C73E-444B-94FF-A2185D65E681" name="GUID-0FA3F135-C73E-444B-94FF-A2185D65E681"></a><h4 id="AHFUG-GUID-0FA3F135-C73E-444B-94FF-A2185D65E681" class="sect4"><span class="enumeration_section">4.3.9.5 </span>Collecting from Specific Components </h4> <div> <p></p> <div class="section"> <p class="subhead3" id="GUID-0FA3F135-C73E-444B-94FF-A2185D65E681__GUID-FC2829C5-60F8-4118-860A-E7DB07A5E745">To collect from specific components:</p> </div>  <ol class="single-step"> <li class="stepexpand"><span>To collect from specific components:</span><div><pre class="pre codeblock"><code>tfactl diagcollect <span class="variable" translate="no">component</span></code></pre><p>For example:</p> <div class="p">To trim and collect all files from the databases <code class="codeph"><span class="variable" translate="no">hrdb</span></code> and <code class="codeph"><span class="variable" translate="no">fdb</span></code> in the last 1 day:<pre class="pre codeblock"><code>tfactl –diagcollect -database hrdb,fdb -last 1d</code></pre></div> <div class="p">To trim and collect all Oracle Clusterware files, operating system logs, and CHMOS/OSW data from <code class="codeph"><span class="variable" translate="no">node1</span></code> and <code class="codeph"><span class="variable" translate="no">node2</span></code> updated in the last 6 hours:<pre class="pre codeblock"><code>tfactl diagcollect -crs -os -node node1,node2 -last 6h</code></pre></div> <div class="p">To trim and collect all Oracle ASM logs from <code class="codeph"><span class="variable" translate="no">node1</span></code> updated between from and to time:<pre class="pre codeblock"><code>tfactl diagcollect -asm -node node1 -from "2016-08-15" -to "2016-08-17"</code></pre></div> <div class="p">Following are the available component options. <div class="tblformal" id="GUID-0FA3F135-C73E-444B-94FF-A2185D65E681__GUID-48587D98-EEE2-4799-9886-97372B9D0F6D"> <p class="titleintable">Table 4-12 Component Options</p> <table cellpadding="4" cellspacing="0" class="Formal" title="Component Options" summary="This table lists and describes the available component options." frame="hsides" border="1" rules="rows"> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" width="20%" id="d64263e8173">Component Option</th> <th align="left" valign="bottom" width="20%" id="d64263e8175">Description</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e8179" headers="d64263e8173 "> <p><code class="codeph">-cha</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e8179 d64263e8175 "> <p>Collects Oracle Cluster Health Advisor logs.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e8187" headers="d64263e8173 "> <p><code class="codeph">-ips</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e8187 d64263e8175 ">Collects Incident Packaging Service logs.</td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e8194" headers="d64263e8173 "> <p><code class="codeph">-database <span class="variable" translate="no">database_names</span></code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e8194 d64263e8175 "> <p>Collects database logs from databases specified in a comma-separated list.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e8204" headers="d64263e8173 "> <p><code class="codeph">-asm</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e8204 d64263e8175 "> <p>Collects Oracle ASM logs.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e8212" headers="d64263e8173 "> <p><code class="codeph">-crsclient</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e8212 d64263e8175 "> <p>Collects Client Logs that are under <code>GIBASE/diag/clients</code>. </p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e8223" headers="d64263e8173 "> <p><code class="codeph">-dbclient</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e8223 d64263e8175 "> <p>Collects Client Logs that are under <code>DB ORABASE/diag/clients</code>. </p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e8234" headers="d64263e8173 "> <p><code class="codeph">-dbwlm</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e8234 d64263e8175 "> <p>Collects Database Workload Management (DBWLM) logs.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e8242" headers="d64263e8173 "> <p><code class="codeph">-tns</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e8242 d64263e8175 "> <p>Collects TNS logs.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e8250" headers="d64263e8173 "> <p><code class="codeph">-rhp</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e8250 d64263e8175 "> <p>Collects Rapid Home Provisioning (RHP) logs.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e8258" headers="d64263e8173 "> <p><code class="codeph">-procinfo</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e8258 d64263e8175 "> <p>Collects <code class="codeph">Gathers stack</code> and <code class="codeph">fd</code> from <code>/proc</code> for all processes. </p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e8275" headers="d64263e8173 "> <p><code class="codeph">-afd</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e8275 d64263e8175 "> <p>Collects AFD logs.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e8284" headers="d64263e8173 "> <p><code class="codeph">-crs</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e8284 d64263e8175 "> <p>Collects Oracle Clusterware logs.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e8292" headers="d64263e8173 "> <p><code class="codeph">-wls</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e8292 d64263e8175 "> <p>Collects Oracle WebLogic Server (WLS) logs.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e8300" headers="d64263e8173 "> <p><code class="codeph">-emagent</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e8300 d64263e8175 "> <p>Collects Oracle Enterprise Manager Agent (EMAGENT) logs.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e8308" headers="d64263e8173 "> <p><code class="codeph">-oms</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e8308 d64263e8175 "> <p>Collects Oracle Management Service (OMS) logs.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e8316" headers="d64263e8173 "> <p><code class="codeph">-ocm</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e8316 d64263e8175 "> <p>Collects Oracle Configuration Manager (OCM) logs.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e8324" headers="d64263e8173 "> <p><code class="codeph">-emplugins</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e8324 d64263e8175 "> <p>Collects Oracle Enterprise Manager Plug-ins (EMPLUGINS) logs.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e8332" headers="d64263e8173 "> <p><code class="codeph">-em</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e8332 d64263e8175 "> <p>Collects Oracle Enterprise Manager (EM) logs.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e8340" headers="d64263e8173 "> <p><code class="codeph">-acfs</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e8340 d64263e8175 "> <p>Oracle Advanced Cluster File System (Oracle ACFS).</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e8349" headers="d64263e8173 "> <p><code class="codeph">-install</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e8349 d64263e8175 "> <p>Collects Oracle Installation related files.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e8357" headers="d64263e8173 "> <p><code class="codeph">-cfgtools</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e8357 d64263e8175 "> <p>Collects configuration tools logs.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e8365" headers="d64263e8173 "> <p><code class="codeph">-os</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e8365 d64263e8175 "> <p>Collects operating system files such as <code>/var/log/messages</code> and <code>/var/log/exadatatmp/*netdiag*</code> files only on Exadata systems. </p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e8380" headers="d64263e8173 "> <p><code class="codeph">-ashhtml</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e8380 d64263e8175 "> <p>Collects Generate Active Session History (ASH) HTML report.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e8388" headers="d64263e8173 "> <p><code class="codeph">-ashtext</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e8388 d64263e8175 "> <p>Collects Generate Active Session History (ASH) text report.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e8396" headers="d64263e8173 "> <p><code class="codeph">-awrhtml</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e8396 d64263e8175 "> <p>Collects Automatic Workload Repository (AWR) HTML logs.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e8404" headers="d64263e8173 "> <p><code class="codeph">-awrtext</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e8404 d64263e8175 "> <p>Collects Automatic Workload Repository (AWR) text report.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e8412" headers="d64263e8173 "> <p><code class="codeph">-avs</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e8412 d64263e8175 "> <p>Collects Audit Vault Server logs.</p> </td> </tr> </tbody> </table> </div>  </div> </div> </li> </ol> </div> <div> <div class="relinfo"> <p><strong>Related Topics</strong></p> <ul> <li><a href="tfactl-diagcollect.html#GUID-4A06751C-9081-4158-88CB-EFBC77A797A0" title="Use the tfactl diagcollect command to perform on-demand diagnostic collection.">tfactl diagcollect</a></li> </ul> </div> <div class="familylinks"> <div class="parentlink"> <p><strong>Parent topic:</strong> <a href="ondemand-diagnostic-collection.html#GUID-E4A2492E-A123-480A-B954-57898DBCE8BE" title="Use the custom collection options to change the diagnostic collections from the default.">Performing Custom Collections</a></p> </div> </div> </div> </div> <div class="sect3"><a id="GUID-37F704DD-6A3E-4337-B089-4A21D30B978E" name="GUID-37F704DD-6A3E-4337-B089-4A21D30B978E"></a><h4 id="AHFUG-GUID-37F704DD-6A3E-4337-B089-4A21D30B978E" class="sect4"><span class="enumeration_section">4.3.9.6 </span>Collecting from Specific Directories </h4> <div> <p></p> <div class="section"> <p>Oracle Trace File Analyzer discovers all Oracle diagnostics and collects relevant files based on the type and last time updated.</p> <p>If you want to collect other files, then you can specify extra directories. Oracle Trace File Analyzer collects only the files updated in the relevant time range (one hour by default).</p> <p>You can configure collection of all files irrespective of the time last updated. Configure on a directory by directory basis using the <code class="codeph">-collectall</code> option. </p> </div>  <div class="section"> <p class="subhead3" id="GUID-37F704DD-6A3E-4337-B089-4A21D30B978E__GUID-7FF923B9-9EBB-465C-A4C4-38937519391D">To collect from specific directories:</p> </div>  <ol> <li class="stepexpand"><span>To include all files updated in the last one hour:</span><div> <div class="p"> <pre class="pre codeblock"><code>tfactl diagcollect –collectdir <span class="variable" translate="no">dir1,dir2,...dirn</span></code></pre> </div> <p>For example:</p> <div class="p">To trim and collect all Oracle Clusterware files updated in the last one hour as well as all files from <code>/tmp_dir1</code> and <code>/tmp_dir2</code> at the initiating node:<pre class="pre codeblock"><code>$ tfactl diagcollect –crs –collectdir /tmp_dir1,/tmpdir_2</code></pre></div> </div> </li> <li class="stepexpand"><span>To configure Oracle Trace File Analyzer to collect all files from a directory, first configure it with the <code class="codeph">-collectall</code> option:</span><div> <div class="p"> <pre class="pre codeblock"><code>$ tfactl add <span class="variable" translate="no">dir</span> -collectall</code></pre> </div> <p>or</p> <div class="p"> <pre class="pre codeblock"><code>tfactl modify <span class="variable" translate="no">dir</span> -collectall</code></pre> </div> <div class="p">Start a diagnostic collection using the <code class="codeph">-collectalldirs</code> option:<pre class="pre codeblock"><code>$ tfactl diagcollect -collectalldirs</code></pre></div> <div class="infoboxnote" id="GUID-37F704DD-6A3E-4337-B089-4A21D30B978E__GUID-B7490A32-E3FD-43BA-B007-F1F6EF0780B5"> <p class="notep1">Note:</p>If the <code class="codeph">-collectalldirs</code> option is not used normal, then the file type, name, and time range restrictions are applied. </div> </div> </li> </ol> </div> <div> <div class="relinfo"> <p><strong>Related Topics</strong></p> <ul> <li><a href="tfactl-diagcollect.html#GUID-4A06751C-9081-4158-88CB-EFBC77A797A0" title="Use the tfactl diagcollect command to perform on-demand diagnostic collection.">tfactl diagcollect</a></li> </ul> </div> <div class="familylinks"> <div class="parentlink"> <p><strong>Parent topic:</strong> <a href="ondemand-diagnostic-collection.html#GUID-E4A2492E-A123-480A-B954-57898DBCE8BE" title="Use the custom collection options to change the diagnostic collections from the default.">Performing Custom Collections</a></p> </div> </div> </div> </div> <div class="sect3"><a id="GUID-8AF18492-233A-4DB6-B116-6889798B4594" name="GUID-8AF18492-233A-4DB6-B116-6889798B4594"></a><h4 id="AHFUG-GUID-8AF18492-233A-4DB6-B116-6889798B4594" class="sect4"><span class="enumeration_section">4.3.9.7 </span>Changing the Collection Name </h4> <div> <p></p> <div class="section"> <p>Oracle Trace File Analyzer zips collections and puts the zip files in the repository directory using the following naming format:</p><pre class="pre codeblock"><code><span class="variable" translate="no">repository</span>/collection_<span class="variable" translate="no">date_time</span>/node_all/<span class="variable" translate="no">node</span>.tfa_<span class="variable" translate="no">date_time</span>.zip</code></pre><p>You must only change the name of the zipped files using the following options. Manually changing the file name prevents you from using collections with various Oracle Support self-service tools.</p> </div>  <div class="section"> <p class="subhead3" id="GUID-8AF18492-233A-4DB6-B116-6889798B4594__GUID-8E9BC718-6881-4489-8E3C-3A4EAC1AF786">To change the collection name:</p> </div>  <ol> <li class="stepexpand"><span>To use your own naming to organize collections:</span><div> <div class="p"><pre class="pre codeblock"><code>–tag <span class="variable" translate="no">tagname</span></code></pre></div> <p>The files are collected into <code class="codeph"><span class="variable" translate="no">tagname</span></code> directory inside the repository. </p> </div> </li> <li class="stepexpand"><span>To rename the <code>zip</code> file:</span><div> <div class="p"><pre class="pre codeblock"><code>–z <span class="variable" translate="no">zip name</span></code></pre></div> </div> </li> </ol> </div> <div> <div class="relinfo"> <p><strong>Related Topics</strong></p> <ul> <li><a href="tfactl-diagcollect.html#GUID-4A06751C-9081-4158-88CB-EFBC77A797A0" title="Use the tfactl diagcollect command to perform on-demand diagnostic collection.">tfactl diagcollect</a></li> </ul> </div> <div class="familylinks"> <div class="parentlink"> <p><strong>Parent topic:</strong> <a href="ondemand-diagnostic-collection.html#GUID-E4A2492E-A123-480A-B954-57898DBCE8BE" title="Use the custom collection options to change the diagnostic collections from the default.">Performing Custom Collections</a></p> </div> </div> </div> </div> <div class="sect3"><a id="GUID-7ACBBD2D-3F93-439D-A71A-5A5D69AD7D02" name="GUID-7ACBBD2D-3F93-439D-A71A-5A5D69AD7D02"></a><h4 id="AHFUG-GUID-7ACBBD2D-3F93-439D-A71A-5A5D69AD7D02" class="sect4"><span class="enumeration_section">4.3.9.8 </span>Preventing Copying Zip Files and Trimming Files </h4> <div> <p></p> <div class="section"> <p>By default, Oracle Trace File Analyzer Collector:</p> <ul style="list-style-type: disc;"> <li> <p>Copies back all zip files from remote notes to the initiating node</p> </li> <li> <p>Trims files around the relevant time</p> </li> </ul> </div>  <div class="section"> <p class="subhead3" id="GUID-7ACBBD2D-3F93-439D-A71A-5A5D69AD7D02__GUID-B83AC7B4-EE1B-448B-BC9A-75AC72BC8D45">To prevent copying zip files and trimming files:</p> </div>  <ol> <li class="stepexpand"><span>To prevent copying the zip file back to the initiating node:</span><div> <div class="p"><pre class="pre codeblock"><code>–nocopy</code></pre></div> <div class="p">For example:<pre class="pre codeblock"><code>$ tfactl diagcollect -last 1d -nocopy</code></pre></div> </div> </li> <li class="stepexpand"><span>To avoid trimming files:</span><div> <div class="p"><pre class="pre codeblock"><code>–notrim</code></pre></div> <div class="p">For example:<pre class="pre codeblock"><code>$ tfactl diagcollect -last 1d -notrim</code></pre></div> </div> </li> </ol> </div> <div> <div class="relinfo"> <p><strong>Related Topics</strong></p> <ul> <li><a href="tfactl-diagcollect.html#GUID-4A06751C-9081-4158-88CB-EFBC77A797A0" title="Use the tfactl diagcollect command to perform on-demand diagnostic collection.">tfactl diagcollect</a></li> </ul> </div> <div class="familylinks"> <div class="parentlink"> <p><strong>Parent topic:</strong> <a href="ondemand-diagnostic-collection.html#GUID-E4A2492E-A123-480A-B954-57898DBCE8BE" title="Use the custom collection options to change the diagnostic collections from the default.">Performing Custom Collections</a></p> </div> </div> </div> </div> <div class="sect3"><a id="GUID-7CA0360B-9996-43D3-B334-81DD5C470ACE" name="GUID-7CA0360B-9996-43D3-B334-81DD5C470ACE"></a><h4 id="AHFUG-GUID-7CA0360B-9996-43D3-B334-81DD5C470ACE" class="sect4"><span class="enumeration_section">4.3.9.9 </span>Performing Silent Collection </h4> <div> <p></p> <div class="section"></div>  <ol class="single-step"> <li class="stepexpand"><span>To initiate a silent collection:</span><div> <div class="p"><pre class="pre codeblock"><code>–silent</code></pre></div> <p>The <code class="codeph">diagcollect</code> command is submitted as a background process. </p> <div class="p">For example:<pre class="pre codeblock"><code>$ tfactl diagcollect -last 1d -silent</code></pre></div> </div> </li> </ol> </div> <div> <div class="relinfo"> <p><strong>Related Topics</strong></p> <ul> <li><a href="tfactl-diagcollect.html#GUID-4A06751C-9081-4158-88CB-EFBC77A797A0" title="Use the tfactl diagcollect command to perform on-demand diagnostic collection.">tfactl diagcollect</a></li> </ul> </div> <div class="familylinks"> <div class="parentlink"> <p><strong>Parent topic:</strong> <a href="ondemand-diagnostic-collection.html#GUID-E4A2492E-A123-480A-B954-57898DBCE8BE" title="Use the custom collection options to change the diagnostic collections from the default.">Performing Custom Collections</a></p> </div> </div> </div> </div> <div class="sect3"><a id="GUID-E97E09E7-E069-4162-BA2B-65738BE85E55" name="GUID-E97E09E7-E069-4162-BA2B-65738BE85E55"></a><h4 id="AHFUG-GUID-E97E09E7-E069-4162-BA2B-65738BE85E55" class="sect4"><span class="enumeration_section">4.3.9.10 </span>Collecting Core Files </h4> <div> <p></p> <div class="section"></div>  <ol class="single-step"> <li class="stepexpand"><span>To collect core files:</span><div> <div class="p"> <pre class="pre codeblock"><code>–cores</code></pre> </div> <div class="p">For example:<pre class="pre codeblock"><code>$ tfactl diagcollect -last 1d -cores</code></pre></div> </div> </li> </ol> </div> <div> <div class="relinfo"> <p><strong>Related Topics</strong></p> <ul> <li><a href="tfactl-diagcollect.html#GUID-4A06751C-9081-4158-88CB-EFBC77A797A0" title="Use the tfactl diagcollect command to perform on-demand diagnostic collection.">tfactl diagcollect</a></li> </ul> </div> <div class="familylinks"> <div class="parentlink"> <p><strong>Parent topic:</strong> <a href="ondemand-diagnostic-collection.html#GUID-E4A2492E-A123-480A-B954-57898DBCE8BE" title="Use the custom collection options to change the diagnostic collections from the default.">Performing Custom Collections</a></p> </div> </div> </div> </div> <div class="sect3"><a id="GUID-465A4E00-3A13-4FBA-8255-0AF98AF7B66E" name="GUID-465A4E00-3A13-4FBA-8255-0AF98AF7B66E"></a><h4 id="AHFUG-GUID-465A4E00-3A13-4FBA-8255-0AF98AF7B66E" class="sect4"><span class="enumeration_section">4.3.9.11 </span>Collecting Incident Packaging Service (IPS) Packages </h4> <div> <p>Incident Packaging Service packages details of problems stored by Oracle Database in ADR for later diagnosis.</p> <div class="section"> <p class="subhead3" id="GUID-465A4E00-3A13-4FBA-8255-0AF98AF7B66E__GUID-87B48AB2-B4FF-46F2-82D8-2E0C48CA0509">Syntax</p> <p>Oracle Trace File Analyzer runs IPS to query and collect these packages.</p> <div class="p"><pre class="pre codeblock"><code>tfactl ips <span class="variable" translate="no">option</span></code></pre></div> <div class="tblformal" id="GUID-465A4E00-3A13-4FBA-8255-0AF98AF7B66E__GUID-F5B400C8-0A52-4270-A07E-1DAC3EB6B610"> <p class="titleintable">Table 4-13 tfactl ips Command Parameters</p> <table cellpadding="4" cellspacing="0" class="Formal" title="tfactl ips Command Parameters" summary="This table lists and describes tfactl ips command parameters." frame="hsides" border="1" rules="rows"> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" width="20%" id="d64263e9699">Command</th> <th align="left" valign="bottom" width="20%" id="d64263e9701">Description</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e9705" headers="d64263e9699 "> <p><code class="codeph">tfactl ips</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e9705 d64263e9701 "> <p>Runs the IPS.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e9713" headers="d64263e9699 "> <p><code class="codeph">tfactl ips show incidents</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e9713 d64263e9701 "> <p>Shows all IPS incidents.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e9721" headers="d64263e9699 "> <p><code class="codeph">tfactl ips show problems</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e9721 d64263e9701 "> <p>Shows all IPS problems.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e9729" headers="d64263e9699 "> <p><code class="codeph">tfactl ips show package</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e9729 d64263e9701 "> <p>Shows all IPS Packages.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e9737" headers="d64263e9699 "> <p><code class="codeph">tfactl diagcollect -ips -h</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e9737 d64263e9701 "> <p>Shows all available <code class="codeph">diagcollect</code> IPS options. </p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e9748" headers="d64263e9699 "> <p><code class="codeph">tfactl diagcollect -ips</code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e9748 d64263e9701 "> <p>Performs an IPS collection following prompts. You can use all the standard <code class="codeph">diagcollect</code> options to limit the scope of IPS collection. </p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e9759" headers="d64263e9699 "> <p><code class="codeph">tfactl diagcollect -ips -adrbasepath <span class="variable" translate="no">adr_base</span> -adrhomepath <span class="variable" translate="no">adr_home</span></code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e9759 d64263e9701 "> <p>Performs an IPS collection in silent mode.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e9772" headers="d64263e9699 "> <p><code class="codeph">tfactl diagcollect -ips -incident <span class="variable" translate="no">incident_id</span></code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e9772 d64263e9701 "> <p>Collects ADR details about a specific incident id.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d64263e9782" headers="d64263e9699 "> <p><code class="codeph">tfactl diagcollect -ips -problem <span class="variable" translate="no">problem_id</span></code></p> </td> <td align="left" valign="top" width="20%" headers="d64263e9782 d64263e9701 "> <p>Collect ADR details about a specific problem id.</p> </td> </tr> </tbody> </table> </div>  <p>You can change the contents of the IPS package. Use the following options:</p> <ol> <li> <p>Start the collection.</p> </li> <li> <p>Suspend the collection using the <code class="codeph">-manageips</code> option. </p> <p>For example:</p><pre class="pre codeblock"><code>$ tfactl diagcollect -ips -incident <span class="variable" translate="no">incident_id</span> -manageips -node local</code></pre></li> <li> <p>Find the suspended collection using the <code class="codeph">print suspendedips</code> option. </p> <p>For example:</p><pre class="pre codeblock"><code>$ tfactl print suspendedips</code></pre></li> <li> <p>Manipulate the package.</p> </li> <li> <p>Resume the collection using the <code class="codeph">-resumeips</code> option. </p> <p>For example:</p><pre class="pre codeblock"><code>$ tfactl diagcollect -resumeips <span class="variable" translate="no">collection_id</span></code></pre></li> </ol> </div>  </div> <div> <div class="relinfo"> <p><strong>Related Topics</strong></p> <ul> <li><a href="tfactl-ips.html#GUID-62B3A421-21D3-4AE5-B57E-E1B15420C5D7" title="Use the tfactl ips  command to collect Automatic Diagnostic Repository diagnostic data.">tfactl ips</a></li> </ul> </div> <div class="familylinks"> <div class="parentlink"> <p><strong>Parent topic:</strong> <a href="ondemand-diagnostic-collection.html#GUID-E4A2492E-A123-480A-B954-57898DBCE8BE" title="Use the custom collection options to change the diagnostic collections from the default.">Performing Custom Collections</a></p> </div> </div> </div> </div> </div> <div class="sect2"><a id="GUID-1552A78B-9E9F-41C9-8DF4-DED1056D28A9" name="GUID-1552A78B-9E9F-41C9-8DF4-DED1056D28A9"></a><h3 id="AHFUG-GUID-1552A78B-9E9F-41C9-8DF4-DED1056D28A9" class="sect3"><span class="enumeration_section">4.3.10 </span>Limit the Maximum Amount of Memory Used by Oracle Trace File Analyzer </h3> <div> <p>You can now limit the amount of memory used by Oracle Trace File Analyzer.</p> <div class="infoboxnote" id="GUID-1552A78B-9E9F-41C9-8DF4-DED1056D28A9__GUID-0D552B64-2E91-40A7-90EE-4F9081AA91FC"> <p class="notep1">Note:</p> <p>This feature is available only on Linux and only when Autonomous Health Framework is installed using a full installation by the <code class="codeph">root</code> user. </p> </div> <p>Memory can be limited between 150 MB and 2GB or 25% of system memory, whichever is lower. By default, memory limits are enabled and set to the maximum.</p> <div class="p">There are various use cases including the following when Oracle Trace File Analyzer resource limits apply: <ul style="list-style-type: disc;" id="GUID-1552A78B-9E9F-41C9-8DF4-DED1056D28A9__UL_MTX_NV4_TNB"> <li>When Oracle Trace File Analyzer is performing automatic diagnostic collections, for example, when Oracle Trace File Analyzer detects an <code class="codeph">ORA-600</code> error has occurred and collects diagnostics for it. </li> <li>When running on-demand collections, for example, if you run an SRDC collection at the request of support.</li> <li>During any other Oracle Trace File Analyzer analysis such as using the <code class="codeph">tfactl analyze</code> command to search logs for recent errors. </li> </ul> </div> <p>Memory can be limited at either the system level using <code class="codeph">ahfctl setresourcelimit -resource kmem</code> or combined system and swap memory using <code class="codeph">ahfctl setresourcelimit -resource swmem</code></p> <p>For example:</p> <div class="p">To limit the memory usage to only 1 GB of system memory run:<pre class="pre codeblock"><code>ahfctl setresourcelimit -resource kmem -value 1024</code></pre></div> <div class="p">Alternatively, to limit the combined total of system memory and the swap memory to 2 GB run:<pre class="pre codeblock"><code>ahfctl setresourcelimit -resource swmem -value 2048</code></pre></div> </div> <div> <div class="relinfo"> <p><strong>Related Topics</strong></p> <ul> <li><a href="ahfctl-getresourcelimit.html#GUID-65CDCB44-E008-4CD9-86F2-3C7B75A8F43F" title="Use the ahfctl getresourcelimit command to fetch details of Oracle Trace File Analyzer CPU and memory usage limitations.">ahfctl getresourcelimit</a></li> <li><a href="ahfctl-setresourcelimit.html#GUID-B2F84D8E-D9C4-434E-8FBC-62DB3F60020F" title="Use the ahfctl setresourcelimit command to restrict the CPU and memory usage of Oracle Trace File Analyzer.">ahfctl setresourcelimit</a></li> <li><a href="ahfctl-unsetresourcelimit.html#GUID-3F9FC7C8-D4EE-46C0-8302-7D635D5AAF35" title="Use the ahfctl unsetresourcelimit command to unset the limitations set on Oracle Trace File Analyzer CPU and memory usage.">ahfctl unsetresourcelimit</a></li> </ul> </div> <div class="familylinks"> <div class="parentlink"> <p><strong>Parent topic:</strong> <a href="ondemand-diagnostic-collection.html#GUID-89D19AFB-0230-49AD-8C90-7B4E77A36174" title="Run Oracle Trace File Analyzer on demand using tfactl command-line tool.">Using On-Demand Diagnostic Collections</a></p> </div> </div> </div> </div> <div class="sect2"><a id="GUID-6D95E3ED-1488-4199-A834-E491AC3B6DA4" name="GUID-6D95E3ED-1488-4199-A834-E491AC3B6DA4"></a><h3 id="AHFUG-GUID-6D95E3ED-1488-4199-A834-E491AC3B6DA4" class="sect3"><span class="enumeration_section">4.3.11 </span>Limit Oracle Trace File Analyzer's CPU Usage </h3> <div> <p>On Linux the CPU usage of Oracle Trace File Analyzer can be limited with the command <code class="codeph">ahfctl setresourcelimit [-value <span class="variable" translate="no">value</span>]</code></p> <p>For example to limit Oracle Trace File Analyzer to a maximum of 50% of a single CPU use: <code class="codeph">ahfctl setresourcelimit -value <span class="variable" translate="no">0.5</span></code></p> <p>CPU resource limits for Oracle Trace File Analyzer can be set between a minimum of 0.5 and maximum of 4 or 75% of available CPUs, whichever is lower. By default, the Oracle Trace File Analyzer CPU limit is set to the maximum.</p> </div> <div> <div class="relinfo"> <p><strong>Related Topics</strong></p> <ul> <li><a href="ahfctl-getresourcelimit.html#GUID-65CDCB44-E008-4CD9-86F2-3C7B75A8F43F" title="Use the ahfctl getresourcelimit command to fetch details of Oracle Trace File Analyzer CPU and memory usage limitations.">ahfctl getresourcelimit</a></li> <li><a href="ahfctl-setresourcelimit.html#GUID-B2F84D8E-D9C4-434E-8FBC-62DB3F60020F" title="Use the ahfctl setresourcelimit command to restrict the CPU and memory usage of Oracle Trace File Analyzer.">ahfctl setresourcelimit</a></li> <li><a href="ahfctl-unsetresourcelimit.html#GUID-3F9FC7C8-D4EE-46C0-8302-7D635D5AAF35" title="Use the ahfctl unsetresourcelimit command to unset the limitations set on Oracle Trace File Analyzer CPU and memory usage.">ahfctl unsetresourcelimit</a></li> <li><a href="tfactl-setresourcelimit.html#GUID-9923B026-E5CF-4A52-843A-DA7E2B8CC37A" title="Use the tfactl setresourcelimit command to restrict the CPU and memory usage of Oracle Trace File Analyzer.">tfactl setresourcelimit</a></li> <li><a href="tfactl-getresourcelimit.html#GUID-CD53E7D5-E07C-4A13-A4EC-1809D51EF98F" title="Use the tfactl getresourcelimit command to fetch details of Oracle Trace File Analyzer CPU and memory usage limitations.">tfactl getresourcelimit</a></li> <li><a href="tfactl-unsetresourcelimit.html#GUID-050BE2A2-778C-445D-BE85-CE420279C471" title="Use the tfactl unsetresourcelimit command to unset the limitations set on Oracle Trace File Analyzer CPU and memory usage.">tfactl unsetresourcelimit</a></li> </ul> </div> <div class="familylinks"> <div class="parentlink"> <p><strong>Parent topic:</strong> <a href="ondemand-diagnostic-collection.html#GUID-89D19AFB-0230-49AD-8C90-7B4E77A36174" title="Run Oracle Trace File Analyzer on demand using tfactl command-line tool.">Using On-Demand Diagnostic Collections</a></p> </div> </div> </div> </div> </div> </article> </body> </html>

CINXE.COM

Using On-Demand Diagnostic Collections