Disable Tfa In Oracle 19c RAC-20220112
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/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- Oracle 19c TFA的安裝與使用Oracle
- Disable Database Audit In Oracle 19c RAC-20220111DatabaseOracle
- 從Oracle TFA偷師學藝Oracle
- Oracle 19C EMOracle
- [20230327]19c sqlnet.ora disable_oob引數 ora-12637.txtSQL
- oracle 19c dataguard silent install (oracle 19c dataguard 靜默安裝)Oracle
- Oracle 19c Concepts(01)：Introduction to Oracle DatabaseOracleDatabase
- Oracle 19c Concepts(13)：Oracle Database InstanceOracleDatabase
- [20221222]How to Enable and Disable Database Options in oracle 11g.txtDatabaseOracle
- Oracle 19c Broker配置Oracle
- Oracle資料泵(Oracle Data Pump) 19cOracle
- Oracle：Oracle RAC 11.2.0.4 升級為 19cOracle
- Oracle 19c Concepts(10)：TransactionsOracle
- Oracle 19c RPM安裝Oracle
- oracle 19c 初體驗Oracle
- Oracle 19c中的TomcatOracleTomcat
- Oracle 19c Concepts(07)：SQLOracleSQL
- Oracle 19c的安裝Oracle
- oracle 19c pdb遷移Oracle
- Oracle 19c Database Management ToolsOracleDatabase
- Oracle 19c Concepts(00)：Changes in This Release for Oracle Database ConceptsOracleDatabase
- Oracle 19c Concepts(16)：Application and Oracle Net Services ArchitectureOracleAPP
- Overview of Oracle Flex ASM In Oracle 19c RAC-20220111ViewOracleFlexASM
- Disable the Evolve Job SYS_AUTO_SPM_EVOLVE_TASK in Oracle 12cOracle
- Oracle 19c - 手動升級 Oracle 12.x, 18c CDB 到 Oracle 19c (19.x)Oracle
- Oracle 19c Concepts(14)：Memory ArchitectureOracle
- Oracle 19c Concepts(15)：Process ArchitectureOracle
- Oracle 19c Concepts(05)：Data IntegrityOracle
- Sqlcl 連線Oracle DataBase 19cSQLOracleDatabase
- Oracle Linux 7.1 silent install 19cOracleLinux
- oracle 19c CDB vs pdb 建立Oracle
- Oracle 19c RAC INS-40724Oracle
- oracle 19C 靜默安裝Oracle
- Docker中安裝Oracle 19cDockerOracle
- 1 Oracle Database 19c 新特性OracleDatabase
- Oracle 19c 安裝嚐鮮Oracle
- LGnn 程式介紹（oracle 19c）GNNOracle
- 【19c】Oracle 19c 和 20c 的新特性解密Oracle解密