在知识库中专注阅读，并随时返回相关工具与课程
Oracle 一键安装脚本，演示 openEuler 22.03 LTS SP3 一键安装 Oracle 19C RAC 过程（全程无需人工干预）：（脚本包括 <font color='red'ORALCE PSU/OJVM 等补丁自动安装</font） ⭐️ <font color='red'脚本下载地址</font：Shell脚本安装Oracle数据库https://www.oracleshe
系统学习 Oracle DBA
开通会员 ¥128/月起
查看完整课程Oracle 一键安装脚本，演示 openEuler 22.03 LTS SP3 一键安装 Oracle 19C RAC 过程（全程无需人工干预）：（脚本包括 ORALCE PSU/OJVM 等补丁自动安装）
⭐️ 脚本下载地址：Shell脚本安装Oracle数据库
脚本第三代支持 N 节点一键安装，不限制节点数！
✨ 偷懒可以直接下载本文安装包合集：openEuler 22.03 LTS SP3 安装 Oracle 19C RAC（19.22） 安装包合集（包含补丁！！！）
1# 主机版本2[root@openEuler01 soft]# cat /etc/openEuler-release 3openEuler release 22.03 (LTS-SP3)45# 网络信息6## 节点一7[root@openEuler01 soft]# ip a82: ens33: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc fq_codel state UP group default qlen 10009 link/ether 00:0c:29:51:f8:ca brd ff:ff:ff:ff:ff:ff10 inet 192.168.6.130/24 brd 192.168.6.255 scope global noprefixroute ens3311 valid_lft forever preferred_lft forever12 inet6 fe80::6bae:9840:87e5:b777/64 scope link noprefixroute 13 valid_lft forever preferred_lft forever143: ens37: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc fq_codel state UP group default qlen 100015 link/ether 00:0c:29:51:f8:de brd ff:ff:ff:ff:ff:ff16 inet 1.1.1.1/24 brd 1.1.1.255 scope global noprefixroute ens3717 valid_lft forever preferred_lft forever18 inet6 fe80::7590:c66c:2046:880c/64 scope link noprefixroute 19 valid_lft forever preferred_lft forever2021## 节点二22[root@openEuler02 ~]# ip a232: ens33: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc fq_codel state UP group default qlen 100024 link/ether 00:0c:29:6e:b2:2c brd ff:ff:ff:ff:ff:ff25 inet 192.168.6.131/24 brd 192.168.6.255 scope global noprefixroute ens3326 valid_lft forever preferred_lft forever27 inet6 fe80::20c:29ff:fe6e:b22c/64 scope link noprefixroute 28 valid_lft forever preferred_lft forever293: ens37: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc fq_codel state UP group default qlen 100030 link/ether 00:0c:29:6e:b2:40 brd ff:ff:ff:ff:ff:ff31 inet 1.1.1.2/24 brd 1.1.1.255 scope global noprefixroute ens3732 valid_lft forever preferred_lft forever33 inet6 fe80::683c:1c48:9251:7df7/64 scope link noprefixroute 34 valid_lft forever preferred_lft forever3536# 挂载本地 ISO 镜像37## 节点一38[root@openEuler01 soft]# mount | grep iso | grep -v "/run/media"39/dev/sr0 on /mnt type iso9660 (ro,relatime,nojoliet,check=s,map=n,blocksize=2048,iocharset=utf8)40[root@openEuler01 soft]# df -h|grep /mnt41/dev/sr0 18G 18G 0 100% /mnt4243## 节点二44[root@openEuler02 soft]# mount | grep iso | grep -v "/run/media"45/dev/sr0 on /mnt type iso9660 (ro,relatime,nojoliet,check=s,map=n,blocksize=2048,iocharset=utf8)46[root@openEuler02 soft]# df -h|grep /mnt47/dev/sr0 18G 18G 0 100% /mnt4849# starwind 共享磁盘挂载（有存储就不需要使用 starwind，直接存储上划盘挂载就可）50yum install -y iscsi-initiator-utils*51systemctl start iscsid.service52systemctl enable iscsid.service53iscsiadm -m discovery -t st -p 192.168.6.18854## 挂载 ASM 磁盘55iscsiadm -m node -T iqn.2008-08.com.starwindsoftware:192.168.6.188-lucifer -p 192.168.6.188 -l56## 配置开机自动挂载57iscsiadm -m node –T iqn.2008-08.com.starwindsoftware:192.168.6.188-lucifer -p 192.168.6.188 --op update -n node.startup -v automatic5859## 节点一60[root@openEuler01 ~]# lsblk 61NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINTS62sda 8:0 0 100G 0 disk 63├─sda1 8:1 0 1G 0 part /boot64└─sda2 8:2 0 99G 0 part 65 ├─openeuler-root 253:0 0 91G 0 lvm /66 └─openeuler-swap 253:1 0 8G 0 lvm [SWAP]67sdb 8:16 0 10G 0 disk 68sdc 8:32 0 50G 0 disk 69sr0 11:0 1 17.1G 0 rom /mnt7071## 节点二72[root@openEuler02 ~]# lsblk 73NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINTS74sda 8:0 0 100G 0 disk 75├─sda1 8:1 0 1G 0 part /boot76└─sda2 8:2 0 99G 0 part 77 ├─openeuler-root 253:0 0 91G 0 lvm /78 └─openeuler-swap 253:1 0 8G 0 lvm [SWAP]79sdb 8:16 0 10G 0 disk 80sdc 8:32 0 50G 0 disk 81sr0 11:0 1 17.1G 0 rom /mnt8283# 安装包存放在 /soft 目录下84[root@openEuler01 ~]# cd /soft/85[root@openEuler01 soft]# ll86-rwx------. 1 root root 3059705302 Mar 20 13:57 LINUX.X64_193000_db_home.zip87-rwx------. 1 root root 2889184573 Mar 20 13:58 LINUX.X64_193000_grid_home.zip88-rwxr-xr-x. 1 root root 163796 Mar 20 15:17 OracleShellInstall89-rwx------. 1 root root 127451050 Mar 20 13:58 p35926646_190000_Linux-x86-64.zip90-rwx------. 1 root root 3153297056 Mar 20 13:58 p35940989_190000_Linux-x86-64.zip91-rwx------. 1 root root 127774864 Mar 20 13:58 p6880880_190000_Linux-x86-64.zip92-rwx------. 1 root root 321590 Mar 20 13:58 rlwrap-0.44.tar.gz9394# 修改 root 密码，脚本不支持特殊字符，例如 @ 符号95# 去除密码复杂度96sed -i 's/^password\+[[:space:]]\+requisite[[:space:]]\+pam_pwquality.so/#&/g' /etc/pam.d/system-auth97sed -i 's/use_authtok$//' /etc/pam.d/system-auth98# 修改 root 密码99[root@openEuler01 soft]# passwd root100Changing password for user root.101New password:102Retype new password:103passwd: all authentication tokens updated successfully.104105[root@openEuler02 ~]# passwd root106Changing password for user root.107New password:108Retype new password:109passwd: all authentication tokens updated successfully.默认使用专业版脚本。脚本下载：ora100.com/shell-install 以上配置完成后，建议重启两台主机，重启后记得再次挂载 ISO：
1[root@openEuler01:/soft]$ mount /dev/cdrom /mnt/2mount: /mnt: WARNING: source write-protected, mounted read-only.34[root@openEuler02:/root]$ mount /dev/cdrom /mnt/5mount: /mnt: WARNING: source write-protected, mounted read-only.确保安装环境准备完成后，即可执行一键安装。
📢注意： 如果安装过程中 GRID 安装报错（一般是因为 ASM 磁盘没有配置好，可能是 openEuler 不适配的原因）：
1[FATAL] [INS-30508] Invalid ASM disks.2 CAUSE: The disks [/dev/asm_ocr_1] were not valid.3 ACTION: Please choose or enter valid ASM disks.4[FATAL] [INS-30515] Insufficient space available in the selected disks.5 CAUSE: Insufficient space available in the selected Disks. At least, 1.2 GB of free space is required.6 ACTION: Choose additional disks such that the total size should be at least 1.2 GB.7Moved the install session logs to:8 /u01/app/oraInventory/logs/GridSetupActions2024-03-20_03-40-18PM9抱歉，Grid 软件安装失败，请检查!则需要重启两台主机，确认 ASM 磁盘已经如下挂载成功后再次执行安装命令：
1[root@openEuler01:/root]$ lsblk 2NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINTS3sda 8:0 0 100G 0 disk 4├─sda1 8:1 0 1G 0 part /boot5└─sda2 8:2 0 99G 0 part 6 ├─openeuler-root 253:0 0 91G 0 lvm /7 └─openeuler-swap 253:1 0 8G 0 lvm [SWAP]8sdb 8:16 0 10G 0 disk 9└─asm_ocr_1 253:3 0 10G 0 mpath 10sdc 8:32 0 50G 0 disk 11└─asm_data_1 253:2 0 50G 0 mpath 12sr0 11:0 1 17.1G 0 rom 1314[root@openEuler02:/root]$ lsblk 15NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINTS16sda 8:0 0 100G 0 disk 17├─sda1 8:1 0 1G 0 part /boot18└─sda2 8:2 0 99G 0 part 19 ├─openeuler-root 253:0 0 91G 0 lvm /20 └─openeuler-swap 253:1 0 8G 0 lvm [SWAP]21sdb 8:16 0 10G 0 disk 22└─asm_ocr_1 253:3 0 10G 0 mpath 23sdc 8:32 0 50G 0 disk 24└─asm_data_1 253:2 0 50G 0 mpath 25sr0 11:0 1 17.1G 0 rom使用标准生产环境安装参数（安装过程若失败，脚本支持重复执行安装）：
1# 根据脚本 README 或者 -h 命令提示，编辑好一键安装命令，进入 /soft 目录执行安装：2./OracleShellInstall -n openEuler `# hostname prefix`\3-hn openEuler01,openEuler02 `# rac node hostname`\4-cn openEuler-cls `# cluster_name`\5-rp welcome1 `# root password`\6-gp welcome1 `# grid password`\7-op welcome1 `# oracle password`\8-lf ens33 `# local ip ifname`\9-pf ens37 `# rac private ip ifname`\10-ri 192.168.6.130,192.168.6.131 `# rac node public ip`\11-vi 192.168.6.132,192.168.6.133 `# rac virtual ip`\12-si 192.168.6.134 `# rac scan ip`\13-od /dev/sdb `# rac ocr asm disk`\14-dd /dev/sdc `# rac data asm disk`\15-o lucifer `# dbname`\16-ds AL32UTF8 `# database character`\17-ns AL16UTF16 `# national character`\18-redo 100 `# redo size`\19-dp oracle `# sys/system password`\20-gpa 35940989 `# grid PSU/RU`\21-jpa 35926646 `# OJVM PSU/RU`\22-opd Y `# optimize db`默认使用专业版脚本。脚本下载：ora100.com/shell-install
选择需要安装的模式以及版本，即可开始安装：
12 ███████ ██ ████████ ██ ██ ██ ██ ██ ██ ██3 ██░░░░░██ ░██ ██░░░░░░ ░██ ░██ ░██░██ ░██ ░██ ░██4 ██ ░░██ ██████ ██████ █████ ░██ █████ ░██ ░██ █████ ░██ ░██░██ ███████ ██████ ██████ ██████ ░██ ░██5░██ ░██░░██░░█ ░░░░░░██ ██░░░██ ░██ ██░░░██░█████████░██████ ██░░░██ ░██ ░██░██░░██░░░██ ██░░░░ ░░░██░ ░░░░░░██ ░██ ░██6░██ ░██ ░██ ░ ███████ ░██ ░░ ░██░███████░░░░░░░░██░██░░░██░███████ ░██ ░██░██ ░██ ░██░░█████ ░██ ███████ ░██ ░██7░░██ ██ ░██ ██░░░░██ ░██ ██ ░██░██░░░░ ░██░██ ░██░██░░░░ ░██ ░██░██ ░██ ░██ ░░░░░██ ░██ ██░░░░██ ░██ ░██8 ░░███████ ░███ ░░████████░░█████ ███░░██████ ████████ ░██ ░██░░██████ ███ ███░██ ███ ░██ ██████ ░░██ ░░████████ ███ ███9 ░░░░░░░ ░░░ ░░░░░░░░ ░░░░░ ░░░ ░░░░░░ ░░░░░░░░ ░░ ░░ ░░░░░░ ░░░ ░░░ ░░ ░░░ ░░ ░░░░░░ ░░ ░░░░░░░░ ░░░ ░░░ 101112请选择安装模式 [单机(si)/单机ASM(sa)/集群(rac)] : rac1314数据库安装模式: rac 1516请选择数据库版本 [11/12/19/21] : 191718数据库版本: 19 1920#==============================================================# 21配置本地 YUM 源 22#==============================================================# 2324[openEuler]25name=openEuler26baseurl=file:////mnt27enabled=128gpgcheck=129gpgkey=file:////mnt/RPM-GPG-KEY-openEuler3031#==============================================================# 32获取 ASM 磁盘 UUID && 格式化磁盘头 33#==============================================================# 3435格式化 OCR 磁盘：/dev/sdb 36371+0 records in381+0 records out391024 bytes (1.0 kB, 1.0 KiB) copied, 0.000149528 s, 6.8 MB/s4041OCR磁盘组的磁盘UUID： 2e87e4f535c397171 4243格式化 DATA 磁盘：/dev/sdc 44451+0 records in461+0 records out471024 bytes (1.0 kB, 1.0 KiB) copied, 0.000148043 s, 6.9 MB/s4849DATA磁盘组的磁盘UUID： 2f218dae15b551c5d 5051#==============================================================# 52禁用防火墙 53#==============================================================# 5455防火墙服务未启动，无需禁用。 5657#==============================================================# 58禁用 SELinux 59#==============================================================# 6061SELinux status: disabled6263#==============================================================# 64YUM 静默安装依赖包 65#==============================================================# 6667bc-1.07.1-12.oe2203sp3.x86_6468binutils-2.37-24.oe2203sp3.x86_6469package compat-libcap1 is not installed70gcc-10.3.1-49.oe2203sp3.x86_6471gcc-c++-10.3.1-49.oe2203sp3.x86_6472package elfutils-libelf is not installed73package elfutils-libelf-devel is not installed74glibc-2.34-143.oe2203sp3.x86_6475glibc-devel-2.34-143.oe2203sp3.x86_6476libaio-0.3.113-9.oe2203sp3.x86_6477libaio-devel-0.3.113-9.oe2203sp3.x86_6478libgcc-10.3.1-49.oe2203sp3.x86_6479libstdc++-10.3.1-49.oe2203sp3.x86_6480libstdc++-devel-10.3.1-49.oe2203sp3.x86_6481libxcb-1.15-1.oe2203sp3.x86_6482libX11-1.7.2-8.oe2203sp3.x86_6483libXau-1.0.10-1.oe2203sp3.x86_6484libXi-1.8-2.oe2203sp3.x86_6485libXrender-0.9.10-12.oe2203sp3.x86_6486make-4.3-4.oe2203sp3.x86_6487net-tools-2.10-3.oe2203sp3.x86_6488smartmontools-7.2-2.oe2203sp3.x86_6489sysstat-12.5.4-9.oe2203sp3.x86_6490e2fsprogs-1.46.4-24.oe2203sp3.x86_6491package e2fsprogs-libs is not installed92unzip-6.0-50.oe2203sp3.x86_6493openssh-clients-8.8p1-23.oe2203sp3.x86_6494readline-8.1-3.oe2203sp3.x86_6495readline-devel-8.1-3.oe2203sp3.x86_6496psmisc-23.5-2.oe2203sp3.x86_6497ksh-2020.0.0-10.oe2203sp3.x86_6498nfs-utils-2.5.4-15.oe2203sp3.x86_6499tar-1.34-5.oe2203sp3.x86_64100package device-mapper-multipath is not installed101avahi-0.8-18.oe2203sp3.x86_64102ntp-4.2.8p15-13.oe2203sp3.x86_64103chrony-4.1-6.oe2203sp3.x86_64104libXtst-1.2.4-1.oe2203sp3.x86_64105libXrender-devel-0.9.10-12.oe2203sp3.x86_64106fontconfig-devel-2.13.94-3.oe2203sp3.x86_64107policycoreutils-3.3-8.oe2203sp3.x86_64108package policycoreutils-python is not installed109package librdmacm is not installed110package libnsl* is not installed111package libibverbs is not installed112package compat-openssl10 is not installed113policycoreutils-python-utils-3.3-8.oe2203sp3.noarch114package elfutils* is not installed115glibc-2.34-143.oe2203sp3.x86_64116117#==============================================================# 118配置主机名 119#==============================================================# 120121openEuler01122123#==============================================================# 124配置 /etc/hosts 文件 125#==============================================================# 126127127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4128::1 localhost localhost.localdomain localhost6 localhost6.localdomain6129130131## OracleBegin132133## RAC1 IP's: openEuler01134135## RAC1 Public IP136192.168.6.130 openEuler01137## RAC1 Virtual IP138192.168.6.132 openEuler01-vip139## RAC1 Private IP1401.1.1.1 openEuler01-priv141142## RAC2 IP's: openEuler02143144## RAC2 Public IP145192.168.6.131 openEuler02146## RAC2 Virtual IP147192.168.6.133 openEuler02-vip148## RAC2 Private IP1491.1.1.2 openEuler02-priv150151## SCAN IP152192.168.6.134 openEuler-scan153154#==============================================================# 155创建用户和组 156#==============================================================# 157158oracle 用户： 159160uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba),54327(asmdba),54328(asmoper),54329(asmadmin)161162grid 用户： 163164uid=11012(grid) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba),54327(asmdba),54328(asmoper),54329(asmadmin)165166167#==============================================================# 168配置 Avahi-daemon 服务 169#==============================================================# 170171○ avahi-daemon.service - Avahi mDNS/DNS-SD Stack172 Loaded: loaded (/usr/lib/systemd/system/avahi-daemon.service; disabled; vendor preset: enabled)173 Active: inactive (dead)174TriggeredBy: ○ avahi-daemon.socket175176#==============================================================# 177配置透明大页 && NUMA && 磁盘 IO 调度器 178#==============================================================# 179180args="ro resume=/dev/mapper/openeuler-swap rd.lvm.lv=openeuler/root rd.lvm.lv=openeuler/swap cgroup_disable=files apparmor=0 crashkernel=512M rhgb quiet numa=off transparent_hugepage=never elevator=deadline"181-resume=/dev/mapper/openeuler-swap182-args="ro183args="ro resume=/dev/mapper/openeuler-swap rd.lvm.lv=openeuler/root rd.lvm.lv=openeuler/swap cgroup_disable=files apparmor=0 crashkernel=512M rhgb quiet numa=off transparent_hugepage=never elevator=deadline"184-rhgb185-crashkernel=512M186187#==============================================================# 188配置 sysctl.conf 189#==============================================================# 190191kernel.sysrq = 0192net.ipv4.ip_forward = 0193net.ipv4.conf.all.send_redirects = 0194net.ipv4.conf.default.send_redirects = 0195net.ipv4.conf.all.accept_source_route = 0196net.ipv4.conf.default.accept_source_route = 0197net.ipv4.conf.all.accept_redirects = 0198net.ipv4.conf.default.accept_redirects = 0199net.ipv4.conf.all.secure_redirects = 0200net.ipv4.conf.default.secure_redirects = 0201net.ipv4.icmp_echo_ignore_broadcasts = 1202net.ipv4.icmp_ignore_bogus_error_responses = 1203net.ipv4.conf.all.rp_filter = 1204net.ipv4.conf.default.rp_filter = 1205net.ipv4.tcp_syncookies = 1206kernel.dmesg_restrict = 1207net.ipv6.conf.all.accept_redirects = 0208net.ipv6.conf.default.accept_redirects = 0209fs.aio-max-nr = 1048576210fs.file-max = 6815744211kernel.shmall = 2097152212kernel.shmmax = 7795077119213kernel.shmmni = 4096214kernel.sem = 250 32000 100 128215net.ipv4.ip_local_port_range = 9000 65500216net.core.rmem_default = 262144217net.core.rmem_max = 4194304218net.core.wmem_default = 262144219net.core.wmem_max = 1048576220vm.min_free_kbytes = 30449221net.ipv4.conf.ens33.rp_filter = 1222vm.swappiness = 10223kernel.panic_on_oops = 1224kernel.randomize_va_space = 2225kernel.numa_balancing = 0226net.ipv4.conf.ens37.rp_filter = 2227228#==============================================================# 229配置 RemoveIPC 230#==============================================================# 231232[Login]233RemoveIPC=no234235#==============================================================# 236配置 /etc/security/limits.conf 和 /etc/pam.d/login 237#==============================================================# 238239查看 /etc/security/limits.conf： 240241oracle soft nofile 1024242oracle hard nofile 65536243oracle soft stack 10240244oracle hard stack 32768245oracle soft nproc 2047246oracle hard nproc 16384247oracle hard memlock unlimited248oracle soft memlock unlimited249grid soft nofile 1024250grid hard nofile 65536251grid soft stack 10240252grid hard stack 32768253grid soft nproc 2047254grid hard nproc 16384255256查看 /etc/pam.d/login 文件： 257258auth substack system-auth259auth include postlogin260account required pam_nologin.so261account include system-auth262password include system-auth263session required pam_selinux.so close264session required pam_loginuid.so265session required pam_selinux.so open266session required pam_namespace.so267session optional pam_keyinit.so force revoke268session include system-auth269session include postlogin270-session optional pam_ck_connector.so271session required pam_limits.so272session required /lib64/security/pam_limits.so273274#==============================================================# 275配置 /dev/shm 276#==============================================================# 277278/dev/mapper/openeuler-root / ext4 defaults 1 1279UUID=07e6a80f-f2f4-42f8-a1ad-df05bd354960 /boot ext4 defaults 1 2280/dev/mapper/openeuler-swap none swap defaults 0 0281tmpfs /dev/shm tmpfs size=7612384k 0 0282283#==============================================================# 284Root 用户环境变量 285#==============================================================# 286287if [ -f ~/.bashrc ]; then288 . ~/.bashrc289fi290PATH=$PATH:$HOME/bin291export PATH292alias so='su - oracle'293export PS1="[`whoami`@`hostname`:"'$PWD]$ '294alias sg='su - grid'295alias crsctl='/u01/app/19.3.0/grid/bin/crsctl'296alias srvctl='/u01/app/19.3.0/grid/bin/srvctl'297298#==============================================================# 299Oracle 用户环境变量 300#==============================================================# 301302[ -f ~/.bashrc ] && . ~/.bashrc303umask 022304export TMP=/tmp305export TMPDIR=$TMP306export NLS_LANG=AMERICAN_AMERICA.AL32UTF8307export ORACLE_BASE=/u01/app/oracle308export ORACLE_HOME=/u01/app/oracle/product/19.3.0/db309export ORACLE_TERM=xterm310export TNS_ADMIN=$ORACLE_HOME/network/admin311export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib312export ORACLE_SID=lucifer1313export PATH=/usr/sbin:$PATH314export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/perl/bin:$PATH315export PERL5LIB=$ORACLE_HOME/perl/lib316alias sas='sqlplus / as sysdba'317alias awr='sqlplus / as sysdba @?/rdbms/admin/awrrpt'318alias ash='sqlplus / as sysdba @?/rdbms/admin/ashrpt'319alias alert='vi $ORACLE_BASE/diag/rdbms/*/$ORACLE_SID/trace/alert_$ORACLE_SID.log'320export PS1="[`whoami`@`hostname`:"'$PWD]$ '321export CV_ASSUME_DISTID=OL7322alias sqlplus='rlwrap sqlplus'323alias rman='rlwrap rman'324alias adrci='rlwrap adrci'325326#==============================================================# 327Grid 用户环境变量 328#==============================================================# 329330[ -f ~/.bashrc ] && . ~/.bashrc331umask 022332export TMP=/tmp333export TMPDIR=$TMP334export NLS_LANG=AMERICAN_AMERICA.AL32UTF8335export ORACLE_BASE=/u01/app/grid336export ORACLE_HOME=/u01/app/19.3.0/grid337export ORACLE_TERM=xterm338export TNS_ADMIN=$ORACLE_HOME/network/admin339export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib340export ORACLE_SID=+ASM1341export PATH=/usr/sbin:$PATH342export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH343alias sas='sqlplus / as sysasm'344export PS1="[`whoami`@`hostname`:"'$PWD]$ '345export CV_ASSUME_DISTID=OL7346alias sqlplus='rlwrap sqlplus'347alias asmcmd='rlwrap asmcmd'348alias adrci='rlwrap adrci'349350#==============================================================# 351配置 multipath 多路径 352#==============================================================# 353354415.530920 | asm_ocr_1: addmap [0 20971520 multipath 0 0 1 1 service-time 0 1 1 8:16 1]355415.732452 | asm_data_1: addmap [0 104857600 multipath 0 0 1 1 service-time 0 1 1 8:32 1]356create: asm_ocr_1 (2e87e4f535c397171) undef ROCKET,IMAGEFILE357size=10G features='0' hwhandler='0' wp=undef358`-+- policy='service-time 0' prio=1 status=undef359 `- 3:0:0:0 sdb 8:16 undef ready running360create: asm_data_1 (2f218dae15b551c5d) undef ROCKET,IMAGEFILE361size=50G features='0' hwhandler='0' wp=undef362`-+- policy='service-time 0' prio=1 status=undef363 `- 3:0:0:1 sdc 8:32 undef ready running364365#==============================================================# 366配置 UDEV 绑盘 367#==============================================================# 368369KERNEL=="dm-*",ENV{DM_UUID}=="mpath-2e87e4f535c397171",SYMLINK+="asm_ocr_1",OWNER="grid",GROUP="asmadmin",MODE="0660"370KERNEL=="dm-*",ENV{DM_UUID}=="mpath-2f218dae15b551c5d",SYMLINK+="asm_data_1",OWNER="grid",GROUP="asmadmin",MODE="0660"371372/dev/asm_data_1373/dev/asm_ocr_1374375UDEV 配置完成! 376377#==============================================================# 378配置 RAC 节点：192.168.6.131 379#==============================================================# 380381正在节点：192.168.6.131 上执行脚本： 382383 ███████ ██ ████████ ██ ██ ██ ██ ██ ██ ██384 ██░░░░░██ ░██ ██░░░░░░ ░██ ░██ ░██░██ ░██ ░██ ░██385 ██ ░░██ ██████ ██████ █████ ░██ █████ ░██ ░██ █████ ░██ ░██░██ ███████ ██████ ██████ ██████ ░██ ░██386░██ ░██░░██░░█ ░░░░░░██ ██░░░██ ░██ ██░░░██░█████████░██████ ██░░░██ ░██ ░██░██░░██░░░██ ██░░░░ ░░░██░ ░░░░░░██ ░██ ░██387░██ ░██ ░██ ░ ███████ ░██ ░░ ░██░███████░░░░░░░░██░██░░░██░███████ ░██ ░██░██ ░██ ░██░░█████ ░██ ███████ ░██ ░██388░░██ ██ ░██ ██░░░░██ ░██ ██ ░██░██░░░░ ░██░██ ░██░██░░░░ ░██ ░██░██ ░██ ░██ ░░░░░██ ░██ ██░░░░██ ░██ ░██389 ░░███████ ░███ ░░████████░░█████ ███░░██████ ████████ ░██ ░██░░██████ ███ ███░██ ███ ░██ ██████ ░░██ ░░████████ ███ ███390 ░░░░░░░ ░░░ ░░░░░░░░ ░░░░░ ░░░ ░░░░░░ ░░░░░░░░ ░░ ░░ ░░░░░░ ░░░ ░░░ ░░ ░░░ ░░ ░░░░░░ ░░ ░░░░░░░░ ░░░ ░░░ 391392393#==============================================================# 394配置本地 YUM 源 395#==============================================================# 396397[openEuler]398name=openEuler399baseurl=file:////mnt400enabled=1401gpgcheck=1402gpgkey=file:////mnt/RPM-GPG-KEY-openEuler403404#==============================================================# 405禁用防火墙 406#==============================================================# 407408防火墙服务未启动，无需禁用。 409410#==============================================================# 411禁用 SELinux 412#==============================================================# 413414SELinux status: disabled415416#==============================================================# 417YUM 静默安装依赖包 418#==============================================================# 419420bc-1.07.1-12.oe2203sp3.x86_64421binutils-2.37-24.oe2203sp3.x86_64422package compat-libcap1 is not installed423gcc-10.3.1-49.oe2203sp3.x86_64424gcc-c++-10.3.1-49.oe2203sp3.x86_64425package elfutils-libelf is not installed426package elfutils-libelf-devel is not installed427glibc-2.34-143.oe2203sp3.x86_64428glibc-devel-2.34-143.oe2203sp3.x86_64429libaio-0.3.113-9.oe2203sp3.x86_64430libaio-devel-0.3.113-9.oe2203sp3.x86_64431libgcc-10.3.1-49.oe2203sp3.x86_64432libstdc++-10.3.1-49.oe2203sp3.x86_64433libstdc++-devel-10.3.1-49.oe2203sp3.x86_64434libxcb-1.15-1.oe2203sp3.x86_64435libX11-1.7.2-8.oe2203sp3.x86_64436libXau-1.0.10-1.oe2203sp3.x86_64437libXi-1.8-2.oe2203sp3.x86_64438libXrender-0.9.10-12.oe2203sp3.x86_64439make-4.3-4.oe2203sp3.x86_64440net-tools-2.10-3.oe2203sp3.x86_64441smartmontools-7.2-2.oe2203sp3.x86_64442sysstat-12.5.4-9.oe2203sp3.x86_64443e2fsprogs-1.46.4-24.oe2203sp3.x86_64444package e2fsprogs-libs is not installed445unzip-6.0-50.oe2203sp3.x86_64446openssh-clients-8.8p1-23.oe2203sp3.x86_64447readline-8.1-3.oe2203sp3.x86_64448readline-devel-8.1-3.oe2203sp3.x86_64449psmisc-23.5-2.oe2203sp3.x86_64450ksh-2020.0.0-10.oe2203sp3.x86_64451nfs-utils-2.5.4-15.oe2203sp3.x86_64452tar-1.34-5.oe2203sp3.x86_64453package device-mapper-multipath is not installed454avahi-0.8-18.oe2203sp3.x86_64455ntp-4.2.8p15-13.oe2203sp3.x86_64456chrony-4.1-6.oe2203sp3.x86_64457libXtst-1.2.4-1.oe2203sp3.x86_64458libXrender-devel-0.9.10-12.oe2203sp3.x86_64459fontconfig-devel-2.13.94-3.oe2203sp3.x86_64460policycoreutils-3.3-8.oe2203sp3.x86_64461package policycoreutils-python is not installed462package librdmacm is not installed463package libnsl* is not installed464package libibverbs is not installed465package compat-openssl10 is not installed466policycoreutils-python-utils-3.3-8.oe2203sp3.noarch467package elfutils* is not installed468glibc-2.34-143.oe2203sp3.x86_64469470#==============================================================# 471配置主机名 472#==============================================================# 473474openEuler02475476#==============================================================# 477配置 /etc/hosts 文件 478#==============================================================# 479480127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4481::1 localhost localhost.localdomain localhost6 localhost6.localdomain6482483## OracleBegin484485## RAC1 IP's: openEuler01486487## RAC1 Public IP488192.168.6.130 openEuler01489## RAC1 Virtual IP490192.168.6.132 openEuler01-vip491## RAC1 Private IP4921.1.1.1 openEuler01-priv493494## RAC2 IP's: openEuler02495496## RAC2 Public IP497192.168.6.131 openEuler02498## RAC2 Virtual IP499192.168.6.133 openEuler02-vip500## RAC2 Private IP5011.1.1.2 openEuler02-priv502503## SCAN IP504192.168.6.134 openEuler-scan505506#==============================================================# 507创建用户和组 508#==============================================================# 509510oracle 用户： 511512uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba),54327(asmdba),54328(asmoper),54329(asmadmin)513514grid 用户： 515516uid=11012(grid) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba),54327(asmdba),54328(asmoper),54329(asmadmin)517518519#==============================================================# 520配置 Avahi-daemon 服务 521#==============================================================# 522523○ avahi-daemon.service - Avahi mDNS/DNS-SD Stack524 Loaded: loaded (/usr/lib/systemd/system/avahi-daemon.service; disabled; vendor preset: enabled)525 Active: inactive (dead)526TriggeredBy: ○ avahi-daemon.socket527528#==============================================================# 529配置透明大页 && NUMA && 磁盘 IO 调度器 530#==============================================================# 531532args="ro resume=/dev/mapper/openeuler-swap rd.lvm.lv=openeuler/root rd.lvm.lv=openeuler/swap cgroup_disable=files apparmor=0 crashkernel=512M rhgb quiet numa=off transparent_hugepage=never elevator=deadline"533-resume=/dev/mapper/openeuler-swap534-args="ro535args="ro resume=/dev/mapper/openeuler-swap rd.lvm.lv=openeuler/root rd.lvm.lv=openeuler/swap cgroup_disable=files apparmor=0 crashkernel=512M rhgb quiet numa=off transparent_hugepage=never elevator=deadline"536-rhgb537-crashkernel=512M538539#==============================================================# 540配置 sysctl.conf 541#==============================================================# 542543kernel.sysrq = 0544net.ipv4.ip_forward = 0545net.ipv4.conf.all.send_redirects = 0546net.ipv4.conf.default.send_redirects = 0547net.ipv4.conf.all.accept_source_route = 0548net.ipv4.conf.default.accept_source_route = 0549net.ipv4.conf.all.accept_redirects = 0550net.ipv4.conf.default.accept_redirects = 0551net.ipv4.conf.all.secure_redirects = 0552net.ipv4.conf.default.secure_redirects = 0553net.ipv4.icmp_echo_ignore_broadcasts = 1554net.ipv4.icmp_ignore_bogus_error_responses = 1555net.ipv4.conf.all.rp_filter = 1556net.ipv4.conf.default.rp_filter = 1557net.ipv4.tcp_syncookies = 1558kernel.dmesg_restrict = 1559net.ipv6.conf.all.accept_redirects = 0560net.ipv6.conf.default.accept_redirects = 0561fs.aio-max-nr = 1048576562fs.file-max = 6815744563kernel.shmall = 2097152564kernel.shmmax = 7795097599565kernel.shmmni = 4096566kernel.sem = 250 32000 100 128567net.ipv4.ip_local_port_range = 9000 65500568net.core.rmem_default = 262144569net.core.rmem_max = 4194304570net.core.wmem_default = 262144571net.core.wmem_max = 1048576572vm.min_free_kbytes = 30449573net.ipv4.conf.ens33.rp_filter = 1574vm.swappiness = 10575kernel.panic_on_oops = 1576kernel.randomize_va_space = 2577kernel.numa_balancing = 0578net.ipv4.conf.ens37.rp_filter = 2579580#==============================================================# 581配置 RemoveIPC 582#==============================================================# 583584[Login]585RemoveIPC=no586587#==============================================================# 588配置 /etc/security/limits.conf 和 /etc/pam.d/login 589#==============================================================# 590591查看 /etc/security/limits.conf： 592593oracle soft nofile 1024594oracle hard nofile 65536595oracle soft stack 10240596oracle hard stack 32768597oracle soft nproc 2047598oracle hard nproc 16384599oracle hard memlock unlimited600oracle soft memlock unlimited601grid soft nofile 1024602grid hard nofile 65536603grid soft stack 10240604grid hard stack 32768605grid soft nproc 2047606grid hard nproc 16384607608查看 /etc/pam.d/login 文件： 609610auth substack system-auth611auth include postlogin612account required pam_nologin.so613account include system-auth614password include system-auth615session required pam_selinux.so close616session required pam_loginuid.so617session required pam_selinux.so open618session required pam_namespace.so619session optional pam_keyinit.so force revoke620session include system-auth621session include postlogin622-session optional pam_ck_connector.so623session required pam_limits.so624session required /lib64/security/pam_limits.so625626#==============================================================# 627配置 /dev/shm 628#==============================================================# 629630/dev/mapper/openeuler-root / ext4 defaults 1 1631UUID=3b8b94fa-6595-453b-938d-16b973646ae1 /boot ext4 defaults 1 2632/dev/mapper/openeuler-swap none swap defaults 0 0633tmpfs /dev/shm tmpfs size=7612400k 0 0634635#==============================================================# 636Root 用户环境变量 637#==============================================================# 638639if [ -f ~/.bashrc ]; then640 . ~/.bashrc641fi642PATH=$PATH:$HOME/bin643export PATH644alias so='su - oracle'645export PS1="[`whoami`@`hostname`:"'$PWD]$ '646alias sg='su - grid'647alias crsctl='/u01/app/19.3.0/grid/bin/crsctl'648alias srvctl='/u01/app/19.3.0/grid/bin/srvctl'649650#==============================================================# 651Oracle 用户环境变量 652#==============================================================# 653654[ -f ~/.bashrc ] && . ~/.bashrc655umask 022656export TMP=/tmp657export TMPDIR=$TMP658export NLS_LANG=AMERICAN_AMERICA.AL32UTF8659export ORACLE_BASE=/u01/app/oracle660export ORACLE_HOME=/u01/app/oracle/product/19.3.0/db661export ORACLE_TERM=xterm662export TNS_ADMIN=$ORACLE_HOME/network/admin663export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib664export ORACLE_SID=lucifer2665export PATH=/usr/sbin:$PATH666export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/perl/bin:$PATH667export PERL5LIB=$ORACLE_HOME/perl/lib668alias sas='sqlplus / as sysdba'669alias awr='sqlplus / as sysdba @?/rdbms/admin/awrrpt'670alias ash='sqlplus / as sysdba @?/rdbms/admin/ashrpt'671alias alert='vi $ORACLE_BASE/diag/rdbms/*/$ORACLE_SID/trace/alert_$ORACLE_SID.log'672export PS1="[`whoami`@`hostname`:"'$PWD]$ '673export CV_ASSUME_DISTID=OL7674alias sqlplus='rlwrap sqlplus'675alias rman='rlwrap rman'676alias adrci='rlwrap adrci'677678#==============================================================# 679Grid 用户环境变量 680#==============================================================# 681682[ -f ~/.bashrc ] && . ~/.bashrc683umask 022684export TMP=/tmp685export TMPDIR=$TMP686export NLS_LANG=AMERICAN_AMERICA.AL32UTF8687export ORACLE_BASE=/u01/app/grid688export ORACLE_HOME=/u01/app/19.3.0/grid689export ORACLE_TERM=xterm690export TNS_ADMIN=$ORACLE_HOME/network/admin691export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib692export ORACLE_SID=+ASM2693export PATH=/usr/sbin:$PATH694export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH695alias sas='sqlplus / as sysasm'696export PS1="[`whoami`@`hostname`:"'$PWD]$ '697export CV_ASSUME_DISTID=OL7698alias sqlplus='rlwrap sqlplus'699alias asmcmd='rlwrap asmcmd'700alias adrci='rlwrap adrci'701702#==============================================================# 703配置 multipath 多路径 704#==============================================================# 705706438.420337 | asm_ocr_1: addmap [0 20971520 multipath 0 0 1 1 service-time 0 1 1 8:16 1]707438.549864 | asm_data_1: addmap [0 104857600 multipath 0 0 1 1 service-time 0 1 1 8:32 1]708create: asm_ocr_1 (2e87e4f535c397171) undef ROCKET,IMAGEFILE709size=10G features='0' hwhandler='0' wp=undef710`-+- policy='service-time 0' prio=1 status=undef711 `- 3:0:0:0 sdb 8:16 undef ready running712create: asm_data_1 (2f218dae15b551c5d) undef ROCKET,IMAGEFILE713size=50G features='0' hwhandler='0' wp=undef714`-+- policy='service-time 0' prio=1 status=undef715 `- 3:0:0:1 sdc 8:32 undef ready running716717#==============================================================# 718配置 UDEV 绑盘 719#==============================================================# 720721KERNEL=="dm-*",ENV{DM_UUID}=="mpath-2e87e4f535c397171",SYMLINK+="asm_ocr_1",OWNER="grid",GROUP="asmadmin",MODE="0660"722KERNEL=="dm-*",ENV{DM_UUID}=="mpath-2f218dae15b551c5d",SYMLINK+="asm_data_1",OWNER="grid",GROUP="asmadmin",MODE="0660"723724/dev/asm_data_1725/dev/asm_ocr_1726727UDEV 配置完成! 728729配置 RAC 节点：192.168.6.131 结束! 730731#==============================================================# 732静默解压缩 Grid 软件包 733#==============================================================# 734735正在静默解压缩 Grid 软件包，请稍等： 736737.---- -. -. . . . .738( .',----- - - ' ' ' __739 \_/ ;--:- __--------------------___ ____=========_||___740__U__n_^_''__[. ooo___ | |_!_||_!_||_!_||_!_| | |..|_i_|..|_i_|..|741c(_ ..(_ ..(_ ..( /,,,,,,] | |___||___||___||___| | | |742,_\___________'_|,L______],|______________________|_i,!________________!_i743/;_(@)(@)==(@)(@) (o)(o) (o)^(o)--(o)^(o) (o)(o)-(o)(o)744""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"'""745746747静默解压 Grid 软件安装包： /soft/LINUX.X64_193000_grid_home.zip 748749静默解压 OPatch 软件补丁包： /soft/p6880880_*.zip 750751#==============================================================# 752静默解压 Oracle 软件包 753#==============================================================# 754755正在静默解压缩 Oracle 软件包，请稍等： 756757.---- -. -. . . . .758( .',----- - - ' ' ' __759 \_/ ;--:- __--------------------___ ____=========_||___760__U__n_^_''__[. ooo___ | |_!_||_!_||_!_||_!_| | |..|_i_|..|_i_|..|761c(_ ..(_ ..(_ ..( /,,,,,,] | |___||___||___||___| | | |762,_\___________'_|,L______],|______________________|_i,!________________!_i763/;_(@)(@)==(@)(@) (o)(o) (o)^(o)--(o)^(o) (o)(o)-(o)(o)764""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"'""765766767静默解压 Oracle 软件安装包： /soft/LINUX.X64_193000_db_home.zip 768769静默解压 OPatch 软件补丁包： /soft/p6880880_*.zip 770771静默解压 OJVM 软件补丁包： /soft/p35926646*.zip 772773#==============================================================# 774Grid 安装静默文件 775#==============================================================# 776777INVENTORY_LOCATION=/u01/app/oraInventory778oracle.install.option=CRS_CONFIG779ORACLE_BASE=/u01/app/grid780oracle.install.asm.OSDBA=asmdba781oracle.install.asm.OSOPER=asmoper782oracle.install.asm.OSASM=asmadmin783oracle.install.crs.config.gpnp.scanName=openEuler-scan784oracle.install.crs.config.gpnp.scanPort=1521785oracle.install.crs.config.clusterName=openEuler-cls786oracle.install.crs.config.gpnp.configureGNS=false787oracle.install.crs.config.clusterNodes=openEuler01:openEuler01-vip,openEuler02:openEuler02-vip788oracle.install.crs.config.networkInterfaceList=ens33:192.168.6.0:1,ens37:1.1.1.0:5789oracle.install.crs.config.useIPMI=false790oracle.install.asm.SYSASMPassword=oracle791oracle.install.asm.diskGroup.name=OCR792oracle.install.asm.diskGroup.redundancy=EXTERNAL793oracle.install.asm.diskGroup.disks=/dev/asm_ocr_1794oracle.install.asm.diskGroup.diskDiscoveryString=/dev/asm*795oracle.install.asm.monitorPassword=oracle796oracle.install.crs.config.ClusterConfiguration=STANDALONE797oracle.install.crs.config.configureAsExtendedCluster=false798oracle.install.crs.configureGIMR=false799oracle.install.asm.storageOption=ASM800oracle.install.asm.diskGroup.AUSize=4801oracle.install.asm.configureAFD=false802oracle.install.crs.config.ignoreDownNodes=false803oracle.install.config.managementOption=NONE804oracle.install.crs.rootconfig.executeRootScript=false805oracle.install.responseFileVersion=/oracle/install/rspfmt_crsinstall_response_schema_v19.0.0806oracle.install.crs.config.scanType=LOCAL_SCAN807808#==============================================================# 809静默安装 Grid 软件 810#==============================================================# 811812Preparing the home to patch...813Applying the patch /soft/35940989...814Successfully applied the patch.815The log can be found at: /tmp/GridSetupActions2024-03-21_10-31-09AM/installerPatchActions_2024-03-21_10-31-09AM.log816Launching Oracle Grid Infrastructure Setup Wizard...817818[WARNING] [INS-30011] The SYS password entered does not conform to the Oracle recommended standards.819 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].820 ACTION: Provide a password that conforms to the Oracle recommended standards.821[WARNING] [INS-30011] The ASMSNMP password entered does not conform to the Oracle recommended standards.822 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].823 ACTION: Provide a password that conforms to the Oracle recommended standards.824The response file for this session can be found at:825 /u01/app/19.3.0/grid/install/response/grid_2024-03-21_10-31-09AM.rsp826827You can find the log of this install session at:828 /tmp/GridSetupActions2024-03-21_10-31-09AM/gridSetupActions2024-03-21_10-31-09AM.log829830As a root user, execute the following script(s):831 1. /u01/app/oraInventory/orainstRoot.sh832 2. /u01/app/19.3.0/grid/root.sh833834Execute /u01/app/oraInventory/orainstRoot.sh on the following nodes: 835[openEuler01, openEuler02]836Execute /u01/app/19.3.0/grid/root.sh on the following nodes: 837[openEuler01, openEuler02]838839Run the script on the local node first. After successful completion, you can start the script in parallel on all other nodes.840841Successfully Setup Software.842As install user, execute the following command to complete the configuration.843 /u01/app/19.3.0/grid/gridSetup.sh -executeConfigTools -responseFile /soft/grid.rsp [-silent]844845846Moved the install session logs to:847 /u01/app/oraInventory/logs/GridSetupActions2024-03-21_10-31-09AM848849#==============================================================# 850执行 root 脚本 851#==============================================================# 852853节点 192.168.6.130 ： 854855Changing permissions of /u01/app/oraInventory.856Adding read,write permissions for group.857Removing read,write,execute permissions for world.858859Changing groupname of /u01/app/oraInventory to oinstall.860The execution of the script is complete.861Check /u01/app/19.3.0/grid/install/root_openEuler01_2024-03-21_11-00-24-542542904.log for the output of root script862863节点 192.168.6.131 ： 864865Changing permissions of /u01/app/oraInventory.866Adding read,write permissions for group.867Removing read,write,execute permissions for world.868869Changing groupname of /u01/app/oraInventory to oinstall.870The execution of the script is complete.871Check /u01/app/19.3.0/grid/install/root_openEuler02_2024-03-21_11-09-02-281159664.log for the output of root script872873#==============================================================# 874Grid 软件版本 875#==============================================================# 876877878SQL*Plus: Release 19.0.0.0.0 - Production879Version 19.22.0.0.0880881882#==============================================================# 883Grid 补丁信息 884#==============================================================# 88588636115038;TOMCAT RELEASE UPDATE 19.0.0.0.0 (36115038)88735967489;OCW RELEASE UPDATE 19.22.0.0.0 (35967489)88835956421;ACFS RELEASE UPDATE 19.22.0.0.0 (35956421)88935943157;Database Release Update : 19.22.0.0.240116 (35943157)89033575402;DBWLM RELEASE UPDATE 19.0.0.0.0 (33575402)891892OPatch succeeded.893894895#==============================================================# 896ASM 磁盘组创建 897#==============================================================# 898899State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name900MOUNTED EXTERN N 512 512 4096 1048576 51200 51092 0 51092 0 N DATA/901MOUNTED EXTERN N 512 512 4096 4194304 10240 9900 0 9900 0 Y OCR/902903#==============================================================# 904Oracle 安装静默文件 905#==============================================================# 906907oracle.install.option=INSTALL_DB_SWONLY908UNIX_GROUP_NAME=oinstall909INVENTORY_LOCATION=/u01/app/oraInventory910ORACLE_BASE=/u01/app/oracle911oracle.install.db.InstallEdition=EE912oracle.install.db.DBA_GROUP=dba913oracle.install.db.OPER_GROUP=oper914oracle.install.db.CLUSTER_NODES=openEuler01,openEuler02915oracle.install.db.OSBACKUPDBA_GROUP=backupdba916oracle.install.db.OSDGDBA_GROUP=dgdba917oracle.install.db.OSKMDBA_GROUP=kmdba918oracle.install.db.OSRACDBA_GROUP=racdba919oracle.install.db.rootconfig.executeRootScript=false920oracle.install.db.rootconfig.configMethod=921oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v19.0.0922923#==============================================================# 924静默安装数据库软件 925#==============================================================# 926927Preparing the home to patch...928Applying the patch /soft/35940989...929Successfully applied the patch.930The log can be found at: /u01/app/oraInventory/logs/InstallActions2024-03-21_11-16-04AM/installerPatchActions_2024-03-21_11-16-04AM.log931Launching Oracle Database Setup Wizard...932933[WARNING] [INS-13013] Target environment does not meet some mandatory requirements.934 CAUSE: Some of the mandatory prerequisites are not met. See logs for details. /u01/app/oraInventory/logs/InstallActions2024-03-21_11-16-04AM/installActions2024-03-21_11-16-04AM.log935 ACTION: Identify the list of failed prerequisite checks from the log: /u01/app/oraInventory/logs/InstallActions2024-03-21_11-16-04AM/installActions2024-03-21_11-16-04AM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.936The response file for this session can be found at:937 /u01/app/oracle/product/19.3.0/db/install/response/db_2024-03-21_11-16-04AM.rsp938939You can find the log of this install session at:940 /u01/app/oraInventory/logs/InstallActions2024-03-21_11-16-04AM/installActions2024-03-21_11-16-04AM.log941942As a root user, execute the following script(s):943 1. /u01/app/oracle/product/19.3.0/db/root.sh944945Execute /u01/app/oracle/product/19.3.0/db/root.sh on the following nodes: 946[openEuler01, openEuler02]947948949Successfully Setup Software with warning(s).950951#==============================================================# 952执行 root 脚本 953#==============================================================# 954955节点 192.168.6.130 ： 956957Changing permissions of /u01/app/oraInventory.958Adding read,write permissions for group.959Removing read,write,execute permissions for world.960961Changing groupname of /u01/app/oraInventory to oinstall.962The execution of the script is complete.963Check /u01/app/oracle/product/19.3.0/db/install/root_openEuler01_2024-03-21_11-56-19-366497121.log for the output of root script964965节点 192.168.6.131 ： 966967Changing permissions of /u01/app/oraInventory.968Adding read,write permissions for group.969Removing read,write,execute permissions for world.970971Changing groupname of /u01/app/oraInventory to oinstall.972The execution of the script is complete.973Check /u01/app/oracle/product/19.3.0/db/install/root_openEuler02_2024-03-21_11-56-20-424984369.log for the output of root script974975#==============================================================# 976OJVM 补丁安装 977#==============================================================# 978979节点 192.168.6.130 ： 980981Oracle Interim Patch Installer version 12.2.0.1.40982Copyright (c) 2024, Oracle Corporation. All rights reserved.983984PREREQ session985986Oracle Home : /u01/app/oracle/product/19.3.0/db987Central Inventory : /u01/app/oraInventory988 from : /u01/app/oracle/product/19.3.0/db/oraInst.loc989OPatch version : 12.2.0.1.40990OUI version : 12.2.0.7.0991Log file location : /u01/app/oracle/product/19.3.0/db/cfgtoollogs/opatch/opatch2024-03-21_11-56-22AM_1.log992993Invoking prereq "checkconflictagainstohwithdetail"994995Prereq "checkConflictAgainstOHWithDetail" passed.996997OPatch succeeded.998Oracle Interim Patch Installer version 12.2.0.1.40999Copyright (c) 2024, Oracle Corporation. All rights reserved.100010011002Oracle Home : /u01/app/oracle/product/19.3.0/db1003Central Inventory : /u01/app/oraInventory1004 from : /u01/app/oracle/product/19.3.0/db/oraInst.loc1005OPatch version : 12.2.0.1.401006OUI version : 12.2.0.7.01007Log file location : /u01/app/oracle/product/19.3.0/db/cfgtoollogs/opatch/opatch2024-03-21_11-56-40AM_1.log10081009Verifying environment and performing prerequisite checks...1010OPatch continues with these patches: 35926646 10111012Do you want to proceed? [y|n]1013Y (auto-answered by -silent)1014User Responded with: Y1015All checks passed.10161017Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.1018(Oracle Home = '/u01/app/oracle/product/19.3.0/db')101910201021Is the local system ready for patching? [y|n]1022Y (auto-answered by -silent)1023User Responded with: Y1024Backing up files...1025Applying interim patch '35926646' to OH '/u01/app/oracle/product/19.3.0/db'10261027Patching component oracle.javavm.server, 19.0.0.0.0...10281029Patching component oracle.javavm.server.core, 19.0.0.0.0...10301031Patching component oracle.rdbms.dbscripts, 19.0.0.0.0...10321033Patching component oracle.rdbms, 19.0.0.0.0...10341035Patching component oracle.javavm.client, 19.0.0.0.0...1036Patch 35926646 successfully applied.1037Log file location: /u01/app/oracle/product/19.3.0/db/cfgtoollogs/opatch/opatch2024-03-21_11-56-40AM_1.log10381039OPatch succeeded.10401041节点 192.168.6.131 ： 10421043Oracle Interim Patch Installer version 12.2.0.1.401044Copyright (c) 2024, Oracle Corporation. All rights reserved.10451046PREREQ session10471048Oracle Home : /u01/app/oracle/product/19.3.0/db1049Central Inventory : /u01/app/oraInventory1050 from : /u01/app/oracle/product/19.3.0/db/oraInst.loc1051OPatch version : 12.2.0.1.401052OUI version : 12.2.0.7.01053Log file location : /u01/app/oracle/product/19.3.0/db/cfgtoollogs/opatch/opatch2024-03-21_11-59-15AM_1.log10541055Invoking prereq "checkconflictagainstohwithdetail"10561057Prereq "checkConflictAgainstOHWithDetail" passed.10581059OPatch succeeded.1060Oracle Interim Patch Installer version 12.2.0.1.401061Copyright (c) 2024, Oracle Corporation. All rights reserved.106210631064Oracle Home : /u01/app/oracle/product/19.3.0/db1065Central Inventory : /u01/app/oraInventory1066 from : /u01/app/oracle/product/19.3.0/db/oraInst.loc1067OPatch version : 12.2.0.1.401068OUI version : 12.2.0.7.01069Log file location : /u01/app/oracle/product/19.3.0/db/cfgtoollogs/opatch/opatch2024-03-21_11-59-33AM_1.log10701071Verifying environment and performing prerequisite checks...1072OPatch continues with these patches: 35926646 10731074Do you want to proceed? [y|n]1075Y (auto-answered by -silent)1076User Responded with: Y1077All checks passed.10781079Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.1080(Oracle Home = '/u01/app/oracle/product/19.3.0/db')108110821083Is the local system ready for patching? [y|n]1084Y (auto-answered by -silent)1085User Responded with: Y1086Backing up files...1087Applying interim patch '35926646' to OH '/u01/app/oracle/product/19.3.0/db'10881089Patching component oracle.javavm.server, 19.0.0.0.0...10901091Patching component oracle.javavm.server.core, 19.0.0.0.0...10921093Patching component oracle.rdbms.dbscripts, 19.0.0.0.0...10941095Patching component oracle.rdbms, 19.0.0.0.0...10961097Patching component oracle.javavm.client, 19.0.0.0.0...1098Patch 35926646 successfully applied.1099Log file location: /u01/app/oracle/product/19.3.0/db/cfgtoollogs/opatch/opatch2024-03-21_11-59-33AM_1.log11001101OPatch succeeded.11021103#==============================================================# 1104Oracle 软件版本 1105#==============================================================# 110611071108SQL*Plus: Release 19.0.0.0.0 - Production1109Version 19.22.0.0.0111011111112#==============================================================# 1113Oracle 补丁信息 1114#==============================================================# 1115111635926646;OJVM RELEASE UPDATE: 19.22.0.0.240116 (35926646)111735967489;OCW RELEASE UPDATE 19.22.0.0.0 (35967489)111835943157;Database Release Update : 19.22.0.0.240116 (35943157)11191120OPatch succeeded.112111221123#==============================================================# 1124静默建库命令 1125#==============================================================# 11261127dbca -silent -createDatabase \1128-ignorePrereqFailure \1129-templateName General_Purpose.dbc \1130-responseFile NO_VALUE \1131-gdbName lucifer \1132-sid lucifer \1133-sysPassword oracle \1134-systemPassword oracle \1135-redoLogFileSize 100 \1136-diskGroupName +DATA \1137-storageType ASM -enableArchive true \1138-archiveLogDest +DATA \1139-databaseConfigType RAC \1140-nodeinfo openEuler01,openEuler02 \1141-characterset AL32UTF8 \1142-nationalCharacterSet AL16UTF16 \1143-emConfiguration NONE \1144-automaticMemoryManagement false \1145-totalMemory 3716 \1146-databaseType OLTP \1147-createAsContainerDatabase false 11481149#==============================================================# 1150创建数据库 1151#==============================================================# 11521153[WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards.1154 CAUSE: 1155a. 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].1156b.The password entered is a keyword that Oracle does not recommend to be used as password1157 ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.1158[WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards.1159 CAUSE: 1160a. 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].1161b.The password entered is a keyword that Oracle does not recommend to be used as password1162 ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.1163Prepare for db operation11648% complete1165Copying database files116633% complete1167Creating and starting Oracle instance116834% complete116935% complete117039% complete117142% complete117245% complete117350% complete1174Creating cluster database views117552% complete117667% complete1177Completing Database Creation117871% complete117973% complete118075% complete1181Executing Post Configuration Actions1182100% complete1183Database creation complete. For details check the logfiles at:1184 /u01/app/oracle/cfgtoollogs/dbca/lucifer.1185Database Information:1186Global Database Name:lucifer1187System Identifier(SID) Prefix:lucifer1188Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/lucifer/lucifer.log" for further details.11891190#==============================================================# 1191配置 OMF && 优化 RMAN 1192#==============================================================# 119311941195Recovery Manager: Release 19.0.0.0.0 - Production on Thu Mar 21 12:34:23 20241196Version 19.22.0.0.011971198Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.11991200connected to target database: LUCIFER (DBID=4020080529)12011202RMAN> 1203using target database control file instead of recovery catalog1204new RMAN configuration parameters:1205CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATA/snapcf_fdcdb1.f';1206new RMAN configuration parameters are successfully stored12071208RMAN> 12091210Recovery Manager complete.121112121213#==============================================================# 1214配置控制文件复用 1215#==============================================================# 121612171218Recovery Manager: Release 19.0.0.0.0 - Production on Thu Mar 21 12:36:21 20241219Version 19.22.0.0.012201221Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.12221223connected to target database: LUCIFER (not mounted)12241225RMAN> 1226Starting restore at 21-MAR-241227using target database control file instead of recovery catalog1228allocated channel: ORA_DISK_11229channel ORA_DISK_1: SID=133 instance=lucifer1 device type=DISK12301231channel ORA_DISK_1: copied control file copy1232Finished restore at 21-MAR-24123312341235Recovery Manager complete.12361237数据库控制文件： 123812391240NAME1241----------------------------------------------------------------------------------------------------1242+DATA/LUCIFER/CONTROLFILE/current.261.11641972651243+DATA/LUCIFER/CONTROLFILE/control02.ctl12441245#==============================================================# 1246配置在线重做日志 1247#==============================================================# 12481249数据库在线重做日志文件： 125012511252 THREAD# GROUP# MEMBER size(M)1253---------- ---------- ------------------------------------------------------------------------------------------------------------------------ ----------1254 1 1 +DATA/LUCIFER/ONLINELOG/group_1.262.1164197267 1001255 1 2 +DATA/LUCIFER/ONLINELOG/group_2.263.1164197267 1001256 1 11 +DATA/LUCIFER/ONLINELOG/group_11.274.1164199055 1001257 1 12 +DATA/LUCIFER/ONLINELOG/group_12.275.1164199057 1001258 1 13 +DATA/LUCIFER/ONLINELOG/group_13.276.1164199059 1001259 1 14 +DATA/LUCIFER/ONLINELOG/group_14.277.1164199061 1001260 1 15 +DATA/LUCIFER/ONLINELOG/group_15.278.1164199065 1001261 2 3 +DATA/LUCIFER/ONLINELOG/group_3.266.1164198731 1001262 2 4 +DATA/LUCIFER/ONLINELOG/group_4.267.1164198733 1001263 2 21 +DATA/LUCIFER/ONLINELOG/group_21.279.1164199067 1001264 2 22 +DATA/LUCIFER/ONLINELOG/group_22.280.1164199069 1001265 2 23 +DATA/LUCIFER/ONLINELOG/group_23.281.1164199071 1001266 2 24 +DATA/LUCIFER/ONLINELOG/group_24.282.1164199077 1001267 2 25 +DATA/LUCIFER/ONLINELOG/group_25.283.1164199079 10012681269#==============================================================# 1270配置 RMAN 备份任务 1271#==============================================================# 12721273## OracleBegin127400 02 * * * /home/oracle/scripts/del_arch.sh1275#00 00 * * 0 /home/oracle/scripts/dbbackup_lv0.sh1276#00 00 * * 1,2,3,4,5,6 /home/oracle/scripts/dbbackup_lv1.sh12771278#==============================================================# 1279配置 glogin.sql 1280#==============================================================# 12811282define _editor=vi1283set serveroutput on size 10000001284set pagesize 99991285set long 999991286set trimspool on1287col name format a801288set termout off1289define gname=idle1290column global_name new_value gname1291select lower(user) || '@' || substr( global_name, 1, decode( dot, 0, length(global_name), dot-1) ) global_name from (select global_name, instr(global_name,'.') dot from global_name );1292ALTER SESSION SET nls_date_format = 'YYYY-MM-DD HH24:MI:SS';1293set sqlprompt '&gname _DATE> '1294set termout on12951296#==============================================================# 1297优化数据库参数 1298#==============================================================# 12991300数据库参数： 130113021303NAME SID SPVALUE VALUE1304-------------------------------------------------- ---------- -------------------------------------------------------------------------------- --------------------------------------------------------------------------------1305_b_tree_bitmap_plans * FALSE FALSE1306_datafile_write_errors_crash_instance * FALSE FALSE1307audit_file_dest * /u01/app/oracle/admin/lucifer/adump /u01/app/oracle/admin/lucifer/adump1308audit_trail * NONE DB1309cluster_database * true TRUE1310compatible * 19.0.0 19.0.01311control_file_record_keep_time * 31 311312db_block_size * 8192 81921313db_create_file_dest * +DATA +DATA1314db_file_multiblock_read_count * 1281315db_files * 5000 2001316db_name * lucifer lucifer1317db_writer_processes * 11318deferred_segment_creation * FALSE FALSE1319diagnostic_dest * /u01/app/oracle /u01/app/oracle1320dispatchers * (PROTOCOL=TCP) (SERVICE=luciferXDB) (PROTOCOL=TCP) (SERVICE=luciferXDB)1321event * 10949 trace name context forever,level 11322event * 28401 trace name context forever,level 11323fast_start_parallel_rollback * LOW1324instance_mode * read-only READ-WRITE1325log_archive_dest_1 * location=+DATA location=+DATA1326log_archive_format * %t_%s_%r.dbf %t_%s_%r.dbf1327max_dump_file_size * unlimited1328max_string_size * STANDARD1329nls_language * AMERICAN AMERICAN1330nls_territory * AMERICA AMERICA1331open_cursors * 1000 3001332optimizer_adaptive_plans * TRUE1333optimizer_adaptive_statistics * FALSE1334optimizer_index_caching * 01335optimizer_mode * ALL_ROWS1336parallel_force_local * TRUE FALSE1337parallel_max_servers * 64 641338pga_aggregate_target * 1246756864 7801405441339processes * 2000 6401340remote_login_passwordfile * exclusive EXCLUSIVE1341session_cached_cursors * 300 501342sessions * 9841343sga_max_size * 4988076032 31205621761344sga_target * 4988076032 31205621761345spfile * +DATA/LUCIFER/PARAMETERFILE/spfile.269.11641987371346statistics_level * TYPICAL1347undo_retention * 10800 90013481349恭喜！Oracle RAC 安装成功，现在是否重启主机：[Y/N] N