오라클 19c exachk 수집 가이드

OS환경 : Oracle Linux 7.6 (64bit)

 

DB 환경 : Oracle Database 19.10.0.0

 

방법 : 오라클 19c exachk 수집 가이드

exachk는 Exadata Database Machine 시스템을 전체적으로 체크, 분석함
exachk 에서 확인하는 목록

Configuration checks for Database Servers, Storage Servers, and Network Fabric Switches:
- Firmware
- Operating System (e.g. Oracle Linux)
- Exadata software
- Grid Infrastructure and ASM
- DatabaseMAA Scorecard:
- MAA Configuration Review
- Exadata Software Planner
- Exadata Critical Issue alerts
Automatic Correction (when applicable):
- Configuration Correction
- Critical Issue Avoidance
Prerequisite checks
- Prerequisite checks for DB and GI software updates
- Prerequisite checks for DB and GI upgrades
- Prerequisite checks for application continuity readiness

 

 

수집 방법

ahf 최신업데이트(오라클 19c ahf(tfa) 업그레이드 가이드 https://positivemh.tistory.com/791 참고)

 

 

RoCE switch 이름 확인

# cat /etc/hosts|grep -i ro
ff02::2   ip6-allrouters
192.168.137.72 testsw-rocea0
192.168.137.73 testsw-roceb0

 

 

exachk 실행(root)

# /opt/oracle.ahf/exachk/exachk
 
Enter RDMA Network Fabric switch names delimited by comma or skip switches using -excludeprofile switch option. (eg. switch1,switch2,switch3): testsw-rocea0, testsw-roceb0 <-- RoCE switch 이름 입력 각 이름 ,로 구분
 
Searching for running databases . . . . .
 
.  .
List of running databases registered in OCR
 
1. TESTRAC
2. None of above
 
Select 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]. <- 전체 DB 다 보고싶은 경우 엔터 입력, 아니면 특정 DB 번호 입력
.  .  .  .
.  .  .
 
Checking Status of Oracle Software Stack - Clusterware, ASM, RDBMS
 
.  .  . . . .
.  .  . . . .  .  .  .  .  .  .  .  .  . . . .  .  .  .  .  .  .  .
Reading storage servers password from wallet.
.  .  .  .  .  .  .  .  .  .
Reading RDMA Network Fabric switches password from wallet.
.  .
Wallet does not have password for all switches
 
 
 
 
9 of the included audit checks require admin privileged data collection on RDMA Network Fabric switch
 
1. Enter 1 if you will enter admin password for each RDMA Network Fabric switch when prompted
 
2. Enter 2 to exit and to arrange for admin access and run the exachk later.
 
3. Enter 3 to skip checking best practices on RDMA Network Fabric switch
 
Indicate your selection from one of the above options for RDMA Network Fabric switch[1-3][1]:- <- 엔터 입력
 
 
Is admin password same on all RDMA Network Fabric switch ?[y/n][y] <- 엔터 입력
 
Enter admin password for RDMA Network Fabric switch :- <- switch 패스워드 입력
Verifying admin password ...
 
 
 
Either Cluster Verification Utility pack (cvupack) does not exist at /opt/oracle.ahf/common/cvu or it is an old or invalid cvupack
 
Checking Cluster Verification Utility (CVU) version at CRS Home - /ORA19/app/grid/19c
 
This version of Cluster Verification Utility (CVU) was released on 14-Apr-2021 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 report
 
Do you want to download latest version of Cluster Verification Utility (CVU) from my oracle support? [y/n] [y] n <- CVU 온라인 업데이트 하지 못하는 환경일 경우 n 입력, 이후 exachk 수집 시작됨
 
Running older version of Cluster Verification Utility (CVU) from CRS Home - /ORA19/app/grid/19c
 
 
Storing RDMA Network Fabric switches password in wallet only for this run and will be removed
 
 
Storing RDMA Network Fabric switches password in wallet only for this run and will be removed
 
 
Starting to run exachk in background on testdb1 using socket
 
.  .  .  .
.  .
 
Checking Status of Oracle Software Stack - Clusterware, ASM, RDBMS on testdb2
 
.  .  . . . .
.  .  . . . .  .  .  .  .  .  .  .
-------------------------------------------------------------------------------------------------------
                                                 Oracle Stack Status
-------------------------------------------------------------------------------------------------------
  Host Name       CRS Installed  RDBMS Installed    CRS UP    ASM UP  RDBMS UP    DB Instance Name
-------------------------------------------------------------------------------------------------------
  testdb2                  Yes          Yes          Yes      Yes      Yes           TESTRAC2
-------------------------------------------------------------------------------------------------------
.
.  .  .  .  .  .  .  .  .
한참 걸림(10분 이상)
 
 
------------------------------------------------------------
                      CLUSTERWIDE CHECKS
------------------------------------------------------------
 
 UNDETERMINED =>     CPU contention may be impacting database performance.
------------------------------------------------------------
 
 
 
 
UPLOAD [if required] - /ORA19/app/grid/oracle.ahf/data/testdb2/exachk/user_root/output/exachk_testdb2_TESTRAC2_081021_17368_2131XLA03N.zip
완료

 

 

수집된 html 파일 확인

 

 

참조 : Oracle Exadata Database Machine Exachk (Doc ID 1070954.1)
Autonomous Health Framework (AHF) - Including TFA and ORAchk/EXAchk (Doc ID 2550798.1)