OS 환경 : Oracle Linux 8.4 (64bit)
DB 환경 : Oracle Database 19.27.0.0
방법 : PRCR-1079 : Failed to start resource ora.cvu
2node rac에서 3번노드를 delnode 한 뒤 다시 add node 함
참고 : 오라클 19c RAC 노드 제거 방법(silent) ( https://positivemh.tistory.com/1244 )
참고 : 오라클 19c RAC 노드 추가 방법(silent) ( https://positivemh.tistory.com/1243 )
이때 발생한 에러들을 게시글로 정리함
양이 많아 나눠서 업로드함
메인 게시글 : 오라클 19c RAC 제거한 노드 다시 추가 시 발생한 에러들 ( https://positivemh.tistory.com/1312 )
에러1. ORA-01613: instance ORA19DB3 (thread 3) only has 0 logs - at least 2 logs required to enable. ( https://positivemh.tistory.com/1308 )
에러2. ORA-30012: undo tablespace 'UNDOTBS3' does not exist or of wrong type ( https://positivemh.tistory.com/1309 )
에러3. [INS-43042] The cluster nodes [ora19rac3] specified for addnode is already part of a cluster. ( https://positivemh.tistory.com/1310 )
에러4. PRCR-1079 : Failed to start resource ora.cvu ( https://positivemh.tistory.com/1311 )
에러4. cvu 리소스가 offline 일때 3번노드 추가시 root.sh 수행시 에러
cvu란?
ora.cvu는 Grid Infrastructure 11.2.0.2에서 새로 도입된 리소스임
이 리소스의 목적은 일정 간격으로 클러스터웨어 헬스 체크를 수행하게 하는 것임
cluster verification utility(클러스터 검증 유틸리티)를 호출함
cvu stop 및 disable 후 add node 수행
cvu stop, disable 처리
|
1
2
|
$ srvctl stop cvu
$ srvctl disable cvu
|
cvu 기동시도
|
1
2
3
|
$ srvctl start cvu
PRCR-1079 : Failed to start resource ora.cvu
CRS-2501: Resource 'ora.cvu' is disabled
|
기동안됨
grid 상태 확인
|
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
|
$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE ora19rac1 STABLE
ONLINE ONLINE ora19rac2 STABLE
ora.chad
ONLINE ONLINE ora19rac1 STABLE
ONLINE ONLINE ora19rac2 STABLE
ora.net1.network
ONLINE ONLINE ora19rac1 STABLE
ONLINE ONLINE ora19rac2 STABLE
ora.ons
ONLINE ONLINE ora19rac1 STABLE
ONLINE ONLINE ora19rac2 STABLE
ora.proxy_advm
OFFLINE OFFLINE ora19rac1 STABLE
OFFLINE OFFLINE ora19rac2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE ora19rac1 STABLE
2 ONLINE ONLINE ora19rac2 STABLE
ora.DATANEW.dg(ora.asmgroup)
1 ONLINE ONLINE ora19rac1 STABLE
2 ONLINE ONLINE ora19rac2 STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE ora19rac1 STABLE
ora.OCRVOTE.dg(ora.asmgroup)
1 ONLINE ONLINE ora19rac1 STABLE
2 ONLINE ONLINE ora19rac2 STABLE
ora.RECONEW.dg(ora.asmgroup)
1 ONLINE ONLINE ora19rac1 STABLE
2 ONLINE ONLINE ora19rac2 STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE ora19rac1 Started,STABLE
2 ONLINE ONLINE ora19rac2 Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE ora19rac1 STABLE
2 ONLINE ONLINE ora19rac2 STABLE
ora.cvu
1 OFFLINE OFFLINE STABLE
ora.ora19db.db
1 ONLINE ONLINE ora19rac1 Open,HOME=/oracle/ap
p/oracle/product/19c
,STABLE
2 ONLINE ONLINE ora19rac2 Open,HOME=/oracle/ap
p/oracle/product/19c
,STABLE
ora.ora19rac1.vip
1 ONLINE ONLINE ora19rac1 STABLE
ora.ora19rac2.vip
1 ONLINE ONLINE ora19rac2 STABLE
ora.qosmserver
1 ONLINE ONLINE ora19rac1 STABLE
ora.scan1.vip
1 ONLINE ONLINE ora19rac1 STABLE
--------------------------------------------------------------------------------
|
아직 3번노드가 없고 cvu는 offline 상태임
gui 또는 silent 모드로 3번 노드 추가 수행
오라클 19c RAC 노드 추가 방법(gui) ( https://positivemh.tistory.com/1245 )
오라클 19c RAC 노드 추가 방법(silent) ( https://positivemh.tistory.com/1243 )
3번노드에서 root 유저로 orainstRoot.sh 및 root.sh 수행
orainstRoot.sh 수행
|
1
2
3
4
5
6
7
|
# /oracle/app/oraInventory/orainstRoot.sh
Changing permissions of /oracle/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.
Changing groupname of /oracle/app/oraInventory to oinstall.
The execution of the script is complete.
|
root.sh 수행
|
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
|
# /oracle/app/grid/19c/root.sh
Performing root user operation.
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /oracle/app/grid/19c
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Relinking oracle with rac_on option
Using configuration parameter file: /oracle/app/grid/19c/crs/install/crsconfig_params
The log of current session can be found at:
/oracle/app/oracle/crsdata/ora19rac3/crsconfig/rootcrs_ora19rac3_2025-11-30_10-41-06AM.log
2025/11/30 10:41:09 CLSRSC-594: Executing installation step 1 of 19: 'ValidateEnv'.
2025/11/30 10:41:10 CLSRSC-594: Executing installation step 2 of 19: 'CheckFirstNode'.
2025/11/30 10:41:10 CLSRSC-594: Executing installation step 3 of 19: 'GenSiteGUIDs'.
2025/11/30 10:41:12 CLSRSC-594: Executing installation step 4 of 19: 'SetupOSD'.
Redirecting to /bin/systemctl restart rsyslog.service
2025/11/30 10:41:12 CLSRSC-594: Executing installation step 5 of 19: 'CheckCRSConfig'.
2025/11/30 10:41:13 CLSRSC-594: Executing installation step 6 of 19: 'SetupLocalGPNP'.
2025/11/30 10:41:15 CLSRSC-594: Executing installation step 7 of 19: 'CreateRootCert'.
2025/11/30 10:41:15 CLSRSC-594: Executing installation step 8 of 19: 'ConfigOLR'.
2025/11/30 10:41:25 CLSRSC-594: Executing installation step 9 of 19: 'ConfigCHMOS'.
2025/11/30 10:41:25 CLSRSC-594: Executing installation step 10 of 19: 'CreateOHASD'.
2025/11/30 10:41:27 CLSRSC-594: Executing installation step 11 of 19: 'ConfigOHASD'.
2025/11/30 10:41:27 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'
2025/11/30 10:41:49 CLSRSC-594: Executing installation step 12 of 19: 'SetupTFA'.
2025/11/30 10:41:49 CLSRSC-594: Executing installation step 13 of 19: 'InstallAFD'.
2025/11/30 10:41:49 CLSRSC-594: Executing installation step 14 of 19: 'InstallACFS'.
2025/11/30 10:42:22 CLSRSC-594: Executing installation step 15 of 19: 'InstallKA'.
2025/11/30 10:42:23 CLSRSC-594: Executing installation step 16 of 19: 'InitConfig'.
2025/11/30 10:42:31 CLSRSC-594: Executing installation step 17 of 19: 'StartCluster'.
2025/11/30 10:43:24 CLSRSC-343: Successfully started Oracle Clusterware stack
2025/11/30 10:43:24 CLSRSC-594: Executing installation step 18 of 19: 'ConfigNode'.
clscfg: EXISTING configuration version 19 detected.
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
2025/11/30 10:43:59 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.
2025/11/30 10:44:17 CLSRSC-594: Executing installation step 19 of 19: 'PostConfig'.
PRCR-1079 : Failed to start resource ora.cvu
CRS-2501: Resource 'ora.cvu' is disabled
2025/11/30 10:44:31 CLSRSC-180: An error occurred while executing the command '/oracle/app/grid/19c/bin/srvctl start cvu'
2025/11/30 10:44:31 CLSRSC-112: Start of the CVU resource failed
2025/11/30 10:44:31 CLSRSC-112: Start of the CVU resource failed
Died at /oracle/app/grid/19c/crs/install/crsinstall.pm line 1453.
|
cvu가 disable 되어있다고 나오고 srvctl start cvu 명령이 성공하지 못해 19번 단계(PostConfig) 단계에서 root.sh이 종료됨
3번노드에서 grid 상태 확인
|
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
|
# crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE ora19rac1 STABLE
ONLINE ONLINE ora19rac2 STABLE
ONLINE ONLINE ora19rac3 STABLE
ora.chad
ONLINE ONLINE ora19rac1 STABLE
ONLINE ONLINE ora19rac2 STABLE
ONLINE ONLINE ora19rac3 STABLE
ora.net1.network
ONLINE ONLINE ora19rac1 STABLE
ONLINE ONLINE ora19rac2 STABLE
ONLINE ONLINE ora19rac3 STABLE
ora.ons
ONLINE ONLINE ora19rac1 STABLE
ONLINE ONLINE ora19rac2 STABLE
ONLINE ONLINE ora19rac3 STABLE
ora.proxy_advm
OFFLINE OFFLINE ora19rac1 STABLE
OFFLINE OFFLINE ora19rac2 STABLE
OFFLINE OFFLINE ora19rac3 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE ora19rac1 STABLE
2 ONLINE ONLINE ora19rac2 STABLE
3 ONLINE ONLINE ora19rac3 STABLE
ora.DATANEW.dg(ora.asmgroup)
1 ONLINE ONLINE ora19rac1 STABLE
2 ONLINE ONLINE ora19rac2 STABLE
3 ONLINE ONLINE ora19rac3 STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE ora19rac1 STABLE
ora.OCRVOTE.dg(ora.asmgroup)
1 ONLINE ONLINE ora19rac1 STABLE
2 ONLINE ONLINE ora19rac2 STABLE
3 ONLINE ONLINE ora19rac3 STABLE
ora.RECONEW.dg(ora.asmgroup)
1 ONLINE ONLINE ora19rac1 STABLE
2 ONLINE ONLINE ora19rac2 STABLE
3 ONLINE ONLINE ora19rac3 STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE ora19rac1 Started,STABLE
2 ONLINE ONLINE ora19rac2 Started,STABLE
3 ONLINE ONLINE ora19rac3 Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE ora19rac1 STABLE
2 ONLINE ONLINE ora19rac2 STABLE
3 ONLINE ONLINE ora19rac3 STABLE
ora.cvu
1 OFFLINE OFFLINE STABLE
ora.ora19db.db
1 ONLINE ONLINE ora19rac1 Open,HOME=/oracle/ap
p/oracle/product/19c
,STABLE
2 ONLINE ONLINE ora19rac2 Open,HOME=/oracle/ap
p/oracle/product/19c
,STABLE
ora.ora19rac1.vip
1 ONLINE ONLINE ora19rac1 STABLE
ora.ora19rac2.vip
1 ONLINE ONLINE ora19rac2 STABLE
ora.ora19rac3.vip
1 ONLINE ONLINE ora19rac3 STABLE
ora.qosmserver
1 ONLINE ONLINE ora19rac1 STABLE
ora.scan1.vip
1 ONLINE ONLINE ora19rac1 STABLE
--------------------------------------------------------------------------------
|
일단 3번노드에 대해 리소스는 다 올라와 있음
cvu는 현재 offline 상태임
cvu 상태 확인
|
1
2
3
4
5
|
$ srvctl config cvu
CVU is configured to run once every 360 minutes
CVU is disabled
CVU is individually enabled on nodes:
CVU is individually disabled on nodes:
|
offline(stop) 및 disable 상태임
cvu 리소스 enable 수행
|
1
2
3
4
5
6
|
# srvctl enable cvu
$ srvctl config cvu
CVU is configured to run once every 360 minutes
CVU is enabled.
CVU is individually enabled on nodes:
CVU is individually disabled on nodes:
|
enable로 변경됨(기동 가능한 상태)
3번 노드에서 root.sh 재수행
|
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
|
# /oracle/app/grid/19c/root.sh
Performing root user operation.
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /oracle/app/grid/19c
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Relinking oracle with rac_on option
Using configuration parameter file: /oracle/app/grid/19c/crs/install/crsconfig_params
The log of current session can be found at:
/oracle/app/oracle/crsdata/ora19rac3/crsconfig/rootcrs_ora19rac3_2025-11-30_12-30-26AM.log
2025/11/30 12:30:30 CLSRSC-594: Executing installation step 1 of 19: 'ValidateEnv'.
2025/11/30 12:30:30 CLSRSC-594: Executing installation step 2 of 19: 'CheckFirstNode'.
2025/11/30 12:30:30 CLSRSC-594: Executing installation step 3 of 19: 'GenSiteGUIDs'.
2025/11/30 12:30:32 CLSRSC-594: Executing installation step 4 of 19: 'SetupOSD'.
2025/11/30 12:30:32 CLSRSC-594: Executing installation step 5 of 19: 'CheckCRSConfig'.
2025/11/30 12:30:34 CLSRSC-594: Executing installation step 6 of 19: 'SetupLocalGPNP'.
2025/11/30 12:30:35 CLSRSC-594: Executing installation step 7 of 19: 'CreateRootCert'.
2025/11/30 12:30:35 CLSRSC-594: Executing installation step 8 of 19: 'ConfigOLR'.
2025/11/30 12:30:38 CLSRSC-594: Executing installation step 9 of 19: 'ConfigCHMOS'.
2025/11/30 12:30:38 CLSRSC-594: Executing installation step 10 of 19: 'CreateOHASD'.
2025/11/30 12:30:39 CLSRSC-594: Executing installation step 11 of 19: 'ConfigOHASD'.
2025/11/30 12:30:44 CLSRSC-594: Executing installation step 12 of 19: 'SetupTFA'.
2025/11/30 12:30:44 CLSRSC-594: Executing installation step 13 of 19: 'InstallAFD'.
2025/11/30 12:30:44 CLSRSC-594: Executing installation step 14 of 19: 'InstallACFS'.
2025/11/30 12:30:46 CLSRSC-594: Executing installation step 15 of 19: 'InstallKA'.
2025/11/30 12:30:47 CLSRSC-594: Executing installation step 16 of 19: 'InitConfig'.
2025/11/30 12:31:10 CLSRSC-594: Executing installation step 17 of 19: 'StartCluster'.
2025/11/30 12:31:47 CLSRSC-343: Successfully started Oracle Clusterware stack
2025/11/30 12:31:47 CLSRSC-594: Executing installation step 18 of 19: 'ConfigNode'.
2025/11/30 12:31:48 CLSRSC-594: Executing installation step 19 of 19: 'PostConfig'.
2025/11/30 12:32:11 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded
2025/11/30 12:32:15 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.
|
정상적으로 완료됨
*root.sh를 재수행해도 되는지에 대한 docs.oracle.com 문서는 찾지 못했지만,
본문 하단 참고 링크에 있는 mos 문서에는 특정 문제로 root.sh 실패시 재수행(rerun) 하라고 가이드 되어 있음
실제 나의 경우도 root.sh를 다시수행했지만 문제없이 완료됨
만약 이부분이 찝찝한 경우 add node gui를 중지하고 아래 deconfig 명령을 새로 추가한 노드에서 수행한 뒤 남은 찌꺼기 경로 제거 및 권한 부여, cvu 패키지 설치한뒤 다시 수행해주면됨
|
1
2
|
# cd $GRID_HOME/crs/install
# ./rootcrs.sh -deconfig -force -verbose
|
참고 : 오라클 19c RAC 노드 제거 방법(silent) ( https://positivemh.tistory.com/1244 )
root.sh 로그 확인(:new nu로 라인까지 확인)
|
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
|
$ vi /oracle/app/oracle/crsdata/ora19rac3/crsconfig/rootcrs_ora19rac3_2025-11-30_12-30-26AM.log
..
2220 2025-11-30 12:32:05: CRS_ADDNODE is defined to 'true'
2221 2025-11-30 12:32:05: 'ora19rac3' is part of add node list: ora19rac3
2222 2025-11-30 12:32:05: It is an add node scenario
2223 2025-11-30 12:32:05: Get diskstring for adding a new node crsutils=HASH(0x1f85be0)->HOST
2224 2025-11-30 12:32:05: AFD Diskstring:
2225 2025-11-30 12:32:05: Invoking "/oracle/app/grid/19c/bin/srvctl start cvu"
2226 2025-11-30 12:32:05: trace file=/oracle/app/oracle/crsdata/ora19rac3/crsconfig/srvmcfg5.log
2227 2025-11-30 12:32:05: Running as user oracle: /oracle/app/grid/19c/bin/srvctl start cvu
2228 2025-11-30 12:32:09: Removing file /tmp/9MnxMV9CwN
2229 2025-11-30 12:32:09: Successfully removed file: /tmp/9MnxMV9CwN
2230 2025-11-30 12:32:09: pipe exit code: 0
2231 2025-11-30 12:32:09: /bin/su successfully executed
2232
2233 2025-11-30 12:32:09:
2234 2025-11-30 12:32:09: start cvu ... success
2235 2025-11-30 12:32:09: Executed stage [PostConfig] in 21 seconds
2236 2025-11-30 12:32:09: Invoking "/oracle/app/grid/19c/bin/cluutil -ckpt -oraclebase /oracle/app/oracle -writeckpt -name ROOTCRS_STACK -state SUCCESS"
2237 2025-11-30 12:32:09: trace file=/oracle/app/oracle/crsdata/ora19rac3/crsconfig/cluutil2.log
2238 2025-11-30 12:32:09: Running as user oracle: /oracle/app/grid/19c/bin/cluutil -ckpt -oraclebase /oracle/app/oracle -writeckpt -name ROOTCRS_STACK -state SUCC ESS
2239 2025-11-30 12:32:11: Removing file /tmp/bGKNPndNXI
2240 2025-11-30 12:32:11: Successfully removed file: /tmp/bGKNPndNXI
2241 2025-11-30 12:32:11: pipe exit code: 0
2242 2025-11-30 12:32:11: /bin/su successfully executed
2243
2244 2025-11-30 12:32:11:
2245 2025-11-30 12:32:11: Succeeded in writing the checkpoint:'ROOTCRS_STACK' with status:SUCCESS
2246 2025-11-30 12:32:11: Install node: ora19rac1
2247 2025-11-30 12:32:11: Local node is neither installer node, nor a forced first node.
2248 2025-11-30 12:32:11: Local node: ora19rac3 is not the first node.
2249 2025-11-30 12:32:11: Executing cmd: /oracle/app/grid/19c/bin/clsecho -p has -f clsrsc -m 325
2250 2025-11-30 12:32:11: Executing cmd: /oracle/app/grid/19c/bin/clsecho -p has -f clsrsc -m 325
2251 2025-11-30 12:32:11: Command output:
2252 > CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded
2253 >End Command output
2254 2025-11-30 12:32:11: CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded
2255 2025-11-30 12:32:15: Command output:
2256 >
2257 > AHF Installer for Platform Linux Architecture x86_64
2258 >
2259 > AHF Installation Log : /tmp/ahf_install_252100_140296_2025_11_30-12_30_44.log
2260 >
2261 > Starting Autonomous Health Framework (AHF) Installation
2262 >
2263 > AHF Version: 25.2.1 Build Date: 202503051815
2264 >
2265 > AHF is already installed at /opt/oracle.ahf
2266 >
2267 > Installed AHF Version: 25.2.1 Build Date: 202503051815
2268 >
2269 > AHF is already running latest version. No need to upgrade.
2270 >
2271 > Moving /tmp/ahf_install_252100_140296_2025_11_30-12_30_44.log to /oracle/app/oracle/oracle.ahf/data/ora19rac3/diag/ahf/
2272 >
2273 >End Command output
2274 2025-11-30 12:32:15: Executing cmd: /oracle/app/grid/19c/bin/clsecho -p has -f clsrsc -m 4002
2275 2025-11-30 12:32:15: Executing cmd: /oracle/app/grid/19c/bin/clsecho -p has -f clsrsc -m 4002
2276 2025-11-30 12:32:15: Command output:
2277 > CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.
2278 >End Command output
2279 2025-11-30 12:32:15: CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.
|
전체 2279 라인중에 2225 라인에서 cvu를 start 시키려고함
cvu가 disable 상태일때는 start 자체가 안되기 때문에 저부분에서 종료되는듯함
cvu 기동 이후
2236 라인에서 /oracle/app/grid/19c/bin/cluutil -ckpt -oraclebase /oracle/app/oracle -writeckpt -name ROOTCRS_STACK -state SUCCESS 명령이 호출 및 수행되고
2249 라인에서 /oracle/app/grid/19c/bin/clsecho -p has -f clsrsc -m 325 명령이 수행되고
2257 라인에서 ahf 설치가 시작되고
2274 라인에서 /oracle/app/grid/19c/bin/clsecho -p has -f clsrsc -m 4002 명령이 수행됨
2277 라인에서 ahf(tfa) 설치가 완료됨
그리고 root.sh이 종료됨
참고로 cvu가 이미 start 되어있는경우 root.sh 메인 로그에는 별다른 내용없이 잘 수행되지만
상세로그를 보면 동일하게 PRCR-1079 : Failed to start resource ora.cvu 에러가 발생하는것을 볼수 있음(이미 기동중이라 start가 실패한것이기 때문)
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
#root.sh 메인로그(화면에 표시되는 로그)
# /oracle/app/grid/19c/root.sh
...
2025/12/01 12:14:54 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.
2025/12/01 12:15:07 CLSRSC-594: Executing installation step 19 of 19: 'PostConfig'.
2025/12/01 12:15:21 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded
#root.sh 상세로그
$ tail -300f /oracle/app/oracle/crsdata/ora19rac3/crsconfig/rootcrs_ora19rac3_2025-12-01_12-12-00AM.log
2025-12-01 12:15:20: PRCC-1014 : cvu was already running
PRCR-1004 : Resource ora.cvu is already running
PRCR-1079 : Failed to start resource ora.cvu <<---
CRS-5702: Resource 'ora.cvu' is already running on 'ora19rac2'
2025-12-01 12:15:20: start cvu ... success
|
이후 db addnode 및 dbca addInstance 까지 잘 수행됨
|
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
|
$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE ora19rac1 STABLE
ONLINE ONLINE ora19rac2 STABLE
ONLINE ONLINE ora19rac3 STABLE
ora.chad
ONLINE ONLINE ora19rac1 STABLE
ONLINE ONLINE ora19rac2 STABLE
ONLINE ONLINE ora19rac3 STABLE
ora.net1.network
ONLINE ONLINE ora19rac1 STABLE
ONLINE ONLINE ora19rac2 STABLE
ONLINE ONLINE ora19rac3 STABLE
ora.ons
ONLINE ONLINE ora19rac1 STABLE
ONLINE ONLINE ora19rac2 STABLE
ONLINE ONLINE ora19rac3 STABLE
ora.proxy_advm
OFFLINE OFFLINE ora19rac1 STABLE
OFFLINE OFFLINE ora19rac2 STABLE
OFFLINE OFFLINE ora19rac3 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE ora19rac1 STABLE
2 ONLINE ONLINE ora19rac2 STABLE
3 ONLINE ONLINE ora19rac3 STABLE
ora.DATANEW.dg(ora.asmgroup)
1 ONLINE ONLINE ora19rac1 STABLE
2 ONLINE ONLINE ora19rac2 STABLE
3 ONLINE ONLINE ora19rac3 STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE ora19rac1 STABLE
ora.OCRVOTE.dg(ora.asmgroup)
1 ONLINE ONLINE ora19rac1 STABLE
2 ONLINE ONLINE ora19rac2 STABLE
3 ONLINE ONLINE ora19rac3 STABLE
ora.RECONEW.dg(ora.asmgroup)
1 ONLINE ONLINE ora19rac1 STABLE
2 ONLINE ONLINE ora19rac2 STABLE
3 ONLINE ONLINE ora19rac3 STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE ora19rac1 Started,STABLE
2 ONLINE ONLINE ora19rac2 Started,STABLE
3 ONLINE ONLINE ora19rac3 Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE ora19rac1 STABLE
2 ONLINE ONLINE ora19rac2 STABLE
3 ONLINE ONLINE ora19rac3 STABLE
ora.cvu
1 ONLINE ONLINE ora19rac3 STABLE
ora.ora19db.db
1 ONLINE ONLINE ora19rac1 Open,HOME=/oracle/ap
p/oracle/product/19c
,STABLE
2 ONLINE ONLINE ora19rac2 Open,HOME=/oracle/ap
p/oracle/product/19c
,STABLE
3 ONLINE ONLINE ora19rac3 Open,HOME=/oracle/ap
p/oracle/product/19c
,STABLE
ora.ora19rac1.vip
1 ONLINE ONLINE ora19rac1 STABLE
ora.ora19rac2.vip
1 ONLINE ONLINE ora19rac2 STABLE
ora.ora19rac3.vip
1 ONLINE ONLINE ora19rac3 STABLE
ora.qosmserver
1 ONLINE ONLINE ora19rac1 STABLE
ora.scan1.vip
1 ONLINE ONLINE ora19rac1 STABLE
--------------------------------------------------------------------------------
|
cvu를 enable 및 start 해도 기존 db에 영향 없음
필요없다면 add node 후 stop 및 disable 가능함
참조 :
https://positivemh.tistory.com/284
https://positivemh.tistory.com/1244
Database fails to start on due to ORA-01618: redo thread 2 is not enabled - cannot mount (Doc ID 1677362.1)
Top Issues When Adding Node for Grid Infrastructure via GridSetup.sh (Doc ID 2955583.1)
https://pat98.tistory.com/731
https://docs.oracle.com/en/database/oracle/oracle-database/19/cwadd/cluster-verification-utility-reference.html#GUID-B445A858-9F00-4423-990E-109545AC11C3
https://dbmentors.blogspot.com/2013/11/clusterware-resource-oracvu.html
Clusterware resource ora.cvu FAQ (Doc ID 1524235.1)
Cluster Verification Utility (CLUVFY) FAQ (Doc ID 316817.1)
"Roottfa.sh: Not Found" after executing root.sh script. (Doc ID 2960836.1)
root.sh Hanging During Relink on AIX (Doc ID 3091869.1)
Root.sh Failed During Rac Installation Due To Antivirus (Doc ID 3058530.1)
https://dbacentrals.blogspot.com/2017/08/srvm1337crs-10051-cvu-found-following.html