[TOCM]

# 您需要知道的
- 您需要熟悉如何去搭建 Linux 作業系統，可參考 OS-INS 類相關文件完成此操作
- 您需要熟悉如何在 Linux 作業系統上安裝 Oracle 資料庫，可參考 ORACLE-INS-FS 類相關文件完成此操作
- 您需要熟悉如何在 Linux 作業系統上安裝單例項 ASM 環境，可參考 ORACLE-INS-ASM 相關文件完成此操作
- 本文不適合零基礎，如果可以，請按照上述三條進行逐步學習
- 本文采用 VMWare Workstation 15.5 虛擬機器/Oracle 19c/Oracle Linux 7.8 環境進行叢集雙節點搭建
- 如果學習 RAC，配置共享磁碟強烈建議使用 VirtualBox 虛擬機器
- 文中出現的系統規劃、網路規劃及儲存規劃作為實驗學習使用，生產環境需根據實際情況進行規劃

# 1 規劃
## 1.1 系統規劃

|磁碟名稱|磁碟大小|作用|
|:-:|:-:|:-:|
|/dev/sda|50G|OS 作業系統|
|/dev/sdb|20G|臨時軟體|
|/dev/sdc|50G|Oracle 軟體|

# 2 作業系統安裝（略）
參考 `OS-INS` 類相關文件完成此操作

# 3 系統環境及引數設定
## 3.1 YUM倉庫配置（雙節點）
```sql
 mv /etc/yum.repos.d/* /tmp/
 echo "[local_yum]" >> /etc/yum.repos.d/henry.repo
 echo "name = henry_repo" >> /etc/yum.repos.d/henry.repo
 echo "baseurl = file:///mnt/" >> /etc/yum.repos.d/henry.repo
 echo "enabled = 1" >> /etc/yum.repos.d/henry.repo
 echo "gpgcheck = 0" >> /etc/yum.repos.d/henry.repo
 mount /dev/cdrom /mnt/

yum -y install autoconf
 yum -y install automake
 yum -y install binutils
 yum -y install binutils-devel
 yum -y install bison
 yum -y install cpp
 yum -y install dos2unix
 yum -y install ftp
 yum -y install gcc
 yum -y install gcc-c++
 yum -y install lrzsz
 yum -y install python-devel
 yum -y install compat-libcap1
 yum -y install compat-libstdc++-33
 yum -y install compat-libstdc++-33.i686
 yum -y install glibc-*
 yum -y install glibc-*.i686
 yum -y install libXpm-*.i686
 yum -y install libXext
 yum -y install libXext.i686
 yum -y install libXtst
 yum -y install libXtst.i686
 yum -y install libX11
 yum -y install libX11.i686
 yum -y install libXau
 yum -y install libXau.i686
 yum -y install libxcb
 yum -y install libxcb.i686
 yum -y install libXi
 yum -y install libXi.i686
 yum -y install libstdc++.i686
 yum -y install libstdc++-devel
 yum -y install libstdc++-devel.i686
 yum -y install libaio
 yum -y install libaio.i686
 yum -y install libaio-devel
 yum -y install libaio-devel.i686
 yum -y install ksh
 yum -y install libXp
 yum -y install libaio-devel
 yum -y install numactl
 yum -y install numactl-devel
 yum -y install make -y
 yum -y install sysstat -y
 yum -y install unixODBC
 yum -y install unixODBC-devel
 yum -y install elfutils-libelf-devel
 yum -y install redhat-lsb-core
 yum -y install unzip
 yum -y install libXrender
 yum -y install libXrender-devel
 yum -y install nfs-utils
 yum -y install smartmontools
 yum -y install tigervnc*
 yum install -y libvirt*
```
## 3.2 編輯HOSTS檔案（雙節點）
```sql
vim /etc/hosts

# 新增內容

#scanip 
192.168.31.100 racscan

#node1
192.168.31.101 racnode1
192.168.31.102 node1vip
192.168.111.128 node1pri

#node2
192.168.31.201 racnode2
192.168.31.202 node2vip
192.168.111.129 node2pri
```
## 3.3 建立使用者和組（雙節點）
```sql
/usr/sbin/groupadd -g 5001 oinstall
/usr/sbin/groupadd -g 5002 dba
/usr/sbin/groupadd -g 5003 oper
/usr/sbin/groupadd -g 5004 asmadmin
/usr/sbin/groupadd -g 5005 asmoper
/usr/sbin/groupadd -g 5006 asmdba
/usr/sbin/useradd -g oinstall -G dba,asmdba,oper -d /home/oracle -m oracle
/usr/sbin/useradd -g oinstall -G asmadmin,asmdba,asmoper,oper,dba -d /home/grid -m grid

# 修改使用者 oracle 及 grid 密碼

passwd oracle
passwd grid
```
## 3.4 建立資料夾及授權（雙節點）
```sql
mkdir -p /u01/app/grid
mkdir -p /u01/app/19.3.0/grid
mkdir -p /u01/app/oracle/product/19.3.0/dbhome_1
mkdir -p /u01/app/oraInventory
chown -R grid:oinstall /u01/app/grid
chown -R grid:oinstall /u01/app/19.3.0
chown -R oracle:oinstall /u01/app/oracle
chown -R grid:oinstall /u01/app/oraInventory
chmod -R 775 /u01
```
## 3.5 使用者資源限制配置（雙節點）
```sql
vim /etc/security/limits.conf

# 新增內容

oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240
oracle hard stack 32768
grid soft nproc 2047
grid hard nproc 16384
grid soft nofile 1024
grid hard nofile 65536
grid soft stack 10240
grid hard stack 32768
* soft memlock unlimited
* hard memlock unlimited
root soft stack 10240
root hard stack 32768
```
## 3.6 將資源限制加入驗證模組（雙節點）
```sql
echo "session required pam_limits.so" >> /etc/pam.d/login
```
## 3.7 修改核心引數（雙節點）
```sql
vim /etc/sysctl.conf

# 編輯檔案新增以下內容
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
kernel.panic_on_oops = 1
kernel.shmmax = 7730941132
kernel.shmall = 1887436
kernel.shmmni = 4096

# 執行命令重新整理生效
sysctl -p
```
## 3.8 關閉交換頁面（雙節點）
```sql
vim /etc/rc.d/rc.local

# 新增內容

if test -f /sys/kernel/mm/transparent_hugepage/enabled; then
echo never > /sys/kernel/mm/transparent_hugepage/enabled
fi
if test -f /sys/kernel/mm/transparent_hugepage/defrag; then
echo never > /sys/kernel/mm/transparent_hugepage/defrag
fi
```
## 3.9 關閉防火牆（雙節點）
```sql
systemctl stop firewalld.service
systemctl disable firewalld.service
```
## 3.10 關閉SELinux（雙節點）
```sql
vim /etc/sysconfig/selinux

# 修改內容

SELINUX=disabled
```
## 3.11 關閉其他不需要的服務（雙節點-可選）
```sql
systemctl stop avahi-dnsconfd
systemctl stop avahi-daemon
systemctl stop cups
systemctl stop postfix
systemctl stop smartd
systemctl disable avahi-dnsconfd
systemctl disable avahi-daemon
systemctl disable cups
systemctl disable postfix
systemctl disable smartd
```
# 4 編輯使用者環境變數
## 4.1 GRID使用者環境變數
### 4.1.1 節點1
```sql
su - grid
vim .bash_profile

# 新增內容

PS1="[`whoami`@`hostname`:"'$PWD]$'
export PS1
umask 022
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_HOSTNAME=racnode1
ORACLE_SID=+ASM1; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
ORACLE_BASE=/u01/app/grid; export ORACLE_BASE
ORACLE_HOME=/u01/app/19.3.0/grid; export ORACLE_HOME
NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"; export NLS_DATE_FORMAT
PATH=.:$PATH:$HOME/bin:$ORACLE_HOME/bin; export PATH
THREADS_FLAG=native; export THREADS_FLAG
if [ $USER = "oracle" ] || [ $USER = "grid" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi
```

### 4.1.2 節點2
```sql
su - grid
vim .bash_profile

# 新增內容

PS1="[`whoami`@`hostname`:"'$PWD]$'
export PS1
umask 022
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_HOSTNAME=racnode2
ORACLE_SID=+ASM2; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
ORACLE_BASE=/u01/app/grid; export ORACLE_BASE
ORACLE_HOME=/u01/app/19.3.0/grid; export ORACLE_HOME
NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"; export NLS_DATE_FORMAT
PATH=.:$PATH:$HOME/bin:$ORACLE_HOME/bin; export PATH
THREADS_FLAG=native; export THREADS_FLAG
if [ $USER = "oracle" ] || [ $USER = "grid" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi
```

## 4.2 ORACLE使用者環境變數
### 4.2.1 節點1

```sql
su - oracle
vim .bash_profile

# 新增內容

PS1="[`whoami`@`hostname`:"'$PWD]$'
export PS1
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_HOSTNAME=racnode1
export ORACLE_UNQNAME=SALESERP
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/19.3.0/dbhome_1; export ORACLE_HOME
ORACLE_SID=SALES1; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"; export NLS_DATE_FORMAT
NLS_LANG=AMERICAN_AMERICA.ZHS16GBK;export NLS_LANG
PATH=.:$PATH:$HOME/bin:$ORACLE_BASE/product/19.3.0/dbhome_1/bin:$ORACLE_HOME/bin; export
PATH
THREADS_FLAG=native; export THREADS_FLAG
if [ $USER = "oracle" ] || [ $USER = "grid" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi
```

### 4.2.2 節點2

```sql
su - oracle
vim .bash_profile

# 新增內容

PS1="[`whoami`@`hostname`:"'$PWD]$'
export PS1
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_HOSTNAME=racnode2
export ORACLE_UNQNAME=SALESERP
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/19.3.0/dbhome_1; export ORACLE_HOME
ORACLE_SID=SALES2; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"; export NLS_DATE_FORMAT
NLS_LANG=AMERICAN_AMERICA.ZHS16GBK;export NLS_LANG
PATH=.:$PATH:$HOME/bin:$ORACLE_BASE/product/19.3.0/dbhome_1/bin:$ORACLE_HOME/bin; export
PATH
THREADS_FLAG=native; export THREADS_FLAG
if [ $USER = "oracle" ] || [ $USER = "grid" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi
```

# 5 SSH 互信
## 5.1 GRID使用者互信
### 5.1.1 節點1
```sql
su - grid
rm -rf ~/.ssh
mkdir ~/.ssh
ssh-keygen -t rsa
ssh-keygen -t dsa
```
### 5.1.2 節點2
```sql
su - grid
rm -rf ~/.ssh
mkdir ~/.ssh
ssh-keygen -t rsa
ssh-keygen -t dsa
```
### 5.1.3 節點1追加互信並複製至節點2
```sql
cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys 
ssh racnode2 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
ssh racnode2 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys
scp /home/grid/.ssh/authorized_keys racnode2:~/.ssh/authorized_keys
```
### 5.1.4 節點1驗證互信（無需密碼）
```sql
ssh racnode1 date
ssh racnode2 date
ssh node1pri date
ssh node2pri date
```
### 5.1.5 節點2驗證互信（無需密碼）
```sql
ssh racnode1 date
ssh racnode2 date
ssh node1pri date
ssh node2pri date
```
## 5.2 ORACLE使用者互信
### 5.2.1 節點1
```sql
su - oracle
rm -rf ~/.ssh
mkdir ~/.ssh
ssh-keygen -t rsa
ssh-keygen -t dsa
```
### 5.2.2 節點2
```sql
su - oracle
rm -rf ~/.ssh
mkdir ~/.ssh
ssh-keygen -t rsa
ssh-keygen -t dsa
```
### 5.2.3 節點1追加互信並複製至節點2
```sql
cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys
ssh racnode2 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
ssh racnode2 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys 
scp /home/oracle/.ssh/authorized_keys racnode2:~/.ssh/authorized_keys
```
### 5.2.4 節點1驗證互信（無需密碼）
```sql
ssh racnode1 date
ssh racnode2 date
ssh node1pri date
ssh node2pri date
```
### 5.2.5 節點2驗證互信（無需密碼）
```sql
ssh racnode1 date
ssh racnode2 date
ssh node1pri date
ssh node2pri date
```
# 6 ASM 磁碟配置（UDEV）
> 本文使用 VMWare Workstation 15.5 虛擬機器進行配置

```sql
# 關閉節點1和節點2

systemctl poweroff

# 建立獨立的共享磁碟資料夾

sharedisk
```
## 6.1 節點1新增磁碟

- 按照 1.3 規劃，新增 4 塊硬碟。
- 虛擬機器設定永久模式前提是不允許存在虛擬機器快照，如存在，請刪除。
- 節點 1 新增一塊共享磁碟步驟如下，以此類推。

![](http://img.blog.itpub.net/blog/2020/10/27/18bc38aa51216e0d.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/27/2212bb36f8f1a0ff.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/27/1c2a46e7858e8f42.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/27/f79e68cf6210ebc0.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/27/9b222f05e206cf78.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/27/be5785b75cf06196.png?x-oss-process=style/bb)

## 6.2 節點2新增磁碟

- 新增磁碟選擇 使用現有虛擬磁碟
- 節點 2 的磁碟選擇與虛擬裝置號要和節點 1 保持一致
- 節點 2 新增一塊共享磁碟步驟如下，以此類推。

![](http://img.blog.itpub.net/blog/2020/10/28/34d098436c50af5e.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/5cc053534336c3d3.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/db2a9bcb14c3609f.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/9f58feef29dfe74c.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/aa516cb63a6da410.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/6a7e56a0fd3e5977.png?x-oss-process=style/bb)

## 6.3 節點2虛擬機器新增程式碼段
```sql
# 節點二虛擬機器配置檔案中新增以下程式碼段，避免同時開啟鎖定磁碟

disk.locking = "FALSE" 
diskLib.dataCacheMaxSize= "0" 
scsi1.sharedBus ="virtual"
diskLib.dataCacheMaxReadAheadSize = "0"
diskLib.DataCacheMinReadAheadSize = "0"
diskLib.dataCachePageSize = "4096"
diskLib.maxUnsyncedWrites = "0"
disk.EnableUUID = "TRUE"
```
## 6.4 節點1分割槽
```sql
fdisk /dev/sdd
fdisk /dev/sde
fdisk /dev/sdf
fdisk /dev/sdg
```
## 6.5 節點1確認SCSI識別符號
- 透過命令 /usr/lib/udev/scsi_id -g -u -d 分割槽名 確認識別符號，最終對應關係如下

## 6.6 節點1編輯UDEV規則檔案
- 建立檔案 `vim /etc/udev/rules.d/99-oracle-asmdevices.rules`，按以下格式編輯條目，替換 `RESULT` 對應的 `SCSI` 識別符號

```sql
KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="36000c29c627c4e18666e2ba340715dc9", SYMLINK+="oasm/asm-ocr1", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="36000c295b648ea51ee6b56b006825def", SYMLINK+="oasm/asm-ocr2", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="36000c29d97a96e82fcd40598caba8115", SYMLINK+="oasm/asm-ocr3", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="36000c2990c196f54a57085a995e97d9d", SYMLINK+="oasm/asm-data", OWNER="grid", GROUP="asmadmin", MODE="0660"
```

- 執行 partprobe 識別

```sql
/sbin/partprobe /dev/sdd1
/sbin/partprobe /dev/sde1
/sbin/partprobe /dev/sdf1
/sbin/partprobe /dev/sdg1
```
- 檢視磁碟

```sql
請確保所有連結磁碟均可見，並具有對應的正確許可權，否則，在進行下一步之前請解決該問題。
[root@racnode1 ~]# ls -lathr /dev/oasm/*
lrwxrwxrwx 1 root root 7 Oct 10 10:26 /dev/oasm/asm-ocr1 -> ../sdd1
lrwxrwxrwx 1 root root 7 Oct 10 10:26 /dev/oasm/asm-ocr2 -> ../sde1
lrwxrwxrwx 1 root root 7 Oct 10 10:26 /dev/oasm/asm-ocr3 -> ../sdf1
lrwxrwxrwx 1 root root 7 Oct 10 10:26 /dev/oasm/asm-data -> ../sdg1

上面連結歸 root 使用者所有，但是連結所指向的磁碟是擁有正確許可權的。
[root@racnode1 ~]# ls -lathr /dev/sd*1 |grep -v sda1 |grep -v sdb1 |grep -v sdc1
brw-rw---- 1 grid asmadmin 8, 49 Oct 10 10:26 /dev/sdd1
brw-rw---- 1 grid asmadmin 8, 65 Oct 10 10:26 /dev/sde1
brw-rw---- 1 grid asmadmin 8, 81 Oct 10 10:26 /dev/sdf1
brw-rw---- 1 grid asmadmin 8, 97 Oct 10 10:26 /dev/sdg1
```
## 6.7 複製節點1 UDEV檔案至節點2
```sql
[root@racnode1 ~]# scp /etc/udev/rules.d/99-oracle-asmdevices.rules racnode2:/etc/udev/rules.d/

The authenticity of host 'racnode2 (192.168.31.201)' can't be established.
ECDSA key fingerprint is SHA256:Yj1vqmj9gGZ5pSF7E9B4kCce/C1TF6HvWHjzWVXMSuE.
ECDSA key fingerprint is MD5:bc:97:90:73:c2:a8:a6:5c:d0:9d:20:9e:6f:4c:d2:9a.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'racnode2,192.168.31.201' (ECDSA) to the list of known hosts.
root@racnode2's password: 
99-oracle-asmdevices.rules                         100%  828     1.2MB/s   00:00
```
## 6.8 節點2重啟UDEV服務

```sql
systemctl restart systemd-udevd.service 
udevadm control --reload-rules
udevadm trigger --type=devices --action=add

[root@racnode2 ~]# ls -lathr /dev/oasm/*
lrwxrwxrwx 1 root root 7 Oct 10 10:34 /dev/oasm/asm-ocr1 -> ../sdd1
lrwxrwxrwx 1 root root 7 Oct 10 10:34 /dev/oasm/asm-ocr2 -> ../sde1
lrwxrwxrwx 1 root root 7 Oct 10 10:34 /dev/oasm/asm-ocr3 -> ../sdf1
lrwxrwxrwx 1 root root 7 Oct 10 10:34 /dev/oasm/asm-data -> ../sdg1

[root@racnode2 ~]# ls -lathr /dev/sd*1 |grep -v sda1 |grep -v sdb1 |grep -v sdc1
brw-rw---- 1 grid asmadmin 8, 49 Oct 10 10:34 /dev/sdd1
brw-rw---- 1 grid asmadmin 8, 65 Oct 10 10:34 /dev/sde1
brw-rw---- 1 grid asmadmin 8, 81 Oct 10 10:34 /dev/sdf1
brw-rw---- 1 grid asmadmin 8, 97 Oct 10 10:34 /dev/sdg1

# 強烈建議直接重啟 systemctl reboot
```
> 學習實驗配置RAC共享磁碟，建議使用 VirtualBox

# 7 Grid Infrastructure 配置安裝
## 7.1 節點1解壓GI軟體

```sql
[root@racnode1 ~]# chmod -R 777 /soft/
[root@racnode1 ~]# su - grid
Last login: Wed Sep 30 10:18:34 CST 2020 on pts/0

[grid@racnode1:/home/grid]$cd $ORACLE_HOME
[grid@racnode1:/u01/app/19.3.0/grid]$unzip -q /soft/LINUX.X64_193000_grid_home.zip
```
## 7.2 節點1安裝叢集檢測包

```sql
[root@racnode1 ~]# cd /u01/app/19.3.0/grid/cv/rpm/
[root@racnode1 rpm]# rpm -ivh cvuqdisk-1.0.10-1.rpm 
Preparing...                          ################################# [100%]
Using default group oinstall to install package
Updating / installing...
   1:cvuqdisk-1.0.10-1                ################################# [100%]
```

## 7.3 節點2安裝叢集檢測包

```sql
# 複製至節點2

[root@racnode1 rpm]# scp cvuqdisk-1.0.10-1.rpm racnode2:/tmp
root@racnode2's password: 
cvuqdisk-1.0.10-1.rpm                       100%   11KB  10.7MB/s   00:00

# 節點2安裝

[root@racnode2 ~]# cd /tmp/
[root@racnode2 tmp]# rpm -ivh cvuqdisk-1.0.10-1.rpm 
Preparing...                          ################################# [100%]
Using default group oinstall to install package
Updating / installing...
   1:cvuqdisk-1.0.10-1                ################################# [100%]
```

## 7.4 解壓更新OPatch工具
> 如不考慮打補丁，可跳過本小節

```sql
# 截至文章釋出，GI軟體最新RU補丁版本為 2020.07.14 釋出的 19.8.0.0.200714（補丁號 Patch 31305339），該補丁要求 OPatch 工具最低版本為 12.2.0.1.21
# 截止二次發文時間（2020.10.28），GI軟體最新RU補丁版本為 2020.10.20 釋出的 19.9.0.0.201020（補丁號 Patch 31750108），OPatch版本要求請自行檢視

# 檢視當前 OPatch 工具版本

[grid@racnode1:/home/grid]$cd $ORACLE_HOME
[grid@racnode1:/u01/app/19.3.0/grid]$OPatch/opatch version
OPatch Version: 12.2.0.1.17

OPatch succeeded.

# 下載最新 OPatch 工具解壓覆蓋

[grid@racnode1:/u01/app/19.3.0/grid]$unzip -q /soft/p6880880_121010_Linux-x86-64.zip

replace OPatch/emdpatch.pl? [y]es, [n]o, [A]ll, [N]one, [r]ename: A

# 檢視最新 OPatch 工具版本

[grid@racnode1:/u01/app/19.3.0/grid]$OPatch/opatch version
OPatch Version: 12.2.0.1.21

OPatch succeeded.
```
## 7.5 解壓GI軟體最新RU補丁
> 如不考慮打補丁，可跳過本小節

```sql
[grid@racnode1:/home/grid]$cd /soft/

[grid@racnode1:/soft]$mkdir ogi

[grid@racnode1:/soft]$unzip -q p31305339_190000_Linux-x86-64.zip -d ogi
```

## 7.6 圖形化安裝GI軟體

```sql
# 進入圖形化桌面（打補丁）

[grid@racnode1 ~]$ cd $ORACLE_HOME
[grid@racnode1 grid]$ ./gridSetup.sh -applyRU /soft/ogi/31305339/

Preparing the home to patch...
Applying the patch /soft/ogi/31305339/...
Successfully applied the patch.
The log can be found at: /tmp/GridSetupActions2020-10-10_11-25-56AM/installerPatchActions_2020-10-10_11-25-56AM.log
Launching Oracle Grid Infrastructure Setup Wizard...

# 進入圖形化桌面（不打補丁）

[grid@racnode1 ~]$ cd $ORACLE_HOME
[grid@racnode1 grid]$ ./gridSetup.sh
```
![](http://img.blog.itpub.net/blog/2020/10/28/891d66c6b5ef450c.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/0d549b4d87db6c6e.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/dc6b4aae2eb177ad.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/dec4325b9f6af187.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/d0f41085c213181f.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/e7d10121d7fccd7b.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/97cd03e0f1695602.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/d648cc92a947d3a3.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/8ff5fda6f32bfb14.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/83a5dff1ff9de6ee.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/697205726e001957.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/72555dd00becad5c.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/8b2c837140a7f2a3.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/05594f6d210e60f7.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/5c7f16b44f335f93.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/06459d89e692f0ad.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/118d647992f7897a.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/8e8b80515643537e.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/b4f012e01a6842fd.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/a607a650fceb4ff8.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/94bc4ee917bd22b8.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/f97223985ff9c7eb.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/0bdabc2c26b3dad9.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/c7bb4976114e1fdb.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/8206368904ed1902.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/006ed1a974f94c8c.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/88e5e69c61525f62.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/e68ec9be85fa3491.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/9b99af30be78fdc0.png?x-oss-process=style/bb)

- 節點1執行1指令碼

```sql
[root@racnode1 ~]# /u01/app/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.

Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete.
```

- 節點2執行1指令碼

```sql
[root@racnode2 ~]# /u01/app/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.

Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete.
```

- 節點1執行2指令碼（等待執行完畢）

```sql
[root@racnode1 ~]# /u01/app/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.

Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete.
[root@racnode1 ~]# /u01/app/19.3.0/grid/root.sh
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u01/app/19.3.0/grid

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.
Relinking oracle with rac_on option
Using configuration parameter file: /u01/app/19.3.0/grid/crs/install/crsconfig_params
The log of current session can be found at:
  /u01/app/grid/crsdata/racnode1/crsconfig/rootcrs_racnode1_2020-10-10_12-00-08AM.log
2020/10/10 12:00:15 CLSRSC-594: Executing installation step 1 of 19: 'SetupTFA'.
2020/10/10 12:00:15 CLSRSC-594: Executing installation step 2 of 19: 'ValidateEnv'.
2020/10/10 12:00:15 CLSRSC-363: User ignored prerequisites during installation
2020/10/10 12:00:15 CLSRSC-594: Executing installation step 3 of 19: 'CheckFirstNode'.
2020/10/10 12:00:18 CLSRSC-594: Executing installation step 4 of 19: 'GenSiteGUIDs'.
2020/10/10 12:00:19 CLSRSC-594: Executing installation step 5 of 19: 'SetupOSD'.
2020/10/10 12:00:19 CLSRSC-594: Executing installation step 6 of 19: 'CheckCRSConfig'.
2020/10/10 12:00:20 CLSRSC-594: Executing installation step 7 of 19: 'SetupLocalGPNP'.
2020/10/10 12:00:36 CLSRSC-594: Executing installation step 8 of 19: 'CreateRootCert'.
2020/10/10 12:00:42 CLSRSC-594: Executing installation step 9 of 19: 'ConfigOLR'.
2020/10/10 12:01:04 CLSRSC-594: Executing installation step 10 of 19: 'ConfigCHMOS'.
2020/10/10 12:01:05 CLSRSC-594: Executing installation step 11 of 19: 'CreateOHASD'.
2020/10/10 12:01:14 CLSRSC-594: Executing installation step 12 of 19: 'ConfigOHASD'.
2020/10/10 12:01:15 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'
2020/10/10 12:01:34 CLSRSC-594: Executing installation step 13 of 19: 'InstallAFD'.
2020/10/10 12:01:34 CLSRSC-594: Executing installation step 14 of 19: 'InstallACFS'.
2020/10/10 12:01:38 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.
2020/10/10 12:02:04 CLSRSC-594: Executing installation step 15 of 19: 'InstallKA'.
2020/10/10 12:02:08 CLSRSC-594: Executing installation step 16 of 19: 'InitConfig'.
Redirecting to /bin/systemctl restart rsyslog.service

ASM has been created and started successfully.

[DBT-30001] Disk groups created successfully. Check /u01/app/grid/cfgtoollogs/asmca/asmca-201010PM120239.log for details.

2020/10/10 12:03:32 CLSRSC-482: Running command: '/u01/app/19.3.0/grid/bin/ocrconfig -upgrade grid oinstall'
CRS-4256: Updating the profile
Successful addition of voting disk be92bb6d24b14f3dbf20624b176c5a05.
Successful addition of voting disk 67641d8f6cc84f32bfb50207eac7d87e.
Successful addition of voting disk 84be0f12ad1c4f6fbf08a9aca3d5a3d3.
Successfully replaced voting disk group with +OCRDG.
CRS-4256: Updating the profile
CRS-4266: Voting file(s) successfully replaced
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   be92bb6d24b14f3dbf20624b176c5a05 (/dev/oasm/asm-ocr1) [OCRDG]
 2. ONLINE   67641d8f6cc84f32bfb50207eac7d87e (/dev/oasm/asm-ocr2) [OCRDG]
 3. ONLINE   84be0f12ad1c4f6fbf08a9aca3d5a3d3 (/dev/oasm/asm-ocr3) [OCRDG]
Located 3 voting disk(s).
2020/10/10 12:04:35 CLSRSC-594: Executing installation step 17 of 19: 'StartCluster'.
2020/10/10 12:05:41 CLSRSC-343: Successfully started Oracle Clusterware stack
2020/10/10 12:05:41 CLSRSC-594: Executing installation step 18 of 19: 'ConfigNode'.
2020/10/10 12:07:16 CLSRSC-594: Executing installation step 19 of 19: 'PostConfig'.
2020/10/10 12:07:53 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded
```

- 節點2執行2指令碼

```sql
[root@racnode2 ~]# /u01/app/19.3.0/grid/root.sh
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u01/app/19.3.0/grid

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.
Relinking oracle with rac_on option
Using configuration parameter file: /u01/app/19.3.0/grid/crs/install/crsconfig_params
The log of current session can be found at:
  /u01/app/grid/crsdata/racnode2/crsconfig/rootcrs_racnode2_2020-10-10_12-11-18AM.log
2020/10/10 12:11:20 CLSRSC-594: Executing installation step 1 of 19: 'SetupTFA'.
2020/10/10 12:11:20 CLSRSC-594: Executing installation step 2 of 19: 'ValidateEnv'.
2020/10/10 12:11:20 CLSRSC-363: User ignored prerequisites during installation
2020/10/10 12:11:20 CLSRSC-594: Executing installation step 3 of 19: 'CheckFirstNode'.
2020/10/10 12:11:22 CLSRSC-594: Executing installation step 4 of 19: 'GenSiteGUIDs'.
2020/10/10 12:11:22 CLSRSC-594: Executing installation step 5 of 19: 'SetupOSD'.
2020/10/10 12:11:23 CLSRSC-594: Executing installation step 6 of 19: 'CheckCRSConfig'.
2020/10/10 12:11:24 CLSRSC-594: Executing installation step 7 of 19: 'SetupLocalGPNP'.
2020/10/10 12:11:26 CLSRSC-594: Executing installation step 8 of 19: 'CreateRootCert'.
2020/10/10 12:11:27 CLSRSC-594: Executing installation step 9 of 19: 'ConfigOLR'.
2020/10/10 12:11:41 CLSRSC-594: Executing installation step 10 of 19: 'ConfigCHMOS'.
2020/10/10 12:11:41 CLSRSC-594: Executing installation step 11 of 19: 'CreateOHASD'.
2020/10/10 12:11:43 CLSRSC-594: Executing installation step 12 of 19: 'ConfigOHASD'.
2020/10/10 12:11:43 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'
2020/10/10 12:12:02 CLSRSC-594: Executing installation step 13 of 19: 'InstallAFD'.
2020/10/10 12:12:02 CLSRSC-594: Executing installation step 14 of 19: 'InstallACFS'.
2020/10/10 12:12:45 CLSRSC-594: Executing installation step 15 of 19: 'InstallKA'.
2020/10/10 12:12:46 CLSRSC-594: Executing installation step 16 of 19: 'InitConfig'.
Redirecting to /bin/systemctl restart rsyslog.service
2020/10/10 12:12:55 CLSRSC-594: Executing installation step 17 of 19: 'StartCluster'.
2020/10/10 12:12:55 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.
2020/10/10 12:13:42 CLSRSC-343: Successfully started Oracle Clusterware stack
2020/10/10 12:13:43 CLSRSC-594: Executing installation step 18 of 19: 'ConfigNode'.
2020/10/10 12:13:58 CLSRSC-594: Executing installation step 19 of 19: 'PostConfig'.
2020/10/10 12:14:05 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded
```
![](http://img.blog.itpub.net/blog/2020/10/28/f7f3e7180f88d687.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/e44783942425201b.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/09dd6a98a57de72c.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/36b227c33928325a.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/4280638f8014fe2d.png?x-oss-process=style/bb)

## 7.7 新增 ASM 磁碟

```sql
[grid@racnode1 ~]$ asmca
```
![](http://img.blog.itpub.net/blog/2020/10/28/c2b0c38248aa5228.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/25003cf8c800e1e8.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/8b850213f52b995c.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/01914168c75e43e0.png?x-oss-process=style/bb)

## 7.8 檢視叢集元件狀態

```sql
[grid@racnode1:/home/grid]$crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
               ONLINE  ONLINE       racnode1                 STABLE
               ONLINE  ONLINE       racnode2                 STABLE
ora.chad
               ONLINE  ONLINE       racnode1                 STABLE
               ONLINE  ONLINE       racnode2                 STABLE
ora.net1.network
               ONLINE  ONLINE       racnode1                 STABLE
               ONLINE  ONLINE       racnode2                 STABLE
ora.ons
               ONLINE  ONLINE       racnode1                 STABLE
               ONLINE  ONLINE       racnode2                 STABLE
ora.proxy_advm
               OFFLINE OFFLINE      racnode1                 STABLE
               OFFLINE OFFLINE      racnode2                 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
      1        ONLINE  ONLINE       racnode1                 STABLE
      2        ONLINE  ONLINE       racnode2                 STABLE
ora.DATA.dg(ora.asmgroup)
      1        ONLINE  ONLINE       racnode1                 STABLE
      2        ONLINE  ONLINE       racnode2                 STABLE
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       racnode1                 STABLE
ora.OCRDG.dg(ora.asmgroup)
      1        ONLINE  ONLINE       racnode1                 STABLE
      2        ONLINE  ONLINE       racnode2                 STABLE
ora.asm(ora.asmgroup)
      1        ONLINE  ONLINE       racnode1                 Started,STABLE
      2        ONLINE  ONLINE       racnode2                 Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
      1        ONLINE  ONLINE       racnode1                 STABLE
      2        ONLINE  ONLINE       racnode2                 STABLE
ora.cvu
      1        ONLINE  ONLINE       racnode1                 STABLE
ora.qosmserver
      1        ONLINE  ONLINE       racnode1                 STABLE
ora.racnode1.vip
      1        ONLINE  ONLINE       racnode1                 STABLE
ora.racnode2.vip
      1        ONLINE  ONLINE       racnode2                 STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       racnode1                 STABLE
--------------------------------------------------------------------------------
```

# 8 Oracle Database 配置安裝
## 8.1 節點1解壓DB軟體

```sql
[oracle@racnode1 ~]$ cd $ORACLE_HOME
[oracle@racnode1 dbhome_1]$ unzip -q /soft/LINUX.X64_193000_db_home.zip
```

## 8.2 解壓更新OPatch工具
> 如不考慮打補丁，可跳過本小節

```sql
# 截至文章釋出，DB軟體最新RU補丁版本為 2020.07.14 釋出的 19.8.0.0.200714（補丁號 Patch Patch 31281355），該補丁要求 OPatch 工具最低版本為 12.2.0.1.21
# 截止二次發文時間（2020.10.28），DB軟體最新RU補丁版本為 2020.10.20 釋出的 19.9.0.0.201020（補丁號 Patch 31771877），OPatch版本要求請自行檢視

# 檢視當前 OPatch 工具版本

[oracle@racnode1 ~]$ cd $ORACLE_HOME
[oracle@racnode1 dbhome_1]$ OPatch/opatch version
OPatch Version: 12.2.0.1.17

OPatch succeeded.

# 下載最新 OPatch 工具解壓覆蓋

[oracle@racnode1 dbhome_1]$ unzip -q /soft/p6880880_121010_Linux-x86-64.zip 
replace OPatch/emdpatch.pl? [y]es, [n]o, [A]ll, [N]one, [r]ename: A

# 檢視最新 OPatch 工具版本

[oracle@racnode1 dbhome_1]$ OPatch/opatch version
OPatch Version: 12.2.0.1.21

OPatch succeeded.
```

## 8.3 解壓DB軟體最新RU補丁
> 如不考慮打補丁，可跳過本小節

```sql
[oracle@racnode1 dbhome_1]$ cd /soft/

[oracle@racnode1 soft]$ mkdir odb

[oracle@racnode1 soft]$ unzip -q p31281355_190000_Linux-x86-64.zip -d odb
```

## 8.4 圖形化安裝DB軟體

```sql
# 進入圖形化桌面（打補丁）

[oracle@racnode1 ~]$ cd $ORACLE_HOME
[oracle@racnode1 dbhome_1]$ ./runInstaller -applyRU /soft/odb/31281355/

Preparing the home to patch...
Applying the patch /soft/odb/31281355/...
Successfully applied the patch.
The log can be found at: /u01/app/oraInventory/logs/InstallActions2020-10-10_01-12-49PM/installerPat    chActions_2020-10-10_01-12-49PM.log
Launching Oracle Database Setup Wizard...

# 進入圖形化桌面（不打補丁）

[oracle@racnode1 ~]$ cd $ORACLE_HOME
[oracle@racnode1 dbhome_1]$ ./runInstaller
```
![](http://img.blog.itpub.net/blog/2020/10/28/94a29e06bcf1d5a1.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/58acb4900e8d3389.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/b2004f58ea14ecdd.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/227c344ef0fb98f2.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/52b0615efd2729ad.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/1daf0f07d6c32930.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/f1839da6d79f61f5.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/db9c799e1d3a550d.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/c11d4e6c8b5df722.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/d8f3a8c62a4dde25.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/030baf3444804265.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/1a3d0b7d22416489.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/ddf3cacf43c12213.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/c4df590a57e8c0ff.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/bc0745106b5e99e5.png?x-oss-process=style/bb)

- 節點1執行指令碼

```sql
[root@racnode1 ~]# /u01/app/oracle/product/19.3.0/dbhome_1/root.sh
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/oracle/product/19.3.0/dbhome_1

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.
```

- 節點2執行指令碼

```sql
[root@racnode2 ~]# /u01/app/oracle/product/19.3.0/dbhome_1/root.sh
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/oracle/product/19.3.0/dbhome_1

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.
```
![](http://img.blog.itpub.net/blog/2020/10/28/a9335928f5576ec7.png?x-oss-process=style/bb)

## 8.5 建立資料庫

```sql
[oracle@racnode1 ~]$ dbca
```
![](http://img.blog.itpub.net/blog/2020/10/28/1df892f855bec971.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/c98a6e064c700a5e.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/047163b386c5ada0.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/76c09c71c3d5e5f3.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/e5c49413ff576093.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/bc9b67ed5201d1c3.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/78432ac948a748ef.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/af4b01d9626e8fec.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/7a3d8d9da6c7b367.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/54bfdf4fe6c327bb.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/5e11bd8c2f383cfb.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/6fa9188d846423fc.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/7214fc7a43eae630.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/469955dcfcba4edb.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/019d92fc8c3dff93.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/cf7edd466d742eb2.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/aa8249c76d3e2267.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/ac28730f614eb576.png?x-oss-process=style/bb)

![](http://img.blog.itpub.net/blog/2020/10/28/34275f474ade2170.png?x-oss-process=style/bb)

[End]

G003-ORACLE-INS-RAC-01 ORACLE 19C RAC Ins ON OEL 7.8

相關文章