工具： Autonomous Health Framework – TFA
Trace File Analyzer(TFA) 是oracle用于分析和收集日志的程序，可以安装在独立或集群节点的数据库节点上。从Oracle12.2开始，这个工具包含在 RDBMS 软件中，当我们运行 root.sh 脚本时，这也是可选的，如果不需要，我们仍然可以跳过它,从19c开始Oracle将ORAchk，EXAchk，TFA等多个诊断工具合并入Autonomous Health Framework(AHF)，作为一个独立的安装软件，也被集成到了RAC安装介质中，AHF可以使用root或者非root用户安装，但是用root可以收集更全的日志。 在我2021DTC分享的主题中有提到“Oracle Autonomous Health Framework是一种有助于预防和解决这些问题的解决方案。它的组件一起工作来识别数据库系统的潜在威胁，并提供纠正措施来修复它们。对于发生的问题，Oracle AHF通过识别问题、诊断其原因并提供解决方案，以帮助快速解决问题。Oracle AHF也收集Oracle支持服务(OSS)所需的相关信息，以快速解决问题。”
Oracle Autonomous Health Framework框架的功能较多，利用机器学习结合EMCC等，目标是实时的自动诊断、分析并提供解决方案，也可以快速收集ORACLE SR中常要的日志信息，也为我们平时分析故障提供了便利，这使 DBA 的工作变得轻松，例如，为了收集 8个节点的诊断信息，我们必须查看所有节点上的警报日志、侦听器日志，这将变得非常冗长，并且也不容易基于所有节点合并信息。 TFA 实用程序可以从 MOS 下载。
安装配置参考 Download the latest version from Autonomous Health Framework (AHF) – Including TFA and ORAchk/EXAChk (Doc ID 2550798.1)
查看状态:
oracle@> 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 | +-------+---------------+-------+------+------------+----------------------+------------------+ | anbob1 | RUNNING | 60664 | 5000 | 20.2.0.0.0 | 20200020200626072308 | COMPLETE | | anbob2 | RUNNING | 60716 | 5000 | 20.2.0.0.0 | 20200020200626072308 | COMPLETE | '-------+---------------+-------+------+------------+----------------------+------------------'
查看进程
oracle@anbob1:/home/oracle> ps -ef|grep tfa |grep -v grep root 58439 1 0 2021 ? 00:30:56 /bin/sh /etc/init.d/init.tfa run >/dev/null 2>&1 </dev/null root 60664 1 0 2021 ? 04:33:39 /opt/oracle.ahf/jre/bin/java -server -Xms512m -Xmx1024m -Djava.awt.headless=true -Ddisable.checkForUpdate=true -XX:HeapDumpPath=/oracle/app/grid/oracle.ahf/data/anbob1/diag/tfa -XX:ParallelGCThreads=5 oracle.rat.tfa.TFAMain /opt/oracle.ahf/tfa oracle@anbob1:/home/oracle>
注意有时安全扫描提示5000 port有安全风险，也就是tfa。
tfa自启动
如果观察安装日志可以发现在linux7中，自动启动是在增加了oracle-tfa.service OS服务 如systemctl status oracle-tfa 也可以停止或禁用 tfactl stop tfactl disable
日志收集
$tfactl diagcollect -from "2021-11-14 03:00:00" -to "2021-11-14 05:00:00" -all 如果提示： Not enough space in Repository or TFA_BASE to run collections 可以增加rep大小或改变路径 [root@anbob1 bin]# tfactl print repository [root@anbob1 bin]# tfactl set reposizeMB=20480 [root@anbob1 bin]# mkdir /tmp/repository [root@anbob1 bin]# tfactl set repositorydir=/tmp/repository [root@anbob1 bin]# ./tfactl diagcollect –h [root@anbob1 bin]# ./tfactl diagcollect -examples
tip:
当然收集的选项很丰富，可以查看help。
直接上传到SR
如果数据库服务器能够 ping 站点https://transport.oracle.com，可以将文件直接发送到 MOS。 $tfactl upload -sr SR_NUMBER -user MOS_USER FILE_YOU_WANT_TO_SEND
日志清理
我们习惯于使用 adrci 来正确管理我们的数据库日志,TFA 也可以清理 CRS 和数据库日志,Adrci 是可配置的，并根据配置的策略执行清除，而 tfactl managelogs 不会。此外，tfactl managelogs 也可清理Listener日志，您可以从一个节点清理所有集群日志，而无需连接到每台服务器以执行从 adrci 的清除。
有一个试运行选项，它将显示将被删除的内容和总释放空间，而无需实际删除任何文件
Usage : /oraadm/dba/ahf/oracle.ahf/tfa/bin/tfactl [run] managelogs [ -purge [[-older <m|h|d>] | [-gi] | [-database <all|d1,d2..>] | [-dryrun] ]] [ -show [usage|variation] [ [-older ] | [-gi] | [-database <all|d1,d2..>] ] ] [-node <all|local|node1,node2..>] Options: -purge Purge logs -older Timeperiod for log purge -gi Purge Grid Infrastructure logs(all ADR homes under GIBASE/diag and crsdata(cvu dirs)) -database Purge Database logs (Default all else provide list) -dryrun Estimate logs which will be cleared by purge command -show Print usage/variation details -older Timeperiod for change in log volume -gi Space utilization under GIBASE -database Space utilization for Database logs (Default all else provide list) -older <m|h|d> Files from past 'n' [d]ays or 'n' [h]ours or 'n' [m]inutes e.g: /oraadm/dba/ahf/oracle.ahf/tfa/bin/tfactl managelogs -purge -older 30d -dryrun /oraadm/dba/ahf/oracle.ahf/tfa/bin/tfactl managelogs -purge -older 30d /oraadm/dba/ahf/oracle.ahf/tfa/bin/tfactl managelogs -show usage
REST API
TFA 还附带一个 REST API，您可以使用 POST 和 GET http，您需要设置之前的使用，它将设置 2 个用户，tfaadmin 和 tfarest，并在服务器上启动 ORDS 服务。
显示配置
oracle@> tfactl print WARNING - TFA Software is older than 180 days. Please consider upgrading TFA to the latest version. Print requested details. Usage : /oracle/app/19c/grid/bin/tfactl print[options] commands:status|components|config|directories|hosts|actions|repository|runmode|suspendedips|protocols|smtp|collections For detailed help on each command use: /oracle/app/19c/grid/bin/tfactl print -help oracle@> tfactl print config WARNING - TFA Software is older than 180 days. Please consider upgrading TFA to the latest version. .---------------------------------------------------------------------------------------------------------------------. | ldcj1 | +--------------------------------------------------------------------------------------------------------+------------+ | 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 ) | 3584 | | 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 | '--------------------------------------------------------------------------------------------------------+------------' oracle@> tfactl print hosts WARNING - TFA Software is older than 180 days. Please consider upgrading TFA to the latest version. Host Name : anbob1 Host Name : anbob2 oracle@anbob1:/home/oracle> tfactl print repository WARNING - TFA Software is older than 180 days. Please consider upgrading TFA to the latest version. .--------------------------------------------------------------------. | anbob1 | +----------------------+---------------------------------------------+ | Repository Parameter | Value | +----------------------+---------------------------------------------+ | Location | /oracle/app/grid/oracle.ahf/data/repository | | Maximum Size (MB) | 10240 | | Current Size (MB) | 3584 | | Free Size (MB) | 6656 | | Status | OPEN | '----------------------+---------------------------------------------' .--------------------------------------------------------------------. | anbob2 | +----------------------+---------------------------------------------+ | Repository Parameter | Value | +----------------------+---------------------------------------------+ | Location | /oracle/app/grid/oracle.ahf/data/repository | | Maximum Size (MB) | 10240 | | Current Size (MB) | 2802 | | Free Size (MB) | 7438 | | Status | OPEN | '----------------------+---------------------------------------------' oracle@anbob1:/home/oracle> tfactl print directories WARNING - TFA Software is older than 180 days. Please consider upgrading TFA to the latest version. Last Rediscovery Run on andb1 : Mon Jan 24 22:38:24 CST 2022 .----------------------------------------------------------------------------------------------------------------------. | andb1 | +------------------------------------+---------------------------------------------------------+------------+----------+ | Trace Directory | Component | Permission | Added By | +------------------------------------+---------------------------------------------------------+------------+----------+ | /etc/oracle | [CRS] | public | root | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/19c/grid/cfgtoollogs | [CFGTOOLS, ODAPATCHING] | public | root | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/19c/grid/install | [INSTALL] | public | root | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/19c/grid/inventory/Con | [INSTALL] | public | root | | tentsXML | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/19c/grid/log/diag/asmt | [CRS] | public | root | | ool | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/19c/grid/log/diag/clie | [CRS] | public | root | | nts | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/19c/grid/log/andb1 | [CRS] | public | root | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/19c/grid/log/andb1/acf | [ACFS] | public | root | | s | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/19c/grid/log/andb1/adm | [CRS] | public | root | | in | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/19c/grid/log/andb1/afd | [ACFS] | public | root | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/19c/grid/log/andb1/cha | [CRS] | public | root | | d | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/19c/grid/log/andb1/cli | [CRS] | public | root | | ent | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/19c/grid/log/andb1/crs | [CRS] | public | root | | d | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/19c/grid/log/andb1/css | [CRS] | public | root | | d | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/19c/grid/log/andb1/cts | [CRS] | public | root | | sd | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/19c/grid/log/andb1/dis | [CRS] | public | root | | kmon | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/19c/grid/log/andb1/evm | [CRS] | public | root | | d | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/19c/grid/log/andb1/gip | [CRS] | public | root | | cd | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/19c/grid/log/andb1/gns | [CRS] | public | root | | d | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/19c/grid/log/andb1/gpn | [CRS] | public | root | | pd | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/19c/grid/log/andb1/mdn | [CRS] | public | root | | sd | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/19c/grid/log/andb1/oha | [CRS] | public | root | | sd | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/19c/grid/log/andb1/rac | [CRS] | public | root | | g | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/19c/grid/log/andb1/srv | [CRS] | public | root | | m | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/19c/grid/log/andb1/xag | [CRS] | public | root | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/19c/grid/rdbms/log | [ASM] | public | root | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/cfgtoollogs | [CFGTOOLS, ODAPATCHING] | public | root | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/cfgtoollogs/dbca | [CFGTOOLS, ODAPATCHING] | public | root | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/cfgtoollogs/dbca/ | [RDBMS]{RDBMS|database=-MGMTDB} | public | root | | -MGMTDB | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/cfgtoollogs/dbca/ | [RDBMS]{RDBMS|database=_mgmtdb} | public | root | | _mgmtdb | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/crsdata/@global/c | [CRS] | public | root | | rsconfig | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/crsdata/@global/c | [CRS] | public | root | | vu | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/crsdata/_global/C | [CRS] | public | root | | FEEC6754B2C122FE0533FF3E60A5273 | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/crsdata/_global/c | [CRS] | public | root | | had | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/crsdata/andb1/acf | [ACFS] | public | root | | s | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/crsdata/andb1/cal | [CRS] | public | root | | og | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/crsdata/andb1/cdp | [CRS] | public | root | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/crsdata/andb1/cha | [CRS] | public | root | | d | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/crsdata/andb1/cor | [CRS] | public | root | | e | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/crsdata/andb1/crf | [CRS] | public | root | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/crsdata/andb1/crs | [CRS] | public | root | | config | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/crsdata/andb1/crs | [CRS] | public | root | | diag | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/crsdata/andb1/css | [CRS] | public | root | | wd | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/crsdata/andb1/cvu | [CRS] | public | root | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/crsdata/andb1/evm | [CRS] | public | root | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/crsdata/andb1/ocr | [CRS] | public | root | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/crsdata/andb1/olr | [CRS] | public | root | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/crsdata/andb1/ons | [CRS] | public | root | | wallet | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/crsdata/andb1/out | [CRS] | public | root | | put | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/crsdata/andb1/ovm | [CRS] | public | root | | mwallets | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/crsdata/andb1/qos | [CRS] | public | root | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/crsdata/andb1/rhp | [RHP] | public | root | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/crsdata/andb1/sca | [CRS] | public | root | | nclusters | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/crsdata/andb1/scr | [CRS] | public | root | | ipts | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/crsdata/andb1/sec | [CRS] | public | root | | urity | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/crsdata/andb1/shm | [CRS] | public | root | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/crsdata/andb1/tra | [CRS] | public | root | | ce | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/crsdata/andb1/tra | [CHA] | public | root | | ce/chad | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/diag/asm/+asm/+AS | [ASM]{ASM|instance=+ASM1} | public | root | | M1/alert | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/diag/asm/+asm/+AS | [ASM]{ASM|instance=+ASM1} | public | root | | M1/cdump | | | | | Collection policy : No Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/diag/asm/+asm/+AS | [ASM]{ASM|instance=+ASM1} | public | root | | M1/incident | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/diag/asm/+asm/+AS | [ASM]{ASM|instance=+ASM1} | public | root | | M1/trace | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/diag/asmcmd/user_ | [ASM] | public | root | | grid/andb1/trace | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/diag/asmcmd/user_ | [ASM] | public | root | | root/andb1/trace | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/diag/asmtool/user | [ASMTOOL]{ASMTOOL|instance=user_root} | public | root | | _root/host_3316717043_110 | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/diag/asmtool/user | [ASMTOOL]{ASMTOOL|instance=user_root} | public | root | | _root/host_3316717043_110/cdump | | | | | Collection policy : No Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/diag/asmtool/user | [ASMTOOL]{ASMTOOL|instance=user_root} | public | root | | _root/host_3316717043_110/trace | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/diag/clients/user | [DBCLIENT]{DBCLIENT|instance=user_grid} | public | root | | _grid/host_3316717043_110 | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/diag/clients/user | [DBCLIENT]{DBCLIENT|instance=user_grid} | public | root | | _grid/host_3316717043_110/cdump | | | | | Collection policy : No Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/diag/clients/user | [DBCLIENT]{DBCLIENT|instance=user_grid} | public | root | | _grid/host_3316717043_110/trace | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/diag/clients/user | [DBCLIENT]{DBCLIENT|instance=user_root} | public | root | | _root/host_3316717043_110 | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/diag/clients/user | [DBCLIENT]{DBCLIENT|instance=user_root} | public | root | | _root/host_3316717043_110/cdump | | | | | Collection policy : No Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/diag/clients/user | [DBCLIENT]{DBCLIENT|instance=user_root} | public | root | | _root/host_3316717043_110/trace | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/diag/crs/andb1/cr | [CRS] | public | root | | s/cdump | | | | | Collection policy : No Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/diag/crs/andb1/cr | [CRS] | public | root | | s/incident | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/diag/crs/andb1/cr | [CRS] | public | root | | s/trace | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/diag/rdbms/_mgmtd | [RDBMS]{RDBMS|database=_mgmtdb, RDBMS|instance=-MGMTDB} | public | root | | b/-MGMTDB/cdump | | | | | Collection policy : No Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/diag/rdbms/_mgmtd | [RDBMS]{RDBMS|database=_mgmtdb, RDBMS|instance=-MGMTDB} | public | root | | b/-MGMTDB/incident | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/diag/rdbms/_mgmtd | [RDBMS]{RDBMS|database=_mgmtdb, RDBMS|instance=-MGMTDB} | public | root | | b/-MGMTDB/trace | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/diag/tnslsnr/ldcj | [TNS] | public | root | | 1/asmnet1lsnr_asm/trace | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/diag/tnslsnr/ldcj | [TNS] | public | root | | 1/listener | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/diag/tnslsnr/ldcj | [TNS] | public | root | | 1/listener/cdump | | | | | Collection policy : No Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/diag/tnslsnr/ldcj | [TNS] | public | root | | 1/listener/trace | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/diag/tnslsnr/ldcj | [TNS] | public | root | | 1/listener_1529 | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/diag/tnslsnr/ldcj | [TNS] | public | root | | 1/listener_1529/cdump | | | | | Collection policy : No Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/diag/tnslsnr/ldcj | [TNS] | public | root | | 1/listener_1529/trace | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/diag/tnslsnr/ldcj | [TNS] | public | root | | 1/listener_dgcja | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/diag/tnslsnr/ldcj | [TNS] | public | root | | 1/listener_dgcja/cdump | | | | | Collection policy : No Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/diag/tnslsnr/ldcj | [TNS] | public | root | | 1/listener_dgcja/trace | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/diag/tnslsnr/ldcj | [TNS] | public | root | | 1/listener_dgcjb | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/diag/tnslsnr/ldcj | [TNS] | public | root | | 1/listener_dgcjb/cdump | | | | | Collection policy : No Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/diag/tnslsnr/ldcj | [TNS] | public | root | | 1/listener_dgcjb/trace | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/diag/tnslsnr/ldcj | [TNS] | public | root | | 1/listener_scan1/cdump | | | | | Collection policy : No Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/diag/tnslsnr/ldcj | [TNS] | public | root | | 1/listener_scan1/trace | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/diag/tnslsnr/ldcj | [TNS] | public | root | | 1/mgmtlsnr/trace | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/oracle.ahf/data/r | [OS] | public | root | | epository/suptools/andb1/oswbb/gri | | | | | d/archive | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/grid/oracle.ahf/data/r | [RDBMS] | public | root | | epository/suptools/prw | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/oraInventory/ContentsX | [INSTALL] | private | root | | ML | | | | | Collection policy : Collect All | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/oraInventory/logs | [INSTALL] | private | root | | Collection policy : Collect All | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/oracle/cfgtoollogs | [CFGTOOLS, ODAPATCHING] | public | root | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/oracle/cfgtoollogs/dbc | [CFGTOOLS, ODAPATCHING] | public | root | | a | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/oracle/cfgtoollogs/dbc | [RDBMS]{RDBMS|database=accta} | public | root | | a/accta | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/oracle/diag/asmcmd/use | [ASM] | public | root | | r_oracle/andb1/trace | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/oracle/diag/asmcmd/use | [ASM] | public | root | | r_oracle/ldjfa1/trace | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/oracle/diag/clients/us | [DBCLIENT]{DBCLIENT|instance=user_oracle} | public | root | | er_oracle/host_2192911409_107/cdum | | | | | p | | | | | Collection policy : No Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/oracle/diag/clients/us | [DBCLIENT]{DBCLIENT|instance=user_oracle} | public | root | | er_oracle/host_2192911409_107/trac | | | | | e | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/oracle/diag/clients/us | [DBCLIENT]{DBCLIENT|instance=user_oracle} | public | root | | er_oracle/host_2192911409_110/cdum | | | | | p | | | | | Collection policy : No Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/oracle/diag/clients/us | [DBCLIENT]{DBCLIENT|instance=user_oracle} | public | root | | er_oracle/host_2192911409_110/trac | | | | | e | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/oracle/diag/clients/us | [DBCLIENT]{DBCLIENT|instance=user_oracle} | public | root | | er_oracle/host_3316717043_110/cdum | | | | | p | | | | | Collection policy : No Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/oracle/diag/clients/us | [DBCLIENT]{DBCLIENT|instance=user_oracle} | public | root | | er_oracle/host_3316717043_110/trac | | | | | e | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/oracle/diag/rdbms/cjb/ | [RDBMS]{RDBMS|database=cjb, RDBMS|instance=cjb1} | public | root | | cjb1/cdump | | | | | Collection policy : No Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/oracle/diag/rdbms/cjb/ | [RDBMS]{RDBMS|database=cjb, RDBMS|instance=cjb1} | public | root | | cjb1/trace | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/oracle/diag/rdbms/pric | [RDBMS]{RDBMS|database=pricj, RDBMS|instance=cj1} | public | root | | j/cj1/cdump | | | | | Collection policy : No Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/oracle/diag/rdbms/pric | [RDBMS]{RDBMS|database=pricj, RDBMS|instance=cj1} | public | root | | j/cj1/trace | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/oracle/diag/tnslsnr | [TNS] | public | root | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/oracle/product/19c/db_ | [CFGTOOLS, ODAPATCHING] | public | root | | 1/cfgtoollogs | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/oracle/product/19c/db_ | [INSTALL] | public | root | | 1/install | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/oracle/product/19c/db_ | [INSTALL] | private | root | | 1/inventory/ContentsXML | | | | | Collection policy : Collect All | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /oracle/app/oracle/product/19c/db_ | [RDBMS] | public | root | | 1/rdbms/log | | | | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /var/adm | [OS] | public | root | | Collection policy : Exclusions | | | | +------------------------------------+---------------------------------------------------------+------------+----------+ | /var/log | [OS, RACDBCLOUD, ODASTORAGE, ACFS] | public | root | | Collection policy : Exclusions | | | | '------------------------------------+---------------------------------------------------------+------------+----------'
工具集
oracle@> tfactl toolstatus WARNING - TFA Software is older than 180 days. Please consider upgrading TFA to the latest version. .------------------------------------------------------------------. | TOOLS STATUS - HOST : ldcj1 | +----------------------+--------------+--------------+-------------+ | 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 | 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.
分析异常事件
oracle@anbob1:/home/oracle> tfactl events -help WARNING - TFA Software is older than 180 days. Please consider upgrading TFA to the latest version. Lists all important events in system Usage : /oracle/app/19c/grid/bin/tfactl events [-search | -component <ASM|CRS> | -database | -instance | -source | -from
NOTE:
可以看到把日志中的错误可以过滤出来，如网络不通，DNS配置文件，CPU使用率高，ORA-4031等。
查看系统配置改变
有时需要查近期是否有做过什么变更,如参数
oracle@anbob1:/home/oracle> tfactl changes -last 5d
WARNING - TFA Software is older than 180 days. Please consider upgrading TFA to the latest version.
Output from host : anbob2
------------------------------
No Changes Found
Output from host : anbob1
------------------------------
No Changes Found
oracle@anbob1:/home/oracle> tfactl analyze -search "alter" -last 5d
WARNING - TFA Software is older than 180 days. Please consider upgrading TFA to the latest version.
oracle@anbob1:/home/oracle> tfactl analyze -search "ALERT" -last 5d
WARNING - TFA Software is older than 180 days. Please consider upgrading TFA to the latest version.
INFO: analyzing all (Alert and Unix System Logs) logs for the last 7200 minutes... Please wait...
INFO: analyzing host: anbob1
Report title: Analysis of Alert,System Logs
Report date range: last ~5 day(s)
Report (default) time zone: CST - China Standard Time
Analysis started at: 26-Jan-2022 10:17:03 AM CST
Elapsed analysis time: 1 minute(s), 9 second(s).
Configuration file: /opt/oracle.ahf/tfa/ext/tnt/conf/tnt.prop
Configuration group: all
Parameter: ALERT
Total message count: 266,942, from 04-Nov-2021 09:52:51 AM CST to 26-Jan-2022 10:15:34 AM CST
Messages matching last ~5 day(s): 2,600, from 21-Jan-2022 10:41:24 AM CST to 26-Jan-2022 10:15:34 AM CST
Matching regex: ALERT
Case sensitive: false
Match count: 0
INFO: analyzing all (Alert and Unix System Logs) logs for the last 7200 minutes... Please wait...
INFO: analyzing host: anbob2
Report title: Analysis of Alert,System Logs
Report date range: last ~5 day(s)
Report (default) time zone: CST - China Standard Time
Analysis started at: 26-Jan-2022 10:18:13 AM CST
Elapsed analysis time: 49 second(s).
Configuration file: /opt/oracle.ahf/tfa/ext/tnt/conf/tnt.prop
Configuration group: all
Parameter: ALERT
Total message count: 154,847, from 04-Nov-2021 10:01:53 AM CST to 26-Jan-2022 10:00:03 AM CST
Messages matching last ~5 day(s): 685, from 21-Jan-2022 10:37:02 AM CST to 26-Jan-2022 10:00:03 AM CST
Matching regex: ALERT
Case sensitive: false
Match count: 0
变更配置
需要root权限
tfactl set -help 设置合适的自动存储库大小 $ tfactl set reposizeMB=50000 （all node） 使用root用户给oracle和grid赋权 $ tfactl access promote -user oracle $ tfactl access promote -user grid 默认OSW未启用compress，如果进程过多，ps可能会占用较大空间，可以修改调度或启用压缩 $ tfactl stop oswbb $ tfactl start oswbb 10 72 gzip
更多使用可以查看 Oracle Premier Support – Oracle Database Support News – Issue February 2017, Volume 72 (Doc ID 2245222.1)
Oracle Trace File Analyzer (TFA) – an Overview Guide
— enjoy —
微信扫一扫，打赏作者吧～
对不起，这篇文章暂时关闭评论。