Disable Tfa In Oracle 19c RAC-20220112
导读：
1.TFA是AHF（自主健康框架）的一部分，TFA可以帮助您收集和分析诊断数据。TFA从12.1.2.3.0之后封装很多oracle问题分析工具。例如：ORAchk,EXchk,OSWatcher,Procwatcher,ORATOP,SQLT,DARDA,alert summary等等，这些工具都不用自行安装了。
2.TFA生产系统中通常预估会占用2%-5%cpu和2%-5%memory。故在不需要收集信息的情况下我们是可以关闭的。
Oracle 19c Rac 关闭 Tfa 步骤如下：
1.检查状态
[root@rac1 ~]# tfactl status WARNING - TFA Software is older than 180 days. Please consider upgrading TFA to the latest version. .-------------------------------------------------------------------------------------------. | Host | Status of TFA | PID | Port | Version | Build ID | Inventory Status | +------+---------------+------+------+------------+----------------------+------------------+ | rac1 | RUNNING | 2186 | 5000 | 20.2.0.0.0 | 20200020200626072308 | COMPLETE | | rac2 | NOT RUNNING | - | | | | | | rac3 | NOT RUNNING | - | | | | | '------+---------------+------+------+------------+----------------------+------------------'
2.关闭自启动
[root@rac1 ~]# tfactl disable WARNING - TFA Software is older than 180 days. Please consider upgrading TFA to the latest version. TFA autostart has been disabled ..
3.关闭tfa
[root@rac1 ~]# tfactl stop WARNING - TFA Software is older than 180 days. Please consider upgrading TFA to the latest version. Stopping TFA from the Command Line WARNING - TFA Software is older than 180 days. Please consider upgrading TFA to the latest version. Stopped OSWatcher Nothing to do ! TFA-00104 Cannot establish connection with TFA Server. Please check TFA Certificates Killing TFA running with pid 2186 . . . Successfully stopped TFA..
4.检查是否关闭TFA
[root@rac1 ~]# tfactl status WARNING - TFA Software is older than 180 days. Please consider upgrading TFA to the latest version. TFA-00002 Oracle Trace File Analyzer (TFA) is not running # 已经关闭TFA
5.保证集群节点统一配置管理，故其余节点也执行关闭TFA操作
# rac2和rac3步骤省略，因过程和rac1节点相同
6.开启tfa
# 先tfactl enable后，才能tfactl start [root@rac3 ~]# tfactl enable WARNING - TFA Software is older than 180 days. Please consider upgrading TFA to the latest version. TFA autostart has been enabled .. [root@rac3 ~]# tfactl start WARNING - TFA Software is older than 180 days. Please consider upgrading TFA to the latest version. Starting TFA.. Waiting up to 100 seconds for TFA to be started.. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Successfully started TFA Process.. . . . . . WARNING - TFA Software is older than 180 days. Please consider upgrading TFA to the latest version. TFA Started and listening for commands
7.查看tfa默认配置
[root@rac3 ~]# tfactl print config WARNING - TFA Software is older than 180 days. Please consider upgrading TFA to the latest version. .---------------------------------------------------------------------------------------------------------------------. | rac3 | +--------------------------------------------------------------------------------------------------------+------------+ | Configuration Parameter | Value | +--------------------------------------------------------------------------------------------------------+------------+ | TFA Version ( tfaversion ) | 20.2.0.0.0 | | Java Version ( javaVersion ) | 1.8 | | Public IP Network ( publicIp ) | true | | Repository current size (MB) ( currentsizemegabytes ) | 163 | | Repository maximum size (MB) ( maxsizemegabytes ) | 10240 | | Cluster Event Monitor ( clustereventmonitor ) | ON | | collectAllDirsByFile | ON | | Auto Diagcollection ( autodiagcollect ) | ON | | Public IP Network ( publicIp ) | ON | | Flood Control ( floodcontrol ) | ON | | File Data Collection ( inventory ) | ON | | Automatic Purging ( autoPurge ) | ON | | Internal Search String ( internalSearchString ) | ON | | ISA Data Gathering ( collection.isa ) | ON | | Trim Files ( trimfiles ) | ON | | collectTrm | OFF | | odscan | ON | | Disk Usage Monitor ( diskUsageMon ) | OFF | | chanotification ( chanotification ) | ON | | Discovery ( discovery ) | ON | | analyze | OFF | | Managelogs Auto Purge ( manageLogsAutoPurge ) | OFF | | indexInventory | ON | | Generation of Telemetry Data ( telemetry ) | OFF | | chaautocollect | ON | | Granular Tracing ( granulartracing ) | OFF | | Alert Log Scan ( rtscan ) | ON | | debugips | OFF | | minPossibleSpaceForPurge | 1024 | | disk.threshold | 90 | | mem.swapfree | 5120 | | mem.util.samples | 4 | | inventoryThreadPoolSize | 1 | | mem.swaptotal.samples | 2 | | maxFileAgeToPurge | 1440 | | mem.free | 20480 | | Minimum Free Space to enable Alert Log Scan (MB) ( minSpaceForRTScan ) | 500 | | cpu.io.samples | 30 | | mem.util | 80 | | Time interval between consecutive Disk Usage Snapshot(minutes) ( diskUsageMonInterval ) | 60 | | TFA ISA Purge Thread Delay (minutes) ( tfaDbUtlPurgeThreadDelay ) | 60 | | firstDiscovery | 1 | | TFA IPS Pool Size ( tfaIpsPoolSize ) | 5 | | maxFileCollectionSize | 5120 | | Time interval between consecutive Managelogs Auto Purge(minutes) ( manageLogsAutoPurgeInterval ) | 60 | | arc.backupmissing.samples | 2 | | cpu.util.samples | 2 | | cpu.usr.samples | 2 | | cpu.sys | 50 | | Flood Control Limit Count ( fc.limit ) | 3 | | Flood Control Pause Time (minutes) ( fc.pauseTime ) | 120 | | maxLogCount | 10 | | cdb.backup.samples | 1 | | arc.backupstatus | 1 | | purgeFrequency | 4 | | TFA ISA Purge Age (seconds) ( tfaDbUtlPurgeAge ) | 604800 | | maxCoreCollectionSize | 500 | | cpu.util | 80 | | mem.swapfree.samples | 2 | | cdb.backupstatus | 1 | | mem.swaputl.samples | 2 | | arc.backup.samples | 1 | | unreachablenodeTimeOut | 3600 | | Flood Control Limit Time (minutes) ( fc.limitTime ) | 60 | | mem.swaputl | 10 | | mem.free.samples | 2 | | maxCoreFileSize | 50 | | disk.samples | 1 | | cpu.sys.samples | 30 | | cpu.usr | 98 | | arc.backupmissing | 1 | | cpu.io | 20 | | inventoryPurgeThreadInterval | 720 | | Age of Purging Collections (Hours) ( minFileAgeToPurge ) | 12 | | cpu.idle.samples | 2 | | unreachablenodeSleepTime | 300 | | cpu.idle | 20 | | mem.swaptotal | 24 | | TFA ISA CRS Profile Delay (minutes) ( tfaDbUtlCrsProfileDelay ) | 720 | | cdb.backupmissing | 1 | | cdb.backupmissing.samples | 2 | | Trim Size ( trimsize ) | 500000 | | maxLogSize | 52428800 | | minTimeForAutoDiagCollection | 300 | | skipScanThreshold | 100 | | fileCountInventorySwitch | 5000 | | TFA ISA Purge Mode ( tfaDbUtlPurgeMode ) | profile | | country | US | | Debug Mask (Hex) ( debugmask ) | 0x000000 | | Object Store Secure Upload ( oss.secure.upload ) | true | | Setting for ACR redaction (none|SANITIZE|MASK) ( redact ) | none | | language | en | | AlertLogLevel | ALL | | BaseLogPath | ERROR | | encoding | UTF-8 | | UserLogLevel | ALL | | Logs older than the time period will be auto purged(days[d]|hours[h]) ( manageLogsAutoPurgePolicyAge ) | 30d | '--------------------------------------------------------------------------------------------------------+------------'
8.tfa封装的组件一览
tfactl> toolstatus Wide character in print at /opt/oracle.ahf/tfa/bin/common/tfactlshare.pm line 1907. .------------------------------------------------------------------. | TOOLS STATUS - HOST : rac3 | +----------------------+--------------+--------------+-------------+ | Tool Type | Tool | Version | Status | +----------------------+--------------+--------------+-------------+ | Development Tools | orachk | 20.2.0.0.0 | DEPLOYED | | | oratop | 14.1.2 | DEPLOYED | +----------------------+--------------+--------------+-------------+ | Support Tools Bundle | darda | 2.10.0.R6036 | DEPLOYED | | | oswbb | 8.3.2 | NOT RUNNING | | | prw | 12.1.13.11.4 | NOT RUNNING | +----------------------+--------------+--------------+-------------+ | TFA Utilities | alertsummary | 20.2.0.0.0 | DEPLOYED | | | calog | 20.2.0.0.0 | DEPLOYED | | | dbcheck | 18.3.0.0.0 | DEPLOYED | | | dbglevel | 20.2.0.0.0 | DEPLOYED | | | grep | 20.2.0.0.0 | DEPLOYED | | | history | 20.2.0.0.0 | DEPLOYED | | | ls | 20.2.0.0.0 | DEPLOYED | | | managelogs | 20.2.0.0.0 | DEPLOYED | | | menu | 20.2.0.0.0 | DEPLOYED | | | param | 20.2.0.0.0 | DEPLOYED | | | ps | 20.2.0.0.0 | DEPLOYED | | | pstack | 20.2.0.0.0 | DEPLOYED | | | summary | 20.2.0.0.0 | DEPLOYED | | | tail | 20.2.0.0.0 | DEPLOYED | | | triage | 20.2.0.0.0 | DEPLOYED | | | vi | 20.2.0.0.0 | DEPLOYED | '----------------------+--------------+--------------+-------------' Note :- DEPLOYED : Installed and Available - To be configured or run interactively. NOT RUNNING : Configured and Available - Currently turned off interactively. RUNNING : Configured and Available.
9.参考文献
便捷的日志收集和分析工具TFA https://blogs.oracle.com/database4cn/post/tfa Oracle GI日志收集工具-TFA简介 https://blogs.oracle.com/database4cn/post/oracle-gi-tfa