OS환경 : Oracle Linux 8.4 (64bit)
DB 환경 : Oracle Database 19.12.0.0 RAC
방법 : 오라클 19c ahf(tfa) 업그레이드 가이드
RAC 로 DB 구성시 자동으로 tfa가 설치됨
이 버전을 새 버전으로 업그레이드(패치) 하는 방법을 설명함
싱글db라 ahf 가 없는 경우 설치 방법 아래 게시글 참고
참고 : 오라클 19c ahf(tfa) 설치 및 로그수집 가이드(SRDC) ( https://positivemh.tistory.com/747 )
기존 버전 확인
|
1
2
3
4
5
|
# ahfctl version
This version of AHF is older than 180 days
Please set software stage location using ahfctl setupgrade and then upgrade using ahfctl upgrade
AHF version: 21.1.4
|
21.1.4 버전을 사용중임
ahf 다운로드
Doc. 2291661.1 에서 해당 OS 용 최신 파일 다운로드
파일 업로드 및 압축 해제(root 유저)
|
1
2
3
4
5
6
7
8
9
10
11
|
# mkdir -p /home/oracle/media/ahf
파일 업로드
# cd /home/oracle/media/ahf
# ls
AHF-LINUX_v21.3.3.zip
# unzip AHF-LINUX_v21.3.3.zip
Archive: AHF-LINUX_v21.3.3.zip
inflating: README.txt
inflating: ahf_setup
extracting: ahf_setup.dat
inflating: oracle-tfa.pub
|
설치(업그레이드)
기동중이라면 자동으로 종료하고 설치함
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
|
# ./ahf_setup -local
AHF Installer for Platform Linux Architecture x86_64
AHF Installation Log : /tmp/ahf_install_213300_9986_2021_12_25-22_46_32.log
Starting Autonomous Health Framework (AHF) Installation
AHF Version: 21.3.3 Build Date: 202112130225
AHF is already installed at /opt/oracle.ahf
Installed AHF Version: 21.1.4 Build Date: 202106281226
Do you want to upgrade AHF [Y]|N : y <-- y 입력
Upgrading /opt/oracle.ahf
Shutting down AHF Services
Stopped OSWatcher
Nothing to do !
Shutting down TFA
Removed /etc/systemd/system/multi-user.target.wants/oracle-tfa.service.
Removed /etc/systemd/system/graphical.target.wants/oracle-tfa.service.
Successfully shutdown TFA..
Starting AHF Services
Starting TFA..
Created symlink /etc/systemd/system/multi-user.target.wants/oracle-tfa.service -> /etc/systemd/system/oracle-tfa.service.
Created symlink /etc/systemd/system/graphical.target.wants/oracle-tfa.service -> /etc/systemd/system/oracle-tfa.service.
Waiting up to 100 seconds for TFA to be started..
. . . . .
Successfully started TFA Process..
. . . . .
TFA Started and listening for commands
No new directories were added to TFA
Directory /oracle/app/oracle/crsdata/oel19db1/trace/chad was already added to TFA Directories.
INFO: Starting orachk scheduler in background. Details for the process can be found at /oracle/app/oracle/oracle.ahf/data/oel19db1/diag/orachk/compliance_start_251221_224916.log
Do you want AHF to store your My Oracle Support Credentials for Automatic Upload ? Y|[N] : n <-- n 입력
AHF is successfully upgraded to latest version
.----------------------------------------------------------------.
| Host | TFA Version | TFA Build ID | Upgrade Status |
+----------+-------------+----------------------+----------------+
| oel19db1 | 21.3.3.0.0 | 21330020211213022521 | UPGRADED |
| oel19db2 | 21.1.4.0.0 | 21140020210628122659 | NOT UPGRADED |
'----------+-------------+----------------------+----------------'
Moving /tmp/ahf_install_213300_9986_2021_12_25-22_46_32.log to /oracle/app/oracle/oracle.ahf/data/oel19db1/diag/ahf/
|
1번 노드만 21.3.3 버전으로 업그레이드됨
나머지 노드도 업그레이드 진행
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
|
# ./ahf_setup -local
AHF Installer for Platform Linux Architecture x86_64
AHF Installation Log : /tmp/ahf_install_213300_15247_2021_12_25-22_52_35.log
Starting Autonomous Health Framework (AHF) Installation
AHF Version: 21.3.3 Build Date: 202112130225
AHF is already installed at /opt/oracle.ahf
Installed AHF Version: 21.1.4 Build Date: 202106281226
Do you want to upgrade AHF [Y]|N : y
Upgrading /opt/oracle.ahf
Shutting down AHF Services
Stopped OSWatcher
Nothing to do !
Shutting down TFA
Removed /etc/systemd/system/multi-user.target.wants/oracle-tfa.service.
Removed /etc/systemd/system/graphical.target.wants/oracle-tfa.service.
Successfully shutdown TFA..
Starting AHF Services
Starting TFA..
Created symlink /etc/systemd/system/multi-user.target.wants/oracle-tfa.service -> /etc/systemd/system/oracle-tfa.service.
Created symlink /etc/systemd/system/graphical.target.wants/oracle-tfa.service -> /etc/systemd/system/oracle-tfa.service.
Waiting up to 100 seconds for TFA to be started..
. . . . .
Successfully started TFA Process..
. . . . .
TFA Started and listening for commands
No new directories were added to TFA
Directory /oracle/app/oracle/crsdata/oel19db2/trace/chad was already added to TFA Directories.
INFO: Starting orachk scheduler in background. Details for the process can be found at /oracle/app/oracle/oracle.ahf/data/oel19db2/diag/orachk/compliance_start_251221_225357.log
Do you want AHF to store your My Oracle Support Credentials for Automatic Upload ? Y|[N] : n
AHF is successfully upgraded to latest version
.----------------------------------------------------------------.
| Host | TFA Version | TFA Build ID | Upgrade Status |
+----------+-------------+----------------------+----------------+
| oel19db2 | 21.3.3.0.0 | 21330020211213022521 | UPGRADED |
| oel19db1 | 21.3.3.0.0 | 21330020211213022521 | UPGRADED |
'----------+-------------+----------------------+----------------'
Moving /tmp/ahf_install_213300_15247_2021_12_25-22_52_35.log to /oracle/app/oracle/oracle.ahf/data/oel19db2/diag/ahf/
|
정상적으로 21.3.3으로 업그레이드됨
모든노드 동시에 업그레이드
-local 없이 ./ahf_setup 을 실행하고 중간에 remote node 도 패치할지 묻는 질문에서 y 입력 후 해당 노드 패스워드를 입력하면됨)
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
|
# ./ahf_setup
AHF Installer for Platform Linux Architecture x86_64
AHF Installation Log : /tmp/ahf_install_214000_24223_2021_12_27-21_01_14.log
Starting Autonomous Health Framework (AHF) Installation
AHF Version: 21.4.0 Build Date: 202112200745
AHF is already installed at /opt/oracle.ahf
Installed AHF Version: 21.3.3 Build Date: 202112130225
Do you want to upgrade AHF [Y]|N : y
AHF will also be installed/upgraded on these Cluster Nodes :
1. oel19db2
The AHF Location and AHF Data Directory must exist on the above nodes
AHF Location : /opt/oracle.ahf
AHF Data Directory : /oracle/app/oracle/oracle.ahf/data
Do you want to install/upgrade AHF on Cluster Nodes ? [Y]|N : y
Upgrading /opt/oracle.ahf
Shutting down AHF Services
Stopped OSWatcher
Nothing to do !
Shutting down TFA
Removed /etc/systemd/system/multi-user.target.wants/oracle-tfa.service.
Removed /etc/systemd/system/graphical.target.wants/oracle-tfa.service.
Successfully shutdown TFA..
Starting AHF Services
Starting TFA..
Created symlink /etc/systemd/system/multi-user.target.wants/oracle-tfa.service -> /etc/systemd/system/oracle-tfa.service.
Created symlink /etc/systemd/system/graphical.target.wants/oracle-tfa.service -> /etc/systemd/system/oracle-tfa.service.
Waiting up to 100 seconds for TFA to be started..
. . . . .
Successfully started TFA Process..
. . . . .
TFA Started and listening for commands
No new directories were added to TFA
Directory /oracle/app/oracle/crsdata/oel19db1/trace/chad was already added to TFA Directories.
INFO: Starting orachk scheduler in background. Details for the process can be found at /oracle/app/oracle/oracle.ahf/data/oel19db1/diag/orachk/compliance_start_271221_210309.log
AHF upgrade completed on oel19db1
Upgrading AHF on Remote Nodes :
AHF will be installed on oel19db2, Please wait.
AHF will prompt twice to install/upgrade per Remote Node. So total 2 prompts
Do you want to continue Y|[N] : y <-- y 입력
AHF will continue with Upgrading on remote nodes
Upgrading AHF on oel19db2 : <-- 2번노드 root 유저 패스워드 입력
[oel19db2] Copying AHF Installer
root@oel19db2 password:
Do you want AHF to store your My Oracle Support Credentials for Automatic Upload ? Y|[N] : n
AHF is successfully upgraded to latest version
.----------------------------------------------------------------.
| Host | TFA Version | TFA Build ID | Upgrade Status |
+----------+-------------+----------------------+----------------+
| oel19db1 | 21.4.0.0.0 | 21400020211220074549 | UPGRADED |
| oel19db2 | 21.4.0.0.0 | 21400020211220074549 | UPGRADED |
'----------+-------------+----------------------+----------------'
Moving /tmp/ahf_install_214000_24223_2021_12_27-21_01_14.log to /oracle/app/oracle/oracle.ahf/data/oel19db1/diag/ahf/
|
정상적으로 양쪽노드 모두 21.4.0 버전으로 업그레이드됨
참조 : 2550798.1
https://positivemh.tistory.com/747
오라클 19c ahf(tfa) 설치 및 로그수집 가이드(SRDC)
OS환경 : Oracle Linux 7.6 (64bit) DB 환경 : Oracle Database 19.10.0.0 방법 : 오라클 19c ahf(tfa) 설치 및 로그수집 가이드(SRDC) TFA 란? Oracle Support는 데이터 수집을 위해 TFA (Trace File Anal..
positivemh.tistory.com
https://positivemh.tistory.com/767
오라클 19c 윈도우 환경에서 ahf(tfa) 설치 및 로그수집 가이드(SRDC)
OS환경 : Windows 2109 (64bit) DB 환경 : Oracle Database 19.3.0.0 방법 : 오라클 19c 윈도우 환경에서 ahf(tfa) 설치 및 로그수집 가이드(SRDC) TFA 란? Oracle Support는 데이터 수집을 위해 TFA (Tr..
positivemh.tistory.com
'ORACLE > Admin' 카테고리의 다른 글
| 오라클 19c rootcrs.sh unlock과 lock (0) | 2021.12.30 |
|---|---|
| 오라클 19c 리스너 로그 자동백업 파라미터 (0) | 2021.12.26 |
| 오라클 11g R2 서버 기동시 db 자동실행 설정 (0) | 2021.11.13 |
| 오라클 19c AWR 에 저장된 정보 확인(awrinfo.sql) (0) | 2021.11.05 |
| 오라클 19c 무료 클라이언트, 모니터링 툴 (0) | 2021.11.03 |