当前位置： 首页 > news >正文

网站建设完成阶段性总结报告/百度关键词搜索量

news 2025/7/1 15:00:45
网站建设完成阶段性总结报告,百度关键词搜索量,深圳信用网企业查询系统,北京网站制作收费标准ahf（Autonomous Health Framework）：就是oracle官方收集日志的工具集合包，包内涵盖了TFA ：收集日志的工具；ORAchk/EXAchk ： 检查系统的工具。 1、AHF的安装 #####AHF软件需要从oracle官方下载 …

        ahf（Autonomous Health Framework）：就是oracle官方收集日志的工具集合包，包内涵盖了TFA ：收集日志的工具；ORAchk/EXAchk ： 检查系统的工具。

1、AHF的安装

#####AHF软件需要从oracle官方下载
#####用unzip解压到指定的目录
[root@oracle19c ~]# unzip AHF-LINUX_v21.2.1.zip -d AHF-LINUX
Archive:  AHF-LINUX_v21.2.1.zipinflating: AHF-LINUX/README.txt    inflating: AHF-LINUX/ahf_setup     extracting: AHF-LINUX/ahf_setup.dat  inflating: AHF-LINUX/oracle-tfa.pub 
######需要先安装perl-Data-Dumper.x86_64包
[root@oracle19c AHF-LINUX]# yum install perl-Data-Dumper.x86_64
已加载插件：langpacks, product-id, search-disabled-repos, subscription-managerThis system is not registered with an entitlement server. You can use subscription-manager to register.media                                                                                                                  | 2.8 kB  00:00:00     
(1/2): media/group_gz                                                                                                  |  95 kB  00:00:00     
(2/2): media/primary                                                                                                   | 2.1 MB  00:00:00     
media                                                                                                                               5231/5231
正在解决依赖关系
--> 正在检查事务
---> 软件包 perl-Data-Dumper.x86_64.0.2.145-3.el7 将被 安装
--> 解决依赖关系完成依赖关系解决==============================================================================================================================================Package                                 架构                          版本                                源                            大小
==============================================================================================================================================
正在安装:perl-Data-Dumper                        x86_64                        2.145-3.el7                         media                         47 k事务概要
==============================================================================================================================================
安装  1 软件包总下载量：47 k
安装大小：97 k
Is this ok [y/d/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction正在安装    : perl-Data-Dumper-2.145-3.el7.x86_64                                                                                       1/1 验证中      : perl-Data-Dumper-2.145-3.el7.x86_64                                                                                       1/1 已安装:perl-Data-Dumper.x86_64 0:2.145-3.el7                                                                                                       完毕！
[root@oracle19c AHF-LINUX]# 
#####开始安装AHF
[root@oracle19c AHF-LINUX]# ./ahf_setup AHF Installer for Platform Linux Architecture x86_64AHF Installation Log : /tmp/ahf_install_212100_2519_2021_09_03-14_12_32.logStarting Autonomous Health Framework (AHF) InstallationAHF Version: 21.2.1 Build Date: 202108130422Default AHF Location : /opt/oracle.ahfDo you want to install AHF at [/opt/oracle.ahf] ? [Y]|N : yAHF Location : /opt/oracle.ahfAHF Data Directory stores diagnostic collections and metadata.
AHF Data Directory requires at least 5GB (Recommended 10GB) of free space.Please Enter AHF Data Directory : /optAHF Data Directory : /opt/oracle.ahf/dataDo you want to add AHF Notification Email IDs ? [Y]|N : nExtracting AHF to /opt/oracle.ahfConfiguring TFA ServicesDiscovering Nodes and Oracle ResourcesSuccessfully generated certificates.Starting 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             |
+-----------+---------------+------+-------+------------+----------------------+
| oracle19c | RUNNING       | 4156 | 30928 | 21.2.1.0.0 | 21210020210813042249 |
'-----------+---------------+------+-------+------------+----------------------'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  | /opt/oracle.ahf/data                |
| Repository      | /opt/oracle.ahf/data/repository     |
| Diag Directory  | /opt/oracle.ahf/data/oracle19c/diag |
'-----------------+-------------------------------------'Starting orachk scheduler from AHF ...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] : nMoving /tmp/ahf_install_212100_2519_2021_09_03-14_12_32.log to /opt/oracle.ahf/data/oracle19c/diag/ahf/[root@oracle19c AHF-LINUX]#

2、ORAchk的使用

#####使用root账户运行orachk，即可检查rdbms的健康检查
[root@oracle19c ~]# orachk List of running databases1. xhh
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]. 1
.  .
.  .  Checking Status of Oracle Software Stack - Clusterware, ASM, RDBMS.  .  . . . .  
.  .  .  .  .  .  .  .  .  
-------------------------------------------------------------------------------------------------------Oracle Stack Status                          
-------------------------------------------------------------------------------------------------------Host Name       CRS Installed       ASM HOME  RDBMS Installed    CRS UP    ASM UP  RDBMS UP    DB Instance Name
-------------------------------------------------------------------------------------------------------oracle19c                  No           No          Yes           No       No      Yes                 xhh
-------------------------------------------------------------------------------------------------------Copying plug-ins. .
.  .  .  .  .  .  *** Checking Best Practice Recommendations ( Pass / Warning / Fail ) ***
.  Collections and audit checks log file is 
/opt/oracle.ahf/data/oracle19c/orachk/user_root/output/orachk_oracle19c_xhh_090321_14222/log/orachk.logTranslated Message files for the language (zh) is not found. Using the default (en) Message files============================================================Node name - oracle19c
============================================================
. . . . . . Collecting - Database Parameters for xhh databaseCollecting - Database Undocumented Parameters for xhh databaseCollecting - List of active logon and logoff triggers for xhh databaseCollecting - CPU InformationCollecting - Disk I/O Scheduler on LinuxCollecting - DiskMount InformationCollecting - Kernel parametersCollecting - Maximum number of semaphore sets on systemCollecting - Maximum number of semaphores on systemCollecting - Maximum number of semaphores per semaphore setCollecting - Memory InformationCollecting - OS PackagesCollecting - Operating system release information and kernel versionCollecting - Patches for RDBMS HomeCollecting - Table of file system defaultsCollecting - number of semaphore operations per semop system callCollecting - Disk InformationCollecting - 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 configurationData collections completed. Checking best practices on oracle19c.
------------------------------------------------------------WARNING =>  Linux swap configuration does not meet recommendationWARNING =>  There are some application objects with STALE statistics for xhhINFO =>     Most recent ADR incidents for /u01/app/oracle/product/19.0.0/dbhome_1FAIL =>     The OMS user does not have the correct value of umask setFAIL =>     The EM_NODEMGR_PORT has expired or will expire within the next day.INFO =>     Oracle GoldenGate failure prevention best practicesCRITICAL => The vm.min_free_kbytes configuration is not set as recommendedINFO =>     user_dump_dest has trace files older than 30 days for xhhWARNING =>  One or more redo log groups are not multiplexed for xhhWARNING =>  Primary database is not protected with Data Guard (standby database) for real-time data protection and availability for xhhINFO =>     Important Storage Minimum Requirements for Grid & Database HomesCRITICAL => Operating system hugepages count does not satisfy total SGA requirementsWARNING =>  OSWatcher is not running as is recommended.FAIL =>     Database parameter DB_LOST_WRITE_PROTECT is not set to recommended value on xhh instanceINFO =>     The Optimizer Fix 28345522 is disabled by default for xhhWARNING =>  Database parameter DB_BLOCK_CHECKING on primary is not set to the recommended value. for xhhINFO =>     The Optimizer Fix 22149010 is disabled by default for xhhINFO =>     The Optimizer Fix 25167306 is disabled by default for xhhWARNING =>  Oracle patch 30786641 is not applied on RDBMS_HOME /u01/app/oracle/product/19.0.0/dbhome_1WARNING =>  Consider setting the value of the parameter _cursor_obsolete_threshold  to 1024 for Non-Multitenant environment which is the appropriate recommended value for xhhINFO =>     The Optimizer Fix 28965084 is disabled by default for xhhINFO =>     The Optimizer Fix 28776811 is disabled by default for xhhINFO =>     The Optimizer Fix 29132869 is disabled by default for xhhINFO =>     The Optimizer Fix 28498976 is disabled by default for xhhINFO =>     The Optimizer Fix 29687220 is disabled by default for xhhINFO =>     The Optimizer Fix 30232638 is disabled by default for xhhINFO =>     The Optimizer Fix 29930457 is disabled by default for xhhINFO =>     The Optimizer Fix 29304314 is disabled by default for xhhINFO =>     The Optimizer Fix 28776431 is disabled by default for xhhINFO =>     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 =>  Oracle patch 30712670 is not applied on RDBMS_HOME /u01/app/oracle/product/19.0.0/dbhome_1WARNING =>  Oracle patch 29423227 is not applied on RDBMS_HOME /u01/app/oracle/product/19.0.0/dbhome_1WARNING =>  Oracle patch 31031240 is not applied on RDBMS_HOME /u01/app/oracle/product/19.0.0/dbhome_1WARNING =>  Oracle patch 29867728 is not applied on RDBMS_HOME /u01/app/oracle/product/19.0.0/dbhome_1WARNING =>  Oracle patch 31142749 is not applied on RDBMS_HOME /u01/app/oracle/product/19.0.0/dbhome_1WARNING =>  Oracle patch 26749785 is not applied on RDBMS_HOME /u01/app/oracle/product/19.0.0/dbhome_1WARNING =>  Oracle patch 29302565 is not applied on RDBMS_HOME /u01/app/oracle/product/19.0.0/dbhome_1WARNING =>  Oracle patch 29259068 is not applied on RDBMS_HOME /u01/app/oracle/product/19.0.0/dbhome_1WARNING =>  Logical and physical size of all datafiles are not same for xhhWARNING =>  Oracle patch 28907129 is not applied on RDBMS_HOME /u01/app/oracle/product/19.0.0/dbhome_1WARNING =>  Oracle clusterware is not being usedWARNING =>  RAC Application Cluster is not being used for database high availability on xhh instanceWARNING =>  DISK_ASYNCH_IO is NOT set to recommended value for xhhFAIL =>     Table AUD$[FGA_LOG$] should use Automatic Segment Space Management for xhhWARNING =>  Flashback on PRIMARY is not configured for xhhINFO =>     Database failure prevention best practicesWARNING =>  fast_start_mttr_target has NOT been changed from default on xhh instanceFAIL =>     Active Data Guard is not configured for xhhINFO =>     Parallel Execution Health-Checks and Diagnostics Reports for xhhINFO =>     Oracle recovery manager(rman) best practicesINFO =>     Database feature usage statistics for xhhWARNING =>  Consider investigating changes to the schema objects such as DDLs or new object creation for xhhWARNING =>  Consider increasing the value of the session_cached_cursors database parameter for xhh
Best Practice checking completed. Checking recommended patches on oracle19c
--------------------------------------------------------------------------------
Collecting patch inventory on ORACLE_HOME /u01/app/oracle/product/19.0.0/dbhome_1
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
1 Recommended RDBMS patches for 190000 from /u01/app/oracle/product/19.0.0/dbhome_1 on oracle19c
--------------------------------------------------------------------------------
Patch#   RDBMS    ASM     type                Patch-Description                       
--------------------------------------------------------------------------------
32904851 no               merge                Database Release Update 19.12.0.0.210720                                       
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------RDBMS homes patches summary report
--------------------------------------------------------------------------------
Total patches  Applied on RDBMS Applied on ASM ORACLE_HOME    
--------------------------------------------------------------------------------
1              1              0                /u01/app/oracle/product/19.0.0/dbhome_1
--------------------------------------------------------------------------------------------------------------------------------------------
Detailed report (html) -  /opt/oracle.ahf/data/oracle19c/orachk/user_root/output/orachk_oracle19c_xhh_090321_14222/orachk_oracle19c_xhh_090321_14222.htmlUPLOAD [if required] - /opt/oracle.ahf/data/oracle19c/orachk/user_root/output/orachk_oracle19c_xhh_090321_14222.zip
Unable to make DB connection[root@oracle19c ~]# 
######收集完毕后，就可以去“/opt/oracle.ahf/data/oracle19c/orachk/user_root/output/orachk_oracle19c_xhh_090321_14222”查看具体的库的诊断信息

三、TFA工具使用

#####使用tfactl收集9月3日的日志
[root@oracle19c orachk_oracle19c_xhh_090321_14222]# tfactl diagcollect -for "2021-09-03"
Collecting data for all nodesTFA is using system timezone for collection, All times shown in CST.
Scanning files for sep/03/2021Collection Id : 20210903145146oracle19cDetailed Logging at : /opt/oracle.ahf/data/repository/collection_Fri_Sep_03_14_51_49_CST_2021_node_all/diagcollect_20210903145146_oracle19c.log
2021/09/03 14:51:54 CST : NOTE : Any file or directory name containing the string .com will be renamed to replace .com with dotcom
2021/09/03 14:51:54 CST : Collection Name : tfa_Fri_Sep_03_14_51_48_CST_2021.zip
2021/09/03 14:51:54 CST : Collecting diagnostics from hosts : [oracle19c]
2021/09/03 14:51:54 CST : Scanning of files for Collection in progress...
2021/09/03 14:51:54 CST : Collecting additional diagnostic information...
2021/09/03 14:51:59 CST : Getting list of files satisfying time range [09/03/2021 00:00:00 CST, 09/03/2021 14:51:54 CST]
2021/09/03 14:52:03 CST : Collecting ADR incident files...
2021/09/03 14:53:32 CST : Completed collection of additional diagnostic information...
2021/09/03 14:53:34 CST : Completed Local Collection.-------------------------------------.
|          Collection Summary         |
+-----------+-----------+------+------+
| Host      | Status    | Size | Time |
+-----------+-----------+------+------+
| oracle19c | Completed | 17MB | 100s |
'-----------+-----------+------+------'Logs are being collected to: /opt/oracle.ahf/data/repository/collection_Fri_Sep_03_14_51_49_CST_2021_node_all
/opt/oracle.ahf/data/repository/collection_Fri_Sep_03_14_51_49_CST_2021_node_all/oracle19c.tfa_Fri_Sep_03_14_51_48_CST_2021.zip

关于TFA更加深入的操作，请参考官方文档：

TFA Collector- The Preferred Tool for Automatic or ADHOC Diagnostic Gathering Across All Cluster Nodes [ID 1513912.2]

http://www.jmfq.cn/news/4778425.html

相关文章：

  • 怎样下载模板网站/黑帽seo培训
  • 实验报告网站建设与网页制作/关键词排名优化怎么做
  • 免费申请一个网站/营销平台是什么意思
  • 做网站公司什么条件/怎样提高百度推广排名
  • aspnet网站开发教程/网络营销讲师
  • 深圳电信网站备案/河南seo外包
  • 网站建设 设计业务范围/六年级下册数学优化设计答案
  • 福州手机网站建设/河源新闻最新消息
  • 网站运营做内容/鸿星尔克网络营销
  • 做网站必须要有数据库/吉林seo管理平台
  • 网站建设需求怎么写/直通车推广
  • 做网站产品搜索展示实现/seo算法入门教程
  • 做写真图片网站合法吗/精品成品网站源码
  • 郑州做营销型网站公司/邯郸百度推广公司
  • 贵金属网站模板/企业查询
  • 济南市住建厅官方网站/网站底部友情链接代码
  • 旅游酒店网站建设/bilibili官网网页入口
  • 都是做面食网站/企业网站推广模式
  • 带你做网站毕设/网站搭建工具
  • 网站修改影响做百度竞价吗/郑州seo公司
  • 天津艺匠做网站怎么样/全网
  • 吉林省长春网站建设/怎么制作网站平台
  • 网站设计基础语言不包括这些内容/安徽网站推广
  • 武汉软件网站开发公司/成功的软文营销案例
  • 建筑工程类招聘网站/网站流量统计分析工具
  • 做网站服务器装虚拟机/seo公司后付费
  • 电子政务门户网站建设的意义/免费找精准客户软件
  • 制作营销网站公司/seo网页优化公司
  • 传奇网站劫持怎么做/百度精简版入口
  • 线上网站怎么做/外链收录网站