前言

Oracle 一鍵安裝腳本，演示 RedHat 7.9 一鍵安裝 Oracle 12CR2 RAC（231017）過程（全程無需人工干預(yù)）。

?? 腳本下載地址：Shell腳本安裝Oracle數(shù)據(jù)庫

安裝準(zhǔn)備

• 1、安裝好操作系統(tǒng)，建議安裝圖形化
• 2、配置好網(wǎng)絡(luò)
• 3、掛載本地 ISO 鏡像源
• 4、上傳軟件安裝包（安裝基礎(chǔ)包，補(bǔ)丁包）
• 5、上傳一鍵安裝腳本：OracleShellInstall

環(huán)境信息

# 主機(jī)版本
## 節(jié)點一
[root@rac01 soft]# cat /etc/os-release 
NAME="Red Hat Enterprise Linux Server"
VERSION="7.9 (Maipo)"
ID="rhel"
ID_LIKE="fedora"
VARIANT="Server"
VARIANT_ID="server"
VERSION_ID="7.9"
PRETTY_NAME="Red Hat Enterprise Linux Server 7.9 (Maipo)"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:redhat:enterprise_linux:7.9:GA:server"
HOME_URL="https://www.redhat.com/"
BUG_REPORT_URL="https://bugzilla.redhat.com/"

REDHAT_BUGZILLA_PRODUCT="Red Hat Enterprise Linux 7"
REDHAT_BUGZILLA_PRODUCT_VERSION=7.9
REDHAT_SUPPORT_PRODUCT="Red Hat Enterprise Linux"
REDHAT_SUPPORT_PRODUCT_VERSION="7.9"

## 節(jié)點二
[root@rac02 ~]# cat /etc/os-release 
NAME="Red Hat Enterprise Linux Server"
VERSION="7.9 (Maipo)"
ID="rhel"
ID_LIKE="fedora"
VARIANT="Server"
VARIANT_ID="server"
VERSION_ID="7.9"
PRETTY_NAME="Red Hat Enterprise Linux Server 7.9 (Maipo)"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:redhat:enterprise_linux:7.9:GA:server"
HOME_URL="https://www.redhat.com/"
BUG_REPORT_URL="https://bugzilla.redhat.com/"

REDHAT_BUGZILLA_PRODUCT="Red Hat Enterprise Linux 7"
REDHAT_BUGZILLA_PRODUCT_VERSION=7.9
REDHAT_SUPPORT_PRODUCT="Red Hat Enterprise Linux"
REDHAT_SUPPORT_PRODUCT_VERSION="7.9"

# 網(wǎng)絡(luò)信息
## 節(jié)點一
[root@rac01 soft]# ip a
2: ens192: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP group default qlen 1000
    link/ether 00:0c:29:96:ac:51 brd ff:ff:ff:ff:ff:ff
    inet 192.168.6.151/24 brd 192.168.6.255 scope global noprefixroute ens192
       valid_lft forever preferred_lft forever
    inet6 fe80::f5b9:ca65:dba2:bf0/64 scope link noprefixroute 
       valid_lft forever preferred_lft forever
3: ens224: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP group default qlen 1000
    link/ether 00:0c:29:96:ac:5b brd ff:ff:ff:ff:ff:ff
    inet 1.1.1.1/24 brd 1.1.1.255 scope global noprefixroute ens224
       valid_lft forever preferred_lft forever
    inet6 fe80::a8ce:7574:2cec:a98e/64 scope link noprefixroute 
       valid_lft forever preferred_lft forever

## 節(jié)點二
[root@rac02 ~]# ip a
2: ens192: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP group default qlen 1000
    link/ether 00:0c:29:f2:87:1f brd ff:ff:ff:ff:ff:ff
    inet 192.168.6.152/24 brd 192.168.6.255 scope global noprefixroute ens192
       valid_lft forever preferred_lft forever
    inet6 fe80::add5:391e:a5cb:6547/64 scope link noprefixroute 
       valid_lft forever preferred_lft forever
3: ens224: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP group default qlen 1000
    link/ether 00:0c:29:f2:87:29 brd ff:ff:ff:ff:ff:ff
    inet 1.1.1.2/24 brd 1.1.1.255 scope global noprefixroute ens224
       valid_lft forever preferred_lft forever
    inet6 fe80::3044:e992:319f:95a2/64 scope link noprefixroute 
       valid_lft forever preferred_lft forever

# 掛載本地 ISO 鏡像
## 節(jié)點一
[root@rac01 soft]# mount | grep iso9660 | grep -v "/run/media"
/dev/sr0 on /mnt type iso9660 (ro,relatime)
[root@rac01 soft]# df -h|grep /mnt
/dev/sr0               4.3G  4.3G     0 100% /mnt

## 節(jié)點二
[root@rac02 ~]# mount | grep iso9660 | grep -v "/run/media"
/dev/sr0 on /mnt type iso9660 (ro,relatime)
[root@rac02 ~]# df -h|grep /mnt
/dev/sr0               4.3G  4.3G     0 100% /mnt

# starwind 共享磁盤掛載（有存儲就不需要使用 starwind，直接存儲上劃盤掛載就可）
yum install -y iscsi-initiator-utils*
systemctl start iscsid.service
systemctl enable iscsid.service
iscsiadm -m discovery -t st -p 192.168.6.188
## 掛載 ASM 磁盤
iscsiadm -m node -T iqn.2008-08.com.starwindsoftware:192.168.6.188-lucifer -p 192.168.6.188 -l
## 配置開機(jī)自動掛載
iscsiadm -m node -T iqn.2008-08.com.starwindsoftware:192.168.6.188-lucifer -p 192.168.6.188 --op update -n node.startup -v automatic

## 節(jié)點一
[root@rac01 soft]# lsblk 
NAME          MAJ:MIN RM  SIZE RO TYPE MOUNTPOINT
sda             8:0    0  100G  0 disk 
├─sda1          8:1    0    1G  0 part /boot
└─sda2          8:2    0   99G  0 part 
  ├─rhel-root 253:0    0   91G  0 lvm  /
  └─rhel-swap 253:1    0    8G  0 lvm  [SWAP]
sdb             8:16   0   10G  0 disk 
sdc             8:32   0   50G  0 disk 
sr0            11:0    1  4.2G  0 rom  /mnt

## 節(jié)點二
[root@rac02 ~]# lsblk 
NAME          MAJ:MIN RM  SIZE RO TYPE MOUNTPOINT
sda             8:0    0  100G  0 disk 
├─sda1          8:1    0    1G  0 part /boot
└─sda2          8:2    0   99G  0 part 
  ├─rhel-root 253:0    0   91G  0 lvm  /
  └─rhel-swap 253:1    0    8G  0 lvm  [SWAP]
sdb             8:16   0   10G  0 disk 
sdc             8:32   0   50G  0 disk 
sr0            11:0    1  4.2G  0 rom  /mnt

# 安裝包存放在 /soft 目錄下
[root@rac01 soft]# ll
-rwx------. 1 root root 3453696911 Apr 24 09:20 LINUX.X64_122010_db_home.zip
-rwx------. 1 root root 2994687209 Apr 24 09:20 LINUX.X64_122010_grid_home.zip
-rwxr-xr-x. 1 root root     197304 Apr 24 09:18 OracleShellInstall
-rwx------. 1 root root 2526745297 Apr 24 09:20 p35745595_122010_Linux-x86-64.zip
-rwx------. 1 root root  138325588 Apr 24 09:28 p35926712_122010_Linux-x86-64.zip
-rwx------. 1 root root  127629034 Apr 24 09:18 p6880880_122010_Linux-x86-64.zip
-rwx------. 1 root root     321590 Mar 11 14:12 rlwrap-0.44.tar.gz

確保安裝環(huán)境準(zhǔn)備完成后，即可執(zhí)行一鍵安裝。

安裝命令

使用標(biāo)準(zhǔn)生產(chǎn)環(huán)境安裝參數(shù)（安裝過程若失敗，腳本支持重復(fù)執(zhí)行安裝）：

# 根據(jù)腳本 README 或者 -h 命令提示，編輯好一鍵安裝命令，進(jìn)入 /soft 目錄執(zhí)行安裝：
./OracleShellInstall -n rac `# hostname prefix`\
-hn rac01,rac02 `# rac node hostname`\
-cn rac-cls `# cluster_name`\
-rp oracle `# root password`\
-gp oracle `# grid password`\
-op oracle `# oracle password`\
-lf ens192 `# local ip ifname`\
-pf ens224 `# rac private ip ifname`\
-ri 192.168.6.151,192.168.6.152 `# rac node public ip`\
-vi 192.168.6.153,192.168.6.154 `# rac virtual ip`\
-si 192.168.6.155 `# rac scan ip`\
-od /dev/sdb `# rac ocr asm disk`\
-dd /dev/sdc `# rac data asm disk`\
-o lucifer,orcl `# dbname`\
-pdb olive `# pdbname`\
-ds AL32UTF8 `# database character`\
-ns AL16UTF16 `# national character`\
-redo 100 `# redo size`\
-dp oracle `# sys/system password`\
-gpa 35745595 `# grid PSU/RU`\
-jpa 35926712 `# OJVM PSU/RU`\
-opd Y `# optimize db`

安裝過程

   ███████                             ██          ████████ ██               ██  ██ ██                    ██              ██  ██
  ██?????██                           ?██         ██?????? ?██              ?██ ?██?██                   ?██             ?██ ?██
 ██     ??██ ██████  ██████    █████  ?██  █████ ?██       ?██       █████  ?██ ?██?██ ███████   ██████ ██████  ██████   ?██ ?██
?██      ?██??██??█ ??????██  ██???██ ?██ ██???██?█████████?██████  ██???██ ?██ ?██?██??██???██ ██???? ???██?  ??????██  ?██ ?██
?██      ?██ ?██ ?   ███████ ?██  ??  ?██?███████????????██?██???██?███████ ?██ ?██?██ ?██  ?██??█████   ?██    ███████  ?██ ?██
??██     ██  ?██    ██????██ ?██   ██ ?██?██????        ?██?██  ?██?██????  ?██ ?██?██ ?██  ?██ ?????██  ?██   ██????██  ?██ ?██
 ??███████  ?███   ??████████??█████  ███??██████ ████████ ?██  ?██??██████ ███ ███?██ ███  ?██ ██████   ??██ ??████████ ███ ███
  ???????   ???     ????????  ?????  ???  ?????? ????????  ??   ??  ?????? ??? ??? ?? ???   ?? ??????     ??   ???????? ??? ??? 

請選擇安裝模式 [單機(jī)(si)/單機(jī)ASM(sa)/集群(rac)] : rac

數(shù)據(jù)庫安裝模式: rac                                                                              

請選擇數(shù)據(jù)庫版本 [11/12/19/21] : 12

數(shù)據(jù)庫版本:     12                                                                               

OracleShellInstall 開始安裝，安裝過程可查看日志： /soft/print_ora_install_20240424123319.log                                                                                  
正在檢查操作系統(tǒng)是否符合安裝條件......已完成 (耗時: 0 秒)
正在去除密碼復(fù)雜度配置......已完成 (耗時: 0 秒)
正在配置 YUM 源......已完成 (耗時: 1 秒)
配置 root 用戶互信......已完成 (耗時: 2 秒)
正在獲取操作系統(tǒng)信息......已完成 (耗時: 1 秒)
正在配置 Swap......已完成 (耗時: 1 秒)
正在配置防火墻......已完成 (耗時: 2 秒)
正在配置 selinux......已完成 (耗時: 1 秒)
正在配置 nsyctl......已完成 (耗時: 1 秒)
正在安裝依賴包......已完成 (耗時: 35 秒)
正在配置主機(jī)名和 /etc/hosts......已完成 (耗時: 0 秒)
正在創(chuàng)建用戶和組......已完成 (耗時: 1 秒)
正在創(chuàng)建安裝目錄......已完成 (耗時: 1 秒)
正在配置 Avahi-daemon 服務(wù)......已完成 (耗時: 2 秒)
正在配置透明大頁 && NUMA && 磁盤 IO 調(diào)度器......已完成 (耗時: 1 秒)
正在配置操作系統(tǒng)參數(shù) sysctl......已完成 (耗時: 1 秒)
正在配置 RemoveIPC......已完成 (耗時: 1 秒)
正在配置用戶限制 limit......已完成 (耗時: 1 秒)
正在配置 shm 目錄......已完成 (耗時: 0 秒)
正在安裝 rlwrap 插件......已完成 (耗時: 12 秒)
正在配置用戶環(huán)境變量......已完成 (耗時: 1 秒)
正在配置 RAC 其他節(jié)點信息......已完成 (耗時: 90 秒)
正在配置 RAC 所有節(jié)點互信......已完成 (耗時: 12 秒)
正在解壓 Grid 安裝包以及補(bǔ)丁......已完成 (耗時: 462 秒)
正在解壓 Oracle 軟件以及補(bǔ)丁......已完成 (耗時: 105 秒)
正在安裝 Grid 軟件以及補(bǔ)丁......已完成 (耗時: 3825 秒)
正在創(chuàng)建 ASM 磁盤組......已完成 (耗時: 51 秒)
正在安裝 Oracle 軟件以及補(bǔ)丁......已完成 (耗時: 3540 秒)
正在創(chuàng)建數(shù)據(jù)庫......已完成 (耗時: 6276 秒)
正在優(yōu)化數(shù)據(jù)庫......已完成 (耗時: 68 秒)

恭喜！Oracle RAC 安裝成功 (耗時: 14530 秒)，現(xiàn)在是否重啟主機(jī)：[Y/N] Y

正在重啟主機(jī)......    

連接測試

查看系統(tǒng)版本：

[root@rac01 soft]# cat /etc/os-release 
NAME="Red Hat Enterprise Linux Server"
VERSION="7.9 (Maipo)"
ID="rhel"
ID_LIKE="fedora"
VARIANT="Server"
VARIANT_ID="server"
VERSION_ID="7.9"
PRETTY_NAME="Red Hat Enterprise Linux Server 7.9 (Maipo)"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:redhat:enterprise_linux:7.9:GA:server"
HOME_URL="https://www.redhat.com/"
BUG_REPORT_URL="https://bugzilla.redhat.com/"

REDHAT_BUGZILLA_PRODUCT="Red Hat Enterprise Linux 7"
REDHAT_BUGZILLA_PRODUCT_VERSION=7.9
REDHAT_SUPPORT_PRODUCT="Red Hat Enterprise Linux"
REDHAT_SUPPORT_PRODUCT_VERSION="7.9"

查看 Grid 版本以及補(bǔ)丁：

[grid@rac01:/home/grid]$ sqlplus -v

SQL*Plus: Release 12.2.0.1.0 Production

[grid@rac01:/home/grid]$ opatch lspatches
35755935;OCW OCT 2023 RELEASE UPDATE 12.2.0.1.231017 (35755935)
35746058;Database Oct 2023 Release Update : 12.2.0.1.231017 (35746058)
33116894;ACFS JUL 2021 RELEASE UPDATE 12.2.0.1.210720 (33116894)
35549460;TOMCAT RELEASE UPDATE 12.2.0.1.0(ID:230628) (35549460)
26839277;DBWLM RELEASE UPDATE 12.2.0.1.0(ID:170913) (26839277)

OPatch succeeded.

查看集群：

[grid@rac01:/home/grid]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
               ONLINE  ONLINE       rac01                    STABLE
               ONLINE  ONLINE       rac02                    STABLE
ora.DATA.dg
               ONLINE  ONLINE       rac01                    STABLE
               ONLINE  ONLINE       rac02                    STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       rac01                    STABLE
               ONLINE  ONLINE       rac02                    STABLE
ora.OCR.dg
               ONLINE  ONLINE       rac01                    STABLE
               ONLINE  ONLINE       rac02                    STABLE
ora.net1.network
               ONLINE  ONLINE       rac01                    STABLE
               ONLINE  ONLINE       rac02                    STABLE
ora.ons
               ONLINE  ONLINE       rac01                    STABLE
               ONLINE  ONLINE       rac02                    STABLE
ora.proxy_advm
               OFFLINE OFFLINE      rac01                    STABLE
               OFFLINE OFFLINE      rac02                    STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       rac01                    STABLE
ora.MGMTLSNR
      1        OFFLINE OFFLINE                               STABLE
ora.asm
      1        ONLINE  ONLINE       rac01                    Started,STABLE
      2        ONLINE  ONLINE       rac02                    Started,STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.cvu
      1        ONLINE  ONLINE       rac01                    STABLE
ora.lucifer.db
      1        ONLINE  ONLINE       rac01                    Open,HOME=/u01/app/o
                                                             racle/product/12.2.0
                                                             /db,STABLE
      2        ONLINE  ONLINE       rac02                    Open,HOME=/u01/app/o
                                                             racle/product/12.2.0
                                                             /db,STABLE
ora.orcl.db
      1        ONLINE  ONLINE       rac01                    Open,HOME=/u01/app/o
                                                             racle/product/12.2.0
                                                             /db,STABLE
      2        ONLINE  ONLINE       rac02                    Open,HOME=/u01/app/o
                                                             racle/product/12.2.0
                                                             /db,STABLE
ora.qosmserver
      1        ONLINE  ONLINE       rac01                    STABLE
ora.rac01.vip
      1        ONLINE  ONLINE       rac01                    STABLE
ora.rac02.vip
      1        ONLINE  ONLINE       rac02                    STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       rac01                    STABLE
--------------------------------------------------------------------------------

[grid@rac01:/home/grid]$ asmcmd lsdg
State    Type    Rebal  Sector  Logical_Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  EXTERN  N         512             512   4096  1048576     51200    42048                0           42048              0             N  DATA/
MOUNTED  EXTERN  N         512             512   4096  4194304     10240     9904                0            9904              0             Y  OCR/

查看 Oracle 版本以及補(bǔ)丁：

[oracle@rac01:/home/oracle]$ sqlplus -v

SQL*Plus: Release 12.2.0.1.0 Production

[oracle@rac01:/home/oracle]$ opatch lspatches
35926712;OJVM RELEASE UPDATE 12.2.0.1.240116 (35926712)
35755935;OCW OCT 2023 RELEASE UPDATE 12.2.0.1.231017 (35755935)
35746058;Database Oct 2023 Release Update : 12.2.0.1.231017 (35746058)

OPatch succeeded.

連接數(shù)據(jù)庫：

[oracle@rac01:/home/oracle]$ . .lucifer 
[oracle@rac01:/home/oracle]$ sas

SQL*Plus: Release 12.2.0.1.0 Production on Wed Apr 24 17:41:09 2024

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

sys@LUCIFER 2024-04-24 17:41:09> show parameter name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
cdb_cluster_name                     string      lucifer
cell_offloadgroup_name               string
db_file_name_convert                 string
db_name                              string      lucifer
db_unique_name                       string      lucifer
global_names                         boolean     FALSE
instance_name                        string      lucifer1
lock_name_space                      string
log_file_name_convert                string
pdb_file_name_convert                string
processor_group_name                 string
service_names                        string      lucifer
sys@LUCIFER 2024-04-24 17:41:14> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 OLIVE                          READ WRITE NO
sys@LUCIFER 2024-04-24 17:41:15> select instance_name,status from gv$instance;

INSTANCE_NAME    STATUS
---------------- ------------
lucifer1         OPEN
lucifer2         OPEN

sys@LUCIFER 2024-04-24 17:41:26> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@rac01:/home/oracle]$ . .orcl 
[oracle@rac01:/home/oracle]$ sas

SQL*Plus: Release 12.2.0.1.0 Production on Wed Apr 24 17:41:32 2024

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

sys@ORCL 2024-04-24 17:41:32> show parameter name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
cdb_cluster_name                     string      orcl
cell_offloadgroup_name               string
db_file_name_convert                 string
db_name                              string      orcl
db_unique_name                       string      orcl
global_names                         boolean     FALSE
instance_name                        string      orcl1
lock_name_space                      string
log_file_name_convert                string
pdb_file_name_convert                string
processor_group_name                 string
service_names                        string      orcl
sys@ORCL 2024-04-24 17:41:35> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 OLIVE                          READ WRITE NO
sys@ORCL 2024-04-24 17:41:36> select instance_name,status from gv$instance;

INSTANCE_NAME    STATUS
---------------- ------------
orcl1            OPEN
orcl2            OPEN

sys@ORCL 2024-04-24 17:41:38> exit

數(shù)據(jù)庫連接正常。