在知识库中专注阅读，并随时返回相关工具与课程
Oracle 一键安装脚本，演示 2 节点 RAC 一键安装过程（全程无需人工干预）：（脚本包括 <font color='red'GRID/ORALCE PSU/OJVM 补丁自动安装</font） ⭐️ <font color='red'脚本下载地址</font：Shell脚本安装Oracle数据库https://ora100.com/shell-install 脚本第三代支持 N 节点
系统学习 Oracle DBA
开通会员 ¥128/月起
查看完整课程Oracle 一键安装脚本，演示 2 节点 RAC 一键安装过程（全程无需人工干预）：（脚本包括 GRID/ORALCE PSU/OJVM 补丁自动安装）
⭐️ 脚本下载地址：Shell脚本安装Oracle数据库
脚本第三代支持 N 节点一键安装，不限制节点数！
1[root@rac01 soft]# ./OracleShellInstall -n rac `# hostname prefix`\2> -hn rac01,rac02 `# rac node hostname`\3> -cn rac-cls `# cluster_name`\4> -rp oracle `# root password`\5> -gp oracle `# grid password`\6> -op oracle `# oracle password`\7> -lf ens192 `# local ip ifname`\8> -pf ens224 `# rac private ip ifname`\9> -ri 192.168.6.151,192.168.6.152 `# rac node public ip`\10> -vi 192.168.6.153,192.168.6.154 `# rac virtual ip`\11> -si 192.168.6.155 `# rac scan ip`\12> -od /dev/sdb `# rac ocr asm disk`\13> -dd /dev/sdc `# rac data asm disk`\14> -o lucifer `# dbname`\15> -ds AL32UTF8 `# database character`\16> -ns AL16UTF16 `# national character`\17> -dp oracle `# sys/system password`\18> -gpa 35940989 `# grid PSU/RU`\19> -ud Y2021 ███████ ██ ████████ ██ ██ ██ ██ ██ ██ ██22 ██░░░░░██ ░██ ██░░░░░░ ░██ ░██ ░██░██ ░██ ░██ ░██23 ██ ░░██ ██████ ██████ █████ ░██ █████ ░██ ░██ █████ ░██ ░██░██ ███████ ██████ ██████ ██████ ░██ ░██24░██ ░██░░██░░█ ░░░░░░██ ██░░░██ ░██ ██░░░██░█████████░██████ ██░░░██ ░██ ░██░██░░██░░░██ ██░░░░ ░░░██░ ░░░░░░██ ░██ ░██25░██ ░██ ░██ ░ ███████ ░██ ░░ ░██░███████░░░░░░░░██░██░░░██░███████ ░██ ░██░██ ░██ ░██░░█████ ░██ ███████ ░██ ░██26░░██ ██ ░██ ██░░░░██ ░██ ██ ░██░██░░░░ ░██░██ ░██░██░░░░ ░██ ░██░██ ░██ ░██ ░░░░░██ ░██ ██░░░░██ ░██ ░██27 ░░███████ ░███ ░░████████░░█████ ███░░██████ ████████ ░██ ░██░░██████ ███ ███░██ ███ ░██ ██████ ░░██ ░░████████ ███ ███28 ░░░░░░░ ░░░ ░░░░░░░░ ░░░░░ ░░░ ░░░░░░ ░░░░░░░░ ░░ ░░ ░░░░░░ ░░░ ░░░ ░░ ░░░ ░░ ░░░░░░ ░░ ░░░░░░░░ ░░░ ░░░ 293031请选择安装模式 [单机(si)/单机ASM(sa)/集群(rac)] : rac3233数据库安装模式: rac 3435请选择数据库版本 [11203/11/12/19/21] : 193637数据库版本: 19 3839#==============================================================# 40配置本地 YUM 源 41#==============================================================# 4243[server]44name=server45baseurl=file:///mnt46enabled=147gpgcheck=04849#==============================================================# 50获取 ASM 磁盘 UUID && 格式化磁盘头 51#==============================================================# 5253格式化 OCR 磁盘：/dev/sdb 54551+0 records in561+0 records out571024 bytes (1.0 kB) copied, 0.0471055 s, 21.7 kB/s5859OCR磁盘组的磁盘UUID： 2e87e4f535c397171 6061格式化 DATA 磁盘：/dev/sdc 62631+0 records in641+0 records out651024 bytes (1.0 kB) copied, 0.0396776 s, 25.8 kB/s6667DATA磁盘组的磁盘UUID： 2f218dae15b551c5d 6869#==============================================================# 70配置 root 用户互信 71#==============================================================# 7273Generating public/private rsa key pair.74Your identification has been saved in /root/.ssh/id_rsa.75Your public key has been saved in /root/.ssh/id_rsa.pub.76The key fingerprint is:77SHA256:WWoGD210PXUNrmIMaZZY4Tkh1KeJnjQlEk//8tBpAZw root@rac0178The key's randomart image is:79+---[RSA 2048]----+80| .o+o*o.. .o.o|81| .o.OEB. o. ..|82| .=+&+o .. |83| +BoX o . |84| o oS O . |85| oo * . |86| . |87| |88| |89+----[SHA256]-----+9091#==============================================================# 92禁用防火墙 93#==============================================================# 9495● firewalld.service - firewalld - dynamic firewall daemon96 Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)97 Active: inactive (dead)98 Docs: man:firewalld(1)99100Mar 11 14:50:08 rac01 systemd[1]: Starting firewalld - dynamic firewall daemon...101Mar 11 14:50:10 rac01 systemd[1]: Started firewalld - dynamic firewall daemon.102Mar 11 14:50:11 rac01 firewalld[982]: WARNING: AllowZoneDrifting is enabled. This is considered an insecure configuration option. It will be removed in a future release. Please consider disabling it now.103Mar 12 13:38:19 rac01 systemd[1]: Stopping firewalld - dynamic firewall daemon...104Mar 12 13:38:20 rac01 systemd[1]: Stopped firewalld - dynamic firewall daemon.105106#==============================================================# 107禁用 SELinux 108#==============================================================# 109110SELinux status: enabled111SELinuxfs mount: /sys/fs/selinux112SELinux root directory: /etc/selinux113Loaded policy name: targeted114Current mode: permissive115Mode from config file: disabled116Policy MLS status: enabled117Policy deny_unknown status: allowed118Max kernel policy version: 31119120#==============================================================# 121YUM 静默安装依赖包 122#==============================================================# 123124bc-1.06.95-13.el7.x86_64125binutils-2.27-44.base.el7.x86_64126compat-libcap1-1.10-7.el7.x86_64127gcc-4.8.5-44.el7.x86_64128gcc-c++-4.8.5-44.el7.x86_64129elfutils-libelf-0.176-5.el7.x86_64130elfutils-libelf-devel-0.176-5.el7.x86_64131glibc-2.17-317.el7.x86_64132glibc-devel-2.17-317.el7.x86_64133libaio-0.3.109-13.el7.x86_64134libaio-devel-0.3.109-13.el7.x86_64135libgcc-4.8.5-44.el7.x86_64136libstdc++-4.8.5-44.el7.x86_64137libstdc++-devel-4.8.5-44.el7.x86_64138libxcb-1.13-1.el7.x86_64139libX11-1.6.7-2.el7.x86_64140libXau-1.0.8-2.1.el7.x86_64141libXi-1.7.9-1.el7.x86_64142libXrender-0.9.10-1.el7.x86_64143make-3.82-24.el7.x86_64144net-tools-2.0-0.25.20131004git.el7.x86_64145smartmontools-7.0-2.el7.x86_64146sysstat-10.1.5-19.el7.x86_64147e2fsprogs-1.42.9-19.el7.x86_64148e2fsprogs-libs-1.42.9-19.el7.x86_64149unzip-6.0-21.el7.x86_64150openssh-clients-7.4p1-21.el7.x86_64151readline-6.2-11.el7.x86_64152readline-devel-6.2-11.el7.x86_64153psmisc-22.20-17.el7.x86_64154ksh-20120801-142.el7.x86_64155nfs-utils-1.3.0-0.68.el7.x86_64156tar-1.26-35.el7.x86_64157device-mapper-multipath-0.4.9-133.el7.x86_64158avahi-0.6.31-20.el7.x86_64159ntp-4.2.6p5-29.el7_8.2.x86_64160chrony-3.4-1.el7.x86_64161libXtst-1.2.3-1.el7.x86_64162libXrender-devel-0.9.10-1.el7.x86_64163fontconfig-devel-2.13.0-4.3.el7.x86_64164policycoreutils-2.5-34.el7.x86_64165policycoreutils-python-2.5-34.el7.x86_64166167#==============================================================# 168配置主机名 169#==============================================================# 170171rac01172173#==============================================================# 174配置 /etc/hosts 文件 175#==============================================================# 176177127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4178::1 localhost localhost.localdomain localhost6 localhost6.localdomain6179180## OracleBegin181182## RAC1 IP's: rac01183184## RAC1 Public IP185192.168.6.151 rac01186## RAC1 Virtual IP187192.168.6.153 rac01-vip188## RAC1 Private IP1891.1.1.1 rac01-priv190191## RAC2 IP's: rac02192193## RAC2 Public IP194192.168.6.152 rac02195## RAC2 Virtual IP196192.168.6.154 rac02-vip197## RAC2 Private IP1981.1.1.2 rac02-priv199200## SCAN IP201192.168.6.155 rac-scan202203#==============================================================# 204创建用户和组 205#==============================================================# 206207oracle 用户： 208209uid=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)210211grid 用户： 212213uid=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)214215216#==============================================================# 217配置 Avahi-daemon 服务 218#==============================================================# 219220● avahi-daemon.service - Avahi mDNS/DNS-SD Stack221 Loaded: loaded (/usr/lib/systemd/system/avahi-daemon.service; disabled; vendor preset: enabled)222 Active: inactive (dead)223224Mar 12 13:33:14 rac01 avahi-daemon[877]: Registering new address record for fe80::f5b9:ca65:dba2:bf0 on ens192.*.225Mar 12 13:33:14 rac01 avahi-daemon[877]: Joining mDNS multicast group on interface ens192.IPv4 with address 192.168.6.151.226Mar 12 13:33:14 rac01 avahi-daemon[877]: New relevant interface ens192.IPv4 for mDNS.227Mar 12 13:33:14 rac01 avahi-daemon[877]: Registering new address record for 192.168.6.151 on ens192.IPv4.228Mar 12 13:33:14 rac01 avahi-daemon[877]: Registering new address record for fe80::a8ce:7574:2cec:a98e on ens224.*.229Mar 12 13:33:14 rac01 avahi-daemon[877]: Joining mDNS multicast group on interface ens224.IPv4 with address 1.1.1.1.230Mar 12 13:33:14 rac01 avahi-daemon[877]: New relevant interface ens224.IPv4 for mDNS.231Mar 12 13:33:14 rac01 avahi-daemon[877]: Registering new address record for 1.1.1.1 on ens224.IPv4.232Mar 12 13:39:02 rac01 systemd[1]: Stopping Avahi mDNS/DNS-SD Stack...233Mar 12 13:39:02 rac01 systemd[1]: Stopped Avahi mDNS/DNS-SD Stack.234235#==============================================================# 236配置透明大页 && NUMA && 磁盘 IO 调度器 237#==============================================================# 238239args="ro rd.lvm.lv=rhel/root rd.lvm.lv=rhel/swap rhgb quiet LANG=en_US.UTF-8 numa=off transparent_hugepage=never elevator=deadline"240-rd.lvm.lv=rhel/root241-args="ro242args="ro rd.lvm.lv=rhel/root rd.lvm.lv=rhel/swap rhgb quiet numa=off transparent_hugepage=never elevator=deadline"243-elevator=deadline"244-transparent_hugepage=never245246#==============================================================# 247配置 sysctl.conf 248#==============================================================# 249250fs.aio-max-nr = 1048576251fs.file-max = 6815744252kernel.shmall = 2097152253kernel.shmmax = 8369385471254kernel.shmmni = 4096255kernel.sem = 250 32000 100 128256net.ipv4.ip_local_port_range = 9000 65500257net.core.rmem_default = 262144258net.core.rmem_max = 4194304259net.core.wmem_default = 262144260net.core.wmem_max = 1048576261vm.min_free_kbytes = 32692262net.ipv4.conf.ens192.rp_filter = 1263vm.swappiness = 10264kernel.panic_on_oops = 1265kernel.randomize_va_space = 2266kernel.numa_balancing = 0267net.ipv4.conf.ens224.rp_filter = 2268269#==============================================================# 270配置 nsysctl.conf 271#==============================================================# 272273NOZEROCONF=yes274275#==============================================================# 276配置 RemoveIPC 277#==============================================================# 278279[Login]280RemoveIPC=no281282#==============================================================# 283配置 /etc/security/limits.conf 和 /etc/pam.d/login 284#==============================================================# 285286查看 /etc/security/limits.conf： 287288oracle soft nofile 1024289oracle hard nofile 65536290oracle soft stack 10240291oracle hard stack 32768292oracle soft nproc 2047293oracle hard nproc 16384294oracle hard memlock unlimited295oracle soft memlock unlimited296grid soft nofile 1024297grid hard nofile 65536298grid soft stack 10240299grid hard stack 32768300grid soft nproc 2047301grid hard nproc 16384302303查看 /etc/pam.d/login 文件： 304305auth [user_unknown=ignore success=ok ignore=ignore default=bad] pam_securetty.so306auth substack system-auth307auth include postlogin308account required pam_nologin.so309account include system-auth310password include system-auth311session required pam_selinux.so close312session required pam_loginuid.so313session optional pam_console.so314session required pam_selinux.so open315session required pam_namespace.so316session optional pam_keyinit.so force revoke317session include system-auth318session include postlogin319-session optional pam_ck_connector.so320session required pam_limits.so321session required /lib64/security/pam_limits.so322323#==============================================================# 324配置 /dev/shm 325#==============================================================# 326327/dev/mapper/rhel-root / xfs defaults 0 0328UUID=64fa46ff-7a45-4939-b2bf-f995a20165d1 /boot xfs defaults 0 0329/dev/mapper/rhel-swap swap swap defaults 0 0330tmpfs /dev/shm tmpfs size=8173228k 0 0331332#==============================================================# 333安装 rlwrap 插件 334#==============================================================# 335336成功安装 rlwrap： rlwrap 0.44 337338#==============================================================# 339Root 用户环境变量 340#==============================================================# 341342if [ -f ~/.bashrc ]; then343 . ~/.bashrc344fi345PATH=$PATH:$HOME/bin346export PATH347alias so='su - oracle'348export PS1="[`whoami`@`hostname`:"'$PWD]$ '349alias sg='su - grid'350alias crsctl='/u01/app/19.3.0/grid/bin/crsctl'351alias srvctl='/u01/app/19.3.0/grid/bin/srvctl'352353#==============================================================# 354Oracle 用户环境变量 355#==============================================================# 356357if [ -f ~/.bashrc ]; then358 . ~/.bashrc359fi360PATH=$PATH:$HOME/.local/bin:$HOME/bin361export PATH362umask 022363export TMP=/tmp364export TMPDIR=$TMP365export NLS_LANG=AMERICAN_AMERICA.AL32UTF8366export ORACLE_BASE=/u01/app/oracle367export ORACLE_HOME=/u01/app/oracle/product/19.3.0/db368export ORACLE_TERM=xterm369export TNS_ADMIN=$ORACLE_HOME/network/admin370export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib371export ORACLE_SID=lucifer1372export PATH=/usr/sbin:$PATH373export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/perl/bin:$PATH374export PERL5LIB=$ORACLE_HOME/perl/lib375alias sas='sqlplus / as sysdba'376alias awr='sqlplus / as sysdba @?/rdbms/admin/awrrpt'377alias ash='sqlplus / as sysdba @?/rdbms/admin/ashrpt'378alias alert='vi $ORACLE_BASE/diag/rdbms/*/$ORACLE_SID/trace/alert_$ORACLE_SID.log'379export PS1="[`whoami`@`hostname`:"'$PWD]$ '380alias sqlplus='rlwrap sqlplus'381alias rman='rlwrap rman'382alias adrci='rlwrap adrci'383384#==============================================================# 385Grid 用户环境变量 386#==============================================================# 387388if [ -f ~/.bashrc ]; then389 . ~/.bashrc390fi391PATH=$PATH:$HOME/.local/bin:$HOME/bin392export PATH393umask 022394export TMP=/tmp395export TMPDIR=$TMP396export NLS_LANG=AMERICAN_AMERICA.AL32UTF8397export ORACLE_BASE=/u01/app/grid398export ORACLE_HOME=/u01/app/19.3.0/grid399export ORACLE_TERM=xterm400export TNS_ADMIN=$ORACLE_HOME/network/admin401export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib402export ORACLE_SID=+ASM1403export PATH=/usr/sbin:$PATH404export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH405alias sas='sqlplus / as sysasm'406export PS1="[`whoami`@`hostname`:"'$PWD]$ '407alias sqlplus='rlwrap sqlplus'408alias asmcmd='rlwrap asmcmd'409alias adrci='rlwrap adrci'410411#==============================================================# 412配置 multipath 多路径 413#==============================================================# 414415create: asm_ocr_1 (2e87e4f535c397171) undef ROCKET ,IMAGEFILE 416size=10G features='0' hwhandler='0' wp=undef417`-+- policy='service-time 0' prio=1 status=undef418 `- 33:0:0:0 sdb 8:16 undef ready running419create: asm_data_1 (2f218dae15b551c5d) undef ROCKET ,IMAGEFILE 420size=20G features='0' hwhandler='0' wp=undef421`-+- policy='service-time 0' prio=1 status=undef422 `- 33:0:0:1 sdc 8:32 undef ready running423424#==============================================================# 425配置 UDEV 绑盘 426#==============================================================# 427428KERNEL=="dm-*",ENV{DM_UUID}=="mpath-2e87e4f535c397171",SYMLINK+="asm_ocr_1",OWNER="grid",GROUP="asmadmin",MODE="0660"429KERNEL=="dm-*",ENV{DM_UUID}=="mpath-2f218dae15b551c5d",SYMLINK+="asm_data_1",OWNER="grid",GROUP="asmadmin",MODE="0660"430431/dev/asm_data_1432/dev/asm_ocr_1433434UDEV 配置完成! 435436#==============================================================# 437配置 RAC 节点：192.168.6.152 438#==============================================================# 439440正在节点：192.168.6.152 上执行脚本： 441442 ███████ ██ ████████ ██ ██ ██ ██ ██ ██ ██443 ██░░░░░██ ░██ ██░░░░░░ ░██ ░██ ░██░██ ░██ ░██ ░██444 ██ ░░██ ██████ ██████ █████ ░██ █████ ░██ ░██ █████ ░██ ░██░██ ███████ ██████ ██████ ██████ ░██ ░██445░██ ░██░░██░░█ ░░░░░░██ ██░░░██ ░██ ██░░░██░█████████░██████ ██░░░██ ░██ ░██░██░░██░░░██ ██░░░░ ░░░██░ ░░░░░░██ ░██ ░██446░██ ░██ ░██ ░ ███████ ░██ ░░ ░██░███████░░░░░░░░██░██░░░██░███████ ░██ ░██░██ ░██ ░██░░█████ ░██ ███████ ░██ ░██447░░██ ██ ░██ ██░░░░██ ░██ ██ ░██░██░░░░ ░██░██ ░██░██░░░░ ░██ ░██░██ ░██ ░██ ░░░░░██ ░██ ██░░░░██ ░██ ░██448 ░░███████ ░███ ░░████████░░█████ ███░░██████ ████████ ░██ ░██░░██████ ███ ███░██ ███ ░██ ██████ ░░██ ░░████████ ███ ███449 ░░░░░░░ ░░░ ░░░░░░░░ ░░░░░ ░░░ ░░░░░░ ░░░░░░░░ ░░ ░░ ░░░░░░ ░░░ ░░░ ░░ ░░░ ░░ ░░░░░░ ░░ ░░░░░░░░ ░░░ ░░░ 450451452#==============================================================# 453配置本地 YUM 源 454#==============================================================# 455456[server]457name=server458baseurl=file:///mnt459enabled=1460gpgcheck=0461462#==============================================================# 463禁用防火墙 464#==============================================================# 465466● firewalld.service - firewalld - dynamic firewall daemon467 Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)468 Active: inactive (dead)469 Docs: man:firewalld(1)470471Mar 11 14:50:11 rac02 systemd[1]: Starting firewalld - dynamic firewall daemon...472Mar 11 14:50:13 rac02 systemd[1]: Started firewalld - dynamic firewall daemon.473Mar 11 14:50:13 rac02 firewalld[972]: WARNING: AllowZoneDrifting is enabled. This is considered an insecure configuration option. It will be removed in a future release. Please consider disabling it now.474Mar 12 13:39:35 rac02 systemd[1]: Stopping firewalld - dynamic firewall daemon...475Mar 12 13:39:36 rac02 systemd[1]: Stopped firewalld - dynamic firewall daemon.476477#==============================================================# 478禁用 SELinux 479#==============================================================# 480481SELinux status: enabled482SELinuxfs mount: /sys/fs/selinux483SELinux root directory: /etc/selinux484Loaded policy name: targeted485Current mode: permissive486Mode from config file: disabled487Policy MLS status: enabled488Policy deny_unknown status: allowed489Max kernel policy version: 31490491#==============================================================# 492YUM 静默安装依赖包 493#==============================================================# 494495bc-1.06.95-13.el7.x86_64496binutils-2.27-44.base.el7.x86_64497compat-libcap1-1.10-7.el7.x86_64498gcc-4.8.5-44.el7.x86_64499gcc-c++-4.8.5-44.el7.x86_64500elfutils-libelf-0.176-5.el7.x86_64501elfutils-libelf-devel-0.176-5.el7.x86_64502glibc-2.17-317.el7.x86_64503glibc-devel-2.17-317.el7.x86_64504libaio-0.3.109-13.el7.x86_64505libaio-devel-0.3.109-13.el7.x86_64506libgcc-4.8.5-44.el7.x86_64507libstdc++-4.8.5-44.el7.x86_64508libstdc++-devel-4.8.5-44.el7.x86_64509libxcb-1.13-1.el7.x86_64510libX11-1.6.7-2.el7.x86_64511libXau-1.0.8-2.1.el7.x86_64512libXi-1.7.9-1.el7.x86_64513libXrender-0.9.10-1.el7.x86_64514make-3.82-24.el7.x86_64515net-tools-2.0-0.25.20131004git.el7.x86_64516smartmontools-7.0-2.el7.x86_64517sysstat-10.1.5-19.el7.x86_64518e2fsprogs-1.42.9-19.el7.x86_64519e2fsprogs-libs-1.42.9-19.el7.x86_64520unzip-6.0-21.el7.x86_64521openssh-clients-7.4p1-21.el7.x86_64522readline-6.2-11.el7.x86_64523readline-devel-6.2-11.el7.x86_64524psmisc-22.20-17.el7.x86_64525ksh-20120801-142.el7.x86_64526nfs-utils-1.3.0-0.68.el7.x86_64527tar-1.26-35.el7.x86_64528device-mapper-multipath-0.4.9-133.el7.x86_64529avahi-0.6.31-20.el7.x86_64530ntp-4.2.6p5-29.el7_8.2.x86_64531chrony-3.4-1.el7.x86_64532libXtst-1.2.3-1.el7.x86_64533libXrender-devel-0.9.10-1.el7.x86_64534fontconfig-devel-2.13.0-4.3.el7.x86_64535policycoreutils-2.5-34.el7.x86_64536policycoreutils-python-2.5-34.el7.x86_64537538#==============================================================# 539配置主机名 540#==============================================================# 541542rac02543544#==============================================================# 545配置 /etc/hosts 文件 546#==============================================================# 547548127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4549::1 localhost localhost.localdomain localhost6 localhost6.localdomain6550551## OracleBegin552553## RAC1 IP's: rac01554555## RAC1 Public IP556192.168.6.151 rac01557## RAC1 Virtual IP558192.168.6.153 rac01-vip559## RAC1 Private IP5601.1.1.1 rac01-priv561562## RAC2 IP's: rac02563564## RAC2 Public IP565192.168.6.152 rac02566## RAC2 Virtual IP567192.168.6.154 rac02-vip568## RAC2 Private IP5691.1.1.2 rac02-priv570571## SCAN IP572192.168.6.155 rac-scan573574#==============================================================# 575创建用户和组 576#==============================================================# 577578oracle 用户： 579580uid=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)581582grid 用户： 583584uid=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)585586587#==============================================================# 588配置 Avahi-daemon 服务 589#==============================================================# 590591● avahi-daemon.service - Avahi mDNS/DNS-SD Stack592 Loaded: loaded (/usr/lib/systemd/system/avahi-daemon.service; disabled; vendor preset: enabled)593 Active: inactive (dead)594595Mar 12 13:31:56 rac02 avahi-daemon[909]: Joining mDNS multicast group on interface ens192.IPv4 with address 192.168.6.152.596Mar 12 13:31:56 rac02 avahi-daemon[909]: New relevant interface ens192.IPv4 for mDNS.597Mar 12 13:31:56 rac02 avahi-daemon[909]: Registering new address record for 192.168.6.152 on ens192.IPv4.598Mar 12 13:31:57 rac02 avahi-daemon[909]: Registering new address record for fe80::3044:e992:319f:95a2 on ens224.*.599Mar 12 13:31:57 rac02 avahi-daemon[909]: Joining mDNS multicast group on interface ens224.IPv4 with address 1.1.1.2.600Mar 12 13:31:57 rac02 avahi-daemon[909]: New relevant interface ens224.IPv4 for mDNS.601Mar 12 13:31:57 rac02 avahi-daemon[909]: Registering new address record for 1.1.1.2 on ens224.IPv4.602Mar 12 13:40:06 rac02 systemd[1]: Stopping Avahi mDNS/DNS-SD Stack...603Mar 12 13:40:06 rac02 avahi-daemon[909]: Got SIGTERM, quitting.604Mar 12 13:40:06 rac02 systemd[1]: Stopped Avahi mDNS/DNS-SD Stack.605606#==============================================================# 607配置透明大页 && NUMA && 磁盘 IO 调度器 608#==============================================================# 609610args="ro rd.lvm.lv=rhel/root rd.lvm.lv=rhel/swap rhgb quiet LANG=en_US.UTF-8 numa=off transparent_hugepage=never elevator=deadline"611-rd.lvm.lv=rhel/root612-args="ro613args="ro rd.lvm.lv=rhel/root rd.lvm.lv=rhel/swap rhgb quiet numa=off transparent_hugepage=never elevator=deadline"614-elevator=deadline"615-transparent_hugepage=never616617#==============================================================# 618配置 sysctl.conf 619#==============================================================# 620621fs.aio-max-nr = 1048576622fs.file-max = 6815744623kernel.shmall = 2097152624kernel.shmmax = 8369381375625kernel.shmmni = 4096626kernel.sem = 250 32000 100 128627net.ipv4.ip_local_port_range = 9000 65500628net.core.rmem_default = 262144629net.core.rmem_max = 4194304630net.core.wmem_default = 262144631net.core.wmem_max = 1048576632vm.min_free_kbytes = 32692633net.ipv4.conf.ens192.rp_filter = 1634vm.swappiness = 10635kernel.panic_on_oops = 1636kernel.randomize_va_space = 2637kernel.numa_balancing = 0638net.ipv4.conf.ens224.rp_filter = 2639640#==============================================================# 641配置 nsysctl.conf 642#==============================================================# 643644NOZEROCONF=yes645646#==============================================================# 647配置 RemoveIPC 648#==============================================================# 649650[Login]651RemoveIPC=no652653#==============================================================# 654配置 /etc/security/limits.conf 和 /etc/pam.d/login 655#==============================================================# 656657查看 /etc/security/limits.conf： 658659oracle soft nofile 1024660oracle hard nofile 65536661oracle soft stack 10240662oracle hard stack 32768663oracle soft nproc 2047664oracle hard nproc 16384665oracle hard memlock unlimited666oracle soft memlock unlimited667grid soft nofile 1024668grid hard nofile 65536669grid soft stack 10240670grid hard stack 32768671grid soft nproc 2047672grid hard nproc 16384673674查看 /etc/pam.d/login 文件： 675676auth [user_unknown=ignore success=ok ignore=ignore default=bad] pam_securetty.so677auth substack system-auth678auth include postlogin679account required pam_nologin.so680account include system-auth681password include system-auth682session required pam_selinux.so close683session required pam_loginuid.so684session optional pam_console.so685session required pam_selinux.so open686session required pam_namespace.so687session optional pam_keyinit.so force revoke688session include system-auth689session include postlogin690-session optional pam_ck_connector.so691session required pam_limits.so692session required /lib64/security/pam_limits.so693694#==============================================================# 695配置 /dev/shm 696#==============================================================# 697698/dev/mapper/rhel-root / xfs defaults 0 0699UUID=96b8401c-571c-4575-82e9-1ce6b248167b /boot xfs defaults 0 0700/dev/mapper/rhel-swap swap swap defaults 0 0701tmpfs /dev/shm tmpfs size=8173224k 0 0702703#==============================================================# 704安装 rlwrap 插件 705#==============================================================# 706707成功安装 rlwrap： rlwrap 0.44 708709#==============================================================# 710Root 用户环境变量 711#==============================================================# 712713if [ -f ~/.bashrc ]; then714 . ~/.bashrc715fi716PATH=$PATH:$HOME/bin717export PATH718alias so='su - oracle'719export PS1="[`whoami`@`hostname`:"'$PWD]$ '720alias sg='su - grid'721alias crsctl='/u01/app/19.3.0/grid/bin/crsctl'722alias srvctl='/u01/app/19.3.0/grid/bin/srvctl'723724#==============================================================# 725Oracle 用户环境变量 726#==============================================================# 727728if [ -f ~/.bashrc ]; then729 . ~/.bashrc730fi731PATH=$PATH:$HOME/.local/bin:$HOME/bin732export PATH733umask 022734export TMP=/tmp735export TMPDIR=$TMP736export NLS_LANG=AMERICAN_AMERICA.AL32UTF8737export ORACLE_BASE=/u01/app/oracle738export ORACLE_HOME=/u01/app/oracle/product/19.3.0/db739export ORACLE_TERM=xterm740export TNS_ADMIN=$ORACLE_HOME/network/admin741export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib742export ORACLE_SID=lucifer2743export PATH=/usr/sbin:$PATH744export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/perl/bin:$PATH745export PERL5LIB=$ORACLE_HOME/perl/lib746alias sas='sqlplus / as sysdba'747alias awr='sqlplus / as sysdba @?/rdbms/admin/awrrpt'748alias ash='sqlplus / as sysdba @?/rdbms/admin/ashrpt'749alias alert='vi $ORACLE_BASE/diag/rdbms/*/$ORACLE_SID/trace/alert_$ORACLE_SID.log'750export PS1="[`whoami`@`hostname`:"'$PWD]$ '751alias sqlplus='rlwrap sqlplus'752alias rman='rlwrap rman'753alias adrci='rlwrap adrci'754755#==============================================================# 756Grid 用户环境变量 757#==============================================================# 758759if [ -f ~/.bashrc ]; then760 . ~/.bashrc761fi762PATH=$PATH:$HOME/.local/bin:$HOME/bin763export PATH764umask 022765export TMP=/tmp766export TMPDIR=$TMP767export NLS_LANG=AMERICAN_AMERICA.AL32UTF8768export ORACLE_BASE=/u01/app/grid769export ORACLE_HOME=/u01/app/19.3.0/grid770export ORACLE_TERM=xterm771export TNS_ADMIN=$ORACLE_HOME/network/admin772export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib773export ORACLE_SID=+ASM2774export PATH=/usr/sbin:$PATH775export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH776alias sas='sqlplus / as sysasm'777export PS1="[`whoami`@`hostname`:"'$PWD]$ '778alias sqlplus='rlwrap sqlplus'779alias asmcmd='rlwrap asmcmd'780alias adrci='rlwrap adrci'781782#==============================================================# 783配置 multipath 多路径 784#==============================================================# 785786create: asm_ocr_1 (2e87e4f535c397171) undef ROCKET ,IMAGEFILE 787size=10G features='0' hwhandler='0' wp=undef788`-+- policy='service-time 0' prio=1 status=undef789 `- 33:0:0:0 sdb 8:16 undef ready running790create: asm_data_1 (2f218dae15b551c5d) undef ROCKET ,IMAGEFILE 791size=20G features='0' hwhandler='0' wp=undef792`-+- policy='service-time 0' prio=1 status=undef793 `- 33:0:0:1 sdc 8:32 undef ready running794795#==============================================================# 796配置 UDEV 绑盘 797#==============================================================# 798799KERNEL=="dm-*",ENV{DM_UUID}=="mpath-2e87e4f535c397171",SYMLINK+="asm_ocr_1",OWNER="grid",GROUP="asmadmin",MODE="0660"800KERNEL=="dm-*",ENV{DM_UUID}=="mpath-2f218dae15b551c5d",SYMLINK+="asm_data_1",OWNER="grid",GROUP="asmadmin",MODE="0660"801802/dev/asm_data_1803/dev/asm_ocr_1804805UDEV 配置完成! 806807配置 RAC 节点：192.168.6.152 结束! 808809#==============================================================# 810配置 GRID 用户 SSH 互信 811#==============================================================# 812813Generating public/private rsa key pair.814Your identification has been saved in /home/grid/.ssh/id_rsa.815Your public key has been saved in /home/grid/.ssh/id_rsa.pub.816The key fingerprint is:817SHA256:Xxy1rYwXHi6ugoU2xinnwvqSPqr7c7xSF6Zkz7remTg grid@rac01818The key's randomart image is:819+---[RSA 2048]----+820| . |821| . o |822| . + .|823| o o . * + |824| o * +S = * |825| + % .. o o |826| = O + . . |827| * Eooo. . |828|==+X*=+ .. |829+----[SHA256]-----+830831#==============================================================# 832配置 ORACLE 用户 SSH 互信 833#==============================================================# 834835Generating public/private rsa key pair.836Your identification has been saved in /home/oracle/.ssh/id_rsa.837Your public key has been saved in /home/oracle/.ssh/id_rsa.pub.838The key fingerprint is:839SHA256:WGnj9li/3rs1bK16dc/5xe9oRJCNMZeptDn7L5Xpyac oracle@rac01840The key's randomart image is:841+---[RSA 2048]----+842| o=.o |843| . =o+ |844| = . = |845| = . = . |846| . S . + o|847| . + .. o+=|848| . . .ooBX|849| o*OB|850| .++EBB|851+----[SHA256]-----+852853#==============================================================# 854静默解压缩 Grid 软件包 855#==============================================================# 856857正在静默解压缩 Grid 软件包，请稍等： 858859.---- -. -. . . . .860( .',----- - - ' ' ' __861 \_/ ;--:- __--------------------___ ____=========_||___862__U__n_^_''__[. ooo___ | |_!_||_!_||_!_||_!_| | |..|_i_|..|_i_|..|863c(_ ..(_ ..(_ ..( /,,,,,,] | |___||___||___||___| | | |864,_\___________'_|,L______],|______________________|_i,!________________!_i865/;_(@)(@)==(@)(@) (o)(o) (o)^(o)--(o)^(o) (o)(o)-(o)(o)866""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"'""867868869静默解压 Grid 软件安装包： /soft/LINUX.X64_193000_grid_home.zip 870871静默解压 OPatch 软件补丁包： /soft/p6880880_*.zip 872873静默解压 Grid 软件补丁包： /soft/p35940989*.zip 874875#==============================================================# 876静默解压 Oracle 软件包 877#==============================================================# 878879正在静默解压缩 Oracle 软件包，请稍等： 880881.---- -. -. . . . .882( .',----- - - ' ' ' __883 \_/ ;--:- __--------------------___ ____=========_||___884__U__n_^_''__[. ooo___ | |_!_||_!_||_!_||_!_| | |..|_i_|..|_i_|..|885c(_ ..(_ ..(_ ..( /,,,,,,] | |___||___||___||___| | | |886,_\___________'_|,L______],|______________________|_i,!________________!_i887/;_(@)(@)==(@)(@) (o)(o) (o)^(o)--(o)^(o) (o)(o)-(o)(o)888""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"'""889890891静默解压 Oracle 软件安装包： /soft/LINUX.X64_193000_db_home.zip 892893静默解压 OPatch 软件补丁包： /soft/p6880880_*.zip 894895#==============================================================# 896Grid 安装静默文件 897#==============================================================# 898899INVENTORY_LOCATION=/u01/app/oraInventory900oracle.install.option=CRS_CONFIG901ORACLE_BASE=/u01/app/grid902oracle.install.asm.OSDBA=asmdba903oracle.install.asm.OSOPER=asmoper904oracle.install.asm.OSASM=asmadmin905oracle.install.crs.config.gpnp.scanName=rac-scan906oracle.install.crs.config.gpnp.scanPort=1521907oracle.install.crs.config.clusterName=rac-cls908oracle.install.crs.config.gpnp.configureGNS=false909oracle.install.crs.config.clusterNodes=rac01:rac01-vip,rac02:rac02-vip910oracle.install.crs.config.networkInterfaceList=ens192:192.168.6.0:1,ens224:1.1.1.0:5911oracle.install.crs.config.useIPMI=false912oracle.install.asm.SYSASMPassword=oracle913oracle.install.asm.diskGroup.name=OCR914oracle.install.asm.diskGroup.redundancy=EXTERNAL915oracle.install.asm.diskGroup.disks=/dev/asm_ocr_1916oracle.install.asm.diskGroup.diskDiscoveryString=/dev/asm*917oracle.install.asm.monitorPassword=oracle918oracle.install.crs.config.ClusterConfiguration=STANDALONE919oracle.install.crs.config.configureAsExtendedCluster=false920oracle.install.crs.configureGIMR=false921oracle.install.asm.storageOption=ASM922oracle.install.asm.diskGroup.AUSize=4923oracle.install.asm.configureAFD=false924oracle.install.crs.config.ignoreDownNodes=false925oracle.install.config.managementOption=NONE926oracle.install.crs.rootconfig.executeRootScript=false927oracle.install.responseFileVersion=/oracle/install/rspfmt_crsinstall_response_schema_v19.0.0928oracle.install.crs.config.scanType=LOCAL_SCAN929930#==============================================================# 931静默安装 Grid 软件 932#==============================================================# 933934Preparing the home to patch...935Applying the patch /soft/35940989...936Successfully applied the patch.937The log can be found at: /tmp/GridSetupActions2024-03-12_01-45-51PM/installerPatchActions_2024-03-12_01-45-51PM.log938Launching Oracle Grid Infrastructure Setup Wizard...939940[WARNING] [INS-30011] The SYS password entered does not conform to the Oracle recommended standards.941 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].942 ACTION: Provide a password that conforms to the Oracle recommended standards.943[WARNING] [INS-30011] The ASMSNMP password entered does not conform to the Oracle recommended standards.944 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].945 ACTION: Provide a password that conforms to the Oracle recommended standards.946The response file for this session can be found at:947 /u01/app/19.3.0/grid/install/response/grid_2024-03-12_01-45-51PM.rsp948949You can find the log of this install session at:950 /tmp/GridSetupActions2024-03-12_01-45-51PM/gridSetupActions2024-03-12_01-45-51PM.log951952As a root user, execute the following script(s):953 1. /u01/app/oraInventory/orainstRoot.sh954 2. /u01/app/19.3.0/grid/root.sh955956Execute /u01/app/oraInventory/orainstRoot.sh on the following nodes: 957[rac01, rac02]958Execute /u01/app/19.3.0/grid/root.sh on the following nodes: 959[rac01, rac02]960961Run the script on the local node first. After successful completion, you can start the script in parallel on all other nodes.962963Successfully Setup Software.964As install user, execute the following command to complete the configuration.965 /u01/app/19.3.0/grid/gridSetup.sh -executeConfigTools -responseFile /soft/grid.rsp [-silent]966967968Moved the install session logs to:969 /u01/app/oraInventory/logs/GridSetupActions2024-03-12_01-45-51PM970971#==============================================================# 972执行 root 脚本 973#==============================================================# 974975节点 192.168.6.151 ： 976977Changing permissions of /u01/app/oraInventory.978Adding read,write permissions for group.979Removing read,write,execute permissions for world.980981Changing groupname of /u01/app/oraInventory to oinstall.982The execution of the script is complete.983Check /u01/app/19.3.0/grid/install/root_rac01_2024-03-12_14-11-35-906912822.log for the output of root script984985节点 192.168.6.152 ： 986987Changing permissions of /u01/app/oraInventory.988Adding read,write permissions for group.989Removing read,write,execute permissions for world.990991Changing groupname of /u01/app/oraInventory to oinstall.992The execution of the script is complete.993Check /u01/app/19.3.0/grid/install/root_rac02_2024-03-12_14-20-28-398646190.log for the output of root script994995#==============================================================# 996Grid 软件版本 997#==============================================================# 9989991000SQL*Plus: Release 19.0.0.0.0 - Production1001Version 19.22.0.0.0100210031004#==============================================================# 1005Grid 补丁信息 1006#==============================================================# 1007100836115038;TOMCAT RELEASE UPDATE 19.0.0.0.0 (36115038)100935967489;OCW RELEASE UPDATE 19.22.0.0.0 (35967489)101035956421;ACFS RELEASE UPDATE 19.22.0.0.0 (35956421)101135943157;Database Release Update : 19.22.0.0.240116 (35943157)101233575402;DBWLM RELEASE UPDATE 19.0.0.0.0 (33575402)10131014OPatch succeeded.101510161017#==============================================================# 1018ASM 磁盘组创建 1019#==============================================================# 10201021State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name1022MOUNTED EXTERN N 512 512 4096 1048576 20480 20372 0 20372 0 N DATA/1023MOUNTED EXTERN N 512 512 4096 4194304 10240 9900 0 9900 0 Y OCR/10241025#==============================================================# 1026Oracle 安装静默文件 1027#==============================================================# 10281029oracle.install.option=INSTALL_DB_SWONLY1030UNIX_GROUP_NAME=oinstall1031INVENTORY_LOCATION=/u01/app/oraInventory1032ORACLE_BASE=/u01/app/oracle1033oracle.install.db.InstallEdition=EE1034oracle.install.db.DBA_GROUP=dba1035oracle.install.db.OPER_GROUP=oper1036oracle.install.db.CLUSTER_NODES=rac01,rac021037oracle.install.db.OSBACKUPDBA_GROUP=backupdba1038oracle.install.db.OSDGDBA_GROUP=dgdba1039oracle.install.db.OSKMDBA_GROUP=kmdba1040oracle.install.db.OSRACDBA_GROUP=racdba1041oracle.install.db.rootconfig.executeRootScript=false1042oracle.install.db.rootconfig.configMethod=1043oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v19.0.010441045#==============================================================# 1046静默安装数据库软件 1047#==============================================================# 10481049Preparing the home to patch...1050Applying the patch /soft/35940989...1051Successfully applied the patch.1052The log can be found at: /u01/app/oraInventory/logs/InstallActions2024-03-12_02-27-24PM/installerPatchActions_2024-03-12_02-27-24PM.log1053Launching Oracle Database Setup Wizard...10541055[WARNING] [INS-13013] Target environment does not meet some mandatory requirements.1056 CAUSE: Some of the mandatory prerequisites are not met. See logs for details. /u01/app/oraInventory/logs/InstallActions2024-03-12_02-27-24PM/installActions2024-03-12_02-27-24PM.log1057 ACTION: Identify the list of failed prerequisite checks from the log: /u01/app/oraInventory/logs/InstallActions2024-03-12_02-27-24PM/installActions2024-03-12_02-27-24PM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.1058The response file for this session can be found at:1059 /u01/app/oracle/product/19.3.0/db/install/response/db_2024-03-12_02-27-24PM.rsp10601061You can find the log of this install session at:1062 /u01/app/oraInventory/logs/InstallActions2024-03-12_02-27-24PM/installActions2024-03-12_02-27-24PM.log10631064As a root user, execute the following script(s):1065 1. /u01/app/oracle/product/19.3.0/db/root.sh10661067Execute /u01/app/oracle/product/19.3.0/db/root.sh on the following nodes: 1068[rac01, rac02]106910701071Successfully Setup Software with warning(s).10721073#==============================================================# 1074执行 root 脚本 1075#==============================================================# 10761077节点 192.168.6.151 ： 10781079Changing permissions of /u01/app/oraInventory.1080Adding read,write permissions for group.1081Removing read,write,execute permissions for world.10821083Changing groupname of /u01/app/oraInventory to oinstall.1084The execution of the script is complete.1085Check /u01/app/oracle/product/19.3.0/db/install/root_rac01_2024-03-12_15-08-43-940864602.log for the output of root script10861087节点 192.168.6.152 ： 10881089Changing permissions of /u01/app/oraInventory.1090Adding read,write permissions for group.1091Removing read,write,execute permissions for world.10921093Changing groupname of /u01/app/oraInventory to oinstall.1094The execution of the script is complete.1095Check /u01/app/oracle/product/19.3.0/db/install/root_rac02_2024-03-12_15-08-45-122786324.log for the output of root script10961097#==============================================================# 1098Oracle 软件版本 1099#==============================================================# 110011011102SQL*Plus: Release 19.0.0.0.0 - Production1103Version 19.22.0.0.0110411051106#==============================================================# 1107Oracle 补丁信息 1108#==============================================================# 1109111035967489;OCW RELEASE UPDATE 19.22.0.0.0 (35967489)111135943157;Database Release Update : 19.22.0.0.240116 (35943157)11121113OPatch succeeded.默认使用专业版脚本。脚本下载：ora100.com/shell-install