Disable Tfa In Oracle 19c RAC-20220112

lovehewenyu發表於2022-03-21

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



來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26442936/viewspace-2878853/,如需轉載,請註明出處,否則將追究法律責任。

相關文章