Cài đặt db Oracle RAC 2 node 19C trên server VMW

1. Môi trường

1.1 Cài đặt OS

Download OracleLinux-R8-U4-x86_64-dvd.iso 

Guide setup: tại đây    

Cấu hình host file Node 1, Node 2

192.32.146.20  ck-tl-orc-dba-01    ck-tl-orc-dba-01.domainname

192.32.146.21  ck-tl-orc-dba-02    ck-tl-orc-dba-02.domainname

192.32.146.26  ck-tl-orc-dba-01-vip    ck-tl-orc-dba-01-vip.domainname

192.32.146.27  ck-tl-orc-dba-01-vip    ck-tl-orc-dba-02-vip.domainname

192.32.146.28  scan    scan.domainname

192.32.146.29  scan    scan.domainname

192.32.146.30  scan    scan.domainname

10.20.10.1   ck-tl-orc-dba-01-priv   ck-tl-orc-dba-01-priv.domainname

10.20.10.2   ck-tl-orc-dba-01-priv   ck-tl-orc-dba-02-priv.domainname 

Stop và disable firewall trên 2 nodes

systemctl stop firewalld.service

systemctl disable firewalld.service

Set dns trỏ về server dns

vi /etc/resolv.conf 

# add line below

nameserver    192.168.1.90

Run all Node

sudo dnf groupinstall "Server with GUI"

Config VNC Server: tại đây 

1.2 Cấu hình tham số hệ thống

a.Cấu hình tham số cần thiết cài đặt Oracle Grid và Database 

# yum -y install oracle-database-preinstall-19c  

b.Cài đặt và cấu hình oracleasm


As user root:

# cd /tmp

# wget https://download.oracle.com/otn_software/asmlib/oracleasmlib-2.0.17-1.el8.x86_64.rpm

# wget https://public-yum.oracle.com/repo/OracleLinux/OL8/addons/x86_64/getPackage/oracleasm-support-2.1.12-1.el8.x86_64.rpm

# yum localinstall ./oracleasm-support-2.1.12-1.el8.x86_64.rpm ./oracleasmlib-2.0.17-1.el8.x86_64.rpm 

c.Cấu hình ssh          

Create Passwordless user root:

Node 1:

Login root

Passphare để trống

ssh-keygen –t rsa

Create file authorized_keys

cat id_rsa.pub >> authorized_keys

Node 2:

Login root

Passphare để trống

ssh-keygen –t rsa

Create file authorized_keys

cat id_rsa.pub >> authorized_keys

Add ssh key Node 1 to Node 2

cat authorized_keys

Copy content in authorized_keys in Node 1 and then past content to authenrized_keys in Node 2

Add ssh key Node 2 to Node 1

cat authorized_keys

Copy content in authorized_keys in Node 2 and then past content to authenrized_keys in Node 1

Check ssh

Login Root in Node 1

ssh hostname_node2 date

Check ssh

Login Root in Node 2

ssh hostname_node1 date

d.Cấu hình ntp client

Cài và cấu hình ntp client

Đưa ntp server vào file cấu hình: /etc/chrony.conf

Server 192.168.1.100

Server 192.168.1.200

systemctl restart chronyd.service

systemctl status chronyd.service 

ntpq -p

e. Đặt crontab cho ntp

30 * * * * /usr/sbin/ntpdate -u 192.168.1.100

f. Tạo Oracle Home

Create Oracle Home trên 2 nodes  

Tạo folder cài đặt Grid

mkdir -p /u01/app/oracle/19.3.0

mkdir -p /u01/app/oracle/grid

Tạo lại đường dẫn oracle home 

  

mkdir -p /u01/app/oracle/database/19.3.0/dbhome_1

chown -R oracle:oinstall /u01/

chmod -R 775 /u01 

1.3 Cấu hình disk cho RAC

1.Yêu cầu quản trị SAN cấp 1 vùng SAN tổng sau đó map lên 2 server theo dạng device:

Lưu ý:  cả 2 server phải cùng đọc và ghi vào các device này .

sdb, sdc, sdd, sde, sdf, sdg, ... 

2. Crate partition cho các device

2.0 # fdisk /dev/sdb

2.1 Nhập vào n để tạo partition mới

2.2 Command aciton: p

2.3 Chọn loại partition là p ( primary )

2.4 Partition number : chọn 1

2.5 First cylender: chọn 1

2.6 Last cylender: để default và nhấn Enter để lấy toàn bộ dung lượng của đĩa cho partition 1

2.7 Chọn w để lưu lại

3. Lặp lại bước 2.0 đến 2.7 cho các disk còn lại

4. Update info kernel

# /sbin/partprobe

1.4 Cấu hình asmdisk

       a. Run on Node 1, Node 2:

# 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

Default group to own the driver interface []: oinstall

Start Oracle ASM library driver on boot (y/n) [n]: y

Scan for Oracle ASM disks on boot (y/n) [y]: y

 

The next two configuration options take substrings to match device names.

The substring "sd" (without the quotes), for example, matches "sda", "sdb",

etc.  You may enter more than one substring pattern, separated by spaces.

The special string "none" (again, without the quotes) will clear the value.

 

Device order to scan for ASM disks []:

Devices to exclude from scanning []:

Directories to scan []:

Use device logical block size for ASM (y/n) [n]: y

Writing Oracle ASM library driver configuration: done

 

b. Run on Node 1, Node 2:

# oracleasm init 

Loading module "oracleasm": oracleasm

Configuring "oracleasm" to use device logical block size

Mounting ASMlib driver filesystem: /dev/oracleasm

c. Run on Node 1:

# oracleasm createdisk archlog1 /dev/sdb1

Writing disk header: done

Instantiating disk: done

# oracleasm createdisk controlfile1 /dev/sdc1

Writing disk header: done

Instantiating disk: done

# oracleasm createdisk controlfile2 /dev/sdd1

Writing disk header: done

Instantiating disk: done

# oracleasm createdisk controlfile3 /dev/sde1

Writing disk header: done

Instantiating disk: done

# oracleasm createdisk data01 /dev/sdf1

Writing disk header: done

Instantiating disk: done

# oracleasm createdisk redo01 /dev/sdg1

Writing disk header: done

Instantiating disk: done

# oracleasm createdisk redo02 /dev/sdh1

Writing disk header: done

Instantiating disk: done

# oracleasm createdisk redo03 /dev/sdi1

Writing disk header: done

Instantiating disk: done

# oracleasm createdisk ocr01 /dev/sdj1

Writing disk header: done

Instantiating disk: done

# oracleasm createdisk ocr02 /dev/sdk1

Writing disk header: done

Instantiating disk: done

# oracleasm createdisk ocr03 /dev/sdl1

Writing disk header: done

Instantiating disk: done

 

 d. Run on Node 1, Node 2:

 

# oracleasm scandisks

Reloading disk partitions: done

Cleaning any stale ASM disks...

Scanning system for ASM disks...

# oracleasm listdisks

ARCHLOG1

CONTROLFILE1

CONTROLFILE2

CONTROLFILE3

DATA01

OCR01

OCR02

OCR03

REDO01

REDO02

REDO03 

 

2. Cài đặt grid 19.3.0

a. Tải soft Grid và DB tại đây

b. Cài đặt Grid

Use user oracle:

Open SNTP or Xftp or WinSCP .. connect to Node 1

Upload source grid to path: /u01/app/oracle/19.3.0

c. Connect VNC Server Node 1

Open VNC Client in MobaXterm

Connect to :192.32.146.20:1

Open terminal

export CV_ASSUME_DISTID=OEL8.4

$ cd /u01/app/oracle/19.3.0

$ unzip grid_home19300.zip

$ rm -rf  grid_home19300.zip

$ ./gridSetup.sh

 

 Next

Next

Next

SSH connectivity

Enter pass 

Setup --> OK

Next

Next

Next

Next

Create diskgroup OCR
Click Next

Next

 

Next

Next

Yes --> Next

Next

Next

Next

Next

Next

Next

Login user root

Run on Node 1, Node 2

# /u01/app/oracle/oraInventory/orainstRoot.sh

 Run on Node 1, Node 2

#  /u01/app/oracle/19.3.0/root.sh

OK

Next

Yes --> Next

Finish

3. Cài đặt database 19.3.0 

Cài đặt database software

Use user oracle:

Open SNTP or Xftp or WinSCP .. connect to Node 1

Upload source db to path: /u01/app/oracle/database/19.3.0/dbhome_1

Open VNC Client in MobaXterm

Connect to :192.32.146.20:1

Open terminal

export CV_ASSUME_DISTID=OEL8.4

$ cd /u01/app/oracle/database/19.3.0/dbhome_1

$ unzip database_home19300.zip

$ rm -rf  database_home19300.zip

$ ./runInstaller

 

Next

Next

Next

Next

Next

Yes and Next

Next

Next

Yes and Next

Next

Login user root

Run on Node 1, Node 2

#  /u01/app/oracle/database/19.3.0/dbhome_1/root.sh

OK 

Finish