OS환경 : Oracle Linux 7.6 (64bit)
DB 환경 : Oracle Database 11.2.0.4
OS 및 사전 설정은 아래 게시물 참조
Oracle Linux 7.6에 Oracle 11gR2 Raw Device RAC 설치 가이드_Part 1(https://positivemh.tistory.com/1224)
방법 : Oracle Linux 7.6에 Oracle 11gR2 Raw Device RAC 설치 가이드_Part 2
OS 설치는 아래 게시물 참조
Oracle Linux 7.6 설치 가이드(https://positivemh.tistory.com/521)
hostname 변경해야함
1번 노드 hostname : oel11db1
2번 노드 hostname : oel11db2
*본문에 2번노드 표시가 없으면 모두 1번노드에서 작업
설치파일은 아래 4가지 파일을 이용함
GRID : p13390677_112040_Linux-x86-64_3of7.zip
DB : p13390677_112040_Linux-x86-64_1of7.zip, p13390677_112040_Linux-x86-64_2of7.zip
Patch p18370031_112040_Linux-x86-64.zip(linux 7에 grid 설치시 필수 패치)
참고 : 11gR2 Grid install – Error: ohasd failed to start the Clusterware. ( https://positivemh.tistory.com/122 )
GRID 설치
node1 에서 작업, GRID 설치파일 압축해제
|
1
2
3
|
# su - oracle
$ cd /app/oracle/media/
$ unzip p13390677_112040_Linux-x86-64_3of7.zip
|
cvu rpm 설치(root 계정)
|
1
2
3
4
5
|
# rpm -ivh /app/oracle/media/grid/stage/cvu/cv/remenv/cvuqdisk-1.0.9-1.rpm
Preparing... ################################# [100%]
Using default group oinstall to install package
Updating / installing...
1:cvuqdisk-1.0.9-1 ################################# [100%]
|
node2에도 rpm 설치(root 계정)
|
1
2
3
4
5
6
7
8
9
10
11
12
|
1번 노드
# rsync --progress /app/oracle/media/grid/stage/cvu/cv/remenv/cvuqdisk-1.0.9-1.rpm oel11db2:/root/
root@oel11db2's password:
cvuqdisk-1.0.9-1.rpm
8,288 100% 0.00kB/s 0:00:00 (xfr#1, to-chk=0/1)
2번 노드
# rpm -ivh /root/cvuqdisk-1.0.9-1.rpm
Preparing... ################################# [100%]
Using default group oinstall to install package
Updating / installing...
1:cvuqdisk-1.0.9-1 ################################# [100%]
|
ssh 수동 설정(yes, 패스워드 입력)
|
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
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
|
$ cd /app/oracle/media/grid/sshsetup
$ ./sshUserSetup.sh -user oracle -hosts "oel11db1 oel11db2" -noPromptPassphrase -advanced
The output of this script is also logged into /tmp/sshUserSetup_2025-06-06-16-49-17.log
Hosts are oel11db1 oel11db2
user is oracle
Platform:- Linux
Checking if the remote hosts are reachable
PING oel11db1 (192.168.137.10) 56(84) bytes of data.
64 bytes from oel11db1 (192.168.137.10): icmp_seq=1 ttl=64 time=0.015 ms
64 bytes from oel11db1 (192.168.137.10): icmp_seq=2 ttl=64 time=0.033 ms
64 bytes from oel11db1 (192.168.137.10): icmp_seq=3 ttl=64 time=0.032 ms
64 bytes from oel11db1 (192.168.137.10): icmp_seq=4 ttl=64 time=0.030 ms
64 bytes from oel11db1 (192.168.137.10): icmp_seq=5 ttl=64 time=0.031 ms
--- oel11db1 ping statistics ---
5 packets transmitted, 5 received, 0% packet loss, time 4086ms
rtt min/avg/max/mdev = 0.015/0.028/0.033/0.007 ms
PING oel11db2 (192.168.137.20) 56(84) bytes of data.
64 bytes from oel11db2 (192.168.137.20): icmp_seq=1 ttl=64 time=0.253 ms
64 bytes from oel11db2 (192.168.137.20): icmp_seq=2 ttl=64 time=0.232 ms
64 bytes from oel11db2 (192.168.137.20): icmp_seq=3 ttl=64 time=0.271 ms
64 bytes from oel11db2 (192.168.137.20): icmp_seq=4 ttl=64 time=0.277 ms
64 bytes from oel11db2 (192.168.137.20): icmp_seq=5 ttl=64 time=0.267 ms
--- oel11db2 ping statistics ---
5 packets transmitted, 5 received, 0% packet loss, time 4094ms
rtt min/avg/max/mdev = 0.232/0.260/0.277/0.016 ms
Remote host reachability check succeeded.
The following hosts are reachable: oel11db1 oel11db2.
The following hosts are not reachable: .
All hosts are reachable. Proceeding further...
firsthost oel11db1
numhosts 2
The script will setup SSH connectivity from the host oel11db1 to all
the remote hosts. After the script is executed, the user can use SSH to run
commands on the remote hosts or copy files between this host oel11db1
and the remote hosts without being prompted for passwords or confirmations.
NOTE 1:
As part of the setup procedure, this script will use ssh and scp to copy
files between the local host and the remote hosts. Since the script does not
store passwords, you may be prompted for the passwords during the execution of
the script whenever ssh or scp is invoked.
NOTE 2:
AS PER SSH REQUIREMENTS, THIS SCRIPT WILL SECURE THE USER HOME DIRECTORY
AND THE .ssh DIRECTORY BY REVOKING GROUP AND WORLD WRITE PRIVILEDGES TO THESE
directories.
Do you want to continue and let the script make the above mentioned changes (yes/no)?
yes <-- yes 입력
The user chose yes
User chose to skip passphrase related questions.
Creating .ssh directory on local host, if not present already
Creating authorized_keys file on local host
Changing permissions on authorized_keys to 644 on local host
Creating known_hosts file on local host
Changing permissions on known_hosts to 644 on local host
Creating config file on local host
If a config file exists already at /home/oracle/.ssh/config, it would be backed up to /home/oracle/.ssh/config.backup.
Creating .ssh directory and setting permissions on remote host oel11db1
THE SCRIPT WOULD ALSO BE REVOKING WRITE PERMISSIONS FOR group AND others ON THE HOME DIRECTORY FOR oracle. THIS IS AN SSH REQUIREMENT.
The script would create ~oracle/.ssh/config file on remote host oel11db1. If a config file exists already at ~oracle/.ssh/config, it would be backed up to ~oracle/.ssh/config.backup.
The user may be prompted for a password here since the script would be running SSH on host oel11db1.
Warning: Permanently added 'oel11db1,192.168.137.10' (ECDSA) to the list of known hosts.
oracle@oel11db1's password: <-- 1번 노드 oracle 유저 패스워드 입력
Done with creating .ssh directory and setting permissions on remote host oel11db1.
Creating .ssh directory and setting permissions on remote host oel11db2
THE SCRIPT WOULD ALSO BE REVOKING WRITE PERMISSIONS FOR group AND others ON THE HOME DIRECTORY FOR oracle. THIS IS AN SSH REQUIREMENT.
The script would create ~oracle/.ssh/config file on remote host oel11db2. If a config file exists already at ~oracle/.ssh/config, it would be backed up to ~oracle/.ssh/config.backup.
The user may be prompted for a password here since the script would be running SSH on host oel11db2.
Warning: Permanently added 'oel11db2,192.168.137.20' (ECDSA) to the list of known hosts.
oracle@oel11db2's password: <-- 2번 노드 oracle 유저 패스워드 입력
Done with creating .ssh directory and setting permissions on remote host oel11db2.
Copying local host public key to the remote host oel11db1
The user may be prompted for a password or passphrase here since the script would be using SCP for host oel11db1.
oracle@oel11db1's password: <-- 1번 노드 oracle 유저 패스워드 입력
Done copying local host public key to the remote host oel11db1
Copying local host public key to the remote host oel11db2
The user may be prompted for a password or passphrase here since the script would be using SCP for host oel11db2.
oracle@oel11db2's password: <-- 2번 노드 oracle 유저 패스워드 입력
Done copying local host public key to the remote host oel11db2
Creating keys on remote host oel11db1 if they do not exist already. This is required to setup SSH on host oel11db1.
Creating keys on remote host oel11db2 if they do not exist already. This is required to setup SSH on host oel11db2.
Generating public/private rsa key pair.
Your identification has been saved in .ssh/id_rsa.
Your public key has been saved in .ssh/id_rsa.pub.
The key fingerprint is:
SHA256:1Wq8yC+4LXtcTfW7C8n4YECRMJW0QhVcQ+HP85F2G5E oracle@oel11db2
The key's randomart image is:
+---[RSA 1024]----+
| +***=. |
| . .++.. . .|
| . o.... E |
| oo .+ +|
| S.+o + =o|
| . oo.+ =.=|
| oo..+ + o.|
| o.+.. o .. |
| o=... . ..|
+----[SHA256]-----+
Updating authorized_keys file on remote host oel11db1
Updating known_hosts file on remote host oel11db1
Updating authorized_keys file on remote host oel11db2
Updating known_hosts file on remote host oel11db2
cat: /home/oracle/.ssh/known_hosts.tmp: No such file or directory
cat: /home/oracle/.ssh/authorized_keys.tmp: No such file or directory
SSH setup is complete.
------------------------------------------------------------------------
Verifying SSH setup
===================
The script will now run the date command on the remote nodes using ssh
to verify if ssh is setup correctly. IF THE SETUP IS CORRECTLY SETUP,
THERE SHOULD BE NO OUTPUT OTHER THAN THE DATE AND SSH SHOULD NOT ASK FOR
PASSWORDS. If you see any output other than date or are prompted for the
password, ssh is not setup correctly and you will need to resolve the
issue and set up ssh again.
The possible causes for failure could be:
1. The server settings in /etc/ssh/sshd_config file do not allow ssh
for user oracle.
2. The server may have disabled public key based authentication.
3. The client public key on the server may be outdated.
4. ~oracle or ~oracle/.ssh on the remote host may not be owned by oracle.
5. User may not have passed -shared option for shared remote users or
may be passing the -shared option for non-shared remote users.
6. If there is output in addition to the date, but no password is asked,
it may be a security alert shown as part of company policy. Append the
additional text to the <OMS HOME>/sysman/prov/resources/ignoreMessages.txt file.
------------------------------------------------------------------------
--oel11db1:--
Running /usr/bin/ssh -x -l oracle oel11db1 date to verify SSH connectivity has been setup from local host to oel11db1.
IF YOU SEE ANY OTHER OUTPUT BESIDES THE OUTPUT OF THE DATE COMMAND OR IF YOU ARE PROMPTED FOR A PASSWORD HERE, IT MEANS SSH SETUP HAS NOT BEEN SUCCESSFUL. Please note that being prompted for a passphrase may be OK but being prompted for a password is ERROR.
Fri Jun 6 16:49:37 KST 2025
------------------------------------------------------------------------
--oel11db2:--
Running /usr/bin/ssh -x -l oracle oel11db2 date to verify SSH connectivity has been setup from local host to oel11db2.
IF YOU SEE ANY OTHER OUTPUT BESIDES THE OUTPUT OF THE DATE COMMAND OR IF YOU ARE PROMPTED FOR A PASSWORD HERE, IT MEANS SSH SETUP HAS NOT BEEN SUCCESSFUL. Please note that being prompted for a passphrase may be OK but being prompted for a password is ERROR.
Fri Jun 6 16:49:37 KST 2025
------------------------------------------------------------------------
------------------------------------------------------------------------
Verifying SSH connectivity has been setup from oel11db1 to oel11db1
IF YOU SEE ANY OTHER OUTPUT BESIDES THE OUTPUT OF THE DATE COMMAND OR IF YOU ARE PROMPTED FOR A PASSWORD HERE, IT MEANS SSH SETUP HAS NOT BEEN SUCCESSFUL.
bash: -c: line 0: unexpected EOF while looking for matching `"'
bash: -c: line 1: syntax error: unexpected end of file
------------------------------------------------------------------------
------------------------------------------------------------------------
Verifying SSH connectivity has been setup from oel11db1 to oel11db2
IF YOU SEE ANY OTHER OUTPUT BESIDES THE OUTPUT OF THE DATE COMMAND OR IF YOU ARE PROMPTED FOR A PASSWORD HERE, IT MEANS SSH SETUP HAS NOT BEEN SUCCESSFUL.
bash: -c: line 0: unexpected EOF while looking for matching `"'
bash: -c: line 1: syntax error: unexpected end of file
------------------------------------------------------------------------
-Verification from complete-
SSH verification complete.
|
사전점검(kernel / package 등)
|
1
2
3
|
$ export CV_ASSUME_DISTID=OEL7.8
$ cd /app/oracle/media/grid
$ ./runcluvfy.sh stage -pre crsinst -n oel11db1,oel11db2 -fixup -verbose >> precheck.log
|
로그 확인
|
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
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
|
$ cat precheck.log
Performing pre-checks for cluster services setup
Checking node reachability...
Check: Node reachability from node "oel11db1"
Destination Node Reachable?
------------------------------------ ------------------------
oel11db1 yes
oel11db2 yes
Result: Node reachability check passed from node "oel11db1"
Checking user equivalence...
Check: User equivalence for user "oracle"
Node Name Status
------------------------------------ ------------------------
oel11db2 passed
oel11db1 passed
Result: User equivalence check passed for user "oracle"
Checking node connectivity...
Checking hosts config file...
Node Name Status
------------------------------------ ------------------------
oel11db2 passed
oel11db1 passed
Verification of the hosts config file successful
Interface information for node "oel11db2"
Name IP Address Subnet Gateway Def. Gateway HW Address MTU
------ --------------- --------------- --------------- --------------- ----------------- ------
ens32 192.168.137.20 192.168.137.0 0.0.0.0 192.168.137.2 00:50:56:2D:1A:C8 1500
ens35 10.10.10.20 10.10.10.0 0.0.0.0 192.168.137.2 00:50:56:36:8A:2C 1500
Interface information for node "oel11db1"
Name IP Address Subnet Gateway Def. Gateway HW Address MTU
------ --------------- --------------- --------------- --------------- ----------------- ------
ens32 192.168.137.10 192.168.137.0 0.0.0.0 192.168.137.2 00:0C:29:9B:25:D2 1500
ens35 10.10.10.10 10.10.10.0 0.0.0.0 192.168.137.2 00:0C:29:9B:25:DC 1500
Check: Node connectivity of subnet "192.168.137.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
oel11db2[192.168.137.20] oel11db1[192.168.137.10] yes
Result: Node connectivity passed for subnet "192.168.137.0" with node(s) oel11db2,oel11db1
Check: TCP connectivity of subnet "192.168.137.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
oel11db1:192.168.137.10 oel11db2:192.168.137.20 passed
Result: TCP connectivity check passed for subnet "192.168.137.0"
Check: Node connectivity of subnet "10.10.10.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
oel11db2[10.10.10.20] oel11db1[10.10.10.10] yes
Result: Node connectivity passed for subnet "10.10.10.0" with node(s) oel11db2,oel11db1
Check: TCP connectivity of subnet "10.10.10.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
oel11db1:10.10.10.10 oel11db2:10.10.10.20 passed
Result: TCP connectivity check passed for subnet "10.10.10.0"
Interfaces found on subnet "192.168.137.0" that are likely candidates for VIP are:
oel11db2 ens32:192.168.137.20
oel11db1 ens32:192.168.137.10
Interfaces found on subnet "10.10.10.0" that are likely candidates for a private interconnect are:
oel11db2 ens35:10.10.10.20
oel11db1 ens35:10.10.10.10
Checking subnet mask consistency...
Subnet mask consistency check passed for subnet "192.168.137.0".
Subnet mask consistency check passed for subnet "10.10.10.0".
Subnet mask consistency check passed.
Result: Node connectivity check passed
Checking multicast communication...
Checking subnet "192.168.137.0" for multicast communication with multicast group "230.0.1.0"...
Check of subnet "192.168.137.0" for multicast communication with multicast group "230.0.1.0" passed.
Checking subnet "10.10.10.0" for multicast communication with multicast group "230.0.1.0"...
Check of subnet "10.10.10.0" for multicast communication with multicast group "230.0.1.0" passed.
Check of multicast communication passed.
Checking ASMLib configuration.
Node Name Status
------------------------------------ ------------------------
oel11db2 passed
oel11db1 passed
Result: Check for ASMLib configuration passed.
Check: Total memory
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
oel11db2 7.7698GB (8147192.0KB) 1.5GB (1572864.0KB) passed
oel11db1 7.7698GB (8147192.0KB) 1.5GB (1572864.0KB) passed
Result: Total memory check passed
Check: Available memory
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
oel11db2 7.0819GB (7425892.0KB) 50MB (51200.0KB) passed
oel11db1 7.2028GB (7552640.0KB) 50MB (51200.0KB) passed
Result: Available memory check passed
Check: Swap space
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
oel11db2 3.7266GB (3907580.0KB) 7.7698GB (8147192.0KB) failed
oel11db1 3.7266GB (3907580.0KB) 7.7698GB (8147192.0KB) failed
Result: Swap space check failed
Check: Free disk space for "oel11db2:/tmp"
Path Node Name Mount point Available Required Status
---------------- ------------ ------------ ------------ ------------ ------------
/tmp oel11db2 / 35.9727GB 1GB passed
Result: Free disk space check passed for "oel11db2:/tmp"
Check: Free disk space for "oel11db1:/tmp"
Path Node Name Mount point Available Required Status
---------------- ------------ ------------ ------------ ------------ ------------
/tmp oel11db1 / 34.6733GB 1GB passed
Result: Free disk space check passed for "oel11db1:/tmp"
Check: User existence for "oracle"
Node Name Status Comment
------------ ------------------------ ------------------------
oel11db2 passed exists(54321)
oel11db1 passed exists(54321)
Checking for multiple users with UID value 54321
Result: Check for multiple users with UID value 54321 passed
Result: User existence check passed for "oracle"
Check: Group existence for "oinstall"
Node Name Status Comment
------------ ------------------------ ------------------------
oel11db2 passed exists
oel11db1 passed exists
Result: Group existence check passed for "oinstall"
Check: Group existence for "dba"
Node Name Status Comment
------------ ------------------------ ------------------------
oel11db2 passed exists
oel11db1 passed exists
Result: Group existence check passed for "dba"
Check: Membership of user "oracle" in group "oinstall" [as Primary]
Node Name User Exists Group Exists User in Group Primary Status
---------------- ------------ ------------ ------------ ------------ ------------
oel11db2 yes yes yes yes passed
oel11db1 yes yes yes yes passed
Result: Membership check for user "oracle" in group "oinstall" [as Primary] passed
Check: Membership of user "oracle" in group "dba"
Node Name User Exists Group Exists User in Group Status
---------------- ------------ ------------ ------------ ----------------
oel11db2 yes yes yes passed
oel11db1 yes yes yes passed
Result: Membership check for user "oracle" in group "dba" passed
Check: Run level
Node Name run level Required Status
------------ ------------------------ ------------------------ ----------
oel11db2 5 3,5 passed
oel11db1 5 3,5 passed
Result: Run level check passed
Check: Hard limits for "maximum open file descriptors"
Node Name Type Available Required Status
---------------- ------------ ------------ ------------ ----------------
oel11db2 hard 65536 65536 passed
oel11db1 hard 65536 65536 passed
Result: Hard limits check passed for "maximum open file descriptors"
Check: Soft limits for "maximum open file descriptors"
Node Name Type Available Required Status
---------------- ------------ ------------ ------------ ----------------
oel11db2 soft 1024 1024 passed
oel11db1 soft 1024 1024 passed
Result: Soft limits check passed for "maximum open file descriptors"
Check: Hard limits for "maximum user processes"
Node Name Type Available Required Status
---------------- ------------ ------------ ------------ ----------------
oel11db2 hard 16384 16384 passed
oel11db1 hard 16384 16384 passed
Result: Hard limits check passed for "maximum user processes"
Check: Soft limits for "maximum user processes"
Node Name Type Available Required Status
---------------- ------------ ------------ ------------ ----------------
oel11db2 soft 16384 2047 passed
oel11db1 soft 16384 2047 passed
Result: Soft limits check passed for "maximum user processes"
Check: System architecture
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
oel11db2 x86_64 x86_64 passed
oel11db1 x86_64 x86_64 passed
Result: System architecture check passed
Check: Kernel version
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
oel11db2 4.14.35-1818.3.3.el7uek.x86_64 2.6.9 passed
oel11db1 4.14.35-1818.3.3.el7uek.x86_64 2.6.9 passed
Result: Kernel version check passed
Check: Kernel parameter for "semmsl"
Node Name Current Configured Required Status Comment
---------------- ------------ ------------ ------------ ------------ ------------
oel11db2 250 250 250 passed
oel11db1 250 250 250 passed
Result: Kernel parameter check passed for "semmsl"
Check: Kernel parameter for "semmns"
Node Name Current Configured Required Status Comment
---------------- ------------ ------------ ------------ ------------ ------------
oel11db2 32000 32000 32000 passed
oel11db1 32000 32000 32000 passed
Result: Kernel parameter check passed for "semmns"
Check: Kernel parameter for "semopm"
Node Name Current Configured Required Status Comment
---------------- ------------ ------------ ------------ ------------ ------------
oel11db2 100 100 100 passed
oel11db1 100 100 100 passed
Result: Kernel parameter check passed for "semopm"
Check: Kernel parameter for "semmni"
Node Name Current Configured Required Status Comment
---------------- ------------ ------------ ------------ ------------ ------------
oel11db2 128 128 128 passed
oel11db1 128 128 128 passed
Result: Kernel parameter check passed for "semmni"
Check: Kernel parameter for "shmmax"
Node Name Current Configured Required Status Comment
---------------- ------------ ------------ ------------ ------------ ------------
oel11db2 4294967296 4294967296 4171362304 passed
oel11db1 4294967296 4294967296 4171362304 passed
Result: Kernel parameter check passed for "shmmax"
Check: Kernel parameter for "shmmni"
Node Name Current Configured Required Status Comment
---------------- ------------ ------------ ------------ ------------ ------------
oel11db2 4096 4096 4096 passed
oel11db1 4096 4096 4096 passed
Result: Kernel parameter check passed for "shmmni"
Check: Kernel parameter for "shmall"
Node Name Current Configured Required Status Comment
---------------- ------------ ------------ ------------ ------------ ------------
oel11db2 4294967296 4294967296 2097152 passed
oel11db1 4294967296 4294967296 2097152 passed
Result: Kernel parameter check passed for "shmall"
Check: Kernel parameter for "file-max"
Node Name Current Configured Required Status Comment
---------------- ------------ ------------ ------------ ------------ ------------
oel11db2 6815744 6815744 6815744 passed
oel11db1 6815744 6815744 6815744 passed
Result: Kernel parameter check passed for "file-max"
Check: Kernel parameter for "ip_local_port_range"
Node Name Current Configured Required Status Comment
---------------- ------------ ------------ ------------ ------------ ------------
oel11db2 between 9000.0 & 65500.0 between 9000.0 & 65500.0 between 9000.0 & 65500.0 passed
oel11db1 between 9000.0 & 65500.0 between 9000.0 & 65500.0 between 9000.0 & 65500.0 passed
Result: Kernel parameter check passed for "ip_local_port_range"
Check: Kernel parameter for "rmem_default"
Node Name Current Configured Required Status Comment
---------------- ------------ ------------ ------------ ------------ ------------
oel11db2 262144 262144 262144 passed
oel11db1 262144 262144 262144 passed
Result: Kernel parameter check passed for "rmem_default"
Check: Kernel parameter for "rmem_max"
Node Name Current Configured Required Status Comment
---------------- ------------ ------------ ------------ ------------ ------------
oel11db2 4194304 4194304 4194304 passed
oel11db1 4194304 4194304 4194304 passed
Result: Kernel parameter check passed for "rmem_max"
Check: Kernel parameter for "wmem_default"
Node Name Current Configured Required Status Comment
---------------- ------------ ------------ ------------ ------------ ------------
oel11db2 262144 262144 262144 passed
oel11db1 262144 262144 262144 passed
Result: Kernel parameter check passed for "wmem_default"
Check: Kernel parameter for "wmem_max"
Node Name Current Configured Required Status Comment
---------------- ------------ ------------ ------------ ------------ ------------
oel11db2 1048576 1048576 1048576 passed
oel11db1 1048576 1048576 1048576 passed
Result: Kernel parameter check passed for "wmem_max"
Check: Kernel parameter for "aio-max-nr"
Node Name Current Configured Required Status Comment
---------------- ------------ ------------ ------------ ------------ ------------
oel11db2 1048576 1048576 1048576 passed
oel11db1 1048576 1048576 1048576 passed
Result: Kernel parameter check passed for "aio-max-nr"
Check: Package existence for "make"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
oel11db2 make-3.82-23.el7 make-3.80 passed
oel11db1 make-3.82-23.el7 make-3.80 passed
Result: Package existence check passed for "make"
Check: Package existence for "binutils"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
oel11db2 binutils-2.27-34.base.0.1.el7 binutils-2.15.92.0.2 passed
oel11db1 binutils-2.27-34.base.0.1.el7 binutils-2.15.92.0.2 passed
Result: Package existence check passed for "binutils"
Check: Package existence for "gcc(x86_64)"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
oel11db2 gcc(x86_64)-4.8.5-36.0.1.el7 gcc(x86_64)-3.4.6 passed
oel11db1 gcc(x86_64)-4.8.5-36.0.1.el7 gcc(x86_64)-3.4.6 passed
Result: Package existence check passed for "gcc(x86_64)"
Check: Package existence for "libaio(x86_64)"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
oel11db2 libaio(x86_64)-0.3.109-13.el7 libaio(x86_64)-0.3.105 passed
oel11db1 libaio(x86_64)-0.3.109-13.el7 libaio(x86_64)-0.3.105 passed
Result: Package existence check passed for "libaio(x86_64)"
Check: Package existence for "glibc(x86_64)"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
oel11db2 glibc(x86_64)-2.17-260.0.9.el7 glibc(x86_64)-2.3.4-2.41 passed
oel11db1 glibc(x86_64)-2.17-260.0.9.el7 glibc(x86_64)-2.3.4-2.41 passed
Result: Package existence check passed for "glibc(x86_64)"
Check: Package existence for "compat-libstdc++-33(x86_64)"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
oel11db2 compat-libstdc++-33(x86_64)-3.2.3-72.el7 compat-libstdc++-33(x86_64)-3.2.3 passed
oel11db1 compat-libstdc++-33(x86_64)-3.2.3-72.el7 compat-libstdc++-33(x86_64)-3.2.3 passed
Result: Package existence check passed for "compat-libstdc++-33(x86_64)"
Check: Package existence for "elfutils-libelf(x86_64)"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
oel11db2 elfutils-libelf(x86_64)-0.176-5.el7 elfutils-libelf(x86_64)-0.97 passed
oel11db1 elfutils-libelf(x86_64)-0.176-5.el7 elfutils-libelf(x86_64)-0.97 passed
Result: Package existence check passed for "elfutils-libelf(x86_64)"
Check: Package existence for "elfutils-libelf-devel"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
oel11db2 elfutils-libelf-devel-0.176-5.el7 elfutils-libelf-devel-0.97 passed
oel11db1 elfutils-libelf-devel-0.176-5.el7 elfutils-libelf-devel-0.97 passed
Result: Package existence check passed for "elfutils-libelf-devel"
Check: Package existence for "glibc-common"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
oel11db2 glibc-common-2.17-260.0.9.el7 glibc-common-2.3.4 passed
oel11db1 glibc-common-2.17-260.0.9.el7 glibc-common-2.3.4 passed
Result: Package existence check passed for "glibc-common"
Check: Package existence for "glibc-devel(x86_64)"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
oel11db2 glibc-devel(x86_64)-2.17-260.0.9.el7 glibc-devel(x86_64)-2.3.4 passed
oel11db1 glibc-devel(x86_64)-2.17-260.0.9.el7 glibc-devel(x86_64)-2.3.4 passed
Result: Package existence check passed for "glibc-devel(x86_64)"
Check: Package existence for "glibc-headers"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
oel11db2 glibc-headers-2.17-260.0.9.el7 glibc-headers-2.3.4 passed
oel11db1 glibc-headers-2.17-260.0.9.el7 glibc-headers-2.3.4 passed
Result: Package existence check passed for "glibc-headers"
Check: Package existence for "gcc-c++(x86_64)"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
oel11db2 gcc-c++(x86_64)-4.8.5-36.0.1.el7 gcc-c++(x86_64)-3.4.6 passed
oel11db1 gcc-c++(x86_64)-4.8.5-36.0.1.el7 gcc-c++(x86_64)-3.4.6 passed
Result: Package existence check passed for "gcc-c++(x86_64)"
Check: Package existence for "libaio-devel(x86_64)"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
oel11db2 libaio-devel(x86_64)-0.3.109-13.el7 libaio-devel(x86_64)-0.3.105 passed
oel11db1 libaio-devel(x86_64)-0.3.109-13.el7 libaio-devel(x86_64)-0.3.105 passed
Result: Package existence check passed for "libaio-devel(x86_64)"
Check: Package existence for "libgcc(x86_64)"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
oel11db2 libgcc(x86_64)-4.8.5-36.0.1.el7 libgcc(x86_64)-3.4.6 passed
oel11db1 libgcc(x86_64)-4.8.5-36.0.1.el7 libgcc(x86_64)-3.4.6 passed
Result: Package existence check passed for "libgcc(x86_64)"
Check: Package existence for "libstdc++(x86_64)"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
oel11db2 libstdc++(x86_64)-4.8.5-36.0.1.el7 libstdc++(x86_64)-3.4.6 passed
oel11db1 libstdc++(x86_64)-4.8.5-36.0.1.el7 libstdc++(x86_64)-3.4.6 passed
Result: Package existence check passed for "libstdc++(x86_64)"
Check: Package existence for "libstdc++-devel(x86_64)"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
oel11db2 libstdc++-devel(x86_64)-4.8.5-36.0.1.el7 libstdc++-devel(x86_64)-3.4.6 passed
oel11db1 libstdc++-devel(x86_64)-4.8.5-36.0.1.el7 libstdc++-devel(x86_64)-3.4.6 passed
Result: Package existence check passed for "libstdc++-devel(x86_64)"
Check: Package existence for "sysstat"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
oel11db2 sysstat-10.1.5-17.el7 sysstat-5.0.5 passed
oel11db1 sysstat-10.1.5-17.el7 sysstat-5.0.5 passed
Result: Package existence check passed for "sysstat"
Check: Package existence for "pdksh"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
oel11db2 missing pdksh-5.2.14 failed
oel11db1 missing pdksh-5.2.14 failed
Result: Package existence check failed for "pdksh"
Check: Package existence for "expat(x86_64)"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
oel11db2 expat(x86_64)-2.1.0-10.el7_3 expat(x86_64)-1.95.7 passed
oel11db1 expat(x86_64)-2.1.0-10.el7_3 expat(x86_64)-1.95.7 passed
Result: Package existence check passed for "expat(x86_64)"
Checking for multiple users with UID value 0
Result: Check for multiple users with UID value 0 passed
Check: Current group ID
Result: Current group ID check passed
Starting check for consistency of primary group of root user
Node Name Status
------------------------------------ ------------------------
oel11db2 passed
oel11db1 passed
Check for consistency of root users primary group passed
Starting Clock synchronization checks using Network Time Protocol(NTP)...
NTP Configuration file check started...
Network Time Protocol(NTP) configuration file not found on any of the nodes. Oracle Cluster Time Synchronization Service(CTSS) can be used instead of NTP for time synchronization on the cluster nodes
No NTP Daemons or Services were found to be running
Result: Clock synchronization check using Network Time Protocol(NTP) passed
Checking Core file name pattern consistency...
Core file name pattern consistency check passed.
Checking to make sure user "oracle" is not in "root" group
Node Name Status Comment
------------ ------------------------ ------------------------
oel11db2 passed does not exist
oel11db1 passed does not exist
Result: User "oracle" is not part of "root" group. Check passed
Check default user file creation mask
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
oel11db2 0022 0022 passed
oel11db1 0022 0022 passed
Result: Default user file creation mask check passed
Checking consistency of file "/etc/resolv.conf" across nodes
Checking the file "/etc/resolv.conf" to make sure only one of domain and search entries is defined
File "/etc/resolv.conf" does not have both domain and search entries defined
Checking if domain entry in file "/etc/resolv.conf" is consistent across the nodes...
domain entry in file "/etc/resolv.conf" is consistent across nodes
Checking if search entry in file "/etc/resolv.conf" is consistent across the nodes...
search entry in file "/etc/resolv.conf" is consistent across nodes
Checking DNS response time for an unreachable node
Node Name Status
------------------------------------ ------------------------
oel11db2 passed
oel11db1 passed
The DNS response time for an unreachable node is within acceptable limit on all nodes
File "/etc/resolv.conf" is consistent across nodes
Check: Time zone consistency
Result: Time zone consistency check passed
Pre-check for cluster services setup was unsuccessful on all the nodes.
|
현재 swap이 조금 부족한걸로 나옴, swap 8gb 추가(양쪽노드 모두에서 실행)
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
# 1. 8GB 스왑 파일 생성
dd if=/dev/zero of=/swapfile8 bs=1M count=8192
# 2. 권한 설정
chmod 600 /swapfile8
# 3. 스왑으로 포맷
mkswap /swapfile8
# 4. 스왑 활성화
swapon /swapfile8
# 5. 적용 확인
swapon --show
free -h
# 6. 재부팅 후에도 유지되도록 /etc/fstab에 추가
echo '/swapfile8 swap swap defaults 0 0' >> /etc/fstab
|
swap 확인
|
1
2
3
4
|
# free -h
total used free shared buff/cache available
Mem: 7.8G 313M 67M 13M 7.4G 7.3G
Swap: 11G 0B 11G
|
이제 충분함
grid 설치
|
1
2
3
4
5
6
7
8
9
|
$ cd /app/oracle/media/grid/
$ ./runInstaller
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 120 MB. Actual 25688 MB Passed
Checking swap space: must be greater than 150 MB. Actual 12007 MB Passed
Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2025-06-06_05-02-21PM. Please wait ...[oracle@oel11db1 grid]$ You can find the log of this install session at:
/app/oraInventory/logs/installActions2025-06-06_05-02-21PM.log
|
Skip software update 선택
Install and Configure Oracle Grid Infrastructure for a Cluster 선택
Advanced Installation 선택
English 선택
scan 이름 설정 후 Next
Add 선택
2번 노드 추가
SSH Connectivity 선택
oracle 유저 패스워드 입력 후 Test
테스트 성공 후 OK
각 IP별 type 설정
ASM 선택
IMSIOCR 디스크그룹 생성(External 및 생성한 디스크 3개 선택)
패스워드 입력
Yes 선택
IPMI 사용안함 선택
그룹 선택
Yes 선택
oracle base 및 grid 엔진경로 선택
인벤토리 경로 선택
pdksh는 버그로 무시해도 되는 패키지임
Yes 선택
Install 선택
설치중..
이 화면이 나오고 바로 스크립트를 수행하면 안됨
root.sh 수행전 grid 패치를 진행해야함
*양쪽노드에 모두 수행해야함
참고 : 11gR2 Grid install – Error: ohasd failed to start the Clusterware. ( https://positivemh.tistory.com/122 )
패치파일 압축 해제 및 확인
|
1
2
3
4
|
$ cd /app/oracle/media
$ unzip p18370031_112040_Linux-x86-64.zip
$ ls 18370031/
custom etc files
|
패치 수행
*양쪽노드에 모두 수행해야함
|
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
|
$ cd $GRID_HOME/OPatch/
$ ./opatch napply -local /app/oracle/media/18370031/ -oh $GRID_HOME
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /app/grid/11g
Central Inventory : /app/oraInventory
from : /app/grid/11g/oraInst.loc
OPatch version : 11.2.0.3.4
OUI version : 11.2.0.4.0
Log file location : /app/grid/11g/cfgtoollogs/opatch/opatch2025-06-06_17-26-21PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 18370031
Do you want to proceed? [y|n]
y <<-- y 입력
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/app/grid/11g')
Is the local system ready for patching? [y|n]
y <<-- y 입력
User Responded with: Y
Backing up files...
Applying interim patch '18370031' to OH '/app/grid/11g'
Patching component oracle.crs, 11.2.0.4.0...
Verifying the update...
Patch 18370031 successfully applied.
Log file location: /app/grid/11g/cfgtoollogs/opatch/opatch2025-06-06_17-26-21PM_1.log
OPatch succeeded.
|
패치를 적용 한 뒤 스크립트를 순차적으로 실행
orainstRoot.sh
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
#1번 노드
# /app/oraInventory/orainstRoot.sh
Changing permissions of /app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.
Changing groupname of /app/oraInventory to oinstall.
The execution of the script is complete.
#2번 노드
# /app/oraInventory/orainstRoot.sh
Changing permissions of /app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.
Changing groupname of /app/oraInventory to oinstall.
The execution of the script is complete.
|
root.sh 1번 노드
|
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
|
# /app/grid/11g/root.sh
Performing root user operation for Oracle 11g
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /app/grid/11g
Enter the full pathname of the local bin directory: [/usr/local/bin]:
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...
Creating /etc/oratab file...
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.
Using configuration parameter file: /app/grid/11g/crs/install/crsconfig_params
Creating trace directory
User ignored Prerequisites during installation
Installing Trace File Analyzer
OLR initialization - successful
root wallet
root wallet cert
root cert export
peer wallet
profile reader wallet
pa wallet
peer wallet keys
pa wallet keys
peer cert request
pa cert request
peer cert
pa cert
peer root cert TP
profile reader root cert TP
pa root cert TP
peer pa cert TP
pa peer cert TP
profile reader pa cert TP
profile reader peer cert TP
peer user cert
pa user cert
Adding Clusterware entries to oracle-ohasd.service
CRS-2672: Attempting to start 'ora.mdnsd' on 'oel11db1'
CRS-2676: Start of 'ora.mdnsd' on 'oel11db1' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'oel11db1'
CRS-2676: Start of 'ora.gpnpd' on 'oel11db1' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'oel11db1'
CRS-2672: Attempting to start 'ora.gipcd' on 'oel11db1'
CRS-2676: Start of 'ora.cssdmonitor' on 'oel11db1' succeeded
CRS-2676: Start of 'ora.gipcd' on 'oel11db1' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'oel11db1'
CRS-2672: Attempting to start 'ora.diskmon' on 'oel11db1'
CRS-2676: Start of 'ora.diskmon' on 'oel11db1' succeeded
CRS-2676: Start of 'ora.cssd' on 'oel11db1' succeeded
ASM created and started successfully.
Disk Group IMSIOCR created successfully.
clscfg: -install mode specified
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-4256: Updating the profile
Successful addition of voting disk 533d9a521eff4fcbbf8d27c5661b391c.
Successfully replaced voting disk group with +IMSIOCR.
CRS-4256: Updating the profile
CRS-4266: Voting file(s) successfully replaced
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 533d9a521eff4fcbbf8d27c5661b391c (ORCL:IMSIOCR1) [IMSIOCR]
Located 1 voting disk(s).
CRS-2672: Attempting to start 'ora.asm' on 'oel11db1'
CRS-2676: Start of 'ora.asm' on 'oel11db1' succeeded
CRS-2672: Attempting to start 'ora.IMSIOCR.dg' on 'oel11db1'
CRS-2676: Start of 'ora.IMSIOCR.dg' on 'oel11db1' succeeded
Configure Oracle Grid Infrastructure for a Cluster ... succeeded
|
root.sh 2번 노드
|
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
|
# /app/grid/11g/root.sh
Performing root user operation for Oracle 11g
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /app/grid/11g
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.
Creating /etc/oratab file...
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.
Using configuration parameter file: /app/grid/11g/crs/install/crsconfig_params
Creating trace directory
User ignored Prerequisites during installation
Installing Trace File Analyzer
OLR initialization - successful
Adding Clusterware entries to oracle-ohasd.service
CRS-2672: Attempting to start 'ora.mdnsd' on 'oel11db2'
CRS-2676: Start of 'ora.mdnsd' on 'oel11db2' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'oel11db2'
CRS-2676: Start of 'ora.gpnpd' on 'oel11db2' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'oel11db2'
CRS-2672: Attempting to start 'ora.gipcd' on 'oel11db2'
CRS-2676: Start of 'ora.cssdmonitor' on 'oel11db2' succeeded
CRS-2676: Start of 'ora.gipcd' on 'oel11db2' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'oel11db2'
CRS-2672: Attempting to start 'ora.diskmon' on 'oel11db2'
CRS-2676: Start of 'ora.diskmon' on 'oel11db2' succeeded
CRS-2676: Start of 'ora.cssd' on 'oel11db2' succeeded
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.
Using configuration parameter file: /app/grid/11g/crs/install/crsconfig_params
User ignored Prerequisites during installation
Installing Trace File Analyzer
CRS-4402: The CSS daemon was started in exclusive mode but found an active CSS daemon on node oel11db1, number 1, and is terminating
An active cluster was found during exclusive startup, restarting to join the cluster
Configure Oracle Grid Infrastructure for a Cluster ... succeeded
|
(2번노드 root.sh는 문제가 있어 deconfig 등 여러 절차를 거치면서 실행해서 로그가 온전하지는 못함)
스크립트 모두 수행 후 OK 선택
이후 설치가 계속 수행됨
이 에러는 무시해도됨 OK 선택
Yes 선택
설치가 완료됨
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
|
$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.IMSIOCR.dg
ONLINE ONLINE oel11db1
ONLINE ONLINE oel11db2
ora.LISTENER.lsnr
ONLINE ONLINE oel11db1
ONLINE ONLINE oel11db2
ora.asm
ONLINE ONLINE oel11db1 Started
ONLINE ONLINE oel11db2 Started
ora.gsd
OFFLINE OFFLINE oel11db1
OFFLINE OFFLINE oel11db2
ora.net1.network
ONLINE ONLINE oel11db1
ONLINE ONLINE oel11db2
ora.ons
ONLINE ONLINE oel11db1
ONLINE ONLINE oel11db2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE oel11db1
ora.cvu
1 ONLINE ONLINE oel11db1
ora.oc4j
1 ONLINE ONLINE oel11db1
ora.oel11db1.vip
1 ONLINE ONLINE oel11db1
ora.oel11db2.vip
1 ONLINE ONLINE oel11db2
ora.scan1.vip
1 ONLINE ONLINE oel11db1
|
정상
OCR 확인
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
# ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 2596
Available space (kbytes) : 259524
ID : 1831248164
Device/File Name : +IMSIOCR
Device/File integrity check succeeded
Device/File not configured
Device/File not configured
Device/File not configured
Device/File not configured
Cluster registry integrity check succeeded
Logical corruption check succeeded
|
현재 +IMSIOCR로 되어있음
OCR 영역 raw device로 이관
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
# ocrconfig -add /dev/raw/raw1
# ocrconfig -add /dev/raw/raw2
# ocrconfig -delete +IMSIOCR
# ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 2596
Available space (kbytes) : 259524
ID : 1831248164
Device/File Name : /dev/raw/raw1
Device/File integrity check succeeded
Device/File Name : /dev/raw/raw2
Device/File integrity check succeeded
Device/File not configured
Device/File not configured
Device/File not configured
Cluster registry integrity check succeeded
Logical corruption check succeeded
|
정상적으로 변경됨
VOTE 확인
|
1
2
3
4
5
|
# crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE ab7df8db23124f20bf43cb8dc985061d (ORCL:IMSIOCR1) [IMSIOCR]
Located 1 voting disk(s).
|
현재 +IMSIOCR로 되어있음
VOTE 영역 raw device로 이관
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
# crsctl replace votedisk /dev/raw/raw3
Now formatting voting disk: /dev/raw/raw3.
CRS-4256: Updating the profile
Successful addition of voting disk 26aaeeab211a4faabf04b34ec5a27c10.
Successful deletion of voting disk ab7df8db23124f20bf43cb8dc985061d.
CRS-4256: Updating the profile
CRS-4266: Voting file(s) successfully replaced
# crsctl add css votedisk /dev/raw/raw4
Now formatting voting disk: /dev/raw/raw4.
CRS-4603: Successful addition of voting disk /dev/raw/raw4.
# crsctl add css votedisk /dev/raw/raw5
Now formatting voting disk: /dev/raw/raw5.
CRS-4603: Successful addition of voting disk /dev/raw/raw5.
# crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 26aaeeab211a4faabf04b34ec5a27c10 (/dev/raw/raw3) []
2. ONLINE a15c149a5cdb4fe2bf1c2ddd193b0bc0 (/dev/raw/raw4) []
3. ONLINE 7c499f946ecf4f1ebf01be6d7ffadb8c (/dev/raw/raw5) []
Located 3 voting disk(s).
|
정상적으로 변경됨
다음 게시글로 이동
Oracle Linux 7.6에 Oracle 11gR2 Raw Device RAC 설치 가이드_Part 3(https://positivemh.tistory.com/1227)
참조 :
https://positivemh.tistory.com/521
Oracle Linux 7.6 설치 가이드
OS환경 : Oracle Linux 7.6 (64bit) 방법 : Oracle Linux 7.6 설치 가이드오라클 리눅스 설치파일은 http://edelivery.oracle.com/ 에서 다운로드 받음Oracle Linux Release 7 Update 6 for x86 (64 bit)(V980739-01).iso 시작 전 네트워
positivemh.tistory.com
https://positivemh.tistory.com/534
/usr/bin/xauth: file /root/.Xauthority does not exist
OS환경 : Oracle Linux 7.6 (64bit) 에러 : /usr/bin/xauth: file /root/.Xauthority does not existroot 계정으로 shell 접속 시 발생하는 메세지12345678Xshell:\> Connecting to 192.168.137.50:22...Connection established.Escape character is '^@]'.
positivemh.tistory.com
'ORACLE > Install' 카테고리의 다른 글
| 오라클 23ai 23.7 골드이미지 패치 가이드 (0) | 2025.06.27 |
|---|---|
| Oracle Linux 7.6에 Oracle 11gR2 Raw Device RAC 설치 가이드_Part 3 (0) | 2025.06.06 |
| Oracle Linux 7.6에 Oracle 11gR2 Raw Device RAC 설치 가이드_Part 1 (0) | 2025.06.06 |
| Docker에 Oracle 23ai Free 설치 및 삭제 가이드 (0) | 2024.09.12 |
| Oracle Linux 8.4에 Oracle 19c Silent 모드 설치 가이드 (1) | 2024.09.06 |