Oracle 19c TFA的安裝與使用
TFA日誌收集工具:
一.介紹:
TFA全稱：Trace File Analyzer，日誌分析工具。
TFA會監視的日誌，以發現可能影響服務的重大問題，在檢測到任何潛在問題時也會自動收集相關的診斷資訊。
TFA可以識別日誌檔案中的相關資訊，將日誌檔案修剪為解決問題所需的部分，還可以跨叢集節點收集資料，並將所有內容整合到一個地方。
工作方式:
1.DBA發出diagcollect命令，啟動TFA日誌收集程式。
2.本地TFA傳送收集請求至其他節點的TFA，在其他節點上開始日誌收集工作。
3.本地TFA也同時開始進行日誌收集工作。
4.所有涉及節點的TFA日誌都歸檔至發起diagcollect命令的"master"節點。
5.DBA提取已歸檔的TFA日誌資訊，進行分析或提交SR進行處理
二.安裝,啟動與關閉:
需配置root的環境變數，否則會報ERROR: ORACLE_HOME is not set
[root@rac19cn1 ~]# more .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
export ORACLE_HOME=/oracle/app/product/193000/db_1
[root@rac19cn1~]#cd /oracle/app/product/193000/db_1/suptools/tfa/release/tfa_home/install/
[root@rac19cn1 install]# ls
inittab_master init.tfa.tmpl oracle-tfa.conf oracle-tfa.service roottfa.sh
[root@ylr install]# ./roottfa.sh
Do you want to setup Oracle Trace File Analyzer (TFA) now ? yes|[no] :
yes
Installing Oracle Trace File Analyzer (TFA).
LogFile: /oracle/app/product/193000/db_1/install/root_rac19cn1_2020-08-26_11-14-01.log
Finished installing Oracle Trace File Analyzer (TFA)
安裝TFA完成
啟動關閉:
啟動:
[root@rac19cn1 bin]# ./tfactl
WARNING - TFA Software is older than 180 days. Please consider upgrading TFA to the latest version.
tfactl> start
Starting TFA..
Waiting up to 100 seconds for TFA to be started..
. . . . .
Message from syslogd@rac19cn1 at Nov 2 16:30:32 ...
kernel:do_IRQ: 0.153 No irq handler for vector (irq -1)
Successfully started TFA Process..
. . . . .
TFA Started and listening for commands
關閉:
tfactl> stop
三.日誌收集:
僅收集資料庫相關日誌
tfactl> diagcollect -database ora19c
By default TFA will collect diagnostics for the last 12 hours. This can result in large collections
For more targeted collections enter the time of the incident, otherwise hit <RETURN> to collect for the last 12 hours
[YYYY-MM-DD HH24:MI:SS,<RETURN>=Collect for last 12 hours] :
Collecting data for the last 12 hours for this component ...
Collecting data for all nodes
Collection Id : 20201103092107rac19cn1
Detailed Logging at : /oracle/gridbase/tfa/repository/collection_Tue_Nov_03_09_21_07_CST_2020_node_all/diagcollect_20201103092107_rac19cn1.log
2020/11/03 09:21:23 CST : NOTE : Any file or directory name containing the string .com will be renamed to replace .com with dotcom
2020/11/03 09:21:23 CST : Collection Name : tfa_Tue_Nov_03_09_21_07_CST_2020.zip
2020/11/03 09:21:24 CST : Collecting diagnostics from hosts : [rac19cn1, rac19cn2]
2020/11/03 09:21:25 CST : Scanning of files for Collection in progress...
2020/11/03 09:21:25 CST : Collecting additional diagnostic information...
2020/11/03 09:21:55 CST : Getting list of files satisfying time range [11/02/2020 21:21:23 CST, 11/03/2020 09:21:55 CST]
2020/11/03 09:22:52 CST : Completed collection of additional diagnostic information...
2020/11/03 09:29:02 CST : Collecting ADR incident files...
2020/11/03 09:29:03 CST : Completed Local Collection
2020/11/03 09:29:03 CST : Remote Collection in Progress...
.-------------------------------------.
| Collection Summary |
+----------+-----------+-------+------+
| Host | Status | Size | Time |
+----------+-----------+-------+------+
| rac19cn2 | Completed | 10kB | 61s |
| rac19cn1 | Completed | 137kB | 459s |
'----------+-----------+-------+------'
Logs are being collected to: /oracle/gridbase/tfa/repository/collection_Tue_Nov_03_09_21_07_CST_2020_node_all
/oracle/gridbase/tfa/repository/collection_Tue_Nov_03_09_21_07_CST_2020_node_all/rac19cn1.tfa_Tue_Nov_03_09_21_07_CST_2020.zip
/oracle/gridbase/tfa/repository/collection_Tue_Nov_03_09_21_07_CST_2020_node_all/rac19cn2.tfa_Tue_Nov_03_09_21_07_CST_2020.zip
收集指定時間的所有trace日誌
tfactl> diagcollect -for Nov/2/2020
Collecting data for all nodes
Scanning files for Nov/2/2020
Collection Id : 20201103101305rac19cn1
Detailed Logging at : /oracle/gridbase/tfa/repository/collection_Tue_Nov_03_10_13_05_CST_2020_node_all/diagcollect_20201103101305_rac19cn1.log
2020/11/03 10:13:13 CST : NOTE : Any file or directory name containing the string .com will be renamed to replace .com with dotcom
2020/11/03 10:13:13 CST : Collection Name : tfa_Tue_Nov_03_10_13_05_CST_2020.zip
2020/11/03 10:13:14 CST : Collecting diagnostics from hosts : [rac19cn1, rac19cn2]
2020/11/03 10:13:14 CST : Scanning of files for Collection in progress...
2020/11/03 10:13:14 CST : Collecting additional diagnostic information...
2020/11/03 10:14:39 CST : Getting list of files satisfying time range [11/02/2020 00:00:00 CST, 11/02/2020 23:59:59 CST]
2020/11/03 10:16:18 CST : Completed collection of additional diagnostic information...
2020/11/03 10:27:16 CST : Collecting ADR incident files...
2020/11/03 10:27:17 CST : Completed Local Collection
2020/11/03 10:27:18 CST : Remote Collection in Progress...
.-------------------------------------.
| Collection Summary |
+----------+-----------+-------+------+
| Host | Status | Size | Time |
+----------+-----------+-------+------+
| rac19cn2 | Completed | 294MB | 332s |
| rac19cn1 | Completed | 315MB | 843s |
'----------+-----------+-------+------'
Logs are being collected to: /oracle/gridbase/tfa/repository/collection_Tue_Nov_03_10_13_05_CST_2020_node_all
/oracle/gridbase/tfa/repository/collection_Tue_Nov_03_10_13_05_CST_2020_node_all/rac19cn1.tfa_Tue_Nov_03_10_13_05_CST_2020.zip
/oracle/gridbase/tfa/repository/collection_Tue_Nov_03_10_13_05_CST_2020_node_all/rac19cn2.tfa_Tue_Nov_03_10_13_05_CST_2020.zip
[root@rac19cn1 diag]# ls
asm clients crs rdbms tnslsnr
//監聽日誌 叢集日誌預設也會收集
***********只收集 2020.11.2的database trace日誌***********:
tfactl> diagcollect -database ora19c -for Nov/2/2020
***********只收集 2020.11.2的叢集日誌***********:
tfactl> diagcollect -crs -for Nov/2/2020
收集指定時間範圍的資料庫日誌:
tfactl> diagcollect -database ora19c -from "2020-11-02 18:00:00" -to "2020-11-03 08:00:00"
Collecting data for all nodes
Scanning files from nov/02/2020 18:00:00 to nov/03/2020 08:00:00
Collection Id : 20201106090421rac19cn1
Detailed Logging at : /oracle/gridbase/tfa/repository/collection_Fri_Nov_06_09_04_21_CST_2020_node_all/diagcollect_20201106090421_rac19cn1.log
2020/11/06 09:04:31 CST : NOTE : Any file or directory name containing the string .com will be renamed to replace .com with dotcom
2020/11/06 09:04:31 CST : Collection Name : tfa_Fri_Nov_06_09_04_21_CST_2020.zip
2020/11/06 09:04:32 CST : Collecting diagnostics from hosts : [rac19cn1, rac19cn2]
2020/11/06 09:04:32 CST : Scanning of files for Collection in progress...
2020/11/06 09:04:32 CST : Collecting additional diagnostic information...
2020/11/06 09:04:57 CST : Getting list of files satisfying time range [11/02/2020 18:00:00 CST, 11/03/2020 08:00:00 CST]
2020/11/06 09:05:47 CST : Completed collection of additional diagnostic information...
2020/11/06 09:12:57 CST : Collecting ADR incident files...
2020/11/06 09:12:57 CST : Completed Local Collection
2020/11/06 09:12:58 CST : Remote Collection in Progress...
.-------------------------------------.
| Collection Summary |
+----------+-----------+-------+------+
| Host | Status | Size | Time |
+----------+-----------+-------+------+
| rac19cn2 | Completed | 10kB | 83s |
| rac19cn1 | Completed | 185kB | 505s |
'----------+-----------+-------+------'
Logs are being collected to: /oracle/gridbase/tfa/repository/collection_Fri_Nov_06_09_04_21_CST_2020_node_all
/oracle/gridbase/tfa/repository/collection_Fri_Nov_06_09_04_21_CST_2020_node_all/rac19cn1.tfa_Fri_Nov_06_09_04_21_CST_2020.zip
/oracle/gridbase/tfa/repository/collection_Fri_Nov_06_09_04_21_CST_2020_node_all/rac19cn2.tfa_Fri_Nov_06_09_04_21_CST_2020.zip
***********收集一小時內資料庫日誌***********:
tfactl> diagcollect –database ora19c –since 1h
收集指定節點資料庫日誌:
tfactl> diagcollect -database ora19c -node rac19cn1 -for Nov/2/2020
Collecting data for rac19cn1 node(s)
Scanning files for Nov/2/2020
Collection Id : 20201106101221rac19cn1
Detailed Logging at : /oracle/gridbase/tfa/repository/collection_Fri_Nov_06_10_12_21_CST_2020_node_rac19cn1/diagcollect_20201106101221_rac19cn1.log
2020/11/06 10:12:31 CST : NOTE : Any file or directory name containing the string .com will be renamed to replace .com with dotcom
2020/11/06 10:12:31 CST : Collection Name : tfa_Fri_Nov_06_10_12_21_CST_2020.zip
2020/11/06 10:12:32 CST : Collecting diagnostics from hosts : [rac19cn1]
2020/11/06 10:12:32 CST : Scanning of files for Collection in progress...
2020/11/06 10:12:32 CST : Collecting additional diagnostic information...
2020/11/06 10:12:37 CST : Getting list of files satisfying time range [11/02/2020 00:00:00 CST, 11/02/2020 23:59:59 CST]
2020/11/06 10:13:37 CST : Completed collection of additional diagnostic information...
2020/11/06 10:21:19 CST : Collecting ADR incident files...
2020/11/06 10:21:20 CST : Completed Local Collection
.-------------------------------------.
| Collection Summary |
+----------+-----------+-------+------+
| Host | Status | Size | Time |
+----------+-----------+-------+------+
| rac19cn1 | Completed | 1.5MB | 528s |
'----------+-----------+-------+------'
Logs are being collected to: /oracle/gridbase/tfa/repository/collection_Fri_Nov_06_10_12_21_CST_2020_node_rac19cn1
/oracle/gridbase/tfa/repository/collection_Fri_Nov_06_10_12_21_CST_2020_node_rac19cn1/rac19cn1.tfa_Fri_Nov_06_10_12_21_CST_2020.zip
四.日誌分析:
Oracle提供了analyze命令來幫助我們分析資料庫當前的trace檔案
常用:
tfactl> analyze -search "ORA-" -since 1d INFO: analyzing all (Alert and Unix System Logs) logs for the last 1440 minutes... Please wait...
INFO: analyzing host: rac19cn1
Report title: Analysis of Alert,System Logs
Report date range: last ~1 day(s)
Report (default) time zone: CST - China Standard Time
Analysis started at: 06-Nov-2020 09:28:08 AM CST
Elapsed analysis time: 15 second(s).
Configuration file: /oracle/grid/crs_1/tfa/rac19cn1/tfa_home/ext/tnt/conf/tnt.prop
Configuration group: all
Parameter: ORA-
Total message count: 24,938, from 25-Aug-2020 06:22:19 PM CST to 06-Nov-2020 09:20:01 AM CST
Messages matching last ~1 day(s): 2,180, from 05-Nov-2020 09:30:01 AM CST to 06-Nov-2020 09:20:01 AM CST
Matching regex: ORA-
Case sensitive: false
Match count: 0
INFO: analyzing all (Alert and Unix System Logs) logs for the last 1440 minutes... Please wait...
INFO: analyzing host: rac19cn2
Report title: Analysis of Alert,System Logs
Report date range: last ~1 day(s)
Report (default) time zone: CST - China Standard Time
Analysis started at: 06-Nov-2020 09:28:26 AM CST
Elapsed analysis time: 8 second(s).
Configuration file: /oracle/grid/crs_1/tfa/rac19cn2/tfa_home/ext/tnt/conf/tnt.prop
Configuration group: all
Parameter: ORA-
Total message count: 35,060, from 25-Aug-2020 06:30:24 PM CST to 06-Nov-2020 09:20:02 AM CST
Messages matching last ~1 day(s): 4,940, from 05-Nov-2020 09:30:01 AM CST to 06-Nov-2020 09:20:02 AM CST
Matching regex: ORA-
Case sensitive: false
Match count: 0
以上os、db、asm、crs等所有日誌都分析.
僅分析最近兩天資料庫例項的日誌
tfactl> analyze -comp db -since 2d
-comp引數可以指定級別為os、db、asm、acfs、crs、all，預設的話是all，表示所有的都收集。
五:其他操作:
檢視當前哪些使用者可以使用tfactl
tfactl> access lsusers
.---------------------------------.
| TFA Users in rac19cn1 |
+-----------+-----------+---------+
| User Name | User Type | Status |
+-----------+-----------+---------+
| grid | USER | Allowed |
'-----------+-----------+---------'
.---------------------------------.
| TFA Users in rac19cn2 |
+-----------+-----------+---------+
| User Name | User Type | Status |
+-----------+-----------+---------+
| grid | USER | Allowed |
'-----------+-----------+---------'
TFA工具預設僅對root使用者和grid使用者授予使用許可權
[oracle@rac19cn1 bin]$ ./tfactl
TFA-00519 Oracle Trace File Analyzer (TFA) is not installed.
//oracle使用者使用出現未安裝
授予oracle使用者使用TFA的許可權
[root@rac19cn1 bin]#tfactl access add -user oracle
Successfully added 'oracle' to TFA Access list.
.---------------------------------.
| TFA Users in rac19cn1 |
+-----------+-----------+---------+
| User Name | User Type | Status |
+-----------+-----------+---------+
| grid | USER | Allowed |
| oracle | USER | Allowed |
'-----------+-----------+---------'
.---------------------------------.
| TFA Users in rac19cn2 |
+-----------+-----------+---------+
| User Name | User Type | Status |
+-----------+-----------+---------+
| grid | USER | Allowed |
| oracle | USER | Allowed |
'-----------+-----------+---------'
檢視當前主機狀態
tfactl> print status
.-----------------------------------------------------------------------------------------------.
| Host | Status of TFA | PID | Port | Version | Build ID | Inventory Status |
+----------+---------------+------+------+------------+----------------------+------------------+
| rac19cn1 | RUNNING | 9127 | 5000 | 18.3.3.0.0 | 18330020190315044534 | COMPLETE |
| rac19cn2 | RUNNING | 1848 | 5000 | 18.3.3.0.0 | 18330020190315044534 | COMPLETE |
'----------+---------------+------+------+------------+----------------------+------------------'
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/23825935/viewspace-2917429/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- Oracle 19c的安裝Oracle
- oracle 19c 安裝、解除安裝Oracle
- Docker中安裝Oracle 19cDockerOracle
- oracle 19C 靜默安裝Oracle
- Oracle 19c RPM安裝Oracle
- Oracle 19c 安裝嚐鮮Oracle
- Oracle Database 19c安裝Sample SchemasOracleDatabase
- Oracle 19C 下載和安裝Oracle
- oracle 19c dataguard silent install (oracle 19c dataguard 靜默安裝)Oracle
- Oracle 19C下載和安裝(二)Oracle
- Docker安裝Oracle 19c 詳細教程DockerOracle
- openPower伺服器安裝Oracle 19c伺服器Oracle
- Oracle 19C的下載和安裝部署（圖形安裝和靜默安裝）Oracle
- Disable Tfa In Oracle 19c RAC-20220112Oracle
- 使用免費的Oracle雲服務-在雲主機上安裝Oracle Database 19cOracleDatabase
- ogg for oracle 19c 非cdb安裝配置Oracle
- 【DB寶3】在Docker中使用rpm包的方式安裝Oracle 19cDockerOracle
- Oracle的安裝與基本使用（章節摘要）Oracle
- 安裝RAC 19C
- 19c安裝配置
- Oracle 安裝與解除安裝Oracle
- Oracle 19c RAC on Linux 7.6安裝手冊OracleLinux
- 從Oracle TFA偷師學藝Oracle
- 【BUILD_ORACLE】Oracle 19c RAC搭建（五）DB軟體安裝UIOracle
- ORACLE TEXT安裝與解除安裝Oracle
- 使用ansible-playbook自動化安裝Oracle DG資料庫19cOracle資料庫
- 【ASK_ORACLE】Oracle 19c RAC使用opatchauto安裝補丁報錯OPATCHAUTO-72083Oracle
- kafka的安裝與使用Kafka
- nvm的安裝與使用
- MySQLdb的安裝與使用MySql
- DrissionPage的安裝與使用
- 【BUILD_ORACLE】Oracle 19c RAC搭建（四）Grid軟體安裝UIOracle
- 【BUILD_ORACLE】Oracle 19c RAC搭建（一）安裝資源規劃UIOracle
- Oracle 19c rac安裝，只能啟動一個節點的ASMOracleASM
- PySpark與GraphFrames的安裝與使用Spark
- 使用yum安裝oracle的包Oracle
- Anaconda的安裝與使用
- DNSmasq 的安裝、配置與使用DNS