{"id":2274,"date":"2021-04-22T21:58:43","date_gmt":"2021-04-22T19:58:43","guid":{"rendered":"http:\/\/clemente.pamplona.name\/dba\/?p=2274"},"modified":"2021-04-23T10:28:33","modified_gmt":"2021-04-23T08:28:33","slug":"comandos-basicos-del-trace-file-analyzer","status":"publish","type":"post","link":"http:\/\/clemente.pamplona.name\/dba\/comandos-basicos-del-trace-file-analyzer\/","title":{"rendered":"Comandos basicos del Trace File Analyzer"},"content":{"rendered":"<p>Hoy vamos a ver los comandos y acciones basicas del <i>tafcl<\/I><br \/>\nEl <i>tafcl<\/I> es el comando de ejecucion del  Trace File Analyzer (TFA),  este peque\u00f1o script esta incluido dentro de la suite Autonomous Health Framework (AHF) , y sera o primero que nos solicite Oracle support una vez abramos un SR<\/p>\n<h1> Instalacion<\/h1>\n<p>Nos descargaremos el paquete de la AHF de la nota de soporte <i> Autonomous Health Framework (AHF) &#8211; Including TFA and ORAchk\/EXAchk (Doc ID 2550798.1 <\/i> Y lo ejecutaremos como superusuario el comando <i> ahf_setup<\/i>.<br \/>\nEste comando tiene varias opciones <\/p>\n<pre>\r\n   Usage for .\/ahf_setup\r\n\r\n   .\/ahf_setup [[-ahf_loc <location>][-data_dir <location>][-nodes <n1,n2>][-extract[orachk|exachk|-notfasetup] [-local][-silent][-tmp_loc <directory>][-force][-debug [-level <1-6>]]]\r\n\r\n        -ahf_loc          -    Install into the directory supplied. (Default \/opt\/oracle.ahf)\r\n        -data_dir         -    AHF Data Directory where all the collections, metadata, etc. will be stored\r\n        -nodes            -    Comma separated Remote Node List\r\n        -extract          -    Extract only files from Installer. (Default for non-root users)\r\n        -nosymlink        -    Do not create symlinks on Exadata DOM0. (Default for non-root users)\r\n        -notfasetup       -    Do not Configure TFA when used with -extract\r\n        -local            -    Only install on the local node\r\n        -silent           -    Do not ask any install questions\r\n        -tmp_loc          -    Temporary location directory for AHF to extract the install archive to (must exist) (Default \/tmp)\r\n        -perlhome         -    Custom location of perl binaries\r\n        -force            -    Force AHF Install\r\n        -debug            -    Debug AHF Install Script\r\n        -level            -    AHF Instal Debug Level 1-6 (Default 4 with option -debug)\r\n                               [FATAL - 1, ERROR - 2, WARNING - 3, INFO - 4, DEBUG - 5, TRACE - 6]\r\n<\/pre>\n<p>Si la instalacionn se hizo de manera estandard, el mismo TFA detectara la instalacion anterior y se actualizara.<br \/>\nVeamos un ejemplo de actualizacion.<\/p>\n<pre>\r\n[oracle@rac1 tmp]$ sudo .\/ahf_setup \r\n\r\nAHF Installer for Platform Linux Architecture x86_64\r\n\r\nAHF Installation Log : \/tmp\/ahf_install_211000_21804_2021_04_01-09_22_26.log\r\n\r\nStarting Autonomous Health Framework (AHF) Installation\r\n\r\nAHF Version: 21.1.0 Build Date: 202104131158\r\n\r\nAHF is already installed at \/opt\/oracle.ahf\r\n\r\nInstalled AHF Version: 20.2.3 Build Date: 202010132201\r\n\r\nDo you want to upgrade AHF [Y]|N : Y\r\n\r\nUpgrading \/opt\/oracle.ahf\r\n\r\nShutting down AHF Services\r\nShutting down TFA\r\nRemoved symlink \/etc\/systemd\/system\/multi-user.target.wants\/oracle-tfa.service.\r\nRemoved symlink \/etc\/systemd\/system\/graphical.target.wants\/oracle-tfa.service.\r\n. . . . .\r\n. . .\r\nSuccessfully shutdown TFA..\r\n\r\n\r\nStarting AHF Services\r\nStarting TFA..\r\nCreated symlink from \/etc\/systemd\/system\/multi-user.target.wants\/oracle-tfa.service to \/etc\/systemd\/system\/oracle-tfa.service.\r\nCreated symlink from \/etc\/systemd\/system\/graphical.target.wants\/oracle-tfa.service to \/etc\/systemd\/system\/oracle-tfa.service.\r\nWaiting up to 100 seconds for TFA to be started..\r\n. . . . .\r\n. . . . .\r\n. . . . .\r\nSuccessfully started TFA Process..\r\n. . . . .\r\nTFA Started and listening for commands\r\nNo new directories were added to TFA\r\n\r\n\r\nINFO: Starting orachk scheduler in background. Details for the process can be found at \/opt\/app\/oracle\/oracle.ahf\/data\/rac1\/diag\/orachk\/compliance_start_230421_093124.log\r\n\r\n\r\nAHF is successfully upgraded to latest version\r\n\r\n.------------------------------------------------------------------.\r\n| Host       | TFA Version | TFA Build ID         | Upgrade Status |\r\n+------------+-------------+----------------------+----------------+\r\n| rac1 |  21.1.0.0.0 | 21100020210413115827 | UPGRADED       |\r\n| rac2 |  20.2.3.0.0 | 20230020201013220107 | NOT UPGRADED   |\r\n'------------+-------------+----------------------+----------------'\r\n\r\nMoving \/tmp\/ahf_install_211000_21804_2021_04_01-09_22_26.log to \/opt\/app\/oracle\/oracle.ahf\/data\/rac1\/diag\/ahf\/\r\n\r\n<\/pre>\n<h1> Usos comunes <\/h1>\n<h2> Obtener informacion de las trazas en un determninado tiempo <\/h2>\n<pre>\r\nSi quremos recabar informacion del sistema entre unas determinadas fechas usaremos los fags <b>-from  -to<\/b>\r\n<pre>\r\n.\/tfactl diagcollect -from \"2021-04-07 08:00:00\" -to \"2021-04-07 10:00:00\"\r\n<\/pre>\n<h2> Obtener informacion ded un determinado error <\/h2>\n<p>Si quremos obtener informacion del sistema sobre un determinado error, usaremos el flag <b>srdc <\/b><\/p>\n<pre>\r\n.\/tfactl diagcollect -srdc ORA-07445\r\n<\/pre>\n<h1> Gestion del repositorio <\/h1>\n<h2> Ver la configuration <\/h2>\n<pre> \r\ntfactl> print config\r\n.---------------------------------------------------------------------------------------------------------------------.\r\n|                                                      wiracdev02                                                     |\r\n+--------------------------------------------------------------------------------------------------------+------------+\r\n| Configuration Parameter                                                                                | Value      |\r\n+--------------------------------------------------------------------------------------------------------+------------+\r\n| TFA Version ( tfaversion )                                                                             | 21.1.0.0.0 |\r\n| Java Version ( javaVersion )                                                                           | 1.8        |\r\n| Public IP Network ( publicIp )                                                                         | true       |\r\n| Repository current size (MB) ( currentsizemegabytes )                                                  | 293        |\r\n| Repository maximum size (MB) ( maxsizemegabytes )                                                      | 10240      |\r\n| Cluster Event Monitor ( clustereventmonitor )                                                          | ON         |\r\n| scandiskmon                                                                                            | OFF        |\r\n| scanacfslog                                                                                            | OFF        |\r\n| File Data Collection ( inventory )                                                                     | ON         |\r\n| Automatic Purging ( autoPurge )                                                                        | ON         |\r\n| Internal Search String ( internalSearchString )                                                        | ON         |\r\n| ISA Data Gathering ( collection.isa )                                                                  | ON         |\r\n| Trim Files ( trimfiles )                                                                               | ON         |\r\n| collectTrm                                                                                             | OFF        |\r\n| chmdataapi                                                                                             | ON         |\r\n| chanotification ( chanotification )                                                                    | ON         |\r\n| Managelogs Auto Purge ( manageLogsAutoPurge )                                                          | OFF        |\r\n| scanacfseventlog                                                                                       | OFF        |\r\n| Alert Log Scan ( rtscan )                                                                              | ON         |\r\n| debugips                                                                                               | OFF        |\r\n| generateZipMetadataJson                                                                                | ON         |\r\n| collectAllDirsByFile                                                                                   | ON         |\r\n| scanvarlog                                                                                             | OFF        |\r\n| Auto Diagcollection ( autodiagcollect )                                                                | ON         |\r\n| Public IP Network ( publicIp )                                                                         | ON         |\r\n| Flood Control ( floodcontrol )                                                                         | ON         |\r\n| Generation of Mini Collections ( minicollection )                                                      | ON         |\r\n| odscan                                                                                                 | ON         |\r\n| Disk Usage Monitor ( diskUsageMon )                                                                    | ON         |\r\n| Discovery ( discovery )                                                                                | ON         |\r\n| analyze                                                                                                | OFF        |\r\n| indexInventory                                                                                         | ON         |\r\n| Generation of Telemetry Data ( telemetry )                                                             | OFF        |\r\n| chaautocollect                                                                                         | ON         |\r\n| Granular Tracing ( granulartracing )                                                                   | OFF        |\r\n| minPossibleSpaceForPurge                                                                               | 1024       |\r\n| disk.threshold                                                                                         | 90         |\r\n| mem.swapfree                                                                                           | 5120       |\r\n| mem.util.samples                                                                                       | 4          |\r\n| inventoryThreadPoolSize                                                                                | 1          |\r\n| mem.swaptotal.samples                                                                                  | 2          |\r\n| maxFileAgeToPurge                                                                                      | 1440       |\r\n| mem.free                                                                                               | 20480      |\r\n| actionrestartlimit                                                                                     | 30         |\r\n| Minimum Free Space to enable Alert Log Scan (MB) ( minSpaceForRTScan )                                 | 500        |\r\n| cpu.io.samples                                                                                         | 30         |\r\n| mem.util                                                                                               | 80         |\r\n| Maximum single Zip File Size (MB) ( maxZipSize )                                                       | 2048       |\r\n| Time interval between consecutive Disk Usage Snapshot(minutes) ( diskUsageMonInterval )                | 60         |\r\n| TFA ISA Purge Thread Delay (minutes) ( tfaDbUtlPurgeThreadDelay )                                      | 60         |\r\n| firstDiscovery                                                                                         | 0          |\r\n| TFA IPS Pool Size ( tfaIpsPoolSize )                                                                   | 5          |\r\n| Maximum File Collection Size (MB) ( maxFileCollectionSize )                                            | 5120       |\r\n| Time interval between consecutive Managelogs Auto Purge(minutes) ( manageLogsAutoPurgeInterval )       | 60         |\r\n| arc.backupmissing.samples                                                                              | 2          |\r\n| cpu.util.samples                                                                                       | 2          |\r\n| cpu.usr.samples                                                                                        | 2          |\r\n| cpu.sys                                                                                                | 50         |\r\n| Flood Control Limit Count ( fc.limit )                                                                 | 3          |\r\n| Flood Control Pause Time (minutes) ( fc.pauseTime )                                                    | 120        |\r\n| Maximum Number of TFA Logs ( maxLogCount )                                                             | 10         |\r\n| DB Backup Delay Hours ( dbbackupdelayhours )                                                           | 27         |\r\n| cdb.backup.samples                                                                                     | 1          |\r\n| arc.backupstatus                                                                                       | 1          |\r\n| purgeFrequency                                                                                         | 4          |\r\n| TFA ISA Purge Age (seconds) ( tfaDbUtlPurgeAge )                                                       | 2592000    |\r\n| Maximum Collection Size of Core Files (MB) ( maxCoreCollectionSize )                                   | 200        |\r\n| cpu.util                                                                                               | 80         |\r\n| mem.swapfree.samples                                                                                   | 2          |\r\n| cdb.backupstatus                                                                                       | 1          |\r\n| mem.swaputl.samples                                                                                    | 2          |\r\n| arc.backup.samples                                                                                     | 3          |\r\n| unreachablenodeTimeOut                                                                                 | 3600       |\r\n| Flood Control Limit Time (minutes) ( fc.limitTime )                                                    | 60         |\r\n| mem.swaputl                                                                                            | 10         |\r\n| mem.free.samples                                                                                       | 2          |\r\n| Maximum Size of Core File (MB) ( maxCoreFileSize )                                                     | 20         |\r\n| disk.samples                                                                                           | 2          |\r\n| cpu.sys.samples                                                                                        | 30         |\r\n| cpu.usr                                                                                                | 98         |\r\n| arc.backupmissing                                                                                      | 1          |\r\n| cpu.io                                                                                                 | 20         |\r\n| Archive Backup Delay Minutes ( archbackupdelaymins )                                                   | 40         |\r\n| inventoryPurgeThreadInterval                                                                           | 720        |\r\n| Age of Purging Collections (Hours) ( minFileAgeToPurge )                                               | 12         |\r\n| cpu.idle.samples                                                                                       | 2          |\r\n| unreachablenodeSleepTime                                                                               | 300        |\r\n| cpu.idle                                                                                               | 20         |\r\n| mem.swaptotal                                                                                          | 24         |\r\n| TFA ISA CRS Profile Delay (minutes) ( tfaDbUtlCrsProfileDelay )                                        | 720        |\r\n| cdb.backupmissing                                                                                      | 1          |\r\n| cdb.backupmissing.samples                                                                              | 2          |\r\n| Trim Size ( trimsize )                                                                                 | 500000     |\r\n| Maximum Size of TFA Log (MB) ( maxLogSize )                                                            | 52428800   |\r\n| minTimeForAutoDiagCollection                                                                           | 300        |\r\n| skipScanThreshold                                                                                      | 100        |\r\n| fileCountInventorySwitch                                                                               | 5000       |\r\n| TFA ISA Purge Mode ( tfaDbUtlPurgeMode )                                                               | profile    |\r\n| country                                                                                                | US         |\r\n| Debug Mask (Hex) ( debugmask )                                                                         | 0x000000   |\r\n| Setting for ACR redaction (none|SANITIZE|MASK) ( redact )                                              | none       |\r\n| language                                                                                               | en         |\r\n| AlertLogLevel                                                                                          | ALL        |\r\n| BaseLogPath                                                                                            | ERROR      |\r\n| encoding                                                                                               | UTF-8      |\r\n| UserLogLevel                                                                                           | ALL        |\r\n| Logs older than the time period will be auto purged(days[d]|hours[h]) ( manageLogsAutoPurgePolicyAge ) | 30d        |\r\n| isaMode                                                                                                | enabled    |\r\n'--------------------------------------------------------------------------------------------------------+------------'\r\n\r\n\r\n<\/pre>\n<h2> cambio de ubicacion <\/h2>\n<p>Supongamos que queremos mover la ubicacion a un directorio compartido.<br \/>\nLa ultima rama del repositorio debe de llamarse <b> repository<\/b><\/p>\n<pre>\r\ntfactl set repositorydir=\/mnt\/tfa\/repository \r\n<\/pre>\n<h1> Desinstalacion <\/h1>\n<p>Para su desinstalacion simplemente tenemos que ejecutarlo con el flag <i> uninstall<\/i><\/p>\n<pre>\r\n[root@rac1 ~]$ which tfactl\r\n\/opt\/app\/12.1\/grid\/bin\/tfactl\r\n[root@rac1 ~]$  \/opt\/app\/12.1\/grid\/bin\/tfactl uninstall\r\n<\/pre>\n<p>Como siempre, mas infrmacion en oracle support:<\/p>\n<ul>\n<li> Autonomous Health Framework (AHF) - Including TFA and ORAchk\/EXAchk (Doc ID 2550798.1),\n<li> <a href=\"https:\/\/docs.oracle.com\/database\/121\/CWADD\/GUID-3749B526-056E-4FD5-9363-B25124781C14.htm\">tfactl diagcollect<\/a>\n<li> <a href=\"https:\/\/docs.oracle.com\/en\/engineered-systems\/health-diagnostics\/trace-file-analyzer\/tfaug\/managing-and-configuring-tfa.html#GUID-204AF3AF-06F7-45D7-9238-98A47DAA064F\">Managing and Configuring Oracle Trace File Analyzer<\/a>\n<li><a href=\"https:\/\/www.hhutzler.de\/blog\/trace-file-analyzer-collector-tfa-collector\/\">Trace File Analyzer Collector \u2013 TFA Collector Usage and installation<\/a>\n<li> <a href=\"https:\/\/oracle-base.com\/articles\/misc\/autonomous-health-framework-ahf\">Autonomous Health Framework (AHF) en Oracle Base<\/a>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Hoy vamos a ver los comandos y acciones basicas del tafcl El tafcl es el comando de ejecucion del Trace File Analyzer (TFA), este peque\u00f1o script esta incluido dentro de la suite Autonomous Health Framework (AHF) , y sera o &hellip; <a href=\"http:\/\/clemente.pamplona.name\/dba\/comandos-basicos-del-trace-file-analyzer\/\">Sigue leyendo <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9,66],"tags":[1013,1012],"class_list":["post-2274","post","type-post","status-publish","format-standard","hentry","category-dummie","category-errores-ora","tag-soporte","tag-tafcl"],"_links":{"self":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/2274","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/comments?post=2274"}],"version-history":[{"count":11,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/2274\/revisions"}],"predecessor-version":[{"id":2285,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/2274\/revisions\/2285"}],"wp:attachment":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/media?parent=2274"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/categories?post=2274"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/tags?post=2274"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}