Oracle Trace File Analyzer 介绍及简单使用
一、什么是Oracle Trace File Analyzer
Oracle Autonomous Health Framework(AHF) 包含 Oracle ORAchk, Oracle EXAchk, and Oracle Trace File Analyzer(TFA). AHF工具包包含了Oracle常用的多种诊断工具,如 ORAchk, Oracle EXAchk, and Oracle Trace File Analyzer(TFA)等,用于Oracle健康检查等用途。
AHF的下载地址:
Autonomous Health Framework (AHF) - Including TFA and ORAchk/EXAchk (Doc ID 2550798.1)
其中Oracle跟踪文件分析器(Oracle Trace File Analyzer)以下简称tfa,是Oracle提供的一个重要的数据库诊断工具。tfa可以收集诊断数据和诊断信息,监视日志中是否存在可能影响您服务的重大问题。tfa可以标识日志文件中的相关信息,将日志文件修整为仅解决问题所需的部分,还可以跨集群节点收集数据,并将所有内容整合到一个位置。
为获得AHF工具的完整功能,建议以root用户安装;如果非root用户安装,其功能会减少。如果已安装 AHF,则重新安装会在现有位置进行升级。
二、在Linux以守护程序模式在root用户下安装
要获得Oracle Trace File Analyzer的全部功能,需要在root用户下安装tfa。tfa维护访问控制列表(ACL),以确定允许哪些用户访问。默认情况下,GRID_HOME所有者和ORACLE_HOME所有者可以访问各自的诊断信息。如果已经安装了Oracle tfa,则重新安装将升级到现有位置;如果尚未安装Oracle tfa,则推荐位置为/opt/oracle.tfa。
在root用户下执行:
2.1. 下载最新版AHF
2.1.1 使用SSO登陆Oracle Support网站
https://support.oracle.com
2.1.2检索文档ID 2550798.1,下载最新版AHF。
Autonomous Health Framework (AHF)-Including TFA and ORAchk/EXAchk (Document 2550798.1)
安装AHF
2.2 将压缩包上传到RAC数据库服务器其中的一台数据库服务器并解压。
Unzip AHF-LINUX_22.2.4.zip
2.2 在解压后的目录中执行AHF的安装命令。
[root@dkf19c01 soft]# unzip AHF-LINUX_v22.3.2.zip
Archive: AHF-LINUX_v22.3.2.zipinflating: README.txt inflating: ahf_setup extracting: ahf_setup.dat inflating: oracle-tfa.pub
具体的安装命令如下:
# ./ahf_setup -ahf_loc /opt -data_dir <ORACLE_BASE of Grid owner>
# ./ahf_setup -ahf_loc /opt -data_dir /u01/app/grid
安装过程如下:
[root@dkf19c01 soft]# ./ahf_setup -ahf_loc /opt -data_dir /u01/app/gridAHF Installer for Platform Linux Architecture x86_64AHF Installation Log : /tmp/ahf_install_223200_9921_2023_02_11-22_19_09.logStarting Autonomous Health Framework (AHF) InstallationAHF Version: 22.3.2 Build Date: 202212190711TFA is already installed at : /u01/app/19.3.0/grid/tfa/dkf19c01/tfa_homeInstalled TFA Version : 183300 Build ID : 20190315044534AHF Location : /opt/oracle.ahfAHF Data Directory : /u01/app/grid/oracle.ahf/dataShutting down TFA : /u01/app/19.3.0/grid/tfa/dkf19c01/tfa_homeCopying TFA Data Files from /u01/app/19.3.0/grid/tfa/dkf19c01/tfa_homeUninstalling TFA : /u01/app/19.3.0/grid/tfa/dkf19c01/tfa_homeDo you want to add AHF Notification Email IDs ? [Y]|N : NAHF will also be installed/upgraded on these Cluster Nodes :1. dkf19c02The AHF Location and AHF Data Directory must exist on the above nodes
AHF Location : /opt/oracle.ahf
AHF Data Directory : /u01/app/grid/oracle.ahf/dataDo you want to install/upgrade AHF on Cluster Nodes ? [Y]|N : YExtracting AHF to /opt/oracle.ahfConfiguring TFA ServicesCopying TFA Data Files to AHFDiscovering Nodes and Oracle ResourcesStarting TFA Services
Created symlink from /etc/systemd/system/multi-user.target.wants/oracle-tfa.service to /etc/systemd/system/oracle-tfa.service.
Created symlink from /etc/systemd/system/graphical.target.wants/oracle-tfa.service to /etc/systemd/system/oracle-tfa.service..-----------------------------------------------------------------------------.
| Host | Status of TFA | PID | Port | Version | Build ID |
+----------+---------------+-------+------+------------+----------------------+
| dkf19c01 | RUNNING | 16604 | 5000 | 22.3.2.0.0 | 22320020221219071158 |
| dkf19c02 | RUNNING | 1532 | 5000 | 18.3.3.0.0 | 18330020190315044534 |
'----------+---------------+-------+------+------------+----------------------'Running TFA Inventory...Adding default users to TFA Access list....---------------------------------------------------------------.
| Summary of AHF Configuration |
+-----------------+---------------------------------------------+
| Parameter | Value |
+-----------------+---------------------------------------------+
| AHF Location | /opt/oracle.ahf |
| TFA Location | /opt/oracle.ahf/tfa |
| Orachk Location | /opt/oracle.ahf/orachk |
| Data Directory | /u01/app/grid/oracle.ahf/data |
| Repository | /u01/app/grid/oracle.ahf/data/repository |
| Diag Directory | /u01/app/grid/oracle.ahf/data/dkf19c01/diag |
'-----------------+---------------------------------------------'Starting Orachk Scheduler from AHFSetting up AHF CLI and SDKAHF install completed on dkf19c01Installing AHF on Remote Nodes :AHF will be installed on dkf19c02, Please wait.AHF will prompt twice to install/upgrade per Remote Node. So total 2 promptsDo you want to continue Y|[N] : YAHF will continue with Installing on remote nodesInstalling AHF on dkf19c02 :[dkf19c02] Copying AHF Installer
root@dkf19c02's password: [dkf19c02] Running AHF Installer
root@dkf19c02's password: AHF binaries are available in /opt/oracle.ahf/binAHF is successfully installedDo you want AHF to store your My Oracle Support Credentials for Automatic Upload ? Y|[N] : Moving /tmp/ahf_install_223200_9921_2023_02_11-22_19_09.log to /u01/app/grid/oracle.ahf/data/dkf19c01/diag/ahf/[root@dkf19c01 soft]#
2.3 查询版本确认安装成功:
[root@dkf19c01 soft]# tfactl version -all
TFA Version : 223200
TFA Build ID : 20221219071158
TFA Build Label : TFA_AHF22.3_GENERIC_221219.0508
[root@dkf19c01 soft]#
2.4 查询下tfactl 各个工具的信息如下:
[root@dkf19c02 bin]# tfactl toolstatusRunning command tfactltoolstatus on dkf19c01 ....------------------------------------------------------------------.
| TOOLS STATUS - HOST : dkf19c01 |
+----------------------+--------------+--------------+-------------+
| Tool Type | Tool | Version | Status |
+----------------------+--------------+--------------+-------------+
| AHF Utilities | alertsummary | 22.3.2 | DEPLOYED |
| | calog | 22.3.2 | DEPLOYED |
| | dbglevel | 22.3.2 | DEPLOYED |
| | grep | 22.3.2 | DEPLOYED |
| | history | 22.3.2 | DEPLOYED |
| | ls | 22.3.2 | DEPLOYED |
| | managelogs | 22.3.2 | DEPLOYED |
| | menu | 22.3.2 | DEPLOYED |
| | orachk | 22.3.2 | DEPLOYED |
| | param | 22.3.2 | DEPLOYED |
| | ps | 22.3.2 | DEPLOYED |
| | pstack | 22.3.2 | DEPLOYED |
| | summary | 22.3.2 | DEPLOYED |
| | tail | 22.3.2 | DEPLOYED |
| | triage | 22.3.2 | DEPLOYED |
| | vi | 22.3.2 | DEPLOYED |
+----------------------+--------------+--------------+-------------+
| Development Tools | oratop | 14.1.2 | DEPLOYED |
+----------------------+--------------+--------------+-------------+
| Support Tools Bundle | darda | 2.10.0.R6036 | DEPLOYED |
| | oswbb | 22.1.0AHF | RUNNING |
| | prw | 12.1.13.11.4 | NOT RUNNING |
'----------------------+--------------+--------------+-------------'Note :-DEPLOYED : Installed and Available - To be configured or run interactively.NOT RUNNING : Configured and Available - Currently turned off interactively.RUNNING : Configured and Available..------------------------------------------------------------------.
| TOOLS STATUS - HOST : dkf19c02 |
+----------------------+--------------+--------------+-------------+
| Tool Type | Tool | Version | Status |
+----------------------+--------------+--------------+-------------+
| AHF Utilities | alertsummary | 22.3.2 | DEPLOYED |
| | calog | 22.3.2 | DEPLOYED |
| | dbglevel | 22.3.2 | DEPLOYED |
| | grep | 22.3.2 | DEPLOYED |
| | history | 22.3.2 | DEPLOYED |
| | ls | 22.3.2 | DEPLOYED |
| | managelogs | 22.3.2 | DEPLOYED |
| | menu | 22.3.2 | DEPLOYED |
| | orachk | 22.3.2 | DEPLOYED |
| | param | 22.3.2 | DEPLOYED |
| | ps | 22.3.2 | DEPLOYED |
| | pstack | 22.3.2 | DEPLOYED |
| | summary | 22.3.2 | DEPLOYED |
| | tail | 22.3.2 | DEPLOYED |
| | triage | 22.3.2 | DEPLOYED |
| | vi | 22.3.2 | DEPLOYED |
+----------------------+--------------+--------------+-------------+
| Development Tools | oratop | 14.1.2 | DEPLOYED |
+----------------------+--------------+--------------+-------------+
| Support Tools Bundle | darda | 2.10.0.R6036 | DEPLOYED |
| | oswbb | 22.1.0AHF | RUNNING |
| | prw | 12.1.13.11.4 | NOT RUNNING |
'----------------------+--------------+--------------+-------------'Note :-DEPLOYED : Installed and Available - To be configured or run interactively.NOT RUNNING : Configured and Available - Currently turned off interactively.RUNNING : Configured and Available.[root@dkf19c02 bin]#
三、 执行TFA进行巡检:
Run a Oracle Trace File Analyzer (TFA) Collection
With the installation complete we can use the tfactl command to perform a number of collections, including TFA Service Request Data Collections (SRDC). There are a large number of SRDC collection types, with each gathering different information, as described here.Here are a few examples.cd /opt/oracle.ahf/tfa/bin/# Gather diagnostic information about TFA itself.
./tfactl diagnosetfa -local# Gather information about errors. You are prompted to select a specific incident.
./tfactl diagcollect -srdc ORA-00600
./tfactl diagcollect -srdc ORA-07445# Collect data for all components for a specific time period.
./tfactl diagcollect -from "2022-06-16 13:00:00" -to "2022-06-16 13:00:00"# Collect data for all components for the last 12 hours.
./tfactl diagcollect
Each TFA collection produces a single zip file that can be uploaded to My Oracle Support (MOS), as described below.
使用orachk工具进行RAC集群的健康巡检:
[root@dkf19c02 ~]# orachkClusterware stack is running from /u01/app/19.3.0/grid. Is this the correct Clusterware Home?[y/n][y] Searching for running databases . . . . .
. .
List of running databases registered in OCR1. dkf19c
2. None of aboveSelect databases from list for checking best practices. For multiple databases, select 1 for All or comma separated number like 1,2 etc [1-2][1].
. . . . . . Either Cluster Verification Utility pack (cvupack) does not exist at /opt/oracle.ahf/common/cvu or it is an old or invalid cvupackChecking Cluster Verification Utility (CVU) version at CRS Home - /u01/app/19.3.0/gridThis version of Cluster Verification Utility (CVU) was released on 13-Mar-2019 and it is older than 180 days. It is highly recommended that you download the latest version of CVU from MOS patch 30839369 to ensure the highest level of accuracy of the data contained within the reportDo you want to download latest version of Cluster Verification Utility (CVU) from my oracle support? [y/n] [y] nRunning older version of Cluster Verification Utility (CVU) from CRS Home - /u01/app/19.3.0/gridStarting to run orachk in background on dkf19c01 using socket
.
. . . .
. . Checking Status of Oracle Software Stack - Clusterware, ASM, RDBMS on dkf19c02
. . . . . .
. . . . . . . . . . . . .
-------------------------------------------------------------------------------------------------------Oracle Stack Status
-------------------------------------------------------------------------------------------------------Host Name CRS Installed RDBMS Installed CRS UP ASM UP RDBMS UP DB Instance Name
-------------------------------------------------------------------------------------------------------dkf19c02 Yes Yes Yes Yes Yes dkf19c2
-------------------------------------------------------------------------------------------------------
.
. . . . . .
.
.
.
.
. *** Checking Best Practice Recommendations ( Pass / Warning / Fail ) ***
.
============================================================Node name - dkf19c02
============================================================
. . . . . . Collecting - ASM Disk GroupsCollecting - ASM Disk I/O statsCollecting - ASM Diskgroup AttributesCollecting - ASM disk partnership imbalanceCollecting - ASM diskgroup attributesCollecting - ASM diskgroup usable free spaceCollecting - ASM initialization parametersCollecting - Active sessions load balance for dkf19c databaseCollecting - Archived Destination Status for dkf19c databaseCollecting - Cluster Interconnect Config for dkf19c databaseCollecting - Database Archive Destinations for dkf19c databaseCollecting - Database Files for dkf19c databaseCollecting - Database Instance Settings for dkf19c databaseCollecting - Database Parameters for dkf19c databaseCollecting - Database Properties for dkf19c databaseCollecting - Database Registry for dkf19c databaseCollecting - Database Sequences for dkf19c databaseCollecting - Database Undocumented Parameters for dkf19c databaseCollecting - Database Undocumented Parameters for dkf19c databaseCollecting - Database Workload Services for dkf19c databaseCollecting - Dataguard Status for dkf19c databaseCollecting - Files not opened by ASMCollecting - List of active logon and logoff triggers for dkf19c databaseCollecting - Log Sequence Numbers for dkf19c databaseCollecting - Percentage of asm disk ImbalanceCollecting - Process for shipping Redo to standby for dkf19c databaseCollecting - Redo Log information for dkf19c databaseCollecting - Standby redo log creation status before switchover for dkf19c databaseCollecting - /proc/cmdlineCollecting - /proc/modulesCollecting - CPU InformationCollecting - CRS active versionCollecting - CRS oifcfgCollecting - CRS software versionCollecting - CSS Reboot timeCollecting - Cluster interconnect (clusterware)Collecting - Clusterware OCR healthcheckCollecting - Clusterware Resource StatusCollecting - Disk I/O Scheduler on LinuxCollecting - DiskFree InformationCollecting - DiskMount InformationCollecting - Huge pages configurationCollecting - Interconnect network card speedCollecting - Kernel parametersCollecting - Linux module config.Collecting - Maximum number of semaphore sets on systemCollecting - Maximum number of semaphores on systemCollecting - Maximum number of semaphores per semaphore setCollecting - Memory InformationCollecting - NUMA ConfigurationCollecting - Network Interface ConfigurationCollecting - Network PerformanceCollecting - Network Service SwitchCollecting - OS PackagesCollecting - OS versionCollecting - Operating system release information and kernel versionCollecting - Oracle executable attributesCollecting - Patches for Grid InfrastructureCollecting - Patches for RDBMS HomeCollecting - RDBMS and GRID software owner UID across clusterCollecting - RDBMS patch inventoryCollecting - Shared memory segmentsCollecting - Table of file system defaultsCollecting - Voting disks (clusterware)Collecting - number of semaphore operations per semop system callCollecting - CHMAnalyzer to report potential Operating system resources usageCollecting - CRS Opatch versionCollecting - CRS user time zone checkCollecting - Clusterware patch inventoryCollecting - Custom rc init scripts (rc.local)Collecting - Disk InformationCollecting - Grid Infastructure user shell limits configurationCollecting - Interconnect interface configCollecting - Linux system service and RAC process configurationCollecting - Network interface statsCollecting - Root user limitsCollecting - Verify ORAchk scheduler configurationCollecting - Verify TCP Selective Acknowledgement is enabledCollecting - Verify no database server kernel out of memory errorsCollecting - Verify the vm.min_free_kbytes configurationCollecting - root time zone checkCollecting - slabinfoCollecting - umask setting for GI ownerData collections completed. Checking best practices on dkf19c02.
------------------------------------------------------------INFO => Important Automatic Storage Management (ASM) Notes and Technical White PapersINFO => Oracle Data Pump Best practices.WARNING => Linux swap configuration does not meet recommendationWARNING => Hidden database initialization parameters should not be set per best practice recommendations for dkf19cINFO => Most recent ADR incidents for /u01/app/oracle/product/19.3.0/dbhome_1INFO => Oracle GoldenGate failure prevention best practicesWARNING => One or more open PDBs have failed service verification checks for dkf19cWARNING => OCR and OCR backup locations are the same pathFAIL => The vm.min_free_kbytes configuration is not set as recommendedCRITICAL => The RMAN snapshot control file location is not shared on all database nodes in the cluster for dkf19cCRITICAL => Temporary location is not configured for auto cleanupINFO => Important Storage Minimum Requirements for Grid & Database HomesWARNING => NIC bonding is not configured for interconnectWARNING => NIC bonding is NOT configured for public network (VIP)WARNING => RAC interconnect network card speed does not meet recommendationFAIL => system service rngd is not runningINFO => Jumbo frames (MTU >= 9000) are not configured for interconnectWARNING => All disk groups should have compatible.rdbms attribute set to recommended valuesWARNING => All disk groups should have compatible.advm attribute set to recommended valuesFAIL => One or more log archive destination and alternate log archive destination settings are not as recommended for dkf19cWARNING => Database home does not fix for bug 30937410 /u01/app/oracle/product/19.3.0/dbhome_1FAIL => Database parameter DB_LOST_WRITE_PROTECT is not set to recommended value on dkf19c2 instanceFAIL => Database parameter DB_BLOCK_CHECKING on primary is not set to the recommended value. for dkf19cWARNING => Oracle patch 30786641 is not applied on RDBMS_HOME /u01/app/oracle/product/19.3.0/dbhome_1INFO => Operational Best PracticesINFO => Database Consolidation Best PracticesINFO => Computer failure prevention best practicesINFO => Data corruption prevention best practicesINFO => Logical corruption prevention best practicesINFO => Database/Cluster/Site failure prevention best practicesINFO => Client failover operational best practicesWARNING => fast_start_mttr_target should be greater than or equal to 300 on dkf19c2 instanceWARNING => Oracle patch 30712670 is not applied on RDBMS_HOME /u01/app/oracle/product/19.3.0/dbhome_1WARNING => Oracle patch 29423227 is not applied on RDBMS_HOME /u01/app/oracle/product/19.3.0/dbhome_1WARNING => Oracle patch 31031240 is not applied on RDBMS_HOME /u01/app/oracle/product/19.3.0/dbhome_1WARNING => Oracle patch 29867728 is not applied on RDBMS_HOME /u01/app/oracle/product/19.3.0/dbhome_1WARNING => Oracle patch 31142749 is not applied on RDBMS_HOME /u01/app/oracle/product/19.3.0/dbhome_1WARNING => Oracle patch 26749785 is not applied on RDBMS_HOME /u01/app/oracle/product/19.3.0/dbhome_1WARNING => Oracle patch 29302565 is not applied on RDBMS_HOME /u01/app/oracle/product/19.3.0/dbhome_1WARNING => Oracle patch 29259068 is not applied on RDBMS_HOME /u01/app/oracle/product/19.3.0/dbhome_1INFO => Information about hanganalyze and systemstate dumpFAIL => Database control files are not configured as recommended for dkf19cWARNING => Oracle patch 28907129 is not applied on RDBMS_HOME /u01/app/oracle/product/19.3.0/dbhome_1INFO => Database failure prevention best practicesFAIL => ASM Credentials are NOT set correctly.WARNING => Perl Patch 33912872 is not found in 19c RDBMS_HOME. /u01/app/oracle/product/19.3.0/dbhome_1WARNING => Perl Patch 33912872 is not found in 19c CRS_HOME. /u01/app/19.3.0/gridWARNING => Oracle patch 32043701 is not applied on RDBMS_HOME /u01/app/oracle/product/19.3.0/dbhome_1WARNING => Oracle patch 31602782 is not applied on RDBMS_HOME /u01/app/oracle/product/19.3.0/dbhome_1WARNING => Oracle patch 33121934 is not applied on RDBMS_HOME /u01/app/oracle/product/19.3.0/dbhome_1WARNING => Oracle patch 33025005 is not applied on RDBMS_HOME /u01/app/oracle/product/19.3.0/dbhome_1WARNING => Oracle patch 32103628 is not applied on RDBMS_HOME /u01/app/oracle/product/19.3.0/dbhome_1WARNING => Oracle patch 31211220 is not applied on RDBMS_HOME /u01/app/oracle/product/19.3.0/dbhome_1INFO => The Optimizer fixes for 19c database version is disabled by default for bugs with status value 0 for dkf19cINFO => Software maintenance best practicesINFO => Oracle recovery manager(rman) best practicesWARNING => Linux Disk I/O Scheduler should be configured to DeadlineWARNING => There exists one or more underscore parameters without a comment for dkf19cWaiting for orachk to finish on remote nodes . . . . . . . . . . . . . . . . Copying results from dkf19c01 and generating report. This might take a while. Be patient.============================================================Node name - dkf19c01
============================================================
. . . . . . Collecting - ASM Disk GroupsCollecting - ASM Disk I/O statsCollecting - ASM Diskgroup AttributesCollecting - ASM disk partnership imbalanceCollecting - ASM diskgroup attributesCollecting - ASM diskgroup usable free spaceCollecting - ASM initialization parametersCollecting - Active sessions load balance for dkf19c databaseCollecting - Archived Destination Status for dkf19c databaseCollecting - Cluster Interconnect Config for dkf19c databaseCollecting - Database Archive Destinations for dkf19c databaseCollecting - Database Files for dkf19c databaseCollecting - Database Instance Settings for dkf19c databaseCollecting - Database Parameters for dkf19c databaseCollecting - Database Properties for dkf19c databaseCollecting - Database Registry for dkf19c databaseCollecting - Database Sequences for dkf19c databaseCollecting - Database Undocumented Parameters for dkf19c databaseCollecting - Database Undocumented Parameters for dkf19c databaseCollecting - Database Workload Services for dkf19c databaseCollecting - Dataguard Status for dkf19c databaseCollecting - Files not opened by ASMCollecting - List of active logon and logoff triggers for dkf19c databaseCollecting - Log Sequence Numbers for dkf19c databaseCollecting - Percentage of asm disk ImbalanceCollecting - Process for shipping Redo to standby for dkf19c databaseCollecting - Redo Log information for dkf19c databaseCollecting - Standby redo log creation status before switchover for dkf19c databaseCollecting - /proc/cmdlineCollecting - /proc/modulesCollecting - CPU InformationCollecting - CRS active versionCollecting - CRS oifcfgCollecting - CRS software versionCollecting - Cluster interconnect (clusterware)Collecting - Disk I/O Scheduler on LinuxCollecting - DiskFree InformationCollecting - DiskMount InformationCollecting - Huge pages configurationCollecting - Interconnect network card speedCollecting - Kernel parametersCollecting - Linux module config.Collecting - Maximum number of semaphore sets on systemCollecting - Maximum number of semaphores on systemCollecting - Maximum number of semaphores per semaphore setCollecting - Memory InformationCollecting - NUMA ConfigurationCollecting - Network Interface ConfigurationCollecting - Network PerformanceCollecting - Network Service SwitchCollecting - OS PackagesCollecting - OS versionCollecting - Operating system release information and kernel versionCollecting - Oracle executable attributesCollecting - Patches for Grid InfrastructureCollecting - Patches for RDBMS HomeCollecting - RDBMS and GRID software owner UID across clusterCollecting - RDBMS patch inventoryCollecting - Shared memory segmentsCollecting - Table of file system defaultsCollecting - number of semaphore operations per semop system callData collections completed. Checking best practices on dkf19c01.
------------------------------------------------------------WARNING => Linux swap configuration does not meet recommendationWARNING => Hidden database initialization parameters should not be set per best practice recommendations for dkf19cINFO => Most recent ADR incidents for /u01/app/oracle/product/19.3.0/dbhome_1INFO => Oracle GoldenGate failure prevention best practicesWARNING => One or more open PDBs have failed service verification checks for dkf19cWARNING => OCR and OCR backup locations are the same pathFAIL => The vm.min_free_kbytes configuration is not set as recommendedWARNING => ARCHIVELOG mode is disabled for dkf19cCRITICAL => The RMAN snapshot control file location is not shared on all database nodes in the cluster for dkf19cINFO => At some times checkpoints are not being completed for dkf19cWARNING => Some user sessions lack proper failover mode (BASIC) and method (SELECT) for dkf19cCRITICAL => Temporary location is not configured for auto cleanupWARNING => Controlfile is not multiplexed for dkf19cWARNING => One or more redo log groups are not multiplexed for dkf19cWARNING => Primary database is not protected with Data Guard (standby database) for real-time data protection and availability for dkf19cWARNING => Flashback on PRIMARY is not configured for dkf19cINFO => Important Storage Minimum Requirements for Grid & Database HomesWARNING => NIC bonding is not configured for interconnectWARNING => NIC bonding is NOT configured for public network (VIP)WARNING => RAC interconnect network card speed does not meet recommendationFAIL => system service rngd is not runningINFO => Jumbo frames (MTU >= 9000) are not configured for interconnectFAIL => One or more log archive destination and alternate log archive destination settings are not as recommended for dkf19cFAIL => Table AUD$[FGA_LOG$] should use Automatic Segment Space Management for dkf19cWARNING => Database home does not fix for bug 30937410 /u01/app/oracle/product/19.3.0/dbhome_1FAIL => Database parameter DB_LOST_WRITE_PROTECT is not set to recommended value on dkf19c1 instanceFAIL => Database parameter DB_BLOCK_CHECKING on primary is not set to the recommended value. for dkf19cWARNING => Oracle patch 30786641 is not applied on RDBMS_HOME /u01/app/oracle/product/19.3.0/dbhome_1WARNING => fast_start_mttr_target should be greater than or equal to 300 on dkf19c1 instanceWARNING => Oracle patch 30712670 is not applied on RDBMS_HOME /u01/app/oracle/product/19.3.0/dbhome_1WARNING => Oracle patch 29423227 is not applied on RDBMS_HOME /u01/app/oracle/product/19.3.0/dbhome_1WARNING => Oracle patch 31031240 is not applied on RDBMS_HOME /u01/app/oracle/product/19.3.0/dbhome_1WARNING => Oracle patch 29867728 is not applied on RDBMS_HOME /u01/app/oracle/product/19.3.0/dbhome_1WARNING => Oracle patch 31142749 is not applied on RDBMS_HOME /u01/app/oracle/product/19.3.0/dbhome_1WARNING => Oracle patch 26749785 is not applied on RDBMS_HOME /u01/app/oracle/product/19.3.0/dbhome_1WARNING => Oracle patch 29302565 is not applied on RDBMS_HOME /u01/app/oracle/product/19.3.0/dbhome_1WARNING => Oracle patch 29259068 is not applied on RDBMS_HOME /u01/app/oracle/product/19.3.0/dbhome_1FAIL => Database control files are not configured as recommended for dkf19cWARNING => Oracle patch 28907129 is not applied on RDBMS_HOME /u01/app/oracle/product/19.3.0/dbhome_1WARNING => One or more read/write errors found for ASM disks for dkf19cWARNING => Database Archivelog Mode should be set to ARCHIVELOG for dkf19cWARNING => Perl Patch 33912872 is not found in 19c RDBMS_HOME. /u01/app/oracle/product/19.3.0/dbhome_1WARNING => Perl Patch 33912872 is not found in 19c CRS_HOME. /u01/app/19.3.0/gridWARNING => Oracle patch 32043701 is not applied on RDBMS_HOME /u01/app/oracle/product/19.3.0/dbhome_1WARNING => Oracle patch 31602782 is not applied on RDBMS_HOME /u01/app/oracle/product/19.3.0/dbhome_1WARNING => Oracle patch 33121934 is not applied on RDBMS_HOME /u01/app/oracle/product/19.3.0/dbhome_1WARNING => Oracle patch 33025005 is not applied on RDBMS_HOME /u01/app/oracle/product/19.3.0/dbhome_1WARNING => Oracle patch 32103628 is not applied on RDBMS_HOME /u01/app/oracle/product/19.3.0/dbhome_1WARNING => Oracle patch 31211220 is not applied on RDBMS_HOME /u01/app/oracle/product/19.3.0/dbhome_1INFO => The Optimizer fixes for 19c database version is disabled by default for bugs with status value 0 for dkf19cINFO => Database feature usage statistics for dkf19cWARNING => Linux Disk I/O Scheduler should be configured to DeadlineWARNING => There exists one or more underscore parameters without a comment for dkf19cWARNING => Consider investigating changes to the schema objects such as DDLs or new object creation for dkf19cWARNING => Consider investigating the frequency of SGA resize operations and take corrective action for dkf19c------------------------------------------------------------CLUSTERWIDE CHECKS
------------------------------------------------------------INFO => Information about the impact of CPU contention on database instance performance is available.
------------------------------------------------------------UPLOAD [if required] - /u01/app/grid/oracle.ahf/data/dkf19c02/orachk/user_root/output/orachk_dkf19c02_dkf19c_021223_175034.zip[root@dkf19c02 ~]#
=======================================================
相关文章:
Oracle Trace File Analyzer 介绍及简单使用
一、什么是Oracle Trace File Analyzer Oracle Autonomous Health Framework(AHF) 包含 Oracle ORAchk, Oracle EXAchk, and Oracle Trace File Analyzer(TFA). AHF工具包包含了Oracle常用的多种诊断工具,如 ORAchk, Oracle EXAchk, and Oracle Trace File Analyzer…...
面试实战篇 | 快手本地生活,结合项目谈Redis实战项目场景?MySQL InnoDB存储引擎如何工作的?策略模式?
本期是【你好,面试官】系列文章的第21期,持续更新中…。 《你好,面试官》系列目前已经连载20篇了,据说看了这个系列的朋友都拿到了大厂offer~ 你好,面试官 | 你真的理解面向 “对象”?你好,面…...
Hadoop之——WordCount案例与执行本地jar包
目录 一、WordCount代码 (一)WordCount简介 1.wordcount.txt (二)WordCount的java代码 1.WordCountMapper 2.WordCountReduce 3.WordCountDriver (三)IDEA运行结果 (四)Hadoop运行wordcount 1.在HDFS上新建一个文件目录 2.新建一个文件,并上传至该目录下…...
利用git reflog 命令来查看历史提交记录,并使用提交记录恢复已经被删除掉的分支
一.问题描述 当我们在操作中手误删除了某个分支,那该分支中提交的内容也没有了,我们可以利用git reflog这个命令来查看历史提交的记录从而恢复被删除的分支和提交的内容 二.模拟问题 1.创建git仓库,并提交一个文件 [rootcentos7-temp /da…...
【软件测试】大厂测试开发你真的了解吗?测试开发养成记......
目录:导读前言一、Python编程入门到精通二、接口自动化项目实战三、Web自动化项目实战四、App自动化项目实战五、一线大厂简历六、测试开发DevOps体系七、常用自动化测试工具八、JMeter性能测试九、总结(尾部小惊喜)前言 在一些大公司里&…...
Redis中的hash结构和扩容机制
1.rehash原理 hash包含两个数据结构为字典数组ht[0]和ht[1]。其中ht[0]用来存放数据,ht[1]在rehash时使用。 扩容时,ht[1]的大小为第一个大于等于ht[0].used*2的2的幂次方的数; 收缩时,ht[1]的大小为第一个大于等于ht[0].used的…...
【C++奇技淫巧】前置自增与后置自增的区别(++i,i++)【2023.02.08】
简介 先说i和i的区别,判断语句中if(i)是拿i的值先判断,而后自增;if(i)是先自增i再进行判断。涉及到左值与右值也有点区别,i返回的是右值,i返回的是左值。也就是下面的代码要解释的东西。 #include <iostream>i…...
实战打靶集锦-005-HL
**写在前面:**记录一次曲折的打靶经历。 目录1. 主机发现2. 端口扫描3. 服务枚举4. 服务探查4.1 浏览器访问4.2 目录枚举4.3 探查admin4.4 探查index4.5 探查login5 公共EXP搜索6. 再次目录枚举6.1 探查superadmin.php6.2 查看页面源代码6.3 base64绕过6.4 构建反弹…...
铁路系统各专业介绍(车机工电辆)
目录 1 车务段 1.1 职能简介 1.2 路段名单 1.3 岗位级别 2 机务段 2.1 职能简介 2.2 路段名单 2.3 岗位级别 3 工务段 3.1 职能简介 3.2 路段名单 3.3 岗位级别 4 电务段 4.1 职能简介 4.2 路段名单 4.3 岗位级别 5 车辆段 5.1 职能简介 5.2 路段名单 5.3 …...
2/11考试总结
时间安排 7:30–7:50 读题,T1貌似是个 dp ,T2 数据结构,T3 可能是数据结构。 7:50–9:45 T1,点规模非常大,可以达到 1e18 级别,感觉应该没法直接做,考虑每条新增的边的贡献,想到用 …...
Java Set集合
7 Set集合 7.1 Set集合的概述和特点 Set集合的特点 不包含重复元素的集合没有带索引的方法,所以不能使用普通for循环 Set集合是接口通过实现类实例化(多态的形式) HashSet:添加的元素是无序,不重复,无索引…...
【手写 Vuex 源码】第七篇 - Vuex 的模块安装
一,前言 上一篇,主要介绍了 Vuex 模块收集的实现,主要涉及以下几个点: Vuex 模块的概念;Vuex 模块和命名空间的使用;Vuex 模块收集的实现-构建“模块树”; 本篇,继续介绍 Vuex 模…...
EOC第六章《块与中枢派发》
文章目录第37条:理解block这一概念第38条:为常用的块类型创建typedef第39条:用handler块降低代码分散程度第41条:多用派发队列,少用同步锁方案一:使用串行同步队列来将读写操作都安排到同一个队列里&#x…...
八、Git远程仓库操作——跨团队成员的协作
前言 前面一篇博文介绍了git团队成员之间的协作,现在在介绍下如果是跨团队成员的话,如何协作? 跨团队成员协作,其实就是你不属于那个项目的成员,你没有权限向那个仓库提交代码。但是github还有另一种 pull request&a…...
算法刷题打卡第88天:字母板上的路径
字母板上的路径 难度:中等 我们从一块字母板上的位置 (0, 0) 出发,该坐标对应的字符为 board[0][0]。 在本题里,字母板为board ["abcde", "fghij", "klmno", "pqrst", "uvwxy", "…...
UVa The Morning after Halloween 万圣节后的早晨 双向BFS
题目链接:The Morning after Halloween 题目描述: 给定一个二维矩阵,图中有障碍物和字母,你需要把小写字母移动到对应的大写字母位置,不同的小写字母可以同时移动(上下左右四个方向或者保持不动 ࿰…...
Connext DDS属性配置参考大全(3)
Transport传输dds.participant.logging.time_based_logging.process_received_messagedds.participant.logging.time_based_logging.process_received_message.timeout...
Docker-安装Jenkins-使用jenkins发版Java项目
文章目录0.前言环境背景1.操作流程1.1前期准备工作1.1.1环境变量的配置1.2使用流水线的方式进行发版1.2.1新建流水线任务1.2.2流水线操作工具tools步骤stages步骤1:拉取代码编译步骤2:发送文件并启动0.前言 学海无涯,旅“途”漫漫,“途”中小记ÿ…...
spring 中的 Bean 是否线程安全
文章目录结论1、spring中的Bean从哪里来?2、spring中什么样的Bean存在线程安全问题?3、如何处理spring Bean的线程安全问题?结论 其实,Spring 中的 Bean 是否线程安全,其实跟 Spring 容器本身无关。Spring框架中没有提…...
微电网两阶段鲁棒优化经济调度方法[3]【升级优化版本】(Matlab代码实现)
💥💥💥💞💞💞欢迎来到本博客❤️❤️❤️💥💥💥 🏆博主优势:🌞🌞🌞博客内容尽量做到思维缜密,逻辑…...
C++入门教程||C++ 数据类型||C++ 变量类型
C 数据类型 使用编程语言进行编程时,需要用到各种变量来存储各种信息。变量保留的是它所存储的值的内存位置。这意味着,当您创建一个变量时,就会在内存中保留一些空间。 您可能需要存储各种数据类型(比如字符型、宽字符型、整型…...
【visio使用技巧】图片导出pdf时去掉多余空白
问题 在visio导出pdf格式的图片时,往往会存在多余的白边,如下图所示: 解决方法 依次点击:菜单栏→文件→选项→自定义功能区→勾选“开发工具”→确定。 依次点击菜单栏→开发工具→显示ShapeSheet→页→Print Properties→将…...
Rust语言之Option枚举类型
概述 Option是Rust语言设计中最重要的枚举类型之一,它编码了其它语言中空值与非空值的概念,差异在于,Rust不会允许你像其它语言一样以非空值的方式来使用一个空值,这避免了很多错误。Option在标准库中的定义如下: pu…...
基于TimeQuest时序优化原理和方法
💡 回顾基于RTL逻辑时序优化的基本思路,在关键路径中插入寄存器来优化时序 分析最坏路径 通过前面对TimeQuest软件的理解,基本上可以找到关键路径,此文章主要对关键路径时序进行优化,使设计达到时序要求,以…...
LeetCode第332场周赛
2023.2.12LeetCode第332场周赛 6354. 找出数组的串联值 思路 双指针模拟,两个指针相遇的时候要特判 算法 class Solution { public:long long findTheArrayConcVal(vector<int>& nums) {long long ans 0;int i 0, j nums.size() - 1;while (i <…...
2023-2-12刷题情况
字母板上的路径 题目描述 我们从一块字母板上的位置 (0, 0) 出发,该坐标对应的字符为 board[0][0]。 在本题里,字母板为board [“abcde”, “fghij”, “klmno”, “pqrst”, “uvwxy”, “z”],如下所示。 我们可以按下面的指令规则行动…...
拉普拉斯矩阵
拉普拉斯算子 Δff(xi1,yj)f(xi−1,yj)f(xi,yj1)f(xi,yj−1)−4f(xi,yj)∑(k,l)∈N(i,j)(f(xk,yl)−f(xi,yj))\begin{aligned} \Delta f & f\left(x_{i1}, y_j\right) f\left(x_{i-1},y_j\right) f\left(x_i,y_{j1}\right)f\left(x_i,y_{j-1}\right) - 4f\left(x_i,y_j\r…...
Top-1错误率、Top-5错误率等常见的模型算法评估指标解析
Top-1 错误率:指预测输出的概率最高的类别与人工标注的类别相符的准确率,就是你预测的label取最后概率向量里面最大的那一个作为预测结果,如过你的预测结果中概率最大的那个分类正确,则预测正确,否则预测错误。比如预测…...
Urho3D 容器类型
Urho3D实现了自己的字符串类型和模板容器,而不是使用STL。其基本原理如下: 在某些情况下提高了性能,例如使用PODVector类时。保证字符串和容器的二进制大小,以允许例如嵌入Variant对象内。减少了编译时间。直接命名和实现&#x…...
C语言学习笔记(四): 循环结构程序设计
while语句 定义 While语句是C语言中的循环语句,它按条件循环执行语句,直到条件不满足为止 语法格式如下: while(condition) {//循环体内容; }使用实例 求123…100 include <stdio.h> int main(){int i 1, sum 0;while (i<100){sum i …...
太原网站域名开发/百度网站推广申请
作者:秦福朗 爱可生 DBA 团队成员,负责项目日常问题处理及公司平台问题排查。热爱 IT,喜欢在互联网里畅游,擅长摄影、厨艺,不会厨艺的 DBA 不是好司机,didi~ 本文来源:原创投稿 *爱可生开源社区…...
福建省建设厅网站资质查/旅游网站网页设计
原文地址:https://facebook.github.io/react/docs/conditional-rendering.html 在React中,您可以创建不同的组件来封装所需的行为。然后,您可以只渲染其中的一些,具体取决于应用程序的state。 eg: function UserGreeting(props) {…...
外贸商城网站建设/汽车软文广告
IntelliJ IDEA有一个强大的编辑器,并始终帮助您创建无差错的应用程序。IDE有许多智能的功能,让我们看看最重要的几个。 代码补全 代码补全通过关联上下文的情况,节省您的时间。主要有两种类型的IntelliJ IDEA的代码补全:基础&…...
淘宝客做网站要钱吗/网络运营是什么意思
https://jingyan.baidu.com/article/fea4511a1a1040f7bb91251a.html转载于:https://www.cnblogs.com/clover-xuqi/p/8316663.html...
独立网站建设步骤/网站维护一年一般多少钱?
1.增加utf8mb4的支持 SHOW VARIABLES WHERE Variable_name LIKE character% OR Variable_name LIKE collation%; 2.xtrabackup 因为测试环境都是5.7,所以需要升级。 具体步骤 mysql5.7 shell自动安装脚本 2.xtarbackup备份测试库,还原到现在的新安装的库…...
网络营销管理方案/移动端seo关键词优化
安装rlwrap-0.37.tar.gz工具--实现SQLPLUS中记忆和上下翻页功能在rpm10g32这个路径中1、解压缩[rootoracle3 ~]# cd /u01/rpm10g32[rootoracle3 rpm10g32]# tar -zxvf rlwrap-0.37.tar.gz 2、安装[rootoracle3 rpm10g32]# cd rlwrap-0.37 --root下安装,安装的时候…...