环境说明
Manjaro Linux 6.12.18, 48G RAM.
Oracle Virutaobox 7.1.8
2个虚拟机分别配置 8G RAM， 共需要空间 118G.
安装步骤
以下操作都以root执行。
- 修改config.ini
比如虚拟机存放目录，ISO文件位置， GI_RU补丁号，dpbp补丁号等
- 执行change.sh
读取config.ini, 根据ISO文件名字判断Linux版本号，比如RHEL9, 则从redhat9_1.model文件建立kickstart使用的redhat.ini, 安装RAC的配置文件setup.ini
- 执行01_create_vm.sh
建立2个实例虚拟机，建立共享盘。root密码为oracle
安装Linux, 完成后自动关闭虚拟机。
- 执行01a_add_sharedisk.sh
把共享盘加到2个虚拟机
- 把如下文件上传到虚拟机1， /stage目录，并解压auto19crac.tar.gz到/stage,执行dos2unix *.sh *.ini
a.oracle db文件
b.oracle grid文件
c.GI_RU 19.27补丁
d. DPBP补丁
e. p35775632补丁。这是RHEL9/OL9安装需要的。
f. OPatch 4 Oracle 19c, 版本 OPATCH_VERSION12.2.0.1.46
g. auto19crac.tar.gz脚本
在安装时， GI_MRP还没有发布，所以没有。
这时DB_MRP已经发布，但是DB_MRP不能用于RAC. 参看： Doc ID 2898740.1。
把 auto19crac.tar.gz 上传到虚拟机2 的/stage目录，并解压到/stage.执行dos2unix *.sh *.ini
在节点1执行脚本03-rpm-user-service-ALL_NODES.sh。 安装需要的rpm包，禁用透明大页。
在节点2 执行脚本03-rpm-user-service-ALL_NODES.sh。 安装需要的rpm包，禁用透明大页。
在节点2执行脚本（注意，节点2先执行）， 04-share-disk-ALL_NODES_NODE2_FIRST.sh
在节点1执行脚本 04-share-disk-ALL_NODES_NODE2_FIRST.sh
在节点2执行脚本05-unzip-grid-db-opatch-update.sh， 建立grid和oracle的目录并授权
在节点1执行脚本05-unzip-grid-db-opatch-update.sh， 建立grid和oracle的目录，解压安装包，耗时10分钟。
在节点1执行脚本06-gi_install.sh ， 安装 集群并打补丁。耗时30分钟。
在执行前，需要去掉oneoff的设置，因为没有GI_MRP
${GI_HOME}/gridSetup.sh -applyRU /stage/patch/${GI_RU}/${GI_RU} -ignorePrereq -waitforcompletion -silent \\
14.在节点1执行脚本07-db_install.sh， 安装数据库软件并打补丁。 耗时40分钟
在执行前需要修改oneoff的设置，因为没有GI_MRP,只有DPBP.
${DB_HOME}/runInstaller -applyRU /stage/patch/${GI_RU}/${GI_RU} -applyOneOffs /stage/patch/${DB_DPBP}/${DB_DPBP} -ignorePrereq -waitforcompletion -silent \\
- 在节点1执行脚本08-crt-diskgroup-data.sh 建立磁盘组。
16.在节点1执行09-createdb.sh 建立数据库。 耗时40分钟。
安装完成检查
[grid@1927c1 ~]$ $ORACLE_HOME/OPatch/opatch lspatches
37762426;TOMCAT RELEASE UPDATE 19.0.0.0.0 (37762426)
37654975;OCW RELEASE UPDATE 19.27.0.0.0 (37654975)
37643161;ACFS RELEASE UPDATE 19.27.0.0.0 (37643161)
37642901;Database Release Update : 19.27.0.0.250415 (37642901)
36758186;DBWLM RELEASE UPDATE 19.0.0.0.0 (36758186)
OPatch succeeded.
[oracle@1927c1 ~]$ $ORACLE_HOME/OPatch/opatch lspatches
37777295;DATAPUMP BUNDLE PATCH 19.27.0.0.0
37654975;OCW RELEASE UPDATE 19.27.0.0.0 (37654975)
37642901;Database Release Update : 19.27.0.0.250415 (37642901)
OPatch succeeded.
[grid@1927c1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE 1927c1 STABLE
ora.chad
ONLINE ONLINE 1927c1 STABLE
ora.net1.network
ONLINE ONLINE 1927c1 STABLE
ora.ons
ONLINE ONLINE 1927c1 STABLE
ora.proxy_advm
OFFLINE OFFLINE 1927c1 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.1927c1.vip
1 ONLINE ONLINE 1927c1 STABLE
ora.1927c2.vip
1 ONLINE INTERMEDIATE 1927c1 FAILED OVER,STABLE
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE 1927c1 STABLE
2 ONLINE OFFLINE STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE ONLINE 1927c1 STABLE
2 OFFLINE OFFLINE STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE 1927c1 STABLE
ora.OCR.dg(ora.asmgroup)
1 ONLINE ONLINE 1927c1 STABLE
2 OFFLINE OFFLINE STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE 1927c1 Started,STABLE
2 ONLINE OFFLINE STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE 1927c1 STABLE
2 ONLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE 1927c1 STABLE
ora.o19.db
1 ONLINE ONLINE 1927c1 Open,HOME=/u01/app/o
racle/product/19.0.0
/dbhome_1,STABLE
2 ONLINE OFFLINE STABLE
ora.qosmserver
1 ONLINE ONLINE 1927c1 STABLE
ora.scan1.vip
1 ONLINE ONLINE 1927c1 STABLE
--------------------------------------------------------------------------------[grid@1927c1 ~]$ $ORACLE_HOME/OPatch/opatch lspatches
37762426;TOMCAT RELEASE UPDATE 19.0.0.0.0 (37762426)
37654975;OCW RELEASE UPDATE 19.27.0.0.0 (37654975)
37643161;ACFS RELEASE UPDATE 19.27.0.0.0 (37643161)
37642901;Database Release Update : 19.27.0.0.250415 (37642901)
36758186;DBWLM RELEASE UPDATE 19.0.0.0.0 (36758186)
OPatch succeeded.
[oracle@1927c1 ~]$ $ORACLE_HOME/OPatch/opatch lspatches
37777295;DATAPUMP BUNDLE PATCH 19.27.0.0.0
37654975;OCW RELEASE UPDATE 19.27.0.0.0 (37654975)
37642901;Database Release Update : 19.27.0.0.250415 (37642901)
OPatch succeeded.
[grid@1927c1 ~]$ free -h
total used free shared buff/cache available
Mem: 7.3Gi 6.0Gi 234Mi 2.6Gi 4.1Gi 1.3Gi
Swap: 4.0Gi 237Mi 3.8Gi
[grid@1927c1 ~]$ uname -r
5.15.0-205.149.5.1.el9uek.x86_64
[grid@1927c1 ~]$ uname -a
Linux 1927c1 5.15.0-205.149.5.1.el9uek.x86_64 #2 SMP Fri Apr 5 11:29:36 PDT 2024 x86_64 x86_64 x86_64 GNU/Linux
安装脚本
https://github.com/liyuefu/auto19crac/
配置文件
安装时19.27刚发布，19.27 GI MRP还没有发布。所以没有设置。
config.ini
nome@manjaro:~/workdir/create_19crac$ cat config.ini
#ISO_FILE=/home/nome/software/opensource/rhel-server-7.9-x86_64-dvd.iso
#ISO_FILE=/home/nome/software/opensource/rhel-8.9-x86_64-dvd.iso
#ISO_FILE=/home/nome/software/opensource/rhel-8.10-x86_64-dvd.iso
ISO_FILE=/home/nome/software/opensource/OracleLinux-R9-U4-x86_64-dvd.iso
VM_BIN=/usr/bin/virtualbox
VM_DATA=/home/nome/work/vm
NODE1_NAME=1927c1
NODE2_NAME=1927c2
NODE1_IP=192.168.56.181
NODE2_IP=192.168.56.182
NODE_VIP1=192.168.56.183
NODE_VIP2=192.168.56.184
RAC_SCAN_IP=192.168.56.185
GROUP_NAME=19c27-ol94
SOFT_PATH=/home/nome/software/19crac_software/19.27_patch
DB_NAME=o19
#19.19
# GI_RU=35037840
# GI_MRP=35869815
# DB_DPBP=35261302
#19.23
#GI_RU=36233126
#GI_MRP=36779399
#DB_DPBP=36420641
#
#19.27
GI_RU=37641958
GI_MRP=
DB_DPBP=37777295
错误和处理
01_create_vm.sh 错误
nome@manjaro:~/workdir/create_19crac$ ./01_create_vm.sh
Virtual machine '1927c1' is created and registered.
UUID: b3be17a3-f0c3-4aad-a00f-691e5130e95f
Settings file: '/home/nome/work/vm/19c27-ol94/1927c1/1927c1.vbox'
0%...10%...20%...30%...40%...50%...60%...70%...80%...90%...100%
Medium created. UUID: 023017c3-0903-432c-b04b-786d1d3aad75
VBoxManage: info: Preparing unattended installation of RedHat_64 in machine '1927c1' (b3be17a3-f0c3-4aad-a00f-691e5130e95f).
VBoxManage: error: Empty user password is not allowed
VBoxManage: error: Details: code NS_ERROR_INVALID_ARG (0x80070057), component UnattendedWrap, interface IUnattended, callee nsISupports
VBoxManage: error: Context: "Prepare()" at line 2571 of file VBoxManageMisc.cpp
Virtual machine '1927c2' is created and registered.
UUID: 0a4bd0a3-dd06-4557/01_create_vm.sh-a882-ee6493143a11
Settings file: '/home/nome/work/vm/19c27-ol94/1927c2/1927c2.vbox'
0%...10%...20%...30%...40%...50%...60%...70%...80%...90%...100%
Medium created. UUID: 10f334c3-8821-4d06-80d2-f41749ecab30
VBoxManage: info: Preparing unattended installation of RedHat_64 in machine '1927c2' (0a4bd0a3-dd06-4557-a882-ee6493143a11).
VBoxManage: error: Empty user password is not allowed
VBoxManage: error: Details: code NS_ERROR_INVALID_ARG (0x80070057), component UnattendedWrap, interface IUnattended, callee nsISupports
VBoxManage: error: Context: "Prepare()" at line 2571 of file VBoxManageMisc.cpp
0%...10%...20%...30%...40%...50%...60%...70%...80%...90%...100%
Medium created. UUID: 07a3ae64-1f20-482c-b992-fbc08dcc86ea
0%...10%...20%...30%...40%...50%...60%...70%...80%...90%...100%
Medium created. UUID: 1e811462-cf7f-4a79-b20e-69265f38919a
0%...10%...20%...30%...40%...50%...60%...70%...80%...90%...100%
Medium created. UUID: 5a0f39b4-c3fd-4818-870b-7f8ff722c5ca
Waiting for VM "1927c1" to power on...
VM "1927c1" has been successfully started.
Waiting for VM "1927c2" to power on...
VM "1927c2" has been successfully started.
分析
可能是升级了virtualbox后导致。前面安装19.24时没有报错。
查看帮助
nome@manjaro:~/workdir/create_19crac$ vboxmanage install -help
找到设置user和password的例子。
后来确认是virtualbox升级到了最新版本。
解决：
vboxmanage 加入参数
–user=“vboxuser” --user-password=“Welcome1”
nome@manjaro:~/workdir/create_19crac$ cat 01_create_vm.model |grep user
VBoxManage unattended install "$var_nodename1" --iso "$var_iso" --package-selection-adjustment "minimal" --script-template="redhat1.ini" --time-zone="Australia/Sydney" --user="vboxuser" --user-password="Welcome1"
VBoxManage unattended install "$var_nodename2" --iso "$var_iso" --package-selection-adjustment "minimal" --script-template="redhat2.ini" --time-zone="Australia/Sydney" --user="vboxuser" --user-password="Welcome1"
安装GI时报错
NAME="Oracle Linux Server"
[INS-32851] A path was provided empty for the (-applyOneOffs) argument value. Provide the complete absolute paths of the patches separated by comma
分析： applyOneOffs 后面没有跟任何参数。 这时应该去掉这个选项。
安装GI时异常退出
但是提示的grid的/u01/app/19.0.0/grid/cfgtoollogs/下的子目录（没有记录）并不存在。没有其他错误。
后来发现是使用的opatch是x86,而不是x86-64. 替换为正确版本后正常。
安装DB时异常推出
因为RAC的GI和DB只能安装GI_MRP, DB_MRP不能给RAC的DB安装。
当没有GI_MRP时，可能有DB_MRP,这时执行07脚本安装数据库软件时，也不能使用DB_MRP,因为这不是给RAC使用的。
Starting in February 2023, MRPs are delivered separately for Single
Instance DB (SIDB) installs and RAC installs. The 19c DB MRPs, which
include DB/ASM fixes cumulatively, are to be applied to SIDB installs.
Whereas, the 19c GI MRPs (system patches), which include DB and
OCW/ACFS/A SM fixes cumulatively, are to be applied to RAC
installs that have DB and GI homes.
参看：
Introducing Monthly Recommended Patches (MRPs) and FAQ (Doc ID 2898740.1)