前言
通常我们DBA去部署一套RAC，操作系统和共享存储会配好，存储方便基本都是多路径，多路径软件建议部署存储厂商的多路径软件，例如EMC的Powerpath，华为的Ultrapath等，当然也可以安装第三方多路径软件，例如红帽的Multipath。所以对磁盘的使用是多路径软件汇聚出来的盘符。
Note：共享存储模拟，可以参考我前面的写的openfiler，https://www.modb.pro/db/84359
环境信息：
操作系统：Oracle linux 7.8
数据库版本：19.3
一、操作系统配置
1、关闭selinux
vi /etc/selinux/config ... SELINUX=disabled ...复制
Note：需要重启操作系统
2、配置好主机名与域名解析
[root@19c-h1 ~]# cat /etc/hostname 19c-h1 [root@19c-h1 ~]#复制
修改hosts文件
[root@19c-h1 ~]# vi /etc/hosts 172.172.30.161 19c-h1.alinge.com 19c-h1 172.172.30.162 19c-h2.alinge.com 19c-h2 172.172.30.163 19c-h1-vip.alinge.com 19c-h1-vip 172.172.30.164 19c-h2-vip.alinge.com 19c-h2-vip 172.172.30.165 wldb-scan.alinge.com wldb-scan 10.10.10.1 19c-h1-priv.alinge.com 19c-h1-priv 10.10.10.2 19c-h2-priv.alinge.com 19c-h2-priv复制
Note：往往系统工程师交付主机过来主机名是没有配置的。这里采用本地解析的方式，不写域也可以。
3、关闭防火墙
systemctl stop firewalld.service systemctl disable firewalld.service systemctl status firewalld.service复制
4、配置yum源
cd /etc/yum.repos.d/ mkdir bak mv * bak vi server.repo [server] name=rhel7.8 baseurl=file:///mnt enable=1 gpgcheck=0复制
挂盘
[root@19c-h1 ~]# mount /dev/sr0 /mnt mount: /dev/sr0 is write-protected, mounting read-only [root@19c-h1 ~]#复制
5、安装依赖包
yum install -y bc binutils* compat-libcap1* compat-libstdc* elfutils-libelf* elfutils-libelf-devel* fontconfig-devel* glibc* glibc-devel* ksh libaio* libaio-devel* libX11* libXau* libXi* libXtst* libXrender* libXrender-devel* libgcc* libstdc++* libstdc++-devel* libxcb* make net-tools nfs-utils smartmontools sysstat unixODBC gcc gcc-c++ python python-configshell python-rtslib python-six targetcli复制
4、关闭avahi-daemon
systemctl stop avahi-daemon systemctl disable avahi-daemon systemctl status avahi-daemon复制
5、配置NTP
mv /etc/chrony.conf /etc/chrony.conf.org复制
Note：这里无ntp服务器，生产环境建议进行配置
6、修改网络参数
[root@19c-h1 ~]# vi /etc/sysconfig/network NOZEROCONF=yes复制
7、（可选）禁用虚拟网卡
systemctl stop libvirtd systemctl disable libvirtd复制
Note：服务器配置虚拟化的一个桥接网卡，virbr0，用处不大
8、关闭透明大页
[root@19c-h1 ~]# cat /sys/kernel/mm/transparent_hugepage/enabled [always] madvise never Note：状态要改成never [root@19c-h1 ~]# vi /etc/default/grub GRUB_TIMEOUT=5 GRUB_DISTRIBUTOR="$(sed 's, release .*$,,g' /etc/system-release)" GRUB_DEFAULT=saved GRUB_DISABLE_SUBMENU=true GRUB_TERMINAL_OUTPUT="console" GRUB_CMDLINE_LINUX="crashkernel=auto rhgb quiet numa=off transparent_hugepage=never" GRUB_DISABLE_RECOVERY="true" Note：transparent_hugepage=never附加在最后 [root@19c-h1 ~]# grub2-mkconfig -o /boot/grub2/grub.cfg Generating grub configuration file ... Found linux image: /boot/vmlinuz-4.14.35-1902.300.11.el7uek.x86_64 Found initrd image: /boot/initramfs-4.14.35-1902.300.11.el7uek.x86_64.img Found linux image: /boot/vmlinuz-3.10.0-1127.el7.x86_64 Found initrd image: /boot/initramfs-3.10.0-1127.el7.x86_64.img Found linux image: /boot/vmlinuz-0-rescue-30045c81c5f94350aadd5efe9ad1f19f Found initrd image: /boot/initramfs-0-rescue-30045c81c5f94350aadd5efe9ad1f19f.img done [root@19c-h1 ~]# [root@19c-h1 ~]# inti 6 [root@19c-h1 ~]# cat /sys/kernel/mm/transparent_hugepage/enabled always madvise [never] [root@19c-h1 ~]# Note：可以看到状态变为never了。复制
9、配置内核参数
[root@19c-h1 ~]# vi /etc/sysctl.conf fs.file-max = 6815744 kernel.sem = 250 32000 100 128 kernel.shmmni = 4096 kernel.shmall = 1073741824 kernel.shmmax = 4398046511104 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复制
生效
[root@19c-h2 yum.repos.d]# sysctl -p fs.file-max = 6815744 kernel.sem = 250 32000 100 128 kernel.shmmni = 4096 kernel.shmall = 1073741824 kernel.shmmax = 4398046511104 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 [root@19c-h2 yum.repos.d]#复制
Note：可以根据实际情况调优。
10、配置资源限制
[root@19c-h1 ~]# vi /etc/security/limits.conf grid soft nofile 1024 grid hard nofile 65536 grid soft nproc 16384 grid hard nproc 16384 grid soft stack 10240 grid soft memlock 3145728 grid hard memlock 3145728 oracle soft nofile 1024 oracle hard nofile 65536 oracle soft nproc 16384 oracle hard nproc 16384 oracle soft memlock 3145728 oracle hard memlock 3145728 oracle soft stack 10240复制
Note：可以根据实际情况调优。
11、创建用户和组
组：
groupadd -g 54321 oinstall groupadd -g 54322 dba groupadd -g 54323 oper groupadd -g 54324 backupdba groupadd -g 54325 dgdba groupadd -g 54326 kmdba groupadd -g 54327 asmdba groupadd -g 54328 asmoper groupadd -g 54329 asmadmin groupadd -g 54330 racdba复制
用户：
useradd -u 54321 -g oinstall -G dba,oper,backupdba,dgdba,kmdba,asmdba,racdba,asmadmin oracle useradd -u 54322 -g oinstall -G asmdba,asmoper,asmadmin,racdba grid复制
改密码：
passwd oracle passwd grid复制
12、创建目录
mkdir -p /oracle/app/oraInventory mkdir -p /oracle/app/19.0.0/grid mkdir -p /oracle/app/grid mkdir -p /oracle/app/oracle/product/19.0.0/dbhome_1 chown -R grid:oinstall /oracle chown -R oracle:oinstall /oracle/app/oracle chmod -R 775 /oracle复制
13、配置用户环境变量
grid用户
umask 022 export PATH=/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin export LD_LIBRARY_PATH=/usr/lib:/usr/X11R6/lib export ORACLE_SID=+ASM1 export ORACLE_BASE=/oracle/app/grid export ORACLE_HOME=/oracle/app/19.0.0/grid export LD_LIBRARY_PATH=$ORACLE_HOME/rdbms/lib:$ORACLE_HOME/lib:$LD_LIBRARY_PATH export PATH=$ORACLE_HOME/bin:$PATH复制
oracle用户
umask 022 export PATH=/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin export LD_LIBRARY_PATH=/usr/lib:/usr/X11R6/lib export ORACLE_BASE=/oracle/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/19.0.0/dbhome_1 export ORACLE_SID=wldb1 export ORACLE_UNQNAME=wldb export LD_LIBRARY_PATH=$ORACLE_HOME/rdbms/lib:$ORACLE_HOME/lib:$LD_LIBRARY_PATH export PATH=$ORACLE_HOME/bin:$PATH复制
14、UDEV绑定asm磁盘
规则生成
for i in b c d e f g ; do echo "KERNEL==\"sd*\", SUBSYSTEM==\"block\", PROGRAM==\"/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/\$name\", RESULT==\"`/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/sd$i`\", SYMLINK+=\"asm_disk$i\", OWNER=\"grid\", GROUP=\"asmadmin\", MODE=\"0660\"" done复制
Note：写法很多，萝卜青菜各有所爱。
编辑规则文件
vi /etc/udev/rules.d/99-oracle-asmdevices.rules
KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="14f504e46494c45524c347234514c2d424e77742d5762374f", SYMLINK+="asm_vote01", OWNER="grid", GROUP="asmadmin", MODE="0660" KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="14f504e46494c45525735446651542d367170502d70386255", SYMLINK+="asm_vote02", OWNER="grid", GROUP="asmadmin", MODE="0660" KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="14f504e46494c45527953307075692d304152612d4d386550", SYMLINK+="asm_vote03", OWNER="grid", GROUP="asmadmin", MODE="0660" KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="14f504e46494c4552584f536353672d7432654c2d7a317777", SYMLINK+="asm_arch01", OWNER="grid", GROUP="asmadmin", MODE="0660" KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="14f504e46494c4552584f745769682d4e74534f2d45596a69", SYMLINK+="asm_data01", OWNER="grid", GROUP="asmadmin", MODE="0660"复制
Note：修改下磁盘名称，容易辨认。
启动
[root@19c-h2 ~]# systemctl restart systemd-udev-trigger.service [root@19c-h2 ~]# [root@19c-h2 ~]# 查看 [root@19c-h1 ~]# ll /dev/asm* lrwxrwxrwx 1 root root 3 Jul 15 22:20 /dev/asm_arch01 -> sde lrwxrwxrwx 1 root root 3 Jul 15 22:20 /dev/asm_data01 -> sdf lrwxrwxrwx 1 root root 3 Jul 15 22:20 /dev/asm_vote01 -> sdb lrwxrwxrwx 1 root root 3 Jul 15 22:10 /dev/asm_vote02 -> sdc lrwxrwxrwx 1 root root 3 Jul 15 22:10 /dev/asm_vote03 -> sdd [root@19c-h1 ~]#复制
15、解压安装包
gi软件 [grid@19c-h1 ~]$ ll total 2821472 -rw-r--r--. 1 grid oinstall 2889184573 Jul 15 17:35 LINUX.X64_193000_grid_home.zip [grid@19c-h1 ~]$ [grid@19c-h1 ~]$ unzip -d /oracle/app/19.0.0/grid/ LINUX.X64_193000_grid_home.zip db软件 [oracle@19c-h1 ~]$ ll total 2987996 -rw-r--r--. 1 oracle oinstall 3059705302 Jul 15 17:35 LINUX.X64_193000_db_home.zip [oracle@19c-h1 ~]$ [oracle@19c-h1 ~]$ unzip -d /oracle/app/oracle/product/19.0.0/dbhome_1/ LINUX.X64_193000_db_home.zip复制
Note：解压就是软件的home目录
16、配置SSH免密
grid用户 $ORACLE_HOME/oui/prov/resources/scripts/sshUserSetup.sh -user grid -hosts "19c-h1 19c-h2" -advanced -noPromptPassphrase oracle用户 $ORACLE_HOME/oui/prov/resources/scripts/sshUserSetup.sh -user oracle -hosts "19c-h1 19c-h2" -advanced -noPromptPassphrase复制
Note：输入yes，输入4次密码即可。
二、GI软件安装
1、校验与修复
[grid@19c-h1 ~]$ cd $ORACLE_HOME [grid@19c-h1 ~]$ ./runcluvfy.sh stage -pre crsinst -n 19c-h1,19c-h2 -verbose -fixup复制
修复
[root@19c-h1 ~]# /tmp/CVU_19.0.0.0.0_grid/runfixup.sh All Fix-up operations were completed successfully. [root@19c-h2 ~]# /tmp/CVU_19.0.0.0.0_grid/runfixup.sh All Fix-up operations were completed successfully.复制
再次校验
[grid@19c-h1 grid]$ ./runcluvfy.sh stage -pre crsinst -n 19c-h1,19c-h2 -verbose Verifying Physical Memory ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- 19c-h2 7.7565GB (8133276.0KB) 8GB (8388608.0KB) passed 19c-h1 7.7565GB (8133268.0KB) 8GB (8388608.0KB) passed Verifying Physical Memory ...PASSED Verifying Available Physical Memory ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- 19c-h2 7.2417GB (7593476.0KB) 50MB (51200.0KB) passed 19c-h1 6.8663GB (7199848.0KB) 50MB (51200.0KB) passed Verifying Available Physical Memory ...PASSED Verifying Swap Size ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- 19c-h2 17GB (1.7825788E7KB) 7.7565GB (8133276.0KB) passed 19c-h1 17GB (1.7825788E7KB) 7.7565GB (8133268.0KB) passed Verifying Swap Size ...PASSED Verifying Free Space: 19c-h2:/usr,19c-h2:/var,19c-h2:/etc,19c-h2:/sbin,19c-h2:/tmp ... Path Node Name Mount point Available Required Status ---------------- ------------ ------------ ------------ ------------ ------------ /usr 19c-h2 / 82.0557GB 25MB passed /var 19c-h2 / 82.0557GB 5MB passed /etc 19c-h2 / 82.0557GB 25MB passed /sbin 19c-h2 / 82.0557GB 10MB passed /tmp 19c-h2 / 82.0557GB 1GB passed Verifying Free Space: 19c-h2:/usr,19c-h2:/var,19c-h2:/etc,19c-h2:/sbin,19c-h2:/tmp ...PASSED Verifying Free Space: 19c-h1:/usr,19c-h1:/var,19c-h1:/etc,19c-h1:/sbin,19c-h1:/tmp ... Path Node Name Mount point Available Required Status ---------------- ------------ ------------ ------------ ------------ ------------ /usr 19c-h1 / 63.206GB 25MB passed /var 19c-h1 / 63.206GB 5MB passed /etc 19c-h1 / 63.206GB 25MB passed /sbin 19c-h1 / 63.206GB 10MB passed /tmp 19c-h1 / 63.206GB 1GB passed Verifying Free Space: 19c-h1:/usr,19c-h1:/var,19c-h1:/etc,19c-h1:/sbin,19c-h1:/tmp ...PASSED Verifying User Existence: grid ... Node Name Status Comment ------------ ------------------------ ------------------------ 19c-h2 passed exists(54322) 19c-h1 passed exists(54322) Verifying Users With Same UID: 54322 ...PASSED Verifying User Existence: grid ...PASSED Verifying Group Existence: asmadmin ... Node Name Status Comment ------------ ------------------------ ------------------------ 19c-h2 passed exists 19c-h1 passed exists Verifying Group Existence: asmadmin ...PASSED Verifying Group Existence: asmdba ... Node Name Status Comment ------------ ------------------------ ------------------------ 19c-h2 passed exists 19c-h1 passed exists Verifying Group Existence: asmdba ...PASSED Verifying Group Existence: oinstall ... Node Name Status Comment ------------ ------------------------ ------------------------ 19c-h2 passed exists 19c-h1 passed exists Verifying Group Existence: oinstall ...PASSED Verifying Group Membership: asmdba ... Node Name User Exists Group Exists User in Group Status ---------------- ------------ ------------ ------------ ---------------- 19c-h2 yes yes yes passed 19c-h1 yes yes yes passed Verifying Group Membership: asmdba ...PASSED Verifying Group Membership: asmadmin ... Node Name User Exists Group Exists User in Group Status ---------------- ------------ ------------ ------------ ---------------- 19c-h2 yes yes yes passed 19c-h1 yes yes yes passed Verifying Group Membership: asmadmin ...PASSED Verifying Group Membership: oinstall(Primary) ... Node Name User Exists Group Exists User in Group Primary Status ---------------- ------------ ------------ ------------ ------------ ------------ 19c-h2 yes yes yes yes passed 19c-h1 yes yes yes yes passed Verifying Group Membership: oinstall(Primary) ...PASSED Verifying Run Level ... Node Name run level Required Status ------------ ------------------------ ------------------------ ---------- 19c-h2 5 3,5 passed 19c-h1 5 3,5 passed Verifying Run Level ...PASSED Verifying Hard Limit: maximum open file descriptors ... Node Name Type Available Required Status ---------------- ------------ ------------ ------------ ---------------- 19c-h2 hard 65536 65536 passed 19c-h1 hard 65536 65536 passed Verifying Hard Limit: maximum open file descriptors ...PASSED Verifying Soft Limit: maximum open file descriptors ... Node Name Type Available Required Status ---------------- ------------ ------------ ------------ ---------------- 19c-h2 soft 1024 1024 passed 19c-h1 soft 1024 1024 passed Verifying Soft Limit: maximum open file descriptors ...PASSED Verifying Hard Limit: maximum user processes ... Node Name Type Available Required Status ---------------- ------------ ------------ ------------ ---------------- 19c-h2 hard 16384 16384 passed 19c-h1 hard 16384 16384 passed Verifying Hard Limit: maximum user processes ...PASSED Verifying Soft Limit: maximum user processes ... Node Name Type Available Required Status ---------------- ------------ ------------ ------------ ---------------- 19c-h2 soft 16384 2047 passed 19c-h1 soft 16384 2047 passed Verifying Soft Limit: maximum user processes ...PASSED Verifying Soft Limit: maximum stack size ... Node Name Type Available Required Status ---------------- ------------ ------------ ------------ ---------------- 19c-h2 soft 10240 10240 passed 19c-h1 soft 10240 10240 passed Verifying Soft Limit: maximum stack size ...PASSED Verifying Architecture ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- 19c-h2 x86_64 x86_64 passed 19c-h1 x86_64 x86_64 passed Verifying Architecture ...PASSED Verifying OS Kernel Version ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- 19c-h2 4.14.35-1902.300.11.el7uek.x86_64 4.1.12 passed 19c-h1 4.14.35-1902.300.11.el7uek.x86_64 4.1.12 passed Verifying OS Kernel Version ...PASSED Verifying OS Kernel Parameter: semmsl ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ 19c-h1 250 250 250 passed 19c-h2 250 250 250 passed Verifying OS Kernel Parameter: semmsl ...PASSED Verifying OS Kernel Parameter: semmns ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ 19c-h1 32000 32000 32000 passed 19c-h2 32000 32000 32000 passed Verifying OS Kernel Parameter: semmns ...PASSED Verifying OS Kernel Parameter: semopm ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ 19c-h1 100 100 100 passed 19c-h2 100 100 100 passed Verifying OS Kernel Parameter: semopm ...PASSED Verifying OS Kernel Parameter: semmni ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ 19c-h1 128 128 128 passed 19c-h2 128 128 128 passed Verifying OS Kernel Parameter: semmni ...PASSED Verifying OS Kernel Parameter: shmmax ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ 19c-h1 4398046511104 4398046511104 4164233216 passed 19c-h2 4398046511104 4398046511104 4164237312 passed Verifying OS Kernel Parameter: shmmax ...PASSED Verifying OS Kernel Parameter: shmmni ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ 19c-h1 4096 4096 4096 passed 19c-h2 4096 4096 4096 passed Verifying OS Kernel Parameter: shmmni ...PASSED Verifying OS Kernel Parameter: shmall ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ 19c-h1 1073741824 1073741824 1073741824 passed 19c-h2 1073741824 1073741824 1073741824 passed Verifying OS Kernel Parameter: shmall ...PASSED Verifying OS Kernel Parameter: file-max ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ 19c-h1 6815744 6815744 6815744 passed 19c-h2 6815744 6815744 6815744 passed Verifying OS Kernel Parameter: file-max ...PASSED Verifying OS Kernel Parameter: ip_local_port_range ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ 19c-h1 between 9000 & 65500 between 9000 & 65500 between 9000 & 65535 passed 19c-h2 between 9000 & 65500 between 9000 & 65500 between 9000 & 65535 passed Verifying OS Kernel Parameter: ip_local_port_range ...PASSED Verifying OS Kernel Parameter: rmem_default ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ 19c-h1 262144 262144 262144 passed 19c-h2 262144 262144 262144 passed Verifying OS Kernel Parameter: rmem_default ...PASSED Verifying OS Kernel Parameter: rmem_max ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ 19c-h1 4194304 4194304 4194304 passed 19c-h2 4194304 4194304 4194304 passed Verifying OS Kernel Parameter: rmem_max ...PASSED Verifying OS Kernel Parameter: wmem_default ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ 19c-h1 262144 262144 262144 passed 19c-h2 262144 262144 262144 passed Verifying OS Kernel Parameter: wmem_default ...PASSED Verifying OS Kernel Parameter: wmem_max ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ 19c-h1 1048576 1048576 1048576 passed 19c-h2 1048576 1048576 1048576 passed Verifying OS Kernel Parameter: wmem_max ...PASSED Verifying OS Kernel Parameter: aio-max-nr ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ 19c-h1 1048576 1048576 1048576 passed 19c-h2 1048576 1048576 1048576 passed Verifying OS Kernel Parameter: aio-max-nr ...PASSED Verifying OS Kernel Parameter: panic_on_oops ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ 19c-h1 1 1 1 passed 19c-h2 1 1 1 passed Verifying OS Kernel Parameter: panic_on_oops ...PASSED Verifying Package: kmod-20-21 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- 19c-h2 kmod(x86_64)-20-28.0.1.el7 kmod(x86_64)-20-21 passed 19c-h1 kmod(x86_64)-20-28.0.1.el7 kmod(x86_64)-20-21 passed Verifying Package: kmod-20-21 (x86_64) ...PASSED Verifying Package: kmod-libs-20-21 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- 19c-h2 kmod-libs(x86_64)-20-28.0.1.el7 kmod-libs(x86_64)-20-21 passed 19c-h1 kmod-libs(x86_64)-20-28.0.1.el7 kmod-libs(x86_64)-20-21 passed Verifying Package: kmod-libs-20-21 (x86_64) ...PASSED Verifying Package: binutils-2.23.52.0.1 ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- 19c-h2 binutils-2.27-43.base.0.1.el7 binutils-2.23.52.0.1 passed 19c-h1 binutils-2.27-43.base.0.1.el7 binutils-2.23.52.0.1 passed Verifying Package: binutils-2.23.52.0.1 ...PASSED Verifying Package: compat-libcap1-1.10 ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- 19c-h2 compat-libcap1-1.10-7.el7 compat-libcap1-1.10 passed 19c-h1 compat-libcap1-1.10-7.el7 compat-libcap1-1.10 passed Verifying Package: compat-libcap1-1.10 ...PASSED Verifying Package: libgcc-4.8.2 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- 19c-h2 libgcc(x86_64)-4.8.5-39.0.3.el7 libgcc(x86_64)-4.8.2 passed 19c-h1 libgcc(x86_64)-4.8.5-39.0.3.el7 libgcc(x86_64)-4.8.2 passed Verifying Package: libgcc-4.8.2 (x86_64) ...PASSED Verifying Package: libstdc++-4.8.2 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- 19c-h2 libstdc++(x86_64)-4.8.5-39.0.3.el7 libstdc++(x86_64)-4.8.2 passed 19c-h1 libstdc++(x86_64)-4.8.5-39.0.3.el7 libstdc++(x86_64)-4.8.2 passed Verifying Package: libstdc++-4.8.2 (x86_64) ...PASSED Verifying Package: libstdc++-devel-4.8.2 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- 19c-h2 libstdc++-devel(x86_64)-4.8.5-39.0.3.el7 libstdc++-devel(x86_64)-4.8.2 passed 19c-h1 libstdc++-devel(x86_64)-4.8.5-39.0.3.el7 libstdc++-devel(x86_64)-4.8.2 passed Verifying Package: libstdc++-devel-4.8.2 (x86_64) ...PASSED Verifying Package: sysstat-10.1.5 ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- 19c-h2 sysstat-10.1.5-19.el7 sysstat-10.1.5 passed 19c-h1 sysstat-10.1.5-19.el7 sysstat-10.1.5 passed Verifying Package: sysstat-10.1.5 ...PASSED Verifying Package: ksh ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- 19c-h2 ksh ksh passed 19c-h1 ksh ksh passed Verifying Package: ksh ...PASSED Verifying Package: make-3.82 ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- 19c-h2 make-3.82-24.el7 make-3.82 passed 19c-h1 make-3.82-24.el7 make-3.82 passed Verifying Package: make-3.82 ...PASSED Verifying Package: glibc-2.17 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- 19c-h2 glibc(x86_64)-2.17-307.0.1.el7.1 glibc(x86_64)-2.17 passed 19c-h1 glibc(x86_64)-2.17-307.0.1.el7.1 glibc(x86_64)-2.17 passed Verifying Package: glibc-2.17 (x86_64) ...PASSED Verifying Package: glibc-devel-2.17 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- 19c-h2 glibc-devel(x86_64)-2.17-307.0.1.el7.1 glibc-devel(x86_64)-2.17 passed 19c-h1 glibc-devel(x86_64)-2.17-307.0.1.el7.1 glibc-devel(x86_64)-2.17 passed Verifying Package: glibc-devel-2.17 (x86_64) ...PASSED Verifying Package: libaio-0.3.109 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- 19c-h2 libaio(x86_64)-0.3.109-13.el7 libaio(x86_64)-0.3.109 passed 19c-h1 libaio(x86_64)-0.3.109-13.el7 libaio(x86_64)-0.3.109 passed Verifying Package: libaio-0.3.109 (x86_64) ...PASSED Verifying Package: libaio-devel-0.3.109 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- 19c-h2 libaio-devel(x86_64)-0.3.109-13.el7 libaio-devel(x86_64)-0.3.109 passed 19c-h1 libaio-devel(x86_64)-0.3.109-13.el7 libaio-devel(x86_64)-0.3.109 passed Verifying Package: libaio-devel-0.3.109 (x86_64) ...PASSED Verifying Package: nfs-utils-1.2.3-15 ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- 19c-h2 nfs-utils-1.3.0-0.66.0.1.el7 nfs-utils-1.2.3-15 passed 19c-h1 nfs-utils-1.3.0-0.66.0.1.el7 nfs-utils-1.2.3-15 passed Verifying Package: nfs-utils-1.2.3-15 ...PASSED Verifying Package: smartmontools-6.2-4 ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- 19c-h2 smartmontools-7.0-2.el7 smartmontools-6.2-4 passed 19c-h1 smartmontools-7.0-2.el7 smartmontools-6.2-4 passed Verifying Package: smartmontools-6.2-4 ...PASSED Verifying Package: net-tools-2.0-0.17 ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- 19c-h2 net-tools-2.0-0.25.20131004git.el7 net-tools-2.0-0.17 passed 19c-h1 net-tools-2.0-0.25.20131004git.el7 net-tools-2.0-0.17 passed Verifying Package: net-tools-2.0-0.17 ...PASSED Verifying Port Availability for component "Oracle Notification Service (ONS)" ... Node Name Port Number Protocol Available Status ---------------- ------------ ------------ ------------ ---------------- 19c-h2 6200 TCP yes successful 19c-h1 6200 TCP yes successful 19c-h2 6100 TCP yes successful 19c-h1 6100 TCP yes successful Verifying Port Availability for component "Oracle Notification Service (ONS)" ...PASSED Verifying Port Availability for component "Oracle Cluster Synchronization Services (CSSD)" ... Node Name Port Number Protocol Available Status ---------------- ------------ ------------ ------------ ---------------- 19c-h2 42424 TCP yes successful 19c-h1 42424 TCP yes successful Verifying Port Availability for component "Oracle Cluster Synchronization Services (CSSD)" ...PASSED Verifying Users With Same UID: 0 ...PASSED Verifying Current Group ID ...PASSED Verifying Root user consistency ... Node Name Status ------------------------------------ ------------------------ 19c-h2 passed 19c-h1 passed Verifying Root user consistency ...PASSED Verifying Package: cvuqdisk-1.0.10-1 ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- 19c-h2 cvuqdisk-1.0.10-1 cvuqdisk-1.0.10-1 passed 19c-h1 cvuqdisk-1.0.10-1 cvuqdisk-1.0.10-1 passed Verifying Package: cvuqdisk-1.0.10-1 ...PASSED Verifying Host name ...PASSED Verifying Node Connectivity ... Verifying Hosts File ... Node Name Status ------------------------------------ ------------------------ 19c-h1 passed 19c-h2 passed Verifying Hosts File ...PASSED Interface information for node "19c-h2" Name IP Address Subnet Gateway Def. Gateway HW Address MTU ------ --------------- --------------- --------------- --------------- ----------------- ------ ens32 172.172.30.162 172.172.30.0 0.0.0.0 172.172.30.254 00:0C:29:20:BF:7D 1500 ens33 10.10.10.2 10.10.10.0 0.0.0.0 172.172.30.254 00:0C:29:20:BF:87 1500 Interface information for node "19c-h1" Name IP Address Subnet Gateway Def. Gateway HW Address MTU ------ --------------- --------------- --------------- --------------- ----------------- ------ ens32 172.172.30.161 172.172.30.0 0.0.0.0 172.172.30.254 00:0C:29:B4:6A:41 1500 ens33 10.10.10.1 10.10.10.0 0.0.0.0 172.172.30.254 00:0C:29:B4:6A:4B 1500 Check: MTU consistency of the subnet "10.10.10.0". Node Name IP Address Subnet MTU ---------------- ------------ ------------ ------------ ---------------- 19c-h2 ens33 10.10.10.2 10.10.10.0 1500 19c-h1 ens33 10.10.10.1 10.10.10.0 1500 Check: MTU consistency of the subnet "172.172.30.0". Node Name IP Address Subnet MTU ---------------- ------------ ------------ ------------ ---------------- 19c-h2 ens32 172.172.30.162 172.172.30.0 1500 19c-h1 ens32 172.172.30.161 172.172.30.0 1500 Verifying Check that maximum (MTU) size packet goes through subnet ...PASSED Source Destination Connected? ------------------------------ ------------------------------ ---------------- 19c-h1[ens33:10.10.10.1] 19c-h2[ens33:10.10.10.2] yes Source Destination Connected? ------------------------------ ------------------------------ ---------------- 19c-h1[ens32:172.172.30.161] 19c-h2[ens32:172.172.30.162] yes Verifying subnet mask consistency for subnet "10.10.10.0" ...PASSED Verifying subnet mask consistency for subnet "172.172.30.0" ...PASSED Verifying Node Connectivity ...PASSED Verifying Multicast or broadcast check ... Checking subnet "10.10.10.0" for multicast communication with multicast group "224.0.0.251" Verifying Multicast or broadcast check ...PASSED Verifying Network Time Protocol (NTP) ...PASSED Verifying Same core file name pattern ...PASSED Verifying User Mask ... Node Name Available Required Comment ------------ ------------------------ ------------------------ ---------- 19c-h2 0022 0022 passed 19c-h1 0022 0022 passed Verifying User Mask ...PASSED Verifying User Not In Group "root": grid ... Node Name Status Comment ------------ ------------------------ ------------------------ 19c-h2 passed does not exist 19c-h1 passed does not exist Verifying User Not In Group "root": grid ...PASSED Verifying Time zone consistency ...PASSED Verifying Time offset between nodes ...PASSED Verifying resolv.conf Integrity ...FAILED (PRVG-13159) Verifying DNS/NIS name service ...PASSED Verifying Domain Sockets ...PASSED Verifying /boot mount ...PASSED Verifying Daemon "avahi-daemon" not configured and running ... Node Name Configured Status ------------ ------------------------ ------------------------ 19c-h2 no passed 19c-h1 no passed Node Name Running? Status ------------ ------------------------ ------------------------ 19c-h2 no passed 19c-h1 no passed Verifying Daemon "avahi-daemon" not configured and running ...PASSED Verifying Daemon "proxyt" not configured and running ... Node Name Configured Status ------------ ------------------------ ------------------------ 19c-h2 no passed 19c-h1 no passed Node Name Running? Status ------------ ------------------------ ------------------------ 19c-h2 no passed 19c-h1 no passed Verifying Daemon "proxyt" not configured and running ...PASSED Verifying User Equivalence ...PASSED Verifying RPM Package Manager database ...INFORMATION (PRVG-11250) Verifying /dev/shm mounted as temporary file system ...PASSED Verifying File system mount options for path /var ...PASSED Verifying DefaultTasksMax parameter ...PASSED Verifying zeroconf check ...PASSED Verifying ASM Filter Driver configuration ...PASSED Verifying Systemd login manager IPC parameter ...PASSED Pre-check for cluster services setup was unsuccessful on all the nodes. Failures were encountered during execution of CVU verification request "stage -pre crsinst". Verifying resolv.conf Integrity ...FAILED 19c-h2: PRVG-13159 : On node "19c-h2" the file "/etc/resolv.conf" could not be parsed because the file is empty. 19c-h1: PRVG-13159 : On node "19c-h1" the file "/etc/resolv.conf" could not be parsed because the file is empty. Verifying RPM Package Manager database ...INFORMATION PRVG-11250 : The check "RPM Package Manager database" was not performed because it needs 'root' user privileges. CVU operation performed: stage -pre crsinst Date: Jul 15, 2021 6:55:06 PM CVU home: /oracle/app/19.0.0/grid/ User: grid [grid@19c-h1 grid]$复制
Note：最后只提示无dns配置的错误，无影响，我们采用本地解析。
2、编辑响应文件
[grid@19c-h1 ~]$ cp /oracle/app/19.0.0/grid/install/response/gridsetup.rsp /home/grid/ [grid@19c-h1 ~]$ vi gridsetup.rsp复制
oracle.install.responseFileVersion=/oracle/install/rspfmt_crsinstall_response_schema_v19.0.0 INVENTORY_LOCATION=/oracle/app/oraInventory oracle.install.option=CRS_CONFIG ORACLE_BASE=/oracle/app/grid oracle.install.asm.OSDBA=asmdba oracle.install.asm.OSOPER=asmoper oracle.install.asm.OSASM=asmadmin oracle.install.crs.config.scanType=LOCAL_SCAN oracle.install.crs.config.SCANClientDataFile= oracle.install.crs.config.gpnp.scanName=wldb-scan.alinge.com oracle.install.crs.config.gpnp.scanPort=1521 oracle.install.crs.config.ClusterConfiguration=STANDALONE oracle.install.crs.config.configureAsExtendedCluster= oracle.install.crs.config.memberClusterManifestFile= oracle.install.crs.config.clusterName=wldb-cluster oracle.install.crs.config.gpnp.configureGNS= oracle.install.crs.config.autoConfigureClusterNodeVIP= oracle.install.crs.config.gpnp.gnsOption= oracle.install.crs.config.gpnp.gnsClientDataFile= oracle.install.crs.config.gpnp.gnsSubDomain= oracle.install.crs.config.gpnp.gnsVIPAddress= oracle.install.crs.config.sites= oracle.install.crs.config.clusterNodes=19c-h1.alinge.com:19c-h1-vip.alinge.com:HUB,19c-h2.alinge.com:19c-h2-vip.alinge.com:HUB oracle.install.crs.config.networkInterfaceList=ens32:172.172.30.0:1,ens33:10.10.10.0:5 oracle.install.crs.configureGIMR=true oracle.install.asm.configureGIMRDataDG=true oracle.install.crs.config.storageOption=FLEX_ASM_STORAGE oracle.install.crs.config.sharedFileSystemStorage.votingDiskLocations= oracle.install.crs.config.sharedFileSystemStorage.ocrLocations= oracle.install.crs.config.useIPMI=false oracle.install.crs.config.ipmi.bmcUsername= oracle.install.crs.config.ipmi.bmcPassword= oracle.install.asm.SYSASMPassword=oracle oracle.install.asm.diskGroup.name=vote oracle.install.asm.diskGroup.redundancy=NORMAL oracle.install.asm.diskGroup.AUSize=4 oracle.install.asm.diskGroup.FailureGroups= oracle.install.asm.diskGroup.disksWithFailureGroupNames= oracle.install.asm.diskGroup.disks=/dev/asm_vote01,/dev/asm_vote02,/dev/asm_vote03 oracle.install.asm.diskGroup.quorumFailureGroupNames= oracle.install.asm.diskGroup.diskDiscoveryString=/dev/asm* oracle.install.asm.monitorPassword=oracle oracle.install.asm.gimrDG.name=DATA oracle.install.asm.gimrDG.redundancy=EXTERNAL oracle.install.asm.gimrDG.AUSize=4 oracle.install.asm.gimrDG.FailureGroups= oracle.install.asm.gimrDG.disksWithFailureGroupNames= oracle.install.asm.gimrDG.disks=/dev/asm_data01 oracle.install.asm.gimrDG.quorumFailureGroupNames= oracle.install.asm.configureAFD=false oracle.install.crs.configureRHPS=false oracle.install.crs.config.ignoreDownNodes=false oracle.install.config.managementOption=NONE oracle.install.config.omsHost= oracle.install.config.omsPort= oracle.install.config.emAdminUser= oracle.install.config.emAdminPassword= oracle.install.crs.rootconfig.executeRootScript=false oracle.install.crs.rootconfig.configMethod= oracle.install.crs.rootconfig.sudoPath= oracle.install.crs.rootconfig.sudoUserName= oracle.install.crs.config.batchinfo= oracle.install.crs.app.applicationAddress= oracle.install.crs.deleteNode.nodes=复制
3、开始安装
[grid@19c-h1 grid]$ ./gridSetup.sh -silent -ignorePrereqFailure -waitForCompletion -responseFile /home/grid/gridsetup.rsp Launching Oracle Grid Infrastructure Setup Wizard... [WARNING] [INS-30011] The SYS password entered does not conform to the Oracle recommended standards. CAUSE: Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. ACTION: Provide a password that conforms to the Oracle recommended standards. [WARNING] [INS-30011] The ASMSNMP password entered does not conform to the Oracle recommended standards. CAUSE: Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. ACTION: Provide a password that conforms to the Oracle recommended standards. [WARNING] [INS-13013] Target environment does not meet some mandatory requirements. CAUSE: Some of the mandatory prerequisites are not met. See logs for details. /tmp/GridSetupActions2021-07-15_07-25-07PM/gridSetupActions2021-07-15_07-25-07PM.log ACTION: Identify the list of failed prerequisite checks from the log: /tmp/GridSetupActions2021-07-15_07-25-07PM/gridSetupActions2021-07-15_07-25-07PM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually. The response file for this session can be found at: /oracle/app/19.0.0/grid/install/response/grid_2021-07-15_07-25-07PM.rsp You can find the log of this install session at: /tmp/GridSetupActions2021-07-15_07-25-07PM/gridSetupActions2021-07-15_07-25-07PM.log As a root user, execute the following script(s): 1. /oracle/app/oraInventory/orainstRoot.sh 2. /oracle/app/19.0.0/grid/root.sh Execute /oracle/app/oraInventory/orainstRoot.sh on the following nodes: [19c-h1, 19c-h2] Execute /oracle/app/19.0.0/grid/root.sh on the following nodes: [19c-h1, 19c-h2] Run the script on the local node first. After successful completion, you can start the script in parallel on all other nodes. Successfully Setup Software with warning(s). As install user, execute the following command to complete the configuration. /oracle/app/19.0.0/grid/gridSetup.sh -executeConfigTools -responseFile /home/grid/gridsetup.rsp [-silent] Moved the install session logs to: /oracle/app/oraInventory/logs/GridSetupActions2021-07-15_07-25-07PM [grid@19c-h1 grid]$复制
4、运行脚本
脚本一： [root@19c-h1 grid]# /oracle/app/oraInventory/orainstRoot.sh Changing permissions of /oracle/app/oraInventory. Adding read,write permissions for group. Removing read,write,execute permissions for world. Changing groupname of /oracle/app/oraInventory to oinstall. The execution of the script is complete. [root@19c-h1 grid]# [root@19c-h2 ~]# /oracle/app/oraInventory/orainstRoot.sh Changing permissions of /oracle/app/oraInventory. Adding read,write permissions for group. Removing read,write,execute permissions for world. Changing groupname of /oracle/app/oraInventory to oinstall. The execution of the script is complete. [root@19c-h2 ~]# 脚本二： [root@19c-h1 ~]# /oracle/app/19.0.0/grid/root.sh Check /oracle/app/19.0.0/grid/install/root_19c-h1_2021-07-15_19-33-35-206950224.log for the output of root script [root@19c-h1 ~]# [root@19c-h1 ~]# tail -f /oracle/app/19.0.0/grid/install/root_19c-h1_2021-07-15_19-33-35-206950224.log 2021/07/15 19:39:41 CLSRSC-594: Executing installation step 18 of 19: 'ConfigNode'. 2021/07/15 19:41:04 CLSRSC-594: Executing installation step 19 of 19: 'PostConfig'. [INFO] [DBT-30001] Disk groups created successfully. Check /oracle/app/grid/cfgtoollogs/asmca/asmca-210715PM074109.log for details. 2021/07/15 19:41:50 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded [root@19c-h2 ~]# /oracle/app/19.0.0/grid/root.sh Check /oracle/app/19.0.0/grid/install/root_19c-h2_2021-07-15_19-43-08-068936322.log for the output of root script [root@19c-h2 ~]# [root@19c-h2 ~]# tail -f /oracle/app/19.0.0/grid/install/root_19c-h2_2021-07-15_19-43-08-068936322.log 2021/07/15 19:45:11 CLSRSC-343: Successfully started Oracle Clusterware stack 2021/07/15 19:45:11 CLSRSC-594: Executing installation step 18 of 19: 'ConfigNode'. 2021/07/15 19:45:26 CLSRSC-594: Executing installation step 19 of 19: 'PostConfig'. 2021/07/15 19:45:32 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded复制
5、最后的配置
[grid@19c-h1 grid]$ /oracle/app/19.0.0/grid/gridSetup.sh -silent -executeConfigTools -responseFile /home/grid/gridsetup.rsp Launching Oracle Grid Infrastructure Setup Wizard... You can find the logs of this session at: /oracle/app/oraInventory/logs/GridSetupActions2021-07-15_07-47-18PM You can find the log of this install session at: /oracle/app/oraInventory/logs/UpdateNodeList2021-07-15_07-47-18PM.log Configuration failed. [WARNING] [INS-43080] Some of the configuration assistants failed, were cancelled or skipped. ACTION: Refer to the logs or contact Oracle Support Services. [grid@19c-h1 grid]$复制
Note：因为前面跳过了DNS错误，所以最后会有警告信息。此步骤前面配置了GIMR所有花费时间会比较久。
6、集群状态查看
[grid@19c-h1 grid]$ crsctl stat res -t -------------------------------------------------------------------------------- Name Target State Server State details -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.LISTENER.lsnr ONLINE ONLINE 19c-h1 STABLE ONLINE ONLINE 19c-h2 STABLE ora.chad ONLINE ONLINE 19c-h1 STABLE ONLINE ONLINE 19c-h2 STABLE ora.net1.network ONLINE ONLINE 19c-h1 STABLE ONLINE ONLINE 19c-h2 STABLE ora.ons ONLINE ONLINE 19c-h1 STABLE ONLINE ONLINE 19c-h2 STABLE -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.19c-h1.vip 1 ONLINE ONLINE 19c-h1 STABLE ora.19c-h2.vip 1 ONLINE ONLINE 19c-h2 STABLE ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup) 1 ONLINE ONLINE 19c-h1 STABLE 2 ONLINE ONLINE 19c-h2 STABLE 3 OFFLINE OFFLINE STABLE ora.DATA.dg(ora.asmgroup) 1 ONLINE ONLINE 19c-h1 STABLE 2 ONLINE ONLINE 19c-h2 STABLE 3 OFFLINE OFFLINE STABLE ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE 19c-h1 STABLE ora.MGMTLSNR 1 ONLINE ONLINE 19c-h1 169.254.1.238 10.10. 10.1,STABLE ora.VOTE.dg(ora.asmgroup) 1 ONLINE ONLINE 19c-h1 STABLE 2 ONLINE ONLINE 19c-h2 STABLE 3 OFFLINE OFFLINE STABLE ora.asm(ora.asmgroup) 1 ONLINE ONLINE 19c-h1 Started,STABLE 2 ONLINE ONLINE 19c-h2 Started,STABLE 3 OFFLINE OFFLINE STABLE ora.asmnet1.asmnetwork(ora.asmgroup) 1 ONLINE ONLINE 19c-h1 STABLE 2 ONLINE ONLINE 19c-h2 STABLE 3 OFFLINE OFFLINE STABLE ora.cvu 1 ONLINE ONLINE 19c-h1 STABLE ora.mgmtdb 1 ONLINE ONLINE 19c-h1 Open,STABLE ora.qosmserver 1 ONLINE ONLINE 19c-h1 STABLE ora.scan1.vip 1 ONLINE ONLINE 19c-h1 STABLE -------------------------------------------------------------------------------- [grid@19c-h1 grid]$复制
三、磁盘组创建
[grid@19c-h1 grid]$ asmca -silent -createDiskGroup -diskGroupName arch -diskList '/dev/asm_arch01' -redundancy EXTERNAL [INFO] [DBT-30001] Disk groups created successfully. Check /oracle/app/grid/cfgtoollogs/asmca/asmca-210715PM082451.log for details. [grid@19c-h1 grid]$复制
Note：前面安装GI配置GIMR，已经创建了data磁盘组。
四、DB软件安装
1、校验
/oracle/app/19.0.0/grid/runcluvfy.sh stage -pre dbinst -n 19c-h1,19c-h2 -verbose复制
Note：GI安装校验过，问题不大，基本会提示SCAN和DNS的问题，可以忽略。
2、编辑响应文件
[oracle@19c-h1 ~]$ cp $ORACLE_HOME/install/response/db_install.rsp /home/oracle [oracle@19c-h1 ~]$ vi db_install.rsp复制
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v19.0.0 oracle.install.option=INSTALL_DB_SWONLY UNIX_GROUP_NAME=oinstall INVENTORY_LOCATION=/oracle/app/oraInventory ORACLE_HOME=/oracle/app/oracle/product/19.0.0/dbhome_1 ORACLE_BASE=/oracle/app/oracle oracle.install.db.InstallEdition=EE oracle.install.db.OSDBA_GROUP=dba oracle.install.db.OSOPER_GROUP=oper oracle.install.db.OSBACKUPDBA_GROUP=backupdba oracle.install.db.OSDGDBA_GROUP=dgdba oracle.install.db.OSKMDBA_GROUP=kmdba oracle.install.db.OSRACDBA_GROUP=racdba oracle.install.db.rootconfig.executeRootScript=false oracle.install.db.rootconfig.configMethod= oracle.install.db.rootconfig.sudoPath= oracle.install.db.rootconfig.sudoUserName= oracle.install.db.CLUSTER_NODES=19c-h1,19c-h2 oracle.install.db.config.starterdb.type= oracle.install.db.config.starterdb.globalDBName= oracle.install.db.config.starterdb.SID= oracle.install.db.ConfigureAsContainerDB= oracle.install.db.config.PDBName= oracle.install.db.config.starterdb.characterSet= oracle.install.db.config.starterdb.memoryOption= oracle.install.db.config.starterdb.memoryLimit= oracle.install.db.config.starterdb.installExampleSchemas= oracle.install.db.config.starterdb.password.ALL= oracle.install.db.config.starterdb.password.SYS= oracle.install.db.config.starterdb.password.SYSTEM= oracle.install.db.config.starterdb.password.DBSNMP= oracle.install.db.config.starterdb.password.PDBADMIN= oracle.install.db.config.starterdb.managementOption= oracle.install.db.config.starterdb.omsHost= oracle.install.db.config.starterdb.omsPort= oracle.install.db.config.starterdb.emAdminUser= oracle.install.db.config.starterdb.emAdminPassword= oracle.install.db.config.starterdb.enableRecovery= oracle.install.db.config.starterdb.storageType= oracle.install.db.config.starterdb.fileSystemStorage.dataLocation= oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation= oracle.install.db.config.asm.diskGroup= oracle.install.db.config.asm.ASMSNMPPassword=复制
3、安装软件
[oracle@19c-h1 dbhome_1]$ ./runInstaller -silent -ignorePrereqFailure -waitForCompletion -responseFile /home/oracle/db_install.rsp Launching Oracle Database Setup Wizard... [WARNING] [INS-13013] Target environment does not meet some mandatory requirements. CAUSE: Some of the mandatory prerequisites are not met. See logs for details. /oracle/app/oraInventory/logs/InstallActions2021-07-15_08-36-43PM/installActions2021-07-15_08-36-43PM.log ACTION: Identify the list of failed prerequisite checks from the log: /oracle/app/oraInventory/logs/InstallActions2021-07-15_08-36-43PM/installActions2021-07-15_08-36-43PM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually. The response file for this session can be found at: /oracle/app/oracle/product/19.0.0/dbhome_1/install/response/db_2021-07-15_08-36-43PM.rsp You can find the log of this install session at: /oracle/app/oraInventory/logs/InstallActions2021-07-15_08-36-43PM/installActions2021-07-15_08-36-43PM.log As a root user, execute the following script(s): 1. /oracle/app/oracle/product/19.0.0/dbhome_1/root.sh Execute /oracle/app/oracle/product/19.0.0/dbhome_1/root.sh on the following nodes: [19c-h1, 19c-h2] Successfully Setup Software with warning(s). [oracle@19c-h1 dbhome_1]$复制
Note：因为前面忽略了DNS和SCAN的错误所以会有告警信息。
4、运行root脚本
[root@19c-h1 ~]# /oracle/app/oracle/product/19.0.0/dbhome_1/root.sh Check /oracle/app/oracle/product/19.0.0/dbhome_1/install/root_19c-h1_2021-07-15_20-50-16-745400442.log for the output of root script [root@19c-h1 ~]# [root@19c-h2 ~]# /oracle/app/oracle/product/19.0.0/dbhome_1/root.sh Check /oracle/app/oracle/product/19.0.0/dbhome_1/install/root_19c-h1_2021-07-15_20-50-16-745400442.log for the output of root script [root@19c-h1 ~]#复制
五、数据库创建
1、命令
dbca -silent -ignorePreReqs -createDatabase \ -templateName General_Purpose.dbc \ -datafileJarLocation $ORACLE_HOME/assistants/dbca/templates \ -gdbName wldb \ -sid wldb \ -sysPassword oracle \ -systemPassword oracle \ -storageType ASM \ -diskGroupName DATA \ -useOMF true \ -asmsnmpPassword oracle \ -dbsnmpPassword oracle \ -runCVUChecks true \ -nodelist 19c-h1,19c-h2 \ -createAsContainerDatabase true \ -useLocalUndoForPDBs true \ -characterset ZHS16GBK \ -nationalCharacterSet AL16UTF16 \ -sampleSchema false \ -databaseType MULTIPURPOSE \ -emConfiguration NONE \ -memoryPercentage 30 ## 2、结果 [oracle@19c-h1 ~]$ dbca -silent -ignorePreReqs -createDatabase \ > -templateName General_Purpose.dbc \ > -datafileJarLocation $ORACLE_HOME/assistants/dbca/templates \ > -gdbName wldb \ > -sid wldb \ > -sysPassword oracle \ > -systemPassword oracle \ > -storageType ASM \ > -diskGroupName DATA \ > -useOMF true \ > -asmsnmpPassword oracle \ > -dbsnmpPassword oracle \ > -runCVUChecks true \ > -nodelist 19c-h1,19c-h2 \ > -createAsContainerDatabase true \ > -useLocalUndoForPDBs true \ > -characterset ZHS16GBK \ > -nationalCharacterSet AL16UTF16 \ > -sampleSchema false \ > -databaseType MULTIPURPOSE \ > -emConfiguration NONE \ > -memoryPercentage 30 [WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards. CAUSE: a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. b.The password entered is a keyword that Oracle does not recommend to be used as password ACTION: Specify a strong password. If required refer Oracle documentation for guidelines. [WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards. CAUSE: a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. b.The password entered is a keyword that Oracle does not recommend to be used as password ACTION: Specify a strong password. If required refer Oracle documentation for guidelines. [WARNING] [DBT-06208] The 'DBSNMP' password entered does not conform to the Oracle recommended standards. CAUSE: a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. b.The password entered is a keyword that Oracle does not recommend to be used as password ACTION: Specify a strong password. If required refer Oracle documentation for guidelines. Prepare for db operation 8% complete Copying database files 33% complete Creating and starting Oracle instance 34% complete 35% complete 39% complete 44% complete 47% complete 50% complete Creating cluster database views 52% complete 67% complete Completing Database Creation 71% complete 73% complete 75% complete Executing Post Configuration Actions 100% complete Database creation complete. For details check the logfiles at: /oracle/app/oracle/cfgtoollogs/dbca/wldb. Database Information: Global Database Name:wldb System Identifier(SID) Prefix:wldb Look at the log file "/oracle/app/oracle/cfgtoollogs/dbca/wldb/wldb0.log" for further details. [oracle@19c-h1 ~]$复制
3、查看
[oracle@19c-h1 ~]$ srvctl status database -d wldb Instance wldb1 is running on node 19c-h1 Instance wldb2 is running on node 19c-h2 [oracle@19c-h1 ~]$复制
最后修改时间：2024-09-04 14:35:17
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
评论
流浪的民工
2年前
评论
0# grid用户互信 配置过程中输入grid用户密码（前面设置的为grid）
source ~/.bash_profile
$ORACLE_HOME/oui/prov/resources/scripts/sshUserSetup.sh -user grid -hosts "19c-h1 19c-h2" -advanced -noPromptPassphrase
# oracle用户互信 配置过程中输入oracle用户密码（前面设置的为oracle）
$ORACLE_HOME/oui/prov/resources/scripts/sshUserSetup.sh -user oracle -hosts "19c-h1 19c-h2" -advanced -noPromptPassphrase
是不是应该这样？
rpm -ivh cvuqdisk-1.0.10-1.rpm 这个关键的需要执行是不是要写上？我是半罐子，专家见谅，其他的都感觉写的很棒，能回复就完美了
2年前
点赞 1
范伟林
2年前
回复
0对，写反了
2年前
点赞 回复
老徐
3年前
评论
0powerpath写错了，另外，libvirtd不只是虚拟网卡，它是linux的虚拟化管理进程
3年前
点赞 1
流浪的民工
2年前
回复
0老兄powerpath那里写错了？我怎么没看出来。
2年前
点赞 回复
熊强
3年前
评论
0有借鉴意义 ，我本来 想打赏的，复制了一点点命令，发现 有乱码 ，感觉格局小气了点，哈哈，索性就没打赏了
3年前
点赞 评论
张亚辉
3年前
评论
0现在基本都是多路径磁盘，如/dev/mapper/mpath*。这种无法如文中所述配置udev，有其他方式吗？
3年前
点赞 1
范伟林
3年前
回复
1这种就是Multipath映射出来的，其实真实的盘符是/dev/dm*，一样适用，当然可以用12-dm-permissions.rules的写法，ENV{DM_NAME}=="ocrvote01", OWNER:="grid", GROUP:="asmadmin", MODE:="660"，ocrvote01就是multipatch映射的别名可自定义
3年前
1 回复
悠游客
3年前
评论
0非常实用的资料
3年前
点赞 评论
