Oracle Linux 8.4에 Oracle 19c RAC to RAC ADG 설치 가이드_Part 1

2022. 4. 4. 11:01 내맘대로긍정

프린트 하기

OS환경 : Oracle Linux 8.4 (64bit)

DB 환경 : Oracle Database 19.12.0.0 RAC ADG

방법 : Oracle Linux 8.4에 Oracle 19c RAC to RAC ADG 설치 가이드_Part 1

RAC 설치는 아래 게시물 참조
Oracle Linux 8.4에 Oracle 19c RAC 설치 가이드_Part 1 (https://positivemh.tistory.com/762)
Oracle Linux 8.4에 Oracle 19c RAC 설치 가이드_Part 2 (https://positivemh.tistory.com/763)
Oracle Linux 8.4에 Oracle 19c RAC 설치 가이드_Part 3 (https://positivemh.tistory.com/765)

추가 RAC ADG용 OS 설치는 아래 게시물 참조

Oracle Linux 8.4 설치 가이드(https://positivemh.tistory.com/761)

기존 RAC
1번 노드 hostname : oel19db1, db_name : ORADB, db_unique_name : ORADB, ip : 192.168.137.10
1번 노드 hostname : oel19db2, db_name : ORADB, db_unique_name : ORADB, ip : 192.168.137.20

ADG 추가 구성
1번 노드(Standby) hostname : oel19adg1, db_name : ORADB, db_unique_name : ORAADG, ip : 192.168.137.50
1번 노드(Standby) hostname : oel19adg2, db_name : ORADB, db_unique_name : ORAADG, ip : 192.168.137.60

설치파일은 아래 4가지 파일을 이용함
GRID : LINUX.X64_193000_grid_home.zip
DB : LINUX.X64_193000_db_home.zip
OPatch : p6880880_190000_Linux-x86-64.zip(12.2.0.1.27)
RU : p32900083_190000_Linux-x86-64.zip
Patch 32900083 - Combo of OJVM Component Release Update 19.12.0.0.210720 + Grid Infrastructure Jul 2021 Release Update 19.12.0.0.210720
ㄴ Patch 32895426 - Database Grid Infrastructure Jul 2021 Release Update 19.12.0.0.210720
ㄴ Patch 32876380 - Oracle JavaVM Component Release Update 19.12.0.0.210720

하드웨어 설정

Oracle Linux 8.4 설치 가이드를 보고 설치한 경우
OEL8.4 폴더에 설치했을텐데
OEL8.4+19120_ASM_ADG라는 폴더를 하나 만들어서 그안에 폴더를 통째로 이동시켜줌
OEL8.4 폴더는 oel19adg1로 폴더명을 변경시켜주고 storage 라는 폴더도 하나 생성해줌

.vmx파일을 실행하면 vmware가 실행됨

Edit virtual machine settings 선택

Add 선택

Hard Disk 선택

SCSI, Indenpendent 선택

Create a new virtual disk 선택

30gb 지정 후, Allocate all disk space now 선택후, single file 선택

위에서 만들어 둔 storage 폴더에 disk30.vmdk로 생성해줌

30gb 가 추가됨, Advanced 선택

SCSI 1:1 선택

기존 NAT 선택 후 Advanced 선택

Generate 선택해서 MAC Address 변경

Add

Network Adapter 선택

Host-only로 선택

변경된 최종 모습

Options 에서 virtual machine name도 변경해줌, oel19adg1

vmware 프로그램 종료 후 E:\vm\OEL8.4+19120_ASM_ADG\oel19adg1\Oracle Enterprise Linux 8.4.vmx 메모장으로 열기
제일 밑에 아래 내용 추가 후 저장

1
2
3
4

disk.locking = "FALSE"
diskLib.dataCacheMaxSize = "0"
scsi1.sharedBus = "virtual"
scsi1:0.deviceType = "disk"

os 기동

기동 시 아래 메세지 발생 시 I copied it 선택

OS 설정

oel19db1 기동 후

/etc/hostname 확인

1
2

# cat /etc/hostname
oel19adg1

기존에 다른 hostname이라면 hostname 변경 후 재기동

1
2

# hostnamectl set-hostname oel19adg1
# reboot

Network 설정

1
2
3
4
5
6
7
8
9
10

Public network(ens32)
IP/Netmask/GW
192.168.137.50/255.255.255.0/192.168.137.2 --노드1
192.168.137.60/255.255.255.0/192.168.137.2 --노드2
DNS 168.126.63.1
 
Private network
IP/Netmask/GW(ens35)
10.10.10.50/255.255.255.0 --노드1
10.10.10.60/255.255.255.0 --노드2

Network 설정(GUI)

OS 기동 후 root 유저 접속 후 우측 상단 전원버튼 선택 후 설정 버튼 선택

ens32의 설정버튼 선택

IPv4로 이동

Address를 192.168.137.50으로 변경 후 Apply

ens35의 + 버튼 선택

Name 을 ens35를 하고 MAC Address 를 ens35 를 선택해줌, IPv4로 이동

Address를 10.10.10.50으로 변경 후 Apply

네트워크 OFF

네트워크 ON 후 설정 확인

네트워크 설정 후 확인

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

# ifconfig
ens32: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500
        inet 192.168.137.50  netmask 255.255.255.0  broadcast 192.168.137.255
        inet6 fe80::250:56ff:fe2d:ef21  prefixlen 64  scopeid 0x20<link>
        ether 00:50:56:2d:ef:21  txqueuelen 1000  (Ethernet)
        RX packets 90  bytes 17732 (17.3 KiB)
        RX errors 0  dropped 0  overruns 0  frame 0
        TX packets 120  bytes 15845 (15.4 KiB)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0
 
ens35: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500
        inet 10.10.10.50  netmask 255.255.255.0  broadcast 10.10.10.255
        inet6 fe80::97d:c25e:fcee:fdda  prefixlen 64  scopeid 0x20<link>
        ether 00:0c:29:2a:42:51  txqueuelen 1000  (Ethernet)
        RX packets 1  bytes 243 (243.0 B)
        RX errors 0  dropped 0  overruns 0  frame 0
        TX packets 39  bytes 4478 (4.3 KiB)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0
 
lo: flags=73<UP,LOOPBACK,RUNNING>  mtu 65536
        inet 127.0.0.1  netmask 255.0.0.0
        inet6 ::1  prefixlen 128  scopeid 0x10<host>
        loop  txqueuelen 1000  (Local Loopback)
        RX packets 122  bytes 11900 (11.6 KiB)
        RX errors 0  dropped 0  overruns 0  frame 0
        TX packets 122  bytes 11900 (11.6 KiB)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0
 
virbr0: flags=4099<UP,BROADCAST,MULTICAST>  mtu 1500
        inet 192.168.122.1  netmask 255.255.255.0  broadcast 192.168.122.255
        ether 52:54:00:16:29:15  txqueuelen 1000  (Ethernet)
        RX packets 0  bytes 0 (0.0 B)
        RX errors 0  dropped 0  overruns 0  frame 0
        TX packets 0  bytes 0 (0.0 B)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0

정상적으로 변경됨

/etc/hosts 설정, 아래 내용 추가 후 저장

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

# vi /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
##Public
192.168.137.50 oel19adg1
192.168.137.60 oel19adg2
 
##Private
10.10.10.50 oel19adg1-priv
10.10.10.60 oel19adg2-priv
 
##Virtual 
192.168.137.51 oel19adg1-vip
192.168.137.61 oel19adg2-vip
 
##SCAN
192.168.137.71 oel19adg-scan

오라클 설치 전 사전 설정

자동 설정

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

# yum install -y oracle-database-preinstall-19c
Oracle Linux 8 BaseOS Latest (x86_64)                                                                                        8.4 MB/s |  43 MB     00:05    
Oracle Linux 8 Application Stream (x86_64)                                                                                   5.5 MB/s |  32 MB     00:05    
Latest Unbreakable Enterprise Kernel Release 6 for Oracle Linux 8 (x86_64)                                                   8.9 MB/s |  41 MB     00:04    
Last metadata expiration check: 0:00:06 ago on Tue 05 Apr 2022 02:29:30 AM KST.
Dependencies resolved.
=============================================================================================================================================================
 Package                                       Architecture          Version                                          Repository                        Size
=============================================================================================================================================================
Installing:
 oracle-database-preinstall-19c                x86_64                1.0-2.el8                                        ol8_appstream                     31 k
Installing dependencies:
 ksh                                           x86_64                20120801-254.0.1.el8                             ol8_appstream                    927 k
 libaio-devel                                  x86_64                0.3.112-1.el8                                    ol8_baseos_latest                 19 k
 libnsl                                        x86_64                2.28-151.0.1.el8                                 ol8_baseos_latest                102 k
 lm_sensors-libs                               x86_64                3.4.0-23.20180522git70f7e08.el8                  ol8_baseos_latest                 59 k
 sysstat                                       x86_64                11.7.3-6.0.1.el8                                 ol8_appstream                    425 k
 
Transaction Summary
=============================================================================================================================================================
Install  6 Packages
 
Total download size: 1.5 M
Installed size: 5.0 M
Downloading Packages:
(1/6): libaio-devel-0.3.112-1.el8.x86_64.rpm                                                                                  25 kB/s |  19 kB     00:00    
(2/6): lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64.rpm                                                             55 kB/s |  59 kB     00:01    
(3/6): oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm                                                                   119 kB/s |  31 kB     00:00    
(4/6): ksh-20120801-254.0.1.el8.x86_64.rpm                                                                                   810 kB/s | 927 kB     00:01    
(5/6): sysstat-11.7.3-6.0.1.el8.x86_64.rpm                                                                                   543 kB/s | 425 kB     00:00    
(6/6): libnsl-2.28-151.0.1.el8.x86_64.rpm                                                                                     31 kB/s | 102 kB     00:03    
-------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                        469 kB/s | 1.5 MB     00:03     
warning: /var/cache/dnf/ol8_baseos_latest-e4c6155830ad002c/packages/libaio-devel-0.3.112-1.el8.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ad986da3: NOKEY
Oracle Linux 8 BaseOS Latest (x86_64)                                                                                        3.0 MB/s | 3.1 kB     00:00    
Importing GPG key 0xAD986DA3:
 Userid     : "Oracle OSS group (Open Source Software group) <build@oss.oracle.com>"
 Fingerprint: 76FD 3DB1 3AB6 7410 B89D B10E 8256 2EA9 AD98 6DA3
 From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
Key imported successfully
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                                                                                                     1/1 
  Installing       : ksh-20120801-254.0.1.el8.x86_64                                                                                                     1/6 
  Running scriptlet: ksh-20120801-254.0.1.el8.x86_64                                                                                                     1/6 
  Installing       : lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64                                                                              2/6 
  Running scriptlet: lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64                                                                              2/6 
/sbin/ldconfig: /etc/ld.so.conf.d/kernel-5.4.17-2102.201.3.el8uek.x86_64.conf:6: hwcap directive ignored
 
  Installing       : sysstat-11.7.3-6.0.1.el8.x86_64                                                                                                     3/6 
  Running scriptlet: sysstat-11.7.3-6.0.1.el8.x86_64                                                                                                     3/6 
  Installing       : libnsl-2.28-151.0.1.el8.x86_64                                                                                                      4/6 
  Installing       : libaio-devel-0.3.112-1.el8.x86_64                                                                                                   5/6 
  Running scriptlet: oracle-database-preinstall-19c-1.0-2.el8.x86_64                                                                                     6/6 
  Installing       : oracle-database-preinstall-19c-1.0-2.el8.x86_64                                                                                     6/6 
  Running scriptlet: oracle-database-preinstall-19c-1.0-2.el8.x86_64                                                                                     6/6 
/sbin/ldconfig: /etc/ld.so.conf.d/kernel-5.4.17-2102.201.3.el8uek.x86_64.conf:6: hwcap directive ignored
 
  Verifying        : libaio-devel-0.3.112-1.el8.x86_64                                                                                                   1/6 
  Verifying        : libnsl-2.28-151.0.1.el8.x86_64                                                                                                      2/6 
  Verifying        : lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64                                                                              3/6 
  Verifying        : ksh-20120801-254.0.1.el8.x86_64                                                                                                     4/6 
  Verifying        : oracle-database-preinstall-19c-1.0-2.el8.x86_64                                                                                     5/6 
  Verifying        : sysstat-11.7.3-6.0.1.el8.x86_64                                                                                                     6/6 
 
Installed:
  ksh-20120801-254.0.1.el8.x86_64                               libaio-devel-0.3.112-1.el8.x86_64                      libnsl-2.28-151.0.1.el8.x86_64        
  lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64        oracle-database-preinstall-19c-1.0-2.el8.x86_64        sysstat-11.7.3-6.0.1.el8.x86_64       
 
Complete!

자동 설정 후 수동설정 파일 확인
/etc/sysctl.conf에 아래 내용 삽입되었는지 확인(안되어있다면 수동삽입)

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

# vi /etc/sysctl.conf
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824 (또는 물리메모리 크기의 절반(byte))
kernel.shmmax = 4398046511104 (또는 물리메모리 크기의 절반(byte))
kernel.panic_on_oops = 1
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.conf.all.rp_filter = 2
net.ipv4.conf.default.rp_filter = 2
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500

위 값은 최소값으로 나의경우 물리메로리를 4GB로 할당했기 때문에 shmall, shmmax를 2147483648(byte) 로 할당함

잘 입력되었는지 확인

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

# /sbin/sysctl -p
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 2147483648
kernel.shmmax = 2147483648
kernel.panic_on_oops = 1
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.conf.all.rp_filter = 2
net.ipv4.conf.default.rp_filter = 2
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500

Shell Limits 설정(안되어있다면 수동삽입)

1
2
3
4
5
6
7
8
9

# vi /etc/security/limits.d/oracle-database-preinstall-19c.conf
oracle   soft   nofile    1024
oracle   hard   nofile    65536
oracle   soft   nproc    16384
oracle   hard   nproc    16384
oracle   soft   stack    10240
oracle   hard   stack    32768
oracle   hard   memlock    3865470566(HugePage 사용시 물리메모리의 90% 이상)
oracle   soft   memlock    3865470566(HugePage 사용시 물리메모리의 90% 이상)

memlock soft, hard의 경우 HugePage 사용시 물리메모리의 90% 이상을 할당해야함(나의경우 4GB이기 때문에 4GB의 90%인 3865470566(byte) 로 할당함)

유저 및 그룹 생성(안되어있다면 수동생성)

1
2

# groupadd dba
# useradd -g dba -G dba oracle

유저 및 그룹 수정(yum preinstall 이용 자동 생성시)

1

# usermod -g dba -G dba oracle

패스워드 설정

1

# passwd oracle

selinux disable 설정

1
2

# vi /etc/selinux/config
SELINUX=disabled

불필요한 서비스 정지(ntp 설정을 했다면 chronyd 는 stop,disable,mv 하지 않아도됨)

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22

#
systemctl stop firewalld
systemctl disable firewalld
 
systemctl stop bluetooth
systemctl disable bluetooth
 
systemctl stop chronyd
systemctl disable chronyd
mv /etc/chrony.conf /etc/chrony.conf.bak
 
systemctl stop ntpdate
systemctl disable ntpdate
 
systemctl stop avahi-daemon.socket
systemctl disable avahi-daemon.socket
 
systemctl stop avahi-daemon
systemctl disable avahi-daemon
 
systemctl stop libvirtd
systemctl disable libvirtd

rpm 설치
https://www.oracle.com/linux/downloads/linux-asmlib-v8-downloads.html
에서 oracleasmlib-2.0.17-1.el8.x86_64.rpm 다운로드
https://yum.oracle.com/repo/OracleLinux/OL8/addons/x86_64/index.html
에서 oracleasm-support-2.1.12-1.el8.rpm 다운로드 후 서버에 업로드

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

# rpm -ivh oracleasmlib-2.0.17-1.el8.x86_64.rpm 
Verifying...                          ################################# [100%]
Preparing...                          ################################# [100%]
Updating / installing...
   1:oracleasmlib-2.0.17-1.el8        ################################# [100%]
/sbin/ldconfig: /etc/ld.so.conf.d/kernel-5.4.17-2102.201.3.el8uek.x86_64.conf:6: hwcap directive ignored
 
# rpm -ivh oracleasm-support-2.1.12-1.el8.x86_64.rpm 
Verifying...                          ################################# [100%]
Preparing...                          ################################# [100%]
Updating / installing...
   1:oracleasm-support-2.1.12-1.el8   ################################# [100%]
Note: Forwarding request to 'systemctl enable oracleasm.service'.
Synchronizing state of oracleasm.service with SysV service script with /usr/lib/systemd/systemd-sysv-install.
Executing: /usr/lib/systemd/systemd-sysv-install enable oracleasm
Created symlink /etc/systemd/system/multi-user.target.wants/oracleasm.service ?? /usr/lib/systemd/system/oracleasm.service.
/sbin/ldconfig: /etc/ld.so.conf.d/kernel-5.4.17-2102.201.3.el8uek.x86_64.conf:6: hwcap directive ignored

oracleasm-support 설치시 hwcap directive ignored 메세지가 나오는데 이 메세지는 무시해도 되는 메세지라고함

Temp 파일시스템 할당

1
2

# vi /etc/fstab
tmpfs                   /dev/shm                 tmpfs   size=7g         0 0

/dev/shm 영역 remount

1

# mount -o remount /dev/shm

추가 후 확인

1
2
3

# df -h /dev/shm
Filesystem      Size  Used Avail Use% Mounted on
tmpfs           7.0G     0  7.0G   0% /dev/shm

추가한 디스크 확인(/dev/sda 30GB)

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

# fdisk -l
Disk /dev/sda: 30 GiB, 32212254720 bytes, 62914560 sectors
Units: sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
 
 
Disk /dev/sdb: 60 GiB, 64424509440 bytes, 125829120 sectors
Units: sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disklabel type: dos
Disk identifier: 0xcf1ef965
 
Device     Boot   Start       End   Sectors  Size Id Type
/dev/sdb1  *       2048   1026047   1024000  500M 83 Linux
/dev/sdb2       1026048 125829119 124803072 59.5G 8e Linux LVM

디스크 포맷(n --> p --> 1 --> Enter --> Enter --> w)

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

# fdisk /dev/sda
 
Welcome to fdisk (util-linux 2.32.1).
Changes will remain in memory only, until you decide to write them.
Be careful before using the write command.
 
Device does not contain a recognized partition table.
Created a new DOS disklabel with disk identifier 0xa8a6e305.
 
Command (m for help): n <-- n 입력
Partition type
   p   primary (0 primary, 0 extended, 4 free)
   e   extended (container for logical partitions)
Select (default p): p <-- p 입력
Partition number (1-4, default 1): 1 <-- 1 입력
First sector (2048-62914559, default 2048):   <-- 엔터 입력
Last sector, +sectors or +size{K,M,G,T,P} (2048-62914559, default 62914559):   <-- 엔터 입력
 
Created a new partition 1 of type 'Linux' and of size 30 GiB.
 
Command (m for help): w <-- w 입력
The partition table has been altered.
Calling ioctl() to re-read partition table.
Syncing disks.

확인

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22

# fdisk -l
Disk /dev/sda: 30 GiB, 32212254720 bytes, 62914560 sectors
Units: sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disklabel type: dos
Disk identifier: 0xa8a6e305
 
Device     Boot Start      End  Sectors Size Id Type
/dev/sda1        2048 62914559 62912512  30G 83 Linux
 
 
Disk /dev/sdb: 60 GiB, 64424509440 bytes, 125829120 sectors
Units: sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disklabel type: dos
Disk identifier: 0xcf1ef965
 
Device     Boot   Start       End   Sectors  Size Id Type
/dev/sdb1  *       2048   1026047   1024000  500M 83 Linux
/dev/sdb2       1026048 125829119 124803072 59.5G 8e Linux LVM

Pv Lv 생성

1
2
3
4
5
6
7

#
pvcreate /dev/sda1
vgcreate 19c /dev/sda1
lvcreate -L 2g -n OCR_VOTE1 19c
lvcreate -L 2g -n OCR_VOTE2 19c
lvcreate -L 2g -n OCR_VOTE3 19c
lvcreate -L 20G -n DATA 19c

Oracle ASM 설정 및 시작(oracle, dba, y, y 순서대로 입력)

1
2
3
4
5
6
7
8
9
10
11
12
13
14

# oracleasm configure -i
Configuring the Oracle ASM library driver.
 
This will configure the on-boot properties of the Oracle ASM library
driver.  The following questions will determine whether the driver is
loaded on boot and what permissions it will have.  The current values
will be shown in brackets ('[]').  Hitting <ENTER> without typing an
answer will keep that current value.  Ctrl-C will abort.
 
Default user to own the driver interface []: oracle <-- oracle 입력
Default group to own the driver interface []: dba  <-- dba 입력
Start Oracle ASM library driver on boot (y/n) [n]: y <-- y 입력
Scan for Oracle ASM disks on boot (y/n) [y]: y <-- y 입력
Writing Oracle ASM library driver configuration: done

아래 명령시 /dev/oracleasm 디렉토리가 만들어지고, oracleasm/disks에 라벨링된 디스크가 저장됨

1
2
3
4
5

# oracleasm init
Creating /dev/oracleasm mount point: /dev/oracleasm
Loading module "oracleasm": oracleasm
Configuring "oracleasm" to use device physical block size
Mounting ASMlib driver filesystem: /dev/oracleasm

상태 확인

1
2
3
4
5
6
7
8
9
10
11
12
13

# oracleasm status
Checking if ASM is loaded: yes
Checking if /dev/oracleasm is mounted: yes
 
# oracleasm configure
ORACLEASM_ENABLED=true
ORACLEASM_UID=oracle
ORACLEASM_GID=dba
ORACLEASM_SCANBOOT=true
ORACLEASM_SCANORDER=""
ORACLEASM_SCANEXCLUDE=""
ORACLEASM_SCAN_DIRECTORIES=""
ORACLEASM_USE_LOGICAL_BLOCK_SIZE="false"

공유 디스크 생성

1
2
3
4
5

#
oracleasm createdisk OCR_VOTE1 /dev/19c/OCR_VOTE1
oracleasm createdisk OCR_VOTE2 /dev/19c/OCR_VOTE2
oracleasm createdisk OCR_VOTE3 /dev/19c/OCR_VOTE3
oracleasm createdisk DATA01 /dev/19c/DATA

디스크 스캔

1
2
3
4
5

# oracleasm scandisks
Reloading disk partitions: 
done
Cleaning any stale ASM disks...
Scanning system for ASM disks...

생성 리스트 확인(4개가 나와야 정상)

1
2
3
4
5

# oracleasm listdisks
DATA01
OCR_VOTE1
OCR_VOTE2
OCR_VOTE3

디렉토리 생성 및 권한부여

1
2
3
4
5
6
7
8
9

#
mkdir -p /oracle/media
mkdir -p /oracle/app/oracle/product/19c
mkdir -p /oracle/app/grid/19c
mkdir -p /oracle/oraInventory
chown -R oracle:dba /oracle
chmod -R 775 /oracle
chown -R oracle:dba /dev/oracleasm
chown -R oracle:dba /dev/19c

/oracle/media 경로에 설치파일 업로드

1
2
3
4
5
6
7
8
9

# chown -R oracle:dba /oracle/media/
# ls -al /oracle/media/
total 8598844
drwxrwxr-x. 2 oracle dba        161 Oct 15 10:26 .
drwxrwxr-x. 5 oracle dba         50 Oct 15 10:24 ..
-rw-r--r--. 1 oracle dba 3059705302 Oct 15 10:26 LINUX.X64_193000_db_home.zip
-rw-r--r--. 1 oracle dba 2889184573 Oct 15 10:26 LINUX.X64_193000_grid_home.zip
-rw-r--r--. 1 oracle dba 2734496202 Oct 15 10:26 p32900083_190000_Linux-x86-64.zip
-rw-r--r--. 1 oracle dba  120761121 Oct 15 10:26 p6880880_190000_Linux-x86-64.zip

오라클 계정 설정 .bash_profile에 아래 내용 추가 후 저장

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

# su - oracle
$ vi .bash_profile 
export ORACLE_BASE=/oracle/app/oracle;
export ORACLE_HOME=$ORACLE_BASE/product/19c;
export ORACLE_SID=ORAADG1;
export GRID_HOME=/oracle/app/grid/19c;
export GRID_SID=+ASM1;
export PATH=$ORACLE_HOME/bin:$GRID_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib;
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;
export DISPLAY=192.168.137.1:0.0;
 
alias grid='export ORACLE_HOME=$GRID_HOME; export ORACLE_SID=$GRID_SID; export PATH=$ORACLE_HOME/bin:$GRID_HOME/bin:$PATH; echo $ORACLE_SID; echo $ORACLE_HOME'
alias db='. ~oracle/.bash_profile;export PATH=$ORACLE_HOME/bin:$GRID_HOME/bin:$PATH; echo $ORACLE_SID;echo $ORACLE_HOME'
alias oh='cd $ORACLE_HOME;pwd'
alias ss='sqlplus / as sysdba'

추가 후 적용

1

$ . ./.bash_profile

※ 여기까지 ADG 1번 노드 세팅 완료

2번 노드 생성(복사)

1번노드 종료 후 노드1 폴더 자체를 복사

복사한 oel19adg1(노드1) -복사본을 oel19adg2(노드2)로 변경

oel19adg2 폴더로 들어간 뒤 vmx 파일 실행

oel19adg2의 vmx파일을 열어서 나온 vm에 Edit virtual machine settings 선택

Network Adapter NAT 선택 후 Advanced 선택

Generate 선택(MAC Address가 변경됨) 후 OK

Network Adapter2 Host-only 선택 후 Advanced 선택

Generate 선택(MAC Address가 변경됨) 후 OK

Options 에서 Virtual machine name을 oel19adg1에서 oel19adg2로 변경

2번노드 oel19db2 OS 기동 후 I copied it 선택

기동 후 root 로 로그인

우측 상단에 있는 설정 실행

ens35에 + 선택

ens35 입력 후 MAC Address 선택

IPv4 선택 후 IP 입력

확인

터미널 실행

2번 노드 아이피 변경, 아이피 제일 뒤 50을 60으로 변경

1
2
3
4
5
6
7

ens32
# vi /etc/sysconfig/network-scripts/ifcfg-ens32
192.138.137.50 -> 192.138.137.60
 
ens35
# vi /etc/sysconfig/network-scripts/ifcfg-ens35
10.10.10.50 -> 10.10.10.60

네트워크 재시작 및 확인

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

# nmcli con down ens32
# nmcli con down ens35
# nmcli con up ens32
# nmcli con up ens35
# systemctl restart NetworkManager.service
# ifconfig
ens32: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500
        inet 192.168.137.60  netmask 255.255.255.0  broadcast 192.168.137.255
        inet6 fe80::250:56ff:fe23:f32  prefixlen 64  scopeid 0x20<link>
        ether 00:50:56:23:0f:32  txqueuelen 1000  (Ethernet)
        RX packets 181  bytes 58210 (56.8 KiB)
        RX errors 0  dropped 0  overruns 0  frame 0
        TX packets 234  bytes 25878 (25.2 KiB)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0
 
ens35: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500
        inet 10.10.10.60  netmask 255.255.255.0  broadcast 10.10.10.255
        inet6 fe80::a9f9:318f:c95f:3cfe  prefixlen 64  scopeid 0x20<link>
        ether 00:50:56:33:a1:5e  txqueuelen 1000  (Ethernet)
        RX packets 9  bytes 1281 (1.2 KiB)
        RX errors 0  dropped 0  overruns 0  frame 0
        TX packets 81  bytes 6382 (6.2 KiB)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0
 
lo: flags=73<UP,LOOPBACK,RUNNING>  mtu 65536
        inet 127.0.0.1  netmask 255.0.0.0
        inet6 ::1  prefixlen 128  scopeid 0x10<host>
        loop  txqueuelen 1000  (Local Loopback)
        RX packets 438  bytes 38660 (37.7 KiB)
        RX errors 0  dropped 0  overruns 0  frame 0
        TX packets 438  bytes 38660 (37.7 KiB)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0

hostnamectl 명령으로 hostname 변경 oel19adg1-> oel19adg2 후 재기동

1
2

# hostnamectl set-hostname oel19adg2
# reboot

1번노드, 2번노드 모두 OS 기동 후 ping TEST

1
2
3
4
5
6
7

1번 노드(2번노드의 ip로 ping 시도)
# ping oel19adg2
# ping oel19adg2-priv
 
2번 노드(1번노드의 ip로 ping 시도)
# ping oel19adg1
# ping oel19adg1-priv

2번노드 오라클 계정 설정(아래 2가지만 1에서 2로 변경)

1
2
3
4

# su - oracle
$ vi .bash_profile
export ORACLE_SID=ORAADG2;
export GRID_SID=+ASM2;

적용

1

$ . ./.bash_profile 

다음 게시글로 이동

다음 게시글에서는 grid 환경구성을 진행함

Oracle Linux 8.4에 Oracle 19c RAC to RAC ADG 설치 가이드_Part 2(https://positivemh.tistory.com/825)

참조 :

저작자표시

'ORACLE > Install' 카테고리의 다른 글

Oracle Linux 8.4에 Oracle 19c RAC to RAC ADG 설치 가이드_Part 3 (3)	2022.04.06
Oracle Linux 8.4에 Oracle 19c RAC to RAC ADG 설치 가이드_Part 2 (0)	2022.04.05
Oracle Linux 8.4에 Oracle 19c ADG 설치 가이드_Part 3 (0)	2022.03.30
Oracle Linux 8.4에 Oracle 19c ADG 설치 가이드_Part 2 (1)	2022.03.28
Oracle Linux 8.4에 Oracle 19c ADG 설치 가이드_Part 1 (0)	2022.03.28

내맘대로긍정

OracleDBA@kakao.com

Category

Menu

Comment

Link