在知识库中专注阅读，并随时返回相关工具与课程
Oracle 一键安装脚本，演示 5 节点 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 一键安装脚本，演示 5 节点 RAC 一键安装过程（全程无需人工干预）：（脚本包括 GRID/ORALCE PSU/OJVM 补丁自动安装）
⭐️ 脚本下载地址：Shell脚本安装Oracle数据库
脚本第三代支持 N 节点一键安装，不限制节点数！
1[root@lucifer01 soft]# ./OracleShellInstall -n luciferdb `# hostname prefix`\2> -hn luciferdb01,luciferdb02,luciferdb03,luciferdb04,luciferdb05 `# rac node hostname`\3> -cn luciferdb-cls `# cluster_name`\4> -sn luciferdb-scan `# scan_name`\5> -rp oracle `# root password`\6> -gp oracle `# grid password`\7> -op oracle `# oracle password`\8> -lf ens192 `# local ip ifname`\9> -pf ens224,ens256 `# rac private ip ifname`\10> -ri 192.168.6.31,192.168.6.32,192.168.6.33,192.168.6.34,192.168.6.35 `# rac node public ip`\11> -vi 192.168.6.51,192.168.6.52,192.168.6.53,192.168.6.54,192.168.6.55 `# rac virtual ip`\12> -si 192.168.6.50 `# rac scan ip`\13> -tsi 202.112.10.36 `# timeserver ip`\14> -od /dev/sdb,/dev/sdc,/dev/sdd `# rac ocr asm disk`\15> -dd /dev/sde,/dev/sdf `# rac data asm disk`\16> -o oradb `# dbname`\17> -ds AL32UTF8 `# database character`\18> -ns AL16UTF16 `# national character`\19> -dp oracle `# sys/system password`\20> -redo 50 `# redo size`\21> -gpa 31718723 `# grid PSU/RU`\22> -jpa 31668908 `# OJVM PSU/RU`\23> -opd Y `# optimize db`242526 ███████ ██ ████████ ██ ██ ██ ██ ██ ██ ██27 ██░░░░░██ ░██ ██░░░░░░ ░██ ░██ ░██░██ ░██ ░██ ░██28 ██ ░░██ ██████ ██████ █████ ░██ █████ ░██ ░██ █████ ░██ ░██░██ ███████ ██████ ██████ ██████ ░██ ░██29░██ ░██░░██░░█ ░░░░░░██ ██░░░██ ░██ ██░░░██░█████████░██████ ██░░░██ ░██ ░██░██░░██░░░██ ██░░░░ ░░░██░ ░░░░░░██ ░██ ░██30░██ ░██ ░██ ░ ███████ ░██ ░░ ░██░███████░░░░░░░░██░██░░░██░███████ ░██ ░██░██ ░██ ░██░░█████ ░██ ███████ ░██ ░██31░░██ ██ ░██ ██░░░░██ ░██ ██ ░██░██░░░░ ░██░██ ░██░██░░░░ ░██ ░██░██ ░██ ░██ ░░░░░██ ░██ ██░░░░██ ░██ ░██32 ░░███████ ░███ ░░████████░░█████ ███░░██████ ████████ ░██ ░██░░██████ ███ ███░██ ███ ░██ ██████ ░░██ ░░████████ ███ ███33 ░░░░░░░ ░░░ ░░░░░░░░ ░░░░░ ░░░ ░░░░░░ ░░░░░░░░ ░░ ░░ ░░░░░░ ░░░ ░░░ ░░ ░░░ ░░ ░░░░░░ ░░ ░░░░░░░░ ░░░ ░░░ 343536请选择安装模式 [单机(si)/集群(rac)] : 37rac3839数据库安装模式: rac 404142请选择数据库版本 [11/12/19/21] : 43114445数据库版本: 11 4647配置本地 YUM 源： 4849[server]50name=server51baseurl=file:///mnt52enabled=153gpgcheck=05455获取 ASM 磁盘 UUID && 格式化磁盘头： 5657格式化 OCR 磁盘：/dev/sdb,/dev/sdc,/dev/sdd 585910+0 records in6010+0 records out611048576000 bytes (1.0 GB) copied, 11.6849 s, 89.7 MB/s6210+0 records in6310+0 records out641048576000 bytes (1.0 GB) copied, 11.2133 s, 93.5 MB/s6510+0 records in6610+0 records out671048576000 bytes (1.0 GB) copied, 11.4255 s, 91.8 MB/s6869OCR磁盘组的磁盘UUID： 2d7490d9f98a4dd33,29d556de9c0521353,22a3d603188b7e7ac 7071格式化 DATA 磁盘：/dev/sde,/dev/sdf 727310+0 records in7410+0 records out751048576000 bytes (1.0 GB) copied, 11.3711 s, 92.2 MB/s7610+0 records in7710+0 records out781048576000 bytes (1.0 GB) copied, 11.3941 s, 92.0 MB/s7980DATA磁盘组的磁盘UUID： 2efbc650f3322eb34,228a97913b281ad29 818283#==============================================================# 84配置 root 用户互信 85#==============================================================# 8687Generating public/private rsa key pair.88Your identification has been saved in /root/.ssh/id_rsa.89Your public key has been saved in /root/.ssh/id_rsa.pub.90The key fingerprint is:91SHA256:q9jTYXhcuywt1GsmVmQLF0B8MmTAcSvkIzuqmxj8lFc root@lucifer0192The key's randomart image is:93+---[RSA 2048]----+94| .+**. |95| o.o+.o |96| . + .+ . |97| o o. = |98| o ESB o |99|. ...o *.= |100|...o . =.= o |101|.+o .o..* B |102|=. .. oo * |103+----[SHA256]-----+104105#==============================================================# 106配置 SELinux 107#==============================================================# 108109SELINUX=disabled110SELINUXTYPE=targeted 111112113#==============================================================# 114YUM 静默安装依赖包 115#==============================================================# 116117bc-1.06.95-13.el7.x86_64118binutils-2.27-43.base.el7.x86_64119compat-libcap1-1.10-7.el7.x86_64120package compat-libstdc++-33 is not installed121gcc-4.8.5-39.el7.x86_64122gcc-c++-4.8.5-39.el7.x86_64123elfutils-libelf-0.176-4.el7.x86_64124elfutils-libelf-devel-0.176-4.el7.x86_64125glibc-2.17-307.el7.1.x86_64126glibc-devel-2.17-307.el7.1.x86_64127libaio-0.3.109-13.el7.x86_64128libaio-devel-0.3.109-13.el7.x86_64129libgcc-4.8.5-39.el7.x86_64130libstdc++-4.8.5-39.el7.x86_64131libstdc++-devel-4.8.5-39.el7.x86_64132libxcb-1.13-1.el7.x86_64133libX11-1.6.7-2.el7.x86_64134libXau-1.0.8-2.1.el7.x86_64135libXi-1.7.9-1.el7.x86_64136libXrender-0.9.10-1.el7.x86_64137make-3.82-24.el7.x86_64138net-tools-2.0-0.25.20131004git.el7.x86_64139smartmontools-7.0-2.el7.x86_64140sysstat-10.1.5-19.el7.x86_64141e2fsprogs-1.42.9-17.el7.x86_64142e2fsprogs-libs-1.42.9-17.el7.x86_64143unzip-6.0-21.el7.x86_64144openssh-clients-7.4p1-21.el7.x86_64145readline-6.2-11.el7.x86_64146readline-devel-6.2-11.el7.x86_64147psmisc-22.20-16.el7.x86_64148ksh-20120801-142.el7.x86_64149nfs-utils-1.3.0-0.66.el7.x86_64150tar-1.26-35.el7.x86_64151device-mapper-multipath-0.4.9-131.el7.x86_64152avahi-0.6.31-20.el7.x86_64153ntp-4.2.6p5-29.el7.x86_64154package chronyd is not installed155libXtst-1.2.3-1.el7.x86_64156libXrender-devel-0.9.10-1.el7.x86_64157fontconfig-devel-2.13.0-4.3.el7.x86_64158policycoreutils-2.5-34.el7.x86_64159policycoreutils-python-2.5-34.el7.x86_64160package policycoreutils-python-utils) is not installed161162#==============================================================# 163配置主机名 164#==============================================================# 165166 Static hostname: luciferdb01167 Icon name: computer-vm168 Chassis: vm169 Machine ID: d4f09aa65cef4e77a5472cbdb59bee2a170 Boot ID: 2f0e96cc7d684affae5de778e02907c9171 Virtualization: vmware172 Operating System: Red Hat Enterprise Linux Server 7.8 (Maipo)173 CPE OS Name: cpe:/o:redhat:enterprise_linux:7.8:GA:server174 Kernel: Linux 3.10.0-1127.el7.x86_64175 Architecture: x86-64176177178#==============================================================# 179配置 HOSTS 文件 180#==============================================================# 181182127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4183::1 localhost localhost.localdomain localhost6 localhost6.localdomain6184185## OracleBegin186187## RAC1 IP's: luciferdb01188189## RAC1 Public IP190192.168.6.31 luciferdb01191## RAC1 Virtual IP192192.168.6.51 luciferdb01-vip193## RAC1 Private IP1942.2.1.1 luciferdb01-priv1952.2.2.1 luciferdb01-priv1196197## RAC2 IP's: luciferdb02198199## RAC2 Public IP200192.168.6.32 luciferdb02201## RAC2 Virtual IP202192.168.6.52 luciferdb02-vip203## RAC2 Private IP2042.2.2.2 luciferdb02-priv2052.2.1.2 luciferdb02-priv1206207## RAC3 IP's: luciferdb03208209## RAC3 Public IP210192.168.6.33 luciferdb03211## RAC3 Virtual IP212192.168.6.53 luciferdb03-vip213## RAC3 Private IP2142.2.2.3 luciferdb03-priv2152.2.1.3 luciferdb03-priv1216217## RAC4 IP's: luciferdb04218219## RAC4 Public IP220192.168.6.34 luciferdb04221## RAC4 Virtual IP222192.168.6.54 luciferdb04-vip223## RAC4 Private IP2242.2.2.4 luciferdb04-priv2252.2.1.4 luciferdb04-priv1226227## RAC5 IP's: luciferdb05228229## RAC5 Public IP230192.168.6.35 luciferdb05231## RAC5 Virtual IP232192.168.6.55 luciferdb05-vip233## RAC5 Private IP2342.2.2.5 luciferdb05-priv2352.2.1.5 luciferdb05-priv1236237## SCAN IP238192.168.6.50 luciferdb-scan239240241#==============================================================# 242创建用户和组 243#==============================================================# 244245uid=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)246247248#==============================================================# 249Avahi-daemon 状态 250#==============================================================# 251252● avahi-daemon.service - Avahi mDNS/DNS-SD Stack253 Loaded: loaded (/usr/lib/systemd/system/avahi-daemon.service; disabled; vendor preset: enabled)254 Active: inactive (dead)255256May 04 17:52:56 lucifer01 avahi-daemon[913]: Registering new address record for 2.2.1.1 on ens224.IPv4.257May 04 17:52:56 lucifer01 avahi-daemon[913]: Registering new address record for fe80::455c:1792:2080:e3ba on ens256.*.258May 04 17:52:56 lucifer01 avahi-daemon[913]: Joining mDNS multicast group on interface ens256.IPv4 with address 2.2.2.1.259May 04 17:52:56 lucifer01 avahi-daemon[913]: New relevant interface ens256.IPv4 for mDNS.260May 04 17:52:56 lucifer01 avahi-daemon[913]: Registering new address record for 2.2.2.1 on ens256.IPv4.261May 04 17:58:06 luciferdb01 avahi-daemon[913]: Got SIGTERM, quitting.262May 04 17:58:06 luciferdb01 avahi-daemon[913]: Leaving mDNS multicast group on interface ens256.IPv4 with address 2.2.2.1.263May 04 17:58:06 luciferdb01 systemd[1]: Stopping Avahi mDNS/DNS-SD Stack...264May 04 17:58:06 luciferdb01 avahi-daemon[913]: Leaving mDNS multicast group on interface ens224.IPv4 with address 2.2.1.1.265May 04 17:58:06 luciferdb01 systemd[1]: Stopped Avahi mDNS/DNS-SD Stack.266267268#==============================================================# 269配置透明大页 && NUMA && 磁盘 IO 调度器 270#==============================================================# 271272args="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"273-rd.lvm.lv=rhel/root274-args="ro275args="ro rd.lvm.lv=rhel/root rd.lvm.lv=rhel/swap rhgb quiet numa=off transparent_hugepage=never elevator=deadline"276-elevator=deadline"277-transparent_hugepage=never278279280#==============================================================# 281配置 sysctl.conf 282#==============================================================# 283284fs.aio-max-nr = 1048576285fs.file-max = 6815744286kernel.shmall = 2097152287kernel.shmmax = 8369393663288kernel.shmmni = 4096289kernel.sem = 250 32000 100 128290net.ipv4.ip_local_port_range = 9000 65500291net.core.rmem_default = 262144292net.core.rmem_max = 4194304293net.core.wmem_default = 262144294net.core.wmem_max = 1048576295vm.min_free_kbytes = 32692296net.ipv4.conf.ens192.rp_filter = 1297net.ipv4.conf.ens224.rp_filter = 2298net.ipv4.conf.ens256.rp_filter = 2299300301#==============================================================# 302配置 nsysctl.conf 303#==============================================================# 304305# Created by anaconda306307> **本章目标**：掌握本章核心知识点308> **前置要求**：完成前序章节学习309> **预计时长**：60 分钟310311NOZEROCONF=yes312313314#==============================================================# 315配置 /etc/security/limits.conf 316#==============================================================# 317318oracle soft nofile 1024319oracle hard nofile 65536320oracle soft stack 10240321oracle hard stack 32768322oracle soft nproc 2047323oracle hard nproc 16384324oracle hard memlock unlimited325oracle soft memlock unlimited326grid soft nofile 1024327grid hard nofile 65536328grid soft stack 10240329grid hard stack 32768330grid soft nproc 2047331grid hard nproc 16384332333334#==============================================================# 335配置 /etc/pam.d/login 336#==============================================================# 337338auth [user_unknown=ignore success=ok ignore=ignore default=bad] pam_securetty.so339auth substack system-auth340auth include postlogin341account required pam_nologin.so342account include system-auth343password include system-auth344session required pam_selinux.so close345session required pam_loginuid.so346session optional pam_console.so347session required pam_selinux.so open348session required pam_namespace.so349session optional pam_keyinit.so force revoke350session include system-auth351session include postlogin352-session optional pam_ck_connector.so353session required pam_limits.so354session required /lib64/security/pam_limits.so355356357#==============================================================# 358配置 /dev/shm 359#==============================================================# 360361/dev/mapper/rhel-root / xfs defaults 0 0362UUID=56e3f825-c9f9-47b8-8a54-c762d0699e79 /boot xfs defaults 0 0363/dev/mapper/rhel-swap swap swap defaults 0 0364tmpfs /dev/shm tmpfs size=8173236k 0 0365366367#==============================================================# 368安装 rlwrap 369#==============================================================# 370371372成功安装 rlwrap： rlwrap 0.42 373374#==============================================================# 375Root 用户环境变量 376#==============================================================# 377378if [ -f ~/.bashrc ]; then379 . ~/.bashrc380fi381PATH=$PATH:$HOME/bin382export PATH383alias so='su - oracle'384export PS1="[`whoami`@`hostname`:"'\w]# '385alias sg='su - grid'386alias crsctl='/u01/app/11.2.0/grid/bin/crsctl'387alias srvctl='/u01/app/11.2.0/grid/bin/srvctl'388389390#==============================================================# 391Oracle 用户环境变量 392#==============================================================# 393394if [ -f ~/.bashrc ]; then395 . ~/.bashrc396fi397PATH=$PATH:$HOME/.local/bin:$HOME/bin398export PATH399umask 022400export TMP=/tmp401export TMPDIR=$TMP402export NLS_LANG=AMERICAN_AMERICA.AL32UTF8403export ORACLE_BASE=/u01/app/oracle404export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db405export ORACLE_TERM=xterm406export TNS_ADMIN=$ORACLE_HOME/network/admin407export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib408export ORACLE_SID=oradb1409export PATH=/usr/sbin:$PATH410export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/perl/bin:$PATH411export PERL5LIB=$ORACLE_HOME/perl/lib412alias sas='sqlplus / as sysdba'413alias awr='sqlplus / as sysdba @?/rdbms/admin/awrrpt'414alias ash='sqlplus / as sysdba @?/rdbms/admin/ashrpt'415alias alert='vi $ORACLE_BASE/diag/rdbms/*/$ORACLE_SID/trace/alert_$ORACLE_SID.log'416export PS1="[`whoami`@`hostname`:"'\w]$ '417alias sqlplus='rlwrap sqlplus'418alias rman='rlwrap rman'419alias adrci='rlwrap adrci'420421422#==============================================================# 423Grid 用户环境变量 424#==============================================================# 425426if [ -f ~/.bashrc ]; then427 . ~/.bashrc428fi429PATH=$PATH:$HOME/.local/bin:$HOME/bin430export PATH431umask 022432export TMP=/tmp433export TMPDIR=$TMP434export NLS_LANG=AMERICAN_AMERICA.AL32UTF8435export ORACLE_BASE=/u01/app/grid436export ORACLE_HOME=/u01/app/11.2.0/grid437export ORACLE_TERM=xterm438export TNS_ADMIN=$ORACLE_HOME/network/admin439export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib440export ORACLE_SID=+ASM1441export PATH=/usr/sbin:$PATH442export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH443alias sas='sqlplus / as sysasm'444export PS1="[`whoami`@`hostname`:"'\w]$ '445alias sqlplus='rlwrap sqlplus'446alias asmcmd='rlwrap asmcmd'447alias adrci='rlwrap adrci'448449450#==============================================================# 451配置时间同步 452#==============================================================# 453454Created symlink from /etc/systemd/system/multi-user.target.wants/ntpd.service to /usr/lib/systemd/system/ntpd.service.455456#==============================================================# 457NTP 检查 458#==============================================================# 459460 remote refid st t when poll reach delay offset jitter461==============================================================================462 202.112.10.36 .INIT. 16 u - 64 0 0.000 0.000 0.001463464465#==============================================================# 466多路径信息 467#==============================================================# 468469create: asm_ocr_1 (2d7490d9f98a4dd33) undef ROCKET ,IMAGEFILE 470size=10G features='0' hwhandler='0' wp=undef471`-+- policy='service-time 0' prio=1 status=undef472 `- 33:0:0:0 sdb 8:16 undef ready running473create: asm_ocr_2 (29d556de9c0521353) undef ROCKET ,IMAGEFILE 474size=10G features='0' hwhandler='0' wp=undef475`-+- policy='service-time 0' prio=1 status=undef476 `- 33:0:0:1 sdc 8:32 undef ready running477create: asm_ocr_3 (22a3d603188b7e7ac) undef ROCKET ,IMAGEFILE 478size=10G features='0' hwhandler='0' wp=undef479`-+- policy='service-time 0' prio=1 status=undef480 `- 33:0:0:2 sdd 8:48 undef ready running481create: asm_data_1 (2efbc650f3322eb34) undef ROCKET ,IMAGEFILE 482size=50G features='0' hwhandler='0' wp=undef483`-+- policy='service-time 0' prio=1 status=undef484 `- 33:0:0:3 sde 8:64 undef ready running485create: asm_data_2 (228a97913b281ad29) undef ROCKET ,IMAGEFILE 486size=50G features='0' hwhandler='0' wp=undef487`-+- policy='service-time 0' prio=1 status=undef488 `- 33:0:0:4 sdf 8:80 undef ready running489490491#==============================================================# 492UDEV 配置文件 493#==============================================================# 494495KERNEL=="dm-*",ENV{DM_UUID}=="mpath-2d7490d9f98a4dd33",SYMLINK+="asm_ocr_1",OWNER="grid",GROUP="asmadmin",MODE="0660"496KERNEL=="dm-*",ENV{DM_UUID}=="mpath-29d556de9c0521353",SYMLINK+="asm_ocr_2",OWNER="grid",GROUP="asmadmin",MODE="0660"497KERNEL=="dm-*",ENV{DM_UUID}=="mpath-22a3d603188b7e7ac",SYMLINK+="asm_ocr_3",OWNER="grid",GROUP="asmadmin",MODE="0660"498KERNEL=="dm-*",ENV{DM_UUID}=="mpath-2efbc650f3322eb34",SYMLINK+="asm_data_1",OWNER="grid",GROUP="asmadmin",MODE="0660"499KERNEL=="dm-*",ENV{DM_UUID}=="mpath-228a97913b281ad29",SYMLINK+="asm_data_2",OWNER="grid",GROUP="asmadmin",MODE="0660"500501502UDEV 已加载成功。 503504#==============================================================# 505ASM 磁盘信息 506#==============================================================# 507508/dev/asm_data_1509/dev/asm_data_2510/dev/asm_ocr_1511/dev/asm_ocr_2512/dev/asm_ocr_3513514515#==============================================================# 516配置 RAC 节点：192.168.6.32 517#==============================================================# 518519正在节点：192.168.6.32 上执行脚本： 520521522 ███████ ██ ████████ ██ ██ ██ ██ ██ ██ ██523 ██░░░░░██ ░██ ██░░░░░░ ░██ ░██ ░██░██ ░██ ░██ ░██524 ██ ░░██ ██████ ██████ █████ ░██ █████ ░██ ░██ █████ ░██ ░██░██ ███████ ██████ ██████ ██████ ░██ ░██525░██ ░██░░██░░█ ░░░░░░██ ██░░░██ ░██ ██░░░██░█████████░██████ ██░░░██ ░██ ░██░██░░██░░░██ ██░░░░ ░░░██░ ░░░░░░██ ░██ ░██526░██ ░██ ░██ ░ ███████ ░██ ░░ ░██░███████░░░░░░░░██░██░░░██░███████ ░██ ░██░██ ░██ ░██░░█████ ░██ ███████ ░██ ░██527░░██ ██ ░██ ██░░░░██ ░██ ██ ░██░██░░░░ ░██░██ ░██░██░░░░ ░██ ░██░██ ░██ ░██ ░░░░░██ ░██ ██░░░░██ ░██ ░██528 ░░███████ ░███ ░░████████░░█████ ███░░██████ ████████ ░██ ░██░░██████ ███ ███░██ ███ ░██ ██████ ░░██ ░░████████ ███ ███529 ░░░░░░░ ░░░ ░░░░░░░░ ░░░░░ ░░░ ░░░░░░ ░░░░░░░░ ░░ ░░ ░░░░░░ ░░░ ░░░ ░░ ░░░ ░░ ░░░░░░ ░░ ░░░░░░░░ ░░░ ░░░ 530531配置本地 YUM 源： 532533[server]534name=server535baseurl=file:///mnt536enabled=1537gpgcheck=0538539#==============================================================# 540配置 SELinux 541#==============================================================# 542543SELINUX=disabled544SELINUXTYPE=targeted 545546547#==============================================================# 548YUM 静默安装依赖包 549#==============================================================# 550551bc-1.06.95-13.el7.x86_64552binutils-2.27-43.base.el7.x86_64553compat-libcap1-1.10-7.el7.x86_64554package compat-libstdc++-33 is not installed555gcc-4.8.5-39.el7.x86_64556gcc-c++-4.8.5-39.el7.x86_64557elfutils-libelf-0.176-4.el7.x86_64558elfutils-libelf-devel-0.176-4.el7.x86_64559glibc-2.17-307.el7.1.x86_64560glibc-devel-2.17-307.el7.1.x86_64561libaio-0.3.109-13.el7.x86_64562libaio-devel-0.3.109-13.el7.x86_64563libgcc-4.8.5-39.el7.x86_64564libstdc++-4.8.5-39.el7.x86_64565libstdc++-devel-4.8.5-39.el7.x86_64566libxcb-1.13-1.el7.x86_64567libX11-1.6.7-2.el7.x86_64568libXau-1.0.8-2.1.el7.x86_64569libXi-1.7.9-1.el7.x86_64570libXrender-0.9.10-1.el7.x86_64571make-3.82-24.el7.x86_64572net-tools-2.0-0.25.20131004git.el7.x86_64573smartmontools-7.0-2.el7.x86_64574sysstat-10.1.5-19.el7.x86_64575e2fsprogs-1.42.9-17.el7.x86_64576e2fsprogs-libs-1.42.9-17.el7.x86_64577unzip-6.0-21.el7.x86_64578openssh-clients-7.4p1-21.el7.x86_64579readline-6.2-11.el7.x86_64580readline-devel-6.2-11.el7.x86_64581psmisc-22.20-16.el7.x86_64582ksh-20120801-142.el7.x86_64583nfs-utils-1.3.0-0.66.el7.x86_64584tar-1.26-35.el7.x86_64585device-mapper-multipath-0.4.9-131.el7.x86_64586avahi-0.6.31-20.el7.x86_64587ntp-4.2.6p5-29.el7.x86_64588package chronyd is not installed589libXtst-1.2.3-1.el7.x86_64590libXrender-devel-0.9.10-1.el7.x86_64591fontconfig-devel-2.13.0-4.3.el7.x86_64592policycoreutils-2.5-34.el7.x86_64593policycoreutils-python-2.5-34.el7.x86_64594package policycoreutils-python-utils) is not installed595596#==============================================================# 597配置主机名 598#==============================================================# 599600 Static hostname: luciferdb02601 Icon name: computer-vm602 Chassis: vm603 Machine ID: 7023288668c24439a1514ac780701abe604 Boot ID: d01791aefb2c47c48a4392f21c2133e7605 Virtualization: vmware606 Operating System: Red Hat Enterprise Linux Server 7.8 (Maipo)607 CPE OS Name: cpe:/o:redhat:enterprise_linux:7.8:GA:server608 Kernel: Linux 3.10.0-1127.el7.x86_64609 Architecture: x86-64610611612#==============================================================# 613配置 HOSTS 文件 614#==============================================================# 615616127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4617::1 localhost localhost.localdomain localhost6 localhost6.localdomain6618619## OracleBegin620621## RAC1 IP's: luciferdb01622623## RAC1 Public IP624192.168.6.31 luciferdb01625## RAC1 Virtual IP626192.168.6.51 luciferdb01-vip627## RAC1 Private IP6282.2.1.1 luciferdb01-priv6292.2.2.1 luciferdb01-priv1630631## RAC2 IP's: luciferdb02632633## RAC2 Public IP634192.168.6.32 luciferdb02635## RAC2 Virtual IP636192.168.6.52 luciferdb02-vip637## RAC2 Private IP6382.2.2.2 luciferdb02-priv6392.2.1.2 luciferdb02-priv1640641## RAC3 IP's: luciferdb03642643## RAC3 Public IP644192.168.6.33 luciferdb03645## RAC3 Virtual IP646192.168.6.53 luciferdb03-vip647## RAC3 Private IP6482.2.2.3 luciferdb03-priv6492.2.1.3 luciferdb03-priv1650651## RAC4 IP's: luciferdb04652653## RAC4 Public IP654192.168.6.34 luciferdb04655## RAC4 Virtual IP656192.168.6.54 luciferdb04-vip657## RAC4 Private IP6582.2.2.4 luciferdb04-priv6592.2.1.4 luciferdb04-priv1660661## RAC5 IP's: luciferdb05662663## RAC5 Public IP664192.168.6.35 luciferdb05665## RAC5 Virtual IP666192.168.6.55 luciferdb05-vip667## RAC5 Private IP6682.2.2.5 luciferdb05-priv6692.2.1.5 luciferdb05-priv1670671## SCAN IP672192.168.6.50 luciferdb-scan673674675#==============================================================# 676创建用户和组 677#==============================================================# 678679uid=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)680681682#==============================================================# 683Avahi-daemon 状态 684#==============================================================# 685686● avahi-daemon.service - Avahi mDNS/DNS-SD Stack687 Loaded: loaded (/usr/lib/systemd/system/avahi-daemon.service; disabled; vendor preset: enabled)688 Active: inactive (dead)689690691#==============================================================# 692配置透明大页 && NUMA && 磁盘 IO 调度器 693#==============================================================# 694695args="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"696-rd.lvm.lv=rhel/root697-args="ro698args="ro rd.lvm.lv=rhel/root rd.lvm.lv=rhel/swap rhgb quiet numa=off transparent_hugepage=never elevator=deadline"699-elevator=deadline"700-transparent_hugepage=never701702703#==============================================================# 704配置 sysctl.conf 705#==============================================================# 706707fs.aio-max-nr = 1048576708fs.file-max = 6815744709kernel.shmall = 2097152710kernel.shmmax = 8369389567711kernel.shmmni = 4096712kernel.sem = 250 32000 100 128713net.ipv4.ip_local_port_range = 9000 65500714net.core.rmem_default = 262144715net.core.rmem_max = 4194304716net.core.wmem_default = 262144717net.core.wmem_max = 1048576718vm.min_free_kbytes = 32692719net.ipv4.conf.ens192.rp_filter = 1720net.ipv4.conf.ens224.rp_filter = 2721net.ipv4.conf.ens256.rp_filter = 2722723724#==============================================================# 725配置 nsysctl.conf 726#==============================================================# 727728# Created by anaconda729NOZEROCONF=yes730731732#==============================================================# 733配置 /etc/security/limits.conf 734#==============================================================# 735736oracle soft nofile 1024737oracle hard nofile 65536738oracle soft stack 10240739oracle hard stack 32768740oracle soft nproc 2047741oracle hard nproc 16384742oracle hard memlock unlimited743oracle soft memlock unlimited744grid soft nofile 1024745grid hard nofile 65536746grid soft stack 10240747grid hard stack 32768748grid soft nproc 2047749grid hard nproc 16384750751752#==============================================================# 753配置 /etc/pam.d/login 754#==============================================================# 755756auth [user_unknown=ignore success=ok ignore=ignore default=bad] pam_securetty.so757auth substack system-auth758auth include postlogin759account required pam_nologin.so760account include system-auth761password include system-auth762session required pam_selinux.so close763session required pam_loginuid.so764session optional pam_console.so765session required pam_selinux.so open766session required pam_namespace.so767session optional pam_keyinit.so force revoke768session include system-auth769session include postlogin770-session optional pam_ck_connector.so771session required pam_limits.so772session required /lib64/security/pam_limits.so773774775#==============================================================# 776配置 /dev/shm 777#==============================================================# 778779/dev/mapper/rhel-root / xfs defaults 0 0780UUID=7c2bbcd9-a8d3-4c6f-a8a2-486e6907ad84 /boot xfs defaults 0 0781/dev/mapper/rhel-swap swap swap defaults 0 0782tmpfs /dev/shm tmpfs size=8173232k 0 0783784785#==============================================================# 786安装 rlwrap 787#==============================================================# 788789790成功安装 rlwrap： rlwrap 0.42 791792#==============================================================# 793Root 用户环境变量 794#==============================================================# 795796if [ -f ~/.bashrc ]; then797 . ~/.bashrc798fi799PATH=$PATH:$HOME/bin800export PATH801alias so='su - oracle'802export PS1="[`whoami`@`hostname`:"'\w]# '803alias sg='su - grid'804alias crsctl='/u01/app/11.2.0/grid/bin/crsctl'805alias srvctl='/u01/app/11.2.0/grid/bin/srvctl'806807808#==============================================================# 809Oracle 用户环境变量 810#==============================================================# 811812if [ -f ~/.bashrc ]; then813 . ~/.bashrc814fi815PATH=$PATH:$HOME/.local/bin:$HOME/bin816export PATH817umask 022818export TMP=/tmp819export TMPDIR=$TMP820export NLS_LANG=AMERICAN_AMERICA.AL32UTF8821export ORACLE_BASE=/u01/app/oracle822export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db823export ORACLE_TERM=xterm824export TNS_ADMIN=$ORACLE_HOME/network/admin825export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib826export ORACLE_SID=oradb2827export PATH=/usr/sbin:$PATH828export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/perl/bin:$PATH829export PERL5LIB=$ORACLE_HOME/perl/lib830alias sas='sqlplus / as sysdba'831alias awr='sqlplus / as sysdba @?/rdbms/admin/awrrpt'832alias ash='sqlplus / as sysdba @?/rdbms/admin/ashrpt'833alias alert='vi $ORACLE_BASE/diag/rdbms/*/$ORACLE_SID/trace/alert_$ORACLE_SID.log'834export PS1="[`whoami`@`hostname`:"'\w]$ '835alias sqlplus='rlwrap sqlplus'836alias rman='rlwrap rman'837alias adrci='rlwrap adrci'838839840#==============================================================# 841Grid 用户环境变量 842#==============================================================# 843844if [ -f ~/.bashrc ]; then845 . ~/.bashrc846fi847PATH=$PATH:$HOME/.local/bin:$HOME/bin848export PATH849umask 022850export TMP=/tmp851export TMPDIR=$TMP852export NLS_LANG=AMERICAN_AMERICA.AL32UTF8853export ORACLE_BASE=/u01/app/grid854export ORACLE_HOME=/u01/app/11.2.0/grid855export ORACLE_TERM=xterm856export TNS_ADMIN=$ORACLE_HOME/network/admin857export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib858export ORACLE_SID=+ASM2859export PATH=/usr/sbin:$PATH860export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH861alias sas='sqlplus / as sysasm'862export PS1="[`whoami`@`hostname`:"'\w]$ '863alias sqlplus='rlwrap sqlplus'864alias asmcmd='rlwrap asmcmd'865alias adrci='rlwrap adrci'866867868#==============================================================# 869配置时间同步 870#==============================================================# 871872Created symlink from /etc/systemd/system/multi-user.target.wants/ntpd.service to /usr/lib/systemd/system/ntpd.service.873874#==============================================================# 875NTP 检查 876#==============================================================# 877878 remote refid st t when poll reach delay offset jitter879==============================================================================880 202.112.10.36 .INIT. 16 u - 64 0 0.000 0.000 0.001881882883#==============================================================# 884多路径信息 885#==============================================================# 886887create: asm_ocr_1 (2d7490d9f98a4dd33) undef ROCKET ,IMAGEFILE 888size=10G features='0' hwhandler='0' wp=undef889`-+- policy='service-time 0' prio=1 status=undef890 `- 33:0:0:0 sdb 8:16 undef ready running891create: asm_ocr_2 (29d556de9c0521353) undef ROCKET ,IMAGEFILE 892size=10G features='0' hwhandler='0' wp=undef893`-+- policy='service-time 0' prio=1 status=undef894 `- 33:0:0:1 sdc 8:32 undef ready running895create: asm_ocr_3 (22a3d603188b7e7ac) undef ROCKET ,IMAGEFILE 896size=10G features='0' hwhandler='0' wp=undef897`-+- policy='service-time 0' prio=1 status=undef898 `- 33:0:0:2 sdd 8:48 undef ready running899create: asm_data_1 (2efbc650f3322eb34) undef ROCKET ,IMAGEFILE 900size=50G features='0' hwhandler='0' wp=undef901`-+- policy='service-time 0' prio=1 status=undef902 `- 33:0:0:3 sde 8:64 undef ready running903create: asm_data_2 (228a97913b281ad29) undef ROCKET ,IMAGEFILE 904size=50G features='0' hwhandler='0' wp=undef905`-+- policy='service-time 0' prio=1 status=undef906 `- 33:0:0:4 sdf 8:80 undef ready running907908909#==============================================================# 910UDEV 配置文件 911#==============================================================# 912913KERNEL=="dm-*",ENV{DM_UUID}=="mpath-2d7490d9f98a4dd33",SYMLINK+="asm_ocr_1",OWNER="grid",GROUP="asmadmin",MODE="0660"914KERNEL=="dm-*",ENV{DM_UUID}=="mpath-29d556de9c0521353",SYMLINK+="asm_ocr_2",OWNER="grid",GROUP="asmadmin",MODE="0660"915KERNEL=="dm-*",ENV{DM_UUID}=="mpath-22a3d603188b7e7ac",SYMLINK+="asm_ocr_3",OWNER="grid",GROUP="asmadmin",MODE="0660"916KERNEL=="dm-*",ENV{DM_UUID}=="mpath-2efbc650f3322eb34",SYMLINK+="asm_data_1",OWNER="grid",GROUP="asmadmin",MODE="0660"917KERNEL=="dm-*",ENV{DM_UUID}=="mpath-228a97913b281ad29",SYMLINK+="asm_data_2",OWNER="grid",GROUP="asmadmin",MODE="0660"918919920UDEV 已加载成功。 921922#==============================================================# 923ASM 磁盘信息 924#==============================================================# 925926/dev/asm_data_1927/dev/asm_data_2928/dev/asm_ocr_1929/dev/asm_ocr_2930/dev/asm_ocr_3931932933配置 RAC 节点：192.168.6.32 结束! 934935#==============================================================# 936配置 RAC 节点：192.168.6.33 937#==============================================================# 938939正在节点：192.168.6.33 上执行脚本： 940941942 ███████ ██ ████████ ██ ██ ██ ██ ██ ██ ██943 ██░░░░░██ ░██ ██░░░░░░ ░██ ░██ ░██░██ ░██ ░██ ░██944 ██ ░░██ ██████ ██████ █████ ░██ █████ ░██ ░██ █████ ░██ ░██░██ ███████ ██████ ██████ ██████ ░██ ░██945░██ ░██░░██░░█ ░░░░░░██ ██░░░██ ░██ ██░░░██░█████████░██████ ██░░░██ ░██ ░██░██░░██░░░██ ██░░░░ ░░░██░ ░░░░░░██ ░██ ░██946░██ ░██ ░██ ░ ███████ ░██ ░░ ░██░███████░░░░░░░░██░██░░░██░███████ ░██ ░██░██ ░██ ░██░░█████ ░██ ███████ ░██ ░██947░░██ ██ ░██ ██░░░░██ ░██ ██ ░██░██░░░░ ░██░██ ░██░██░░░░ ░██ ░██░██ ░██ ░██ ░░░░░██ ░██ ██░░░░██ ░██ ░██948 ░░███████ ░███ ░░████████░░█████ ███░░██████ ████████ ░██ ░██░░██████ ███ ███░██ ███ ░██ ██████ ░░██ ░░████████ ███ ███949 ░░░░░░░ ░░░ ░░░░░░░░ ░░░░░ ░░░ ░░░░░░ ░░░░░░░░ ░░ ░░ ░░░░░░ ░░░ ░░░ ░░ ░░░ ░░ ░░░░░░ ░░ ░░░░░░░░ ░░░ ░░░ 950951配置本地 YUM 源： 952953[server]954name=server955baseurl=file:///mnt956enabled=1957gpgcheck=0958959#==============================================================# 960配置 SELinux 961#==============================================================# 962963SELINUX=disabled964SELINUXTYPE=targeted 965966967#==============================================================# 968YUM 静默安装依赖包 969#==============================================================# 970971bc-1.06.95-13.el7.x86_64972binutils-2.27-43.base.el7.x86_64973compat-libcap1-1.10-7.el7.x86_64974package compat-libstdc++-33 is not installed975gcc-4.8.5-39.el7.x86_64976gcc-c++-4.8.5-39.el7.x86_64977elfutils-libelf-0.176-4.el7.x86_64978elfutils-libelf-devel-0.176-4.el7.x86_64979glibc-2.17-307.el7.1.x86_64980glibc-devel-2.17-307.el7.1.x86_64981libaio-0.3.109-13.el7.x86_64982libaio-devel-0.3.109-13.el7.x86_64983libgcc-4.8.5-39.el7.x86_64984libstdc++-4.8.5-39.el7.x86_64985libstdc++-devel-4.8.5-39.el7.x86_64986libxcb-1.13-1.el7.x86_64987libX11-1.6.7-2.el7.x86_64988libXau-1.0.8-2.1.el7.x86_64989libXi-1.7.9-1.el7.x86_64990libXrender-0.9.10-1.el7.x86_64991make-3.82-24.el7.x86_64992net-tools-2.0-0.25.20131004git.el7.x86_64993smartmontools-7.0-2.el7.x86_64994sysstat-10.1.5-19.el7.x86_64995e2fsprogs-1.42.9-17.el7.x86_64996e2fsprogs-libs-1.42.9-17.el7.x86_64997unzip-6.0-21.el7.x86_64998openssh-clients-7.4p1-21.el7.x86_64999readline-6.2-11.el7.x86_641000readline-devel-6.2-11.el7.x86_641001psmisc-22.20-16.el7.x86_641002ksh-20120801-142.el7.x86_641003nfs-utils-1.3.0-0.66.el7.x86_641004tar-1.26-35.el7.x86_641005device-mapper-multipath-0.4.9-131.el7.x86_641006avahi-0.6.31-20.el7.x86_641007ntp-4.2.6p5-29.el7.x86_641008package chronyd is not installed1009libXtst-1.2.3-1.el7.x86_641010libXrender-devel-0.9.10-1.el7.x86_641011fontconfig-devel-2.13.0-4.3.el7.x86_641012policycoreutils-2.5-34.el7.x86_641013policycoreutils-python-2.5-34.el7.x86_641014package policycoreutils-python-utils) is not installed10151016#==============================================================# 1017配置主机名 1018#==============================================================# 10191020 Static hostname: luciferdb031021 Icon name: computer-vm1022 Chassis: vm1023 Machine ID: 724a2c2cf20045c5a50e8cbee59824111024 Boot ID: 6947165888e94b7fb9a3eb4e6edfd9161025 Virtualization: vmware1026 Operating System: Red Hat Enterprise Linux Server 7.8 (Maipo)1027 CPE OS Name: cpe:/o:redhat:enterprise_linux:7.8:GA:server1028 Kernel: Linux 3.10.0-1127.el7.x86_641029 Architecture: x86-64103010311032#==============================================================# 1033配置 HOSTS 文件 1034#==============================================================# 10351036127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain41037::1 localhost localhost.localdomain localhost6 localhost6.localdomain610381039## OracleBegin10401041## RAC1 IP's: luciferdb0110421043## RAC1 Public IP1044192.168.6.31 luciferdb011045## RAC1 Virtual IP1046192.168.6.51 luciferdb01-vip1047## RAC1 Private IP10482.2.1.1 luciferdb01-priv10492.2.2.1 luciferdb01-priv110501051## RAC2 IP's: luciferdb0210521053## RAC2 Public IP1054192.168.6.32 luciferdb021055## RAC2 Virtual IP1056192.168.6.52 luciferdb02-vip1057## RAC2 Private IP10582.2.2.2 luciferdb02-priv10592.2.1.2 luciferdb02-priv110601061## RAC3 IP's: luciferdb0310621063## RAC3 Public IP1064192.168.6.33 luciferdb031065## RAC3 Virtual IP1066192.168.6.53 luciferdb03-vip1067## RAC3 Private IP10682.2.2.3 luciferdb03-priv10692.2.1.3 luciferdb03-priv110701071## RAC4 IP's: luciferdb0410721073## RAC4 Public IP1074192.168.6.34 luciferdb041075## RAC4 Virtual IP1076192.168.6.54 luciferdb04-vip1077## RAC4 Private IP10782.2.2.4 luciferdb04-priv10792.2.1.4 luciferdb04-priv110801081## RAC5 IP's: luciferdb0510821083## RAC5 Public IP1084192.168.6.35 luciferdb051085## RAC5 Virtual IP1086192.168.6.55 luciferdb05-vip1087## RAC5 Private IP10882.2.2.5 luciferdb05-priv10892.2.1.5 luciferdb05-priv110901091## SCAN IP1092192.168.6.50 luciferdb-scan109310941095#==============================================================# 1096创建用户和组 1097#==============================================================# 10981099uid=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)110011011102#==============================================================# 1103Avahi-daemon 状态 1104#==============================================================# 11051106● avahi-daemon.service - Avahi mDNS/DNS-SD Stack1107 Loaded: loaded (/usr/lib/systemd/system/avahi-daemon.service; disabled; vendor preset: enabled)1108 Active: inactive (dead)11091110May 04 17:53:30 lucifer03 avahi-daemon[907]: New relevant interface ens256.IPv4 for mDNS.1111May 04 17:53:30 lucifer03 avahi-daemon[907]: Registering new address record for 2.2.2.3 on ens256.IPv4.1112May 04 18:00:02 luciferdb03 avahi-daemon[907]: Got SIGTERM, quitting.1113May 04 18:00:02 luciferdb03 systemd[1]: Stopping Avahi mDNS/DNS-SD Stack...1114May 04 18:00:02 luciferdb03 avahi-daemon[907]: Leaving mDNS multicast group on interface virbr0.IPv4 with address 192.168.122.1.1115May 04 18:00:02 luciferdb03 avahi-daemon[907]: Leaving mDNS multicast group on interface ens256.IPv4 with address 2.2.2.3.1116May 04 18:00:02 luciferdb03 avahi-daemon[907]: Leaving mDNS multicast group on interface ens224.IPv4 with address 2.2.1.3.1117May 04 18:00:02 luciferdb03 avahi-daemon[907]: Leaving mDNS multicast group on interface ens192.IPv4 with address 192.168.6.33.1118May 04 18:00:02 luciferdb03 avahi-daemon[907]: avahi-daemon 0.6.31 exiting.1119May 04 18:00:02 luciferdb03 systemd[1]: Stopped Avahi mDNS/DNS-SD Stack.112011211122#==============================================================# 1123配置透明大页 && NUMA && 磁盘 IO 调度器 1124#==============================================================# 11251126args="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"1127-rd.lvm.lv=rhel/root1128-args="ro1129args="ro rd.lvm.lv=rhel/root rd.lvm.lv=rhel/swap rhgb quiet numa=off transparent_hugepage=never elevator=deadline"1130-elevator=deadline"1131-transparent_hugepage=never113211331134#==============================================================# 1135配置 sysctl.conf 1136#==============================================================# 11371138fs.aio-max-nr = 10485761139fs.file-max = 68157441140kernel.shmall = 20971521141kernel.shmmax = 83700162551142kernel.shmmni = 40961143kernel.sem = 250 32000 100 1281144net.ipv4.ip_local_port_range = 9000 655001145net.core.rmem_default = 2621441146net.core.rmem_max = 41943041147net.core.wmem_default = 2621441148net.core.wmem_max = 10485761149vm.min_free_kbytes = 326951150net.ipv4.conf.ens192.rp_filter = 11151net.ipv4.conf.ens224.rp_filter = 21152net.ipv4.conf.ens256.rp_filter = 2115311541155#==============================================================# 1156配置 nsysctl.conf 1157#==============================================================# 11581159# Created by anaconda1160NOZEROCONF=yes116111621163#==============================================================# 1164配置 /etc/security/limits.conf 1165#==============================================================# 11661167oracle soft nofile 10241168oracle hard nofile 655361169oracle soft stack 102401170oracle hard stack 327681171oracle soft nproc 20471172oracle hard nproc 163841173oracle hard memlock unlimited1174oracle soft memlock unlimited1175grid soft nofile 10241176grid hard nofile 655361177grid soft stack 102401178grid hard stack 327681179grid soft nproc 20471180grid hard nproc 16384118111821183#==============================================================# 1184配置 /etc/pam.d/login 1185#==============================================================# 11861187auth [user_unknown=ignore success=ok ignore=ignore default=bad] pam_securetty.so1188auth substack system-auth1189auth include postlogin1190account required pam_nologin.so1191account include system-auth1192password include system-auth1193session required pam_selinux.so close1194session required pam_loginuid.so1195session optional pam_console.so1196session required pam_selinux.so open1197session required pam_namespace.so1198session optional pam_keyinit.so force revoke1199session include system-auth1200session include postlogin1201-session optional pam_ck_connector.so1202session required pam_limits.so1203session required /lib64/security/pam_limits.so120412051206#==============================================================# 1207配置 /dev/shm 1208#==============================================================# 12091210/dev/mapper/rhel-root / xfs defaults 0 01211UUID=ff1a641a-a4df-497c-9371-c1acdc2c078f /boot xfs defaults 0 01212/dev/mapper/rhel-swap swap swap defaults 0 01213tmpfs /dev/shm tmpfs size=8173844k 0 0121412151216#==============================================================# 1217安装 rlwrap 1218#==============================================================# 121912201221成功安装 rlwrap： rlwrap 0.42 12221223#==============================================================# 1224Root 用户环境变量 1225#==============================================================# 12261227if [ -f ~/.bashrc ]; then1228 . ~/.bashrc1229fi1230PATH=$PATH:$HOME/bin1231export PATH1232alias so='su - oracle'1233export PS1="[`whoami`@`hostname`:"'\w]# '1234alias sg='su - grid'1235alias crsctl='/u01/app/11.2.0/grid/bin/crsctl'1236alias srvctl='/u01/app/11.2.0/grid/bin/srvctl'123712381239#==============================================================# 1240Oracle 用户环境变量 1241#==============================================================# 12421243if [ -f ~/.bashrc ]; then1244 . ~/.bashrc1245fi1246PATH=$PATH:$HOME/.local/bin:$HOME/bin1247export PATH1248umask 0221249export TMP=/tmp1250export TMPDIR=$TMP1251export NLS_LANG=AMERICAN_AMERICA.AL32UTF81252export ORACLE_BASE=/u01/app/oracle1253export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db1254export ORACLE_TERM=xterm1255export TNS_ADMIN=$ORACLE_HOME/network/admin1256export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib1257export ORACLE_SID=oradb31258export PATH=/usr/sbin:$PATH1259export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/perl/bin:$PATH1260export PERL5LIB=$ORACLE_HOME/perl/lib1261alias sas='sqlplus / as sysdba'1262alias awr='sqlplus / as sysdba @?/rdbms/admin/awrrpt'1263alias ash='sqlplus / as sysdba @?/rdbms/admin/ashrpt'1264alias alert='vi $ORACLE_BASE/diag/rdbms/*/$ORACLE_SID/trace/alert_$ORACLE_SID.log'1265export PS1="[`whoami`@`hostname`:"'\w]$ '1266alias sqlplus='rlwrap sqlplus'1267alias rman='rlwrap rman'1268alias adrci='rlwrap adrci'126912701271#==============================================================# 1272Grid 用户环境变量 1273#==============================================================# 12741275if [ -f ~/.bashrc ]; then1276 . ~/.bashrc1277fi1278PATH=$PATH:$HOME/.local/bin:$HOME/bin1279export PATH1280umask 0221281export TMP=/tmp1282export TMPDIR=$TMP1283export NLS_LANG=AMERICAN_AMERICA.AL32UTF81284export ORACLE_BASE=/u01/app/grid1285export ORACLE_HOME=/u01/app/11.2.0/grid1286export ORACLE_TERM=xterm1287export TNS_ADMIN=$ORACLE_HOME/network/admin1288export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib1289export ORACLE_SID=+ASM31290export PATH=/usr/sbin:$PATH1291export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH1292alias sas='sqlplus / as sysasm'1293export PS1="[`whoami`@`hostname`:"'\w]$ '1294alias sqlplus='rlwrap sqlplus'1295alias asmcmd='rlwrap asmcmd'1296alias adrci='rlwrap adrci'129712981299#==============================================================# 1300配置时间同步 1301#==============================================================# 13021303Created symlink from /etc/systemd/system/multi-user.target.wants/ntpd.service to /usr/lib/systemd/system/ntpd.service.13041305#==============================================================# 1306NTP 检查 1307#==============================================================# 13081309 remote refid st t when poll reach delay offset jitter1310==============================================================================1311 202.112.10.36 .INIT. 16 u - 64 0 0.000 0.000 0.001131213131314#==============================================================# 1315多路径信息 1316#==============================================================# 13171318create: asm_ocr_1 (2d7490d9f98a4dd33) undef ROCKET ,IMAGEFILE 1319size=10G features='0' hwhandler='0' wp=undef1320`-+- policy='service-time 0' prio=1 status=undef1321 `- 33:0:0:0 sdb 8:16 undef ready running1322create: asm_ocr_2 (29d556de9c0521353) undef ROCKET ,IMAGEFILE 1323size=10G features='0' hwhandler='0' wp=undef1324`-+- policy='service-time 0' prio=1 status=undef1325 `- 33:0:0:1 sdc 8:32 undef ready running1326create: asm_ocr_3 (22a3d603188b7e7ac) undef ROCKET ,IMAGEFILE 1327size=10G features='0' hwhandler='0' wp=undef1328`-+- policy='service-time 0' prio=1 status=undef1329 `- 33:0:0:2 sdd 8:48 undef ready running1330create: asm_data_1 (2efbc650f3322eb34) undef ROCKET ,IMAGEFILE 1331size=50G features='0' hwhandler='0' wp=undef1332`-+- policy='service-time 0' prio=1 status=undef1333 `- 33:0:0:3 sde 8:64 undef ready running1334create: asm_data_2 (228a97913b281ad29) undef ROCKET ,IMAGEFILE 1335size=50G features='0' hwhandler='0' wp=undef1336`-+- policy='service-time 0' prio=1 status=undef1337 `- 33:0:0:4 sdf 8:80 undef ready running133813391340#==============================================================# 1341UDEV 配置文件 1342#==============================================================# 13431344KERNEL=="dm-*",ENV{DM_UUID}=="mpath-2d7490d9f98a4dd33",SYMLINK+="asm_ocr_1",OWNER="grid",GROUP="asmadmin",MODE="0660"1345KERNEL=="dm-*",ENV{DM_UUID}=="mpath-29d556de9c0521353",SYMLINK+="asm_ocr_2",OWNER="grid",GROUP="asmadmin",MODE="0660"1346KERNEL=="dm-*",ENV{DM_UUID}=="mpath-22a3d603188b7e7ac",SYMLINK+="asm_ocr_3",OWNER="grid",GROUP="asmadmin",MODE="0660"1347KERNEL=="dm-*",ENV{DM_UUID}=="mpath-2efbc650f3322eb34",SYMLINK+="asm_data_1",OWNER="grid",GROUP="asmadmin",MODE="0660"1348KERNEL=="dm-*",ENV{DM_UUID}=="mpath-228a97913b281ad29",SYMLINK+="asm_data_2",OWNER="grid",GROUP="asmadmin",MODE="0660"134913501351UDEV 已加载成功。 13521353#==============================================================# 1354ASM 磁盘信息 1355#==============================================================# 13561357/dev/asm_data_11358/dev/asm_data_21359/dev/asm_ocr_11360/dev/asm_ocr_21361/dev/asm_ocr_3136213631364配置 RAC 节点：192.168.6.33 结束! 13651366#==============================================================# 1367配置 RAC 节点：192.168.6.34 1368#==============================================================# 13691370正在节点：192.168.6.34 上执行脚本： 137113721373 ███████ ██ ████████ ██ ██ ██ ██ ██ ██ ██1374 ██░░░░░██ ░██ ██░░░░░░ ░██ ░██ ░██░██ ░██ ░██ ░██1375 ██ ░░██ ██████ ██████ █████ ░██ █████ ░██ ░██ █████ ░██ ░██░██ ███████ ██████ ██████ ██████ ░██ ░██1376░██ ░██░░██░░█ ░░░░░░██ ██░░░██ ░██ ██░░░██░█████████░██████ ██░░░██ ░██ ░██░██░░██░░░██ ██░░░░ ░░░██░ ░░░░░░██ ░██ ░██1377░██ ░██ ░██ ░ ███████ ░██ ░░ ░██░███████░░░░░░░░██░██░░░██░███████ ░██ ░██░██ ░██ ░██░░█████ ░██ ███████ ░██ ░██1378░░██ ██ ░██ ██░░░░██ ░██ ██ ░██░██░░░░ ░██░██ ░██░██░░░░ ░██ ░██░██ ░██ ░██ ░░░░░██ ░██ ██░░░░██ ░██ ░██1379 ░░███████ ░███ ░░████████░░█████ ███░░██████ ████████ ░██ ░██░░██████ ███ ███░██ ███ ░██ ██████ ░░██ ░░████████ ███ ███1380 ░░░░░░░ ░░░ ░░░░░░░░ ░░░░░ ░░░ ░░░░░░ ░░░░░░░░ ░░ ░░ ░░░░░░ ░░░ ░░░ ░░ ░░░ ░░ ░░░░░░ ░░ ░░░░░░░░ ░░░ ░░░ 13811382配置本地 YUM 源： 13831384[server]1385name=server1386baseurl=file:///mnt1387enabled=11388gpgcheck=013891390#==============================================================# 1391配置 SELinux 1392#==============================================================# 13931394SELINUX=disabled1395SELINUXTYPE=targeted 139613971398#==============================================================# 1399YUM 静默安装依赖包 1400#==============================================================# 14011402bc-1.06.95-13.el7.x86_641403binutils-2.27-43.base.el7.x86_641404compat-libcap1-1.10-7.el7.x86_641405package compat-libstdc++-33 is not installed1406gcc-4.8.5-39.el7.x86_641407gcc-c++-4.8.5-39.el7.x86_641408elfutils-libelf-0.176-4.el7.x86_641409elfutils-libelf-devel-0.176-4.el7.x86_641410glibc-2.17-307.el7.1.x86_641411glibc-devel-2.17-307.el7.1.x86_641412libaio-0.3.109-13.el7.x86_641413libaio-devel-0.3.109-13.el7.x86_641414libgcc-4.8.5-39.el7.x86_641415libstdc++-4.8.5-39.el7.x86_641416libstdc++-devel-4.8.5-39.el7.x86_641417libxcb-1.13-1.el7.x86_641418libX11-1.6.7-2.el7.x86_641419libXau-1.0.8-2.1.el7.x86_641420libXi-1.7.9-1.el7.x86_641421libXrender-0.9.10-1.el7.x86_641422make-3.82-24.el7.x86_641423net-tools-2.0-0.25.20131004git.el7.x86_641424smartmontools-7.0-2.el7.x86_641425sysstat-10.1.5-19.el7.x86_641426e2fsprogs-1.42.9-17.el7.x86_641427e2fsprogs-libs-1.42.9-17.el7.x86_641428unzip-6.0-21.el7.x86_641429openssh-clients-7.4p1-21.el7.x86_641430readline-6.2-11.el7.x86_641431readline-devel-6.2-11.el7.x86_641432psmisc-22.20-16.el7.x86_641433ksh-20120801-142.el7.x86_641434nfs-utils-1.3.0-0.66.el7.x86_641435tar-1.26-35.el7.x86_641436device-mapper-multipath-0.4.9-131.el7.x86_641437avahi-0.6.31-20.el7.x86_641438ntp-4.2.6p5-29.el7.x86_641439package chronyd is not installed1440libXtst-1.2.3-1.el7.x86_641441libXrender-devel-0.9.10-1.el7.x86_641442fontconfig-devel-2.13.0-4.3.el7.x86_641443policycoreutils-2.5-34.el7.x86_641444policycoreutils-python-2.5-34.el7.x86_641445package policycoreutils-python-utils) is not installed14461447#==============================================================# 1448配置主机名 1449#==============================================================# 14501451 Static hostname: luciferdb041452 Icon name: computer-vm1453 Chassis: vm1454 Machine ID: 716b4ed4547946529219b5abcdf3f70b1455 Boot ID: 27c2685c6f34474baf54d4fffe8c2f8d1456 Virtualization: vmware1457 Operating System: Red Hat Enterprise Linux Server 7.8 (Maipo)1458 CPE OS Name: cpe:/o:redhat:enterprise_linux:7.8:GA:server1459 Kernel: Linux 3.10.0-1127.el7.x86_641460 Architecture: x86-64146114621463#==============================================================# 1464配置 HOSTS 文件 1465#==============================================================# 14661467127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain41468::1 localhost localhost.localdomain localhost6 localhost6.localdomain614691470## OracleBegin14711472## RAC1 IP's: luciferdb0114731474## RAC1 Public IP1475192.168.6.31 luciferdb011476## RAC1 Virtual IP1477192.168.6.51 luciferdb01-vip1478## RAC1 Private IP14792.2.1.1 luciferdb01-priv14802.2.2.1 luciferdb01-priv114811482## RAC2 IP's: luciferdb0214831484## RAC2 Public IP1485192.168.6.32 luciferdb021486## RAC2 Virtual IP1487192.168.6.52 luciferdb02-vip1488## RAC2 Private IP14892.2.2.2 luciferdb02-priv14902.2.1.2 luciferdb02-priv114911492## RAC3 IP's: luciferdb0314931494## RAC3 Public IP1495192.168.6.33 luciferdb031496## RAC3 Virtual IP1497192.168.6.53 luciferdb03-vip1498## RAC3 Private IP14992.2.2.3 luciferdb03-priv15002.2.1.3 luciferdb03-priv115011502## RAC4 IP's: luciferdb0415031504## RAC4 Public IP1505192.168.6.34 luciferdb041506## RAC4 Virtual IP1507192.168.6.54 luciferdb04-vip1508## RAC4 Private IP15092.2.2.4 luciferdb04-priv15102.2.1.4 luciferdb04-priv115111512## RAC5 IP's: luciferdb0515131514## RAC5 Public IP1515192.168.6.35 luciferdb051516## RAC5 Virtual IP1517192.168.6.55 luciferdb05-vip1518## RAC5 Private IP15192.2.2.5 luciferdb05-priv15202.2.1.5 luciferdb05-priv115211522## SCAN IP1523192.168.6.50 luciferdb-scan152415251526#==============================================================# 1527创建用户和组 1528#==============================================================# 15291530uid=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)153115321533#==============================================================# 1534Avahi-daemon 状态 1535#==============================================================# 15361537● avahi-daemon.service - Avahi mDNS/DNS-SD Stack1538 Loaded: loaded (/usr/lib/systemd/system/avahi-daemon.service; disabled; vendor preset: enabled)1539 Active: inactive (dead)15401541May 04 17:51:31 lucifer04 avahi-daemon[959]: Registering new address record for fe80::f08d:ddd2:1257:5ccd on ens256.*.1542May 04 17:51:31 lucifer04 avahi-daemon[959]: Joining mDNS multicast group on interface ens256.IPv4 with address 2.2.2.4.1543May 04 17:51:31 lucifer04 avahi-daemon[959]: New relevant interface ens256.IPv4 for mDNS.1544May 04 17:51:31 lucifer04 avahi-daemon[959]: Registering new address record for 2.2.2.4 on ens256.IPv4.1545May 04 18:01:01 luciferdb04 avahi-daemon[959]: Got SIGTERM, quitting.1546May 04 18:01:01 luciferdb04 systemd[1]: Stopping Avahi mDNS/DNS-SD Stack...1547May 04 18:01:01 luciferdb04 avahi-daemon[959]: Leaving mDNS multicast group on interface virbr0.IPv4 with address 192.168.122.1.1548May 04 18:01:01 luciferdb04 avahi-daemon[959]: Leaving mDNS multicast group on interface ens256.IPv4 with address 2.2.2.4.1549May 04 18:01:01 luciferdb04 avahi-daemon[959]: Leaving mDNS multicast group on interface ens224.IPv4 with address 2.2.1.4.1550May 04 18:01:01 luciferdb04 systemd[1]: Stopped Avahi mDNS/DNS-SD Stack.155115521553#==============================================================# 1554配置透明大页 && NUMA && 磁盘 IO 调度器 1555#==============================================================# 15561557args="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"1558-rd.lvm.lv=rhel/root1559-args="ro1560args="ro rd.lvm.lv=rhel/root rd.lvm.lv=rhel/swap rhgb quiet numa=off transparent_hugepage=never elevator=deadline"1561-elevator=deadline"1562-transparent_hugepage=never156315641565#==============================================================# 1566配置 sysctl.conf 1567#==============================================================# 15681569fs.aio-max-nr = 10485761570fs.file-max = 68157441571kernel.shmall = 20971521572kernel.shmmax = 83700121591573kernel.shmmni = 40961574kernel.sem = 250 32000 100 1281575net.ipv4.ip_local_port_range = 9000 655001576net.core.rmem_default = 2621441577net.core.rmem_max = 41943041578net.core.wmem_default = 2621441579net.core.wmem_max = 10485761580vm.min_free_kbytes = 326951581net.ipv4.conf.ens192.rp_filter = 11582net.ipv4.conf.ens224.rp_filter = 21583net.ipv4.conf.ens256.rp_filter = 2158415851586#==============================================================# 1587配置 nsysctl.conf 1588#==============================================================# 15891590# Created by anaconda1591NOZEROCONF=yes159215931594#==============================================================# 1595配置 /etc/security/limits.conf 1596#==============================================================# 15971598oracle soft nofile 10241599oracle hard nofile 655361600oracle soft stack 102401601oracle hard stack 327681602oracle soft nproc 20471603oracle hard nproc 163841604oracle hard memlock unlimited1605oracle soft memlock unlimited1606grid soft nofile 10241607grid hard nofile 655361608grid soft stack 102401609grid hard stack 327681610grid soft nproc 20471611grid hard nproc 16384161216131614#==============================================================# 1615配置 /etc/pam.d/login 1616#==============================================================# 16171618auth [user_unknown=ignore success=ok ignore=ignore default=bad] pam_securetty.so1619auth substack system-auth1620auth include postlogin1621account required pam_nologin.so1622account include system-auth1623password include system-auth1624session required pam_selinux.so close1625session required pam_loginuid.so1626session optional pam_console.so1627session required pam_selinux.so open1628session required pam_namespace.so1629session optional pam_keyinit.so force revoke1630session include system-auth1631session include postlogin1632-session optional pam_ck_connector.so1633session required pam_limits.so1634session required /lib64/security/pam_limits.so163516361637#==============================================================# 1638配置 /dev/shm 1639#==============================================================# 16401641/dev/mapper/rhel-root / xfs defaults 0 01642UUID=a4eeb7a6-9f11-4b60-8c45-0a06764f93c1 /boot xfs defaults 0 01643/dev/mapper/rhel-swap swap swap defaults 0 01644tmpfs /dev/shm tmpfs size=8173840k 0 0164516461647#==============================================================# 1648安装 rlwrap 1649#==============================================================# 165016511652成功安装 rlwrap： rlwrap 0.42 16531654#==============================================================# 1655Root 用户环境变量 1656#==============================================================# 16571658if [ -f ~/.bashrc ]; then1659 . ~/.bashrc1660fi1661PATH=$PATH:$HOME/bin1662export PATH1663alias so='su - oracle'1664export PS1="[`whoami`@`hostname`:"'\w]# '1665alias sg='su - grid'1666alias crsctl='/u01/app/11.2.0/grid/bin/crsctl'1667alias srvctl='/u01/app/11.2.0/grid/bin/srvctl'166816691670#==============================================================# 1671Oracle 用户环境变量 1672#==============================================================# 16731674if [ -f ~/.bashrc ]; then1675 . ~/.bashrc1676fi1677PATH=$PATH:$HOME/.local/bin:$HOME/bin1678export PATH1679umask 0221680export TMP=/tmp1681export TMPDIR=$TMP1682export NLS_LANG=AMERICAN_AMERICA.AL32UTF81683export ORACLE_BASE=/u01/app/oracle1684export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db1685export ORACLE_TERM=xterm1686export TNS_ADMIN=$ORACLE_HOME/network/admin1687export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib1688export ORACLE_SID=oradb41689export PATH=/usr/sbin:$PATH1690export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/perl/bin:$PATH1691export PERL5LIB=$ORACLE_HOME/perl/lib1692alias sas='sqlplus / as sysdba'1693alias awr='sqlplus / as sysdba @?/rdbms/admin/awrrpt'1694alias ash='sqlplus / as sysdba @?/rdbms/admin/ashrpt'1695alias alert='vi $ORACLE_BASE/diag/rdbms/*/$ORACLE_SID/trace/alert_$ORACLE_SID.log'1696export PS1="[`whoami`@`hostname`:"'\w]$ '1697alias sqlplus='rlwrap sqlplus'1698alias rman='rlwrap rman'1699alias adrci='rlwrap adrci'170017011702#==============================================================# 1703Grid 用户环境变量 1704#==============================================================# 17051706if [ -f ~/.bashrc ]; then1707 . ~/.bashrc1708fi1709PATH=$PATH:$HOME/.local/bin:$HOME/bin1710export PATH1711umask 0221712export TMP=/tmp1713export TMPDIR=$TMP1714export NLS_LANG=AMERICAN_AMERICA.AL32UTF81715export ORACLE_BASE=/u01/app/grid1716export ORACLE_HOME=/u01/app/11.2.0/grid1717export ORACLE_TERM=xterm1718export TNS_ADMIN=$ORACLE_HOME/network/admin1719export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib1720export ORACLE_SID=+ASM41721export PATH=/usr/sbin:$PATH1722export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH1723alias sas='sqlplus / as sysasm'1724export PS1="[`whoami`@`hostname`:"'\w]$ '1725alias sqlplus='rlwrap sqlplus'1726alias asmcmd='rlwrap asmcmd'1727alias adrci='rlwrap adrci'172817291730#==============================================================# 1731配置时间同步 1732#==============================================================# 17331734Created symlink from /etc/systemd/system/multi-user.target.wants/ntpd.service to /usr/lib/systemd/system/ntpd.service.17351736#==============================================================# 1737NTP 检查 1738#==============================================================# 17391740 remote refid st t when poll reach delay offset jitter1741==============================================================================1742 202.112.10.36 .INIT. 16 u - 64 0 0.000 0.000 0.001174317441745#==============================================================# 1746多路径信息 1747#==============================================================# 17481749create: asm_ocr_1 (2d7490d9f98a4dd33) undef ROCKET ,IMAGEFILE 1750size=10G features='0' hwhandler='0' wp=undef1751`-+- policy='service-time 0' prio=1 status=undef1752 `- 33:0:0:0 sdb 8:16 undef ready running1753create: asm_ocr_2 (29d556de9c0521353) undef ROCKET ,IMAGEFILE 1754size=10G features='0' hwhandler='0' wp=undef1755`-+- policy='service-time 0' prio=1 status=undef1756 `- 33:0:0:1 sdc 8:32 undef ready running1757create: asm_ocr_3 (22a3d603188b7e7ac) undef ROCKET ,IMAGEFILE 1758size=10G features='0' hwhandler='0' wp=undef1759`-+- policy='service-time 0' prio=1 status=undef1760 `- 33:0:0:2 sdd 8:48 undef ready running1761create: asm_data_1 (2efbc650f3322eb34) undef ROCKET ,IMAGEFILE 1762size=50G features='0' hwhandler='0' wp=undef1763`-+- policy='service-time 0' prio=1 status=undef1764 `- 33:0:0:3 sde 8:64 undef ready running1765create: asm_data_2 (228a97913b281ad29) undef ROCKET ,IMAGEFILE 1766size=50G features='0' hwhandler='0' wp=undef1767`-+- policy='service-time 0' prio=1 status=undef1768 `- 33:0:0:4 sdf 8:80 undef ready running176917701771#==============================================================# 1772UDEV 配置文件 1773#==============================================================# 17741775KERNEL=="dm-*",ENV{DM_UUID}=="mpath-2d7490d9f98a4dd33",SYMLINK+="asm_ocr_1",OWNER="grid",GROUP="asmadmin",MODE="0660"1776KERNEL=="dm-*",ENV{DM_UUID}=="mpath-29d556de9c0521353",SYMLINK+="asm_ocr_2",OWNER="grid",GROUP="asmadmin",MODE="0660"1777KERNEL=="dm-*",ENV{DM_UUID}=="mpath-22a3d603188b7e7ac",SYMLINK+="asm_ocr_3",OWNER="grid",GROUP="asmadmin",MODE="0660"1778KERNEL=="dm-*",ENV{DM_UUID}=="mpath-2efbc650f3322eb34",SYMLINK+="asm_data_1",OWNER="grid",GROUP="asmadmin",MODE="0660"1779KERNEL=="dm-*",ENV{DM_UUID}=="mpath-228a97913b281ad29",SYMLINK+="asm_data_2",OWNER="grid",GROUP="asmadmin",MODE="0660"178017811782UDEV 已加载成功。 17831784#==============================================================# 1785ASM 磁盘信息 1786#==============================================================# 17871788/dev/asm_data_11789/dev/asm_data_21790/dev/asm_ocr_11791/dev/asm_ocr_21792/dev/asm_ocr_3179317941795配置 RAC 节点：192.168.6.34 结束! 17961797#==============================================================# 1798配置 RAC 节点：192.168.6.35 1799#==============================================================# 18001801正在节点：192.168.6.35 上执行脚本： 180218031804 ███████ ██ ████████ ██ ██ ██ ██ ██ ██ ██1805 ██░░░░░██ ░██ ██░░░░░░ ░██ ░██ ░██░██ ░██ ░██ ░██1806 ██ ░░██ ██████ ██████ █████ ░██ █████ ░██ ░██ █████ ░██ ░██░██ ███████ ██████ ██████ ██████ ░██ ░██1807░██ ░██░░██░░█ ░░░░░░██ ██░░░██ ░██ ██░░░██░█████████░██████ ██░░░██ ░██ ░██░██░░██░░░██ ██░░░░ ░░░██░ ░░░░░░██ ░██ ░██1808░██ ░██ ░██ ░ ███████ ░██ ░░ ░██░███████░░░░░░░░██░██░░░██░███████ ░██ ░██░██ ░██ ░██░░█████ ░██ ███████ ░██ ░██1809░░██ ██ ░██ ██░░░░██ ░██ ██ ░██░██░░░░ ░██░██ ░██░██░░░░ ░██ ░██░██ ░██ ░██ ░░░░░██ ░██ ██░░░░██ ░██ ░██1810 ░░███████ ░███ ░░████████░░█████ ███░░██████ ████████ ░██ ░██░░██████ ███ ███░██ ███ ░██ ██████ ░░██ ░░████████ ███ ███1811 ░░░░░░░ ░░░ ░░░░░░░░ ░░░░░ ░░░ ░░░░░░ ░░░░░░░░ ░░ ░░ ░░░░░░ ░░░ ░░░ ░░ ░░░ ░░ ░░░░░░ ░░ ░░░░░░░░ ░░░ ░░░ 18121813配置本地 YUM 源： 18141815[server]1816name=server1817baseurl=file:///mnt1818enabled=11819gpgcheck=018201821#==============================================================# 1822配置 SELinux 1823#==============================================================# 18241825SELINUX=disabled1826SELINUXTYPE=targeted 182718281829#==============================================================# 1830YUM 静默安装依赖包 1831#==============================================================# 18321833bc-1.06.95-13.el7.x86_641834binutils-2.27-43.base.el7.x86_641835compat-libcap1-1.10-7.el7.x86_641836package compat-libstdc++-33 is not installed1837gcc-4.8.5-39.el7.x86_641838gcc-c++-4.8.5-39.el7.x86_641839elfutils-libelf-0.176-4.el7.x86_641840elfutils-libelf-devel-0.176-4.el7.x86_641841glibc-2.17-307.el7.1.x86_641842glibc-devel-2.17-307.el7.1.x86_641843libaio-0.3.109-13.el7.x86_641844libaio-devel-0.3.109-13.el7.x86_641845libgcc-4.8.5-39.el7.x86_641846libstdc++-4.8.5-39.el7.x86_641847libstdc++-devel-4.8.5-39.el7.x86_641848libxcb-1.13-1.el7.x86_641849libX11-1.6.7-2.el7.x86_641850libXau-1.0.8-2.1.el7.x86_641851libXi-1.7.9-1.el7.x86_641852libXrender-0.9.10-1.el7.x86_641853make-3.82-24.el7.x86_641854net-tools-2.0-0.25.20131004git.el7.x86_641855smartmontools-7.0-2.el7.x86_641856sysstat-10.1.5-19.el7.x86_641857e2fsprogs-1.42.9-17.el7.x86_641858e2fsprogs-libs-1.42.9-17.el7.x86_641859unzip-6.0-21.el7.x86_641860openssh-clients-7.4p1-21.el7.x86_641861readline-6.2-11.el7.x86_641862readline-devel-6.2-11.el7.x86_641863psmisc-22.20-16.el7.x86_641864ksh-20120801-142.el7.x86_641865nfs-utils-1.3.0-0.66.el7.x86_641866tar-1.26-35.el7.x86_641867device-mapper-multipath-0.4.9-131.el7.x86_641868avahi-0.6.31-20.el7.x86_641869ntp-4.2.6p5-29.el7.x86_641870package chronyd is not installed1871libXtst-1.2.3-1.el7.x86_641872libXrender-devel-0.9.10-1.el7.x86_641873fontconfig-devel-2.13.0-4.3.el7.x86_641874policycoreutils-2.5-34.el7.x86_641875policycoreutils-python-2.5-34.el7.x86_641876package policycoreutils-python-utils) is not installed18771878#==============================================================# 1879配置主机名 1880#==============================================================# 18811882 Static hostname: luciferdb051883 Icon name: computer-vm1884 Chassis: vm1885 Machine ID: d5f34781900f43b78b5c2ace1e48e7a41886 Boot ID: efe84f48c36f462ea927df3638b4fb011887 Virtualization: vmware1888 Operating System: Red Hat Enterprise Linux Server 7.8 (Maipo)1889 CPE OS Name: cpe:/o:redhat:enterprise_linux:7.8:GA:server1890 Kernel: Linux 3.10.0-1127.el7.x86_641891 Architecture: x86-64189218931894#==============================================================# 1895配置 HOSTS 文件 1896#==============================================================# 18971898127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain41899::1 localhost localhost.localdomain localhost6 localhost6.localdomain619001901## OracleBegin19021903## RAC1 IP's: luciferdb0119041905## RAC1 Public IP1906192.168.6.31 luciferdb011907## RAC1 Virtual IP1908192.168.6.51 luciferdb01-vip1909## RAC1 Private IP19102.2.1.1 luciferdb01-priv19112.2.2.1 luciferdb01-priv119121913## RAC2 IP's: luciferdb0219141915## RAC2 Public IP1916192.168.6.32 luciferdb021917## RAC2 Virtual IP1918192.168.6.52 luciferdb02-vip1919## RAC2 Private IP19202.2.2.2 luciferdb02-priv19212.2.1.2 luciferdb02-priv119221923## RAC3 IP's: luciferdb0319241925## RAC3 Public IP1926192.168.6.33 luciferdb031927## RAC3 Virtual IP1928192.168.6.53 luciferdb03-vip1929## RAC3 Private IP19302.2.2.3 luciferdb03-priv19312.2.1.3 luciferdb03-priv119321933## RAC4 IP's: luciferdb0419341935## RAC4 Public IP1936192.168.6.34 luciferdb041937## RAC4 Virtual IP1938192.168.6.54 luciferdb04-vip1939## RAC4 Private IP19402.2.2.4 luciferdb04-priv19412.2.1.4 luciferdb04-priv119421943## RAC5 IP's: luciferdb0519441945## RAC5 Public IP1946192.168.6.35 luciferdb051947## RAC5 Virtual IP1948192.168.6.55 luciferdb05-vip1949## RAC5 Private IP19502.2.2.5 luciferdb05-priv19512.2.1.5 luciferdb05-priv119521953## SCAN IP1954192.168.6.50 luciferdb-scan195519561957#==============================================================# 1958创建用户和组 1959#==============================================================# 19601961uid=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)196219631964#==============================================================# 1965Avahi-daemon 状态 1966#==============================================================# 19671968● avahi-daemon.service - Avahi mDNS/DNS-SD Stack1969 Loaded: loaded (/usr/lib/systemd/system/avahi-daemon.service; disabled; vendor preset: enabled)1970 Active: inactive (dead)19711972May 04 05:51:18 lucifer05 avahi-daemon[845]: Joining mDNS multicast group on interface ens256.IPv4 with address 2.2.2.5.1973May 04 05:51:18 lucifer05 avahi-daemon[845]: New relevant interface ens256.IPv4 for mDNS.1974May 04 05:51:18 lucifer05 avahi-daemon[845]: Registering new address record for 2.2.2.5 on ens256.IPv4.1975May 04 06:02:04 luciferdb05 systemd[1]: Stopping Avahi mDNS/DNS-SD Stack...1976May 04 06:02:04 luciferdb05 avahi-daemon[845]: Got SIGTERM, quitting.1977May 04 06:02:04 luciferdb05 avahi-daemon[845]: Leaving mDNS multicast group on interface virbr0.IPv4 with address 192.168.122.1.1978May 04 06:02:04 luciferdb05 avahi-daemon[845]: Leaving mDNS multicast group on interface ens256.IPv4 with address 2.2.2.5.1979May 04 06:02:04 luciferdb05 avahi-daemon[845]: Leaving mDNS multicast group on interface ens224.IPv4 with address 2.2.1.5.1980May 04 06:02:04 luciferdb05 avahi-daemon[845]: Leaving mDNS multicast group on interface ens192.IPv4 with address 192.168.6.35.1981May 04 06:02:04 luciferdb05 systemd[1]: Stopped Avahi mDNS/DNS-SD Stack.198219831984#==============================================================# 1985配置透明大页 && NUMA && 磁盘 IO 调度器 1986#==============================================================# 19871988args="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"1989-rd.lvm.lv=rhel/root1990-args="ro1991args="ro rd.lvm.lv=rhel/root rd.lvm.lv=rhel/swap rhgb quiet numa=off transparent_hugepage=never elevator=deadline"1992-elevator=deadline"1993-transparent_hugepage=never199419951996#==============================================================# 1997配置 sysctl.conf 1998#==============================================================# 19992000fs.aio-max-nr = 10485762001fs.file-max = 68157442002kernel.shmall = 20971522003kernel.shmmax = 83700162552004kernel.shmmni = 40962005kernel.sem = 250 32000 100 1282006net.ipv4.ip_local_port_range = 9000 655002007net.core.rmem_default = 2621442008net.core.rmem_max = 41943042009net.core.wmem_default = 2621442010net.core.wmem_max = 10485762011vm.min_free_kbytes = 326952012net.ipv4.conf.ens192.rp_filter = 12013net.ipv4.conf.ens224.rp_filter = 22014net.ipv4.conf.ens256.rp_filter = 2201520162017#==============================================================# 2018配置 nsysctl.conf 2019#==============================================================# 20202021# Created by anaconda2022NOZEROCONF=yes202320242025#==============================================================# 2026配置 /etc/security/limits.conf 2027#==============================================================# 20282029oracle soft nofile 10242030oracle hard nofile 655362031oracle soft stack 102402032oracle hard stack 327682033oracle soft nproc 20472034oracle hard nproc 163842035oracle hard memlock unlimited2036oracle soft memlock unlimited2037grid soft nofile 10242038grid hard nofile 655362039grid soft stack 102402040grid hard stack 327682041grid soft nproc 20472042grid hard nproc 16384204320442045#==============================================================# 2046配置 /etc/pam.d/login 2047#==============================================================# 20482049auth [user_unknown=ignore success=ok ignore=ignore default=bad] pam_securetty.so2050auth substack system-auth2051auth include postlogin2052account required pam_nologin.so2053account include system-auth2054password include system-auth2055session required pam_selinux.so close2056session required pam_loginuid.so2057session optional pam_console.so2058session required pam_selinux.so open2059session required pam_namespace.so2060session optional pam_keyinit.so force revoke2061session include system-auth2062session include postlogin2063-session optional pam_ck_connector.so2064session required pam_limits.so2065session required /lib64/security/pam_limits.so206620672068#==============================================================# 2069配置 /dev/shm 2070#==============================================================# 20712072/dev/mapper/rhel-root / xfs defaults 0 02073UUID=0a1b3b00-847e-4d2f-86e5-22ccadd8b871 /boot xfs defaults 0 02074/dev/mapper/rhel-swap swap swap defaults 0 02075tmpfs /dev/shm tmpfs size=8173844k 0 0207620772078#==============================================================# 2079安装 rlwrap 2080#==============================================================# 208120822083成功安装 rlwrap： rlwrap 0.42 20842085#==============================================================# 2086Root 用户环境变量 2087#==============================================================# 20882089if [ -f ~/.bashrc ]; then2090 . ~/.bashrc2091fi2092PATH=$PATH:$HOME/bin2093export PATH2094alias so='su - oracle'2095export PS1="[`whoami`@`hostname`:"'\w]# '2096alias sg='su - grid'2097alias crsctl='/u01/app/11.2.0/grid/bin/crsctl'2098alias srvctl='/u01/app/11.2.0/grid/bin/srvctl'209921002101#==============================================================# 2102Oracle 用户环境变量 2103#==============================================================# 21042105if [ -f ~/.bashrc ]; then2106 . ~/.bashrc2107fi2108PATH=$PATH:$HOME/.local/bin:$HOME/bin2109export PATH2110umask 0222111export TMP=/tmp2112export TMPDIR=$TMP2113export NLS_LANG=AMERICAN_AMERICA.AL32UTF82114export ORACLE_BASE=/u01/app/oracle2115export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db2116export ORACLE_TERM=xterm2117export TNS_ADMIN=$ORACLE_HOME/network/admin2118export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib2119export ORACLE_SID=oradb52120export PATH=/usr/sbin:$PATH2121export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/perl/bin:$PATH2122export PERL5LIB=$ORACLE_HOME/perl/lib2123alias sas='sqlplus / as sysdba'2124alias awr='sqlplus / as sysdba @?/rdbms/admin/awrrpt'2125alias ash='sqlplus / as sysdba @?/rdbms/admin/ashrpt'2126alias alert='vi $ORACLE_BASE/diag/rdbms/*/$ORACLE_SID/trace/alert_$ORACLE_SID.log'2127export PS1="[`whoami`@`hostname`:"'\w]$ '2128alias sqlplus='rlwrap sqlplus'2129alias rman='rlwrap rman'2130alias adrci='rlwrap adrci'213121322133#==============================================================# 2134Grid 用户环境变量 2135#==============================================================# 21362137if [ -f ~/.bashrc ]; then2138 . ~/.bashrc2139fi2140PATH=$PATH:$HOME/.local/bin:$HOME/bin2141export PATH2142umask 0222143export TMP=/tmp2144export TMPDIR=$TMP2145export NLS_LANG=AMERICAN_AMERICA.AL32UTF82146export ORACLE_BASE=/u01/app/grid2147export ORACLE_HOME=/u01/app/11.2.0/grid2148export ORACLE_TERM=xterm2149export TNS_ADMIN=$ORACLE_HOME/network/admin2150export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib2151export ORACLE_SID=+ASM52152export PATH=/usr/sbin:$PATH2153export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH2154alias sas='sqlplus / as sysasm'2155export PS1="[`whoami`@`hostname`:"'\w]$ '2156alias sqlplus='rlwrap sqlplus'2157alias asmcmd='rlwrap asmcmd'2158alias adrci='rlwrap adrci'215921602161#==============================================================# 2162配置时间同步 2163#==============================================================# 21642165Removed symlink /etc/systemd/system/multi-user.target.wants/chronyd.service.2166Created symlink from /etc/systemd/system/multi-user.target.wants/ntpd.service to /usr/lib/systemd/system/ntpd.service.21672168#==============================================================# 2169NTP 检查 2170#==============================================================# 21712172 remote refid st t when poll reach delay offset jitter2173==============================================================================2174 202.112.10.36 .INIT. 16 u - 64 0 0.000 0.000 0.001217521762177#==============================================================# 2178多路径信息 2179#==============================================================# 21802181create: asm_ocr_1 (2d7490d9f98a4dd33) undef ROCKET ,IMAGEFILE 2182size=10G features='0' hwhandler='0' wp=undef2183`-+- policy='service-time 0' prio=1 status=undef2184 `- 33:0:0:0 sdb 8:16 undef ready running2185create: asm_ocr_2 (29d556de9c0521353) undef ROCKET ,IMAGEFILE 2186size=10G features='0' hwhandler='0' wp=undef2187`-+- policy='service-time 0' prio=1 status=undef2188 `- 33:0:0:1 sdc 8:32 undef ready running2189create: asm_ocr_3 (22a3d603188b7e7ac) undef ROCKET ,IMAGEFILE 2190size=10G features='0' hwhandler='0' wp=undef2191`-+- policy='service-time 0' prio=1 status=undef2192 `- 33:0:0:2 sdd 8:48 undef ready running2193create: asm_data_1 (2efbc650f3322eb34) undef ROCKET ,IMAGEFILE 2194size=50G features='0' hwhandler='0' wp=undef2195`-+- policy='service-time 0' prio=1 status=undef2196 `- 33:0:0:3 sde 8:64 undef ready running2197create: asm_data_2 (228a97913b281ad29) undef ROCKET ,IMAGEFILE 2198size=50G features='0' hwhandler='0' wp=undef2199`-+- policy='service-time 0' prio=1 status=undef2200 `- 33:0:0:4 sdf 8:80 undef ready running220122022203#==============================================================# 2204UDEV 配置文件 2205#==============================================================# 22062207KERNEL=="dm-*",ENV{DM_UUID}=="mpath-2d7490d9f98a4dd33",SYMLINK+="asm_ocr_1",OWNER="grid",GROUP="asmadmin",MODE="0660"2208KERNEL=="dm-*",ENV{DM_UUID}=="mpath-29d556de9c0521353",SYMLINK+="asm_ocr_2",OWNER="grid",GROUP="asmadmin",MODE="0660"2209KERNEL=="dm-*",ENV{DM_UUID}=="mpath-22a3d603188b7e7ac",SYMLINK+="asm_ocr_3",OWNER="grid",GROUP="asmadmin",MODE="0660"2210KERNEL=="dm-*",ENV{DM_UUID}=="mpath-2efbc650f3322eb34",SYMLINK+="asm_data_1",OWNER="grid",GROUP="asmadmin",MODE="0660"2211KERNEL=="dm-*",ENV{DM_UUID}=="mpath-228a97913b281ad29",SYMLINK+="asm_data_2",OWNER="grid",GROUP="asmadmin",MODE="0660"221222132214UDEV 已加载成功。 22152216#==============================================================# 2217ASM 磁盘信息 2218#==============================================================# 22192220/dev/asm_data_12221/dev/asm_data_22222/dev/asm_ocr_12223/dev/asm_ocr_22224/dev/asm_ocr_3222522262227配置 RAC 节点：192.168.6.35 结束! 22282229#==============================================================# 2230配置 GRID 用户互信 2231#==============================================================# 22322233Generating public/private rsa key pair.2234Your identification has been saved in /home/grid/.ssh/id_rsa.2235Your public key has been saved in /home/grid/.ssh/id_rsa.pub.2236The key fingerprint is:2237SHA256:2nlWBubEHZgtf808s3mX6I3a0/xoGIC2vs2D2dpfG6Q grid@luciferdb012238The key's randomart image is:2239+---[RSA 2048]----+2240| +. |2241| .+... |2242| .=o. + |2243| o+... .o+|2244| .S...o.o *|2245| o.. o.+ +o|2246| ..o+o EoB o|2247| +*o o=.B |2248| oo++oo+ o|2249+----[SHA256]-----+22502251#==============================================================# 2252配置 ORACLE 用户互信 2253#==============================================================# 22542255Generating public/private rsa key pair.2256Your identification has been saved in /home/oracle/.ssh/id_rsa.2257Your public key has been saved in /home/oracle/.ssh/id_rsa.pub.2258The key fingerprint is:2259SHA256:uxhnfWFXxiBZS6omQit8m6XFY/BCB8iRVIf6ybIisSc oracle@luciferdb012260The key's randomart image is:2261+---[RSA 2048]----+2262| oo=o.. .o+ |2263| + .o .+ + |2264| .+ . . . +|2265| ..o * . o |2266| oo=.S o o . |2267|. .o+X * . o |2268| o o= + . . |2269|E o . = . . |2270| + . . . |2271+----[SHA256]-----+22722273#==============================================================# 2274静默解压缩 Grid 软件包 2275#==============================================================# 22762277正在静默解压缩 Grid 软件包，请稍等： 227822792280.---- -. -. . . . .2281( .',----- - - ' ' ' __2282 \_/ ;--:- __--------------------___ ____=========_||___2283__U__n_^_''__[. ooo___ | |_!_||_!_||_!_||_!_| | |..|_i_|..|_i_|..|2284c(_ ..(_ ..(_ ..( /,,,,,,] | |___||___||___||___| | | |2285,_\___________'_|,L______],|______________________|_i,!________________!_i2286/;_(@)(@)==(@)(@) (o)(o) (o)^(o)--(o)^(o) (o)(o)-(o)(o)2287""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"'""228822892290静默解压 Grid 软件安装包： /soft/p13390677_112040_Linux-x86-64_3of7.zip 22912292静默解压 Grid 软件补丁包： /soft/p31718723*.zip 22932294安装 cvu 软件： 22952296Preparing... ################################# [100%]2297Using default group oinstall to install package2298Updating / installing...2299 1:cvuqdisk-1.0.9-1 ################################# [100%]2300Preparing... ########################################2301Using default group oinstall to install package2302Updating / installing...2303cvuqdisk-1.0.9-1 ########################################2304Preparing... ########################################2305Using default group oinstall to install package2306Updating / installing...2307cvuqdisk-1.0.9-1 ########################################2308Preparing... ########################################2309Using default group oinstall to install package2310Updating / installing...2311cvuqdisk-1.0.9-1 ########################################2312Preparing... ########################################2313Using default group oinstall to install package2314Updating / installing...2315cvuqdisk-1.0.9-1 ########################################23162317#==============================================================# 2318静默解压 Oracle 软件包 2319#==============================================================# 23202321正在静默解压缩 Oracle 软件包，请稍等： 232223232324.---- -. -. . . . .2325( .',----- - - ' ' ' __2326 \_/ ;--:- __--------------------___ ____=========_||___2327__U__n_^_''__[. ooo___ | |_!_||_!_||_!_||_!_| | |..|_i_|..|_i_|..|2328c(_ ..(_ ..(_ ..( /,,,,,,] | |___||___||___||___| | | |2329,_\___________'_|,L______],|______________________|_i,!________________!_i2330/;_(@)(@)==(@)(@) (o)(o) (o)^(o)--(o)^(o) (o)(o)-(o)(o)2331""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"'""233223332334静默解压 Oracle 软件安装包： /soft/p13390677_112040_Linux-x86-64_1of7.zip,/soft/p13390677_112040_Linux-x86-64_2of7.zip 23352336静默解压 OJVM 软件补丁包： /soft/p31668908*.zip 23372338#==============================================================# 2339Grid 安装静默文件 2340#==============================================================# 23412342INVENTORY_LOCATION=/u01/app/oraInventory2343oracle.install.option=CRS_CONFIG2344ORACLE_BASE=/u01/app/grid2345oracle.install.asm.OSDBA=asmdba2346oracle.install.asm.OSOPER=asmoper2347oracle.install.asm.OSASM=asmadmin2348oracle.install.crs.config.gpnp.scanName=luciferdb-scan2349oracle.install.crs.config.gpnp.scanPort=15212350oracle.install.crs.config.clusterName=luciferdb-cls2351oracle.install.crs.config.gpnp.configureGNS=false2352oracle.install.crs.config.clusterNodes=luciferdb01:luciferdb01-vip,luciferdb02:luciferdb02-vip,luciferdb03:luciferdb03-vip,luciferdb04:luciferdb04-vip,luciferdb05:luciferdb05-vip2353oracle.install.crs.config.networkInterfaceList=ens192:192.168.6.0:1,ens224:2.2.1.0:2,ens256:2.2.2.0:22354oracle.install.crs.config.useIPMI=false2355oracle.install.asm.SYSASMPassword=oracle2356oracle.install.asm.diskGroup.name=OCR2357oracle.install.asm.diskGroup.redundancy=EXTERNAL2358oracle.install.asm.diskGroup.disks=/dev/asm_ocr_1,/dev/asm_ocr_2,/dev/asm_ocr_32359oracle.install.asm.diskGroup.diskDiscoveryString=/dev/asm*2360oracle.install.asm.monitorPassword=oracle2361oracle.install.responseFileVersion=/oracle/install/rspfmt_crsinstall_response_schema_v11_2_02362SELECTED_LANGUAGES=en2363ORACLE_HOME=/u01/app/11.2.0/grid2364oracle.install.crs.config.storageOption=ASM_STORAGE2365oracle.install.asm.diskGroup.AUSize=12366oracle.installer.autoupdates.option=SKIP_UPDATES236723682369#==============================================================# 2370静默安装 Grid 软件 2371#==============================================================# 23722373Starting Oracle Universal Installer...23742375Checking Temp space: must be greater than 120 MB. Actual 75921 MB Passed2376Checking swap space: must be greater than 150 MB. Actual 8191 MB Passed2377Preparing to launch Oracle Universal Installer from /tmp/OraInstall2023-05-04_06-10-42PM. Please wait ...[WARNING] [INS-30011] The SYS password entered does not conform to the Oracle recommended standards.2378 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].2379 ACTION: Provide a password that conforms to the Oracle recommended standards.2380[WARNING] [INS-30011] The ASMSNMP password entered does not conform to the Oracle recommended standards.2381 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].2382 ACTION: Provide a password that conforms to the Oracle recommended standards.2383You can find the log of this install session at:2384 /u01/app/oraInventory/logs/installActions2023-05-04_06-10-42PM.log23852386Prepare in progress.2387.................................................. 9% Done.23882389Prepare successful.23902391Copy files in progress.2392.................................................. 15% Done.2393.................................................. 20% Done.2394.................................................. 25% Done.2395.................................................. 30% Done.2396.................................................. 35% Done.2397.................................................. 40% Done.2398.................................................. 45% Done.2399........................................2400Copy files successful.24012402Link binaries in progress.24032404Link binaries successful.2405.................................................. 62% Done.24062407Setup files in progress.24082409Setup files successful.2410.................................................. 76% Done.24112412Perform remote operations in progress.2413.................................................. 89% Done.24142415Perform remote operations successful.2416The installation of Oracle Grid Infrastructure 11g was successful.2417Please check '/u01/app/oraInventory/logs/silentInstall2023-05-04_06-10-42PM.log' for more details.2418.................................................. 94% Done.24192420Execute Root Scripts in progress.24212422As a root user, execute the following script(s):2423 1. /u01/app/oraInventory/orainstRoot.sh2424 2. /u01/app/11.2.0/grid/root.sh24252426Execute /u01/app/oraInventory/orainstRoot.sh on the following nodes: 2427[luciferdb01, luciferdb02, luciferdb03, luciferdb04, luciferdb05]2428Execute /u01/app/11.2.0/grid/root.sh on the following nodes: 2429[luciferdb01, luciferdb02, luciferdb03, luciferdb04, luciferdb05]24302431.................................................. 100% Done.24322433Execute Root Scripts successful.2434As install user, execute the following script to complete the configuration.2435 1. /u01/app/11.2.0/grid/cfgtoollogs/configToolAllCommands RESPONSE_FILE=<response_file>24362437 Note:2438 1. This script must be run on the same host from where installer was run. 2439 2. This script needs a small password properties file for configuration assistants that require passwords (refer to install guide documentation).244024412442Successfully Setup Software.24432444#==============================================================# 2445静默安装 18370031 补丁 2446#==============================================================# 24472448节点 192.168.6.31 ： 24492450Oracle Interim Patch Installer version 11.2.0.3.42451Copyright (c) 2012, Oracle Corporation. All rights reserved.245224532454Oracle Home : /u01/app/11.2.0/grid2455Central Inventory : /u01/app/oraInventory2456 from : /u01/app/11.2.0/grid/oraInst.loc2457OPatch version : 11.2.0.3.42458OUI version : 11.2.0.4.02459Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2023-05-04_18-22-58PM_1.log24602461Verifying environment and performing prerequisite checks...2462OPatch continues with these patches: 18370031 24632464Do you want to proceed? [y|n]2465Y (auto-answered by -silent)2466User Responded with: Y2467All checks passed.24682469Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.2470(Oracle Home = '/u01/app/11.2.0/grid')247124722473Is the local system ready for patching? [y|n]2474Y (auto-answered by -silent)2475User Responded with: Y2476Backing up files...2477Applying interim patch '18370031' to OH '/u01/app/11.2.0/grid'24782479Patching component oracle.crs, 11.2.0.4.0...24802481Verifying the update...2482Patch 18370031 successfully applied.2483Log file location: /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2023-05-04_18-22-58PM_1.log24842485OPatch succeeded.24862487节点 192.168.6.32 ： 24882489Oracle Interim Patch Installer version 11.2.0.3.42490Copyright (c) 2012, Oracle Corporation. All rights reserved.249124922493Oracle Home : /u01/app/11.2.0/grid2494Central Inventory : /u01/app/oraInventory2495 from : /u01/app/11.2.0/grid/oraInst.loc2496OPatch version : 11.2.0.3.42497OUI version : 11.2.0.4.02498Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2023-05-04_18-24-05PM_1.log24992500Verifying environment and performing prerequisite checks...2501OPatch continues with these patches: 18370031 25022503Do you want to proceed? [y|n]2504Y (auto-answered by -silent)2505User Responded with: Y2506All checks passed.25072508Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.2509(Oracle Home = '/u01/app/11.2.0/grid')251025112512Is the local system ready for patching? [y|n]2513Y (auto-answered by -silent)2514User Responded with: Y2515Backing up files...2516Applying interim patch '18370031' to OH '/u01/app/11.2.0/grid'25172518Patching component oracle.crs, 11.2.0.4.0...25192520Verifying the update...2521Patch 18370031 successfully applied.2522Log file location: /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2023-05-04_18-24-05PM_1.log25232524OPatch succeeded.25252526节点 192.168.6.33 ： 25272528Oracle Interim Patch Installer version 11.2.0.3.42529Copyright (c) 2012, Oracle Corporation. All rights reserved.253025312532Oracle Home : /u01/app/11.2.0/grid2533Central Inventory : /u01/app/oraInventory2534 from : /u01/app/11.2.0/grid/oraInst.loc2535OPatch version : 11.2.0.3.42536OUI version : 11.2.0.4.02537Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2023-05-04_18-25-15PM_1.log25382539Verifying environment and performing prerequisite checks...2540OPatch continues with these patches: 18370031 25412542Do you want to proceed? [y|n]2543Y (auto-answered by -silent)2544User Responded with: Y2545All checks passed.25462547Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.2548(Oracle Home = '/u01/app/11.2.0/grid')254925502551Is the local system ready for patching? [y|n]2552Y (auto-answered by -silent)2553User Responded with: Y2554Backing up files...2555Applying interim patch '18370031' to OH '/u01/app/11.2.0/grid'25562557Patching component oracle.crs, 11.2.0.4.0...25582559Verifying the update...2560Patch 18370031 successfully applied.2561Log file location: /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2023-05-04_18-25-15PM_1.log25622563OPatch succeeded.25642565节点 192.168.6.34 ： 25662567Oracle Interim Patch Installer version 11.2.0.3.42568Copyright (c) 2012, Oracle Corporation. All rights reserved.256925702571Oracle Home : /u01/app/11.2.0/grid2572Central Inventory : /u01/app/oraInventory2573 from : /u01/app/11.2.0/grid/oraInst.loc2574OPatch version : 11.2.0.3.42575OUI version : 11.2.0.4.02576Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2023-05-04_18-26-15PM_1.log25772578Verifying environment and performing prerequisite checks...2579OPatch continues with these patches: 18370031 25802581Do you want to proceed? [y|n]2582Y (auto-answered by -silent)2583User Responded with: Y2584All checks passed.25852586Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.2587(Oracle Home = '/u01/app/11.2.0/grid')258825892590Is the local system ready for patching? [y|n]2591Y (auto-answered by -silent)2592User Responded with: Y2593Backing up files...2594Applying interim patch '18370031' to OH '/u01/app/11.2.0/grid'25952596Patching component oracle.crs, 11.2.0.4.0...25972598Verifying the update...2599Patch 18370031 successfully applied.2600Log file location: /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2023-05-04_18-26-15PM_1.log26012602OPatch succeeded.26032604节点 192.168.6.35 ： 26052606Oracle Interim Patch Installer version 11.2.0.3.42607Copyright (c) 2012, Oracle Corporation. All rights reserved.260826092610Oracle Home : /u01/app/11.2.0/grid2611Central Inventory : /u01/app/oraInventory2612 from : /u01/app/11.2.0/grid/oraInst.loc2613OPatch version : 11.2.0.3.42614OUI version : 11.2.0.4.02615Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2023-05-04_06-27-13AM_1.log26162617Verifying environment and performing prerequisite checks...2618OPatch continues with these patches: 18370031 26192620Do you want to proceed? [y|n]2621Y (auto-answered by -silent)2622User Responded with: Y2623All checks passed.26242625Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.2626(Oracle Home = '/u01/app/11.2.0/grid')262726282629Is the local system ready for patching? [y|n]2630Y (auto-answered by -silent)2631User Responded with: Y2632Backing up files...2633Applying interim patch '18370031' to OH '/u01/app/11.2.0/grid'26342635Patching component oracle.crs, 11.2.0.4.0...26362637Verifying the update...2638Patch 18370031 successfully applied.2639Log file location: /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2023-05-04_06-27-13AM_1.log26402641OPatch succeeded.26422643#==============================================================# 2644Grid 执行 root 脚本 2645#==============================================================# 26462647节点 192.168.6.31 ： 26482649Changing permissions of /u01/app/oraInventory.2650Adding read,write permissions for group.2651Removing read,write,execute permissions for world.26522653Changing groupname of /u01/app/oraInventory to oinstall.2654The execution of the script is complete.2655Check /u01/app/11.2.0/grid/install/root_luciferdb01_2023-05-04_18-28-02.log for the output of root script26562657节点 192.168.6.32 ： 26582659Changing permissions of /u01/app/oraInventory.2660Adding read,write permissions for group.2661Removing read,write,execute permissions for world.26622663Changing groupname of /u01/app/oraInventory to oinstall.2664The execution of the script is complete.2665Check /u01/app/11.2.0/grid/install/root_luciferdb02_2023-05-04_18-35-03.log for the output of root script26662667节点 192.168.6.33 ： 26682669Changing permissions of /u01/app/oraInventory.2670Adding read,write permissions for group.2671Removing read,write,execute permissions for world.26722673Changing groupname of /u01/app/oraInventory to oinstall.2674The execution of the script is complete.2675Check /u01/app/11.2.0/grid/install/root_luciferdb03_2023-05-04_18-40-07.log for the output of root script26762677节点 192.168.6.34 ： 26782679Changing permissions of /u01/app/oraInventory.2680Adding read,write permissions for group.2681Removing read,write,execute permissions for world.26822683Changing groupname of /u01/app/oraInventory to oinstall.2684The execution of the script is complete.2685Check /u01/app/11.2.0/grid/install/root_luciferdb04_2023-05-04_18-45-15.log for the output of root script26862687节点 192.168.6.35 ： 26882689Changing permissions of /u01/app/oraInventory.2690Adding read,write permissions for group.2691Removing read,write,execute permissions for world.26922693Changing groupname of /u01/app/oraInventory to oinstall.2694The execution of the script is complete.2695Check /u01/app/11.2.0/grid/install/root_luciferdb05_2023-05-04_06-50-21.log for the output of root script26962697#==============================================================# 2698Grid 软件安装补丁 2699#==============================================================# 27002701节点 192.168.6.31 ： 27022703Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /soft -patchn 31718723 -oh /u01/app/11.2.0/grid -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params27042705This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2023-05-04_19-00-25.log27062707This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:2708/u01/app/11.2.0/grid/cfgtoollogs/opatchauto2023-05-04_19-00-25.report.log270927102023-05-04 19:00:25: Starting Clusterware Patch Setup2711Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params27122713Stopping CRS...2714Stopped CRS successfully27152716patch /soft/31718723/29938455 apply successful for home /u01/app/11.2.0/grid 2717patch /soft/31718723/31537677 apply successful for home /u01/app/11.2.0/grid 2718patch /soft/31718723/29509309 apply successful for home /u01/app/11.2.0/grid 27192720Starting CRS...2721Installing Trace File Analyzer2722CRS-4123: Oracle High Availability Services has been started.27232724opatch auto succeeded.27252726节点 192.168.6.32 ： 27272728Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /soft -patchn 31718723 -oh /u01/app/11.2.0/grid -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params27292730This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2023-05-04_19-12-35.log27312732This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:2733/u01/app/11.2.0/grid/cfgtoollogs/opatchauto2023-05-04_19-12-35.report.log273427352023-05-04 19:12:35: Starting Clusterware Patch Setup2736Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params27372738Stopping CRS...2739Stopped CRS successfully27402741patch /soft/31718723/29938455 apply successful for home /u01/app/11.2.0/grid 2742patch /soft/31718723/31537677 apply successful for home /u01/app/11.2.0/grid 2743patch /soft/31718723/29509309 apply successful for home /u01/app/11.2.0/grid 27442745Starting CRS...2746Installing Trace File Analyzer2747CRS-4123: Oracle High Availability Services has been started.27482749opatch auto succeeded.27502751节点 192.168.6.33 ： 27522753Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /soft -patchn 31718723 -oh /u01/app/11.2.0/grid -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params27542755This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2023-05-04_19-24-16.log27562757This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:2758/u01/app/11.2.0/grid/cfgtoollogs/opatchauto2023-05-04_19-24-16.report.log275927602023-05-04 19:24:16: Starting Clusterware Patch Setup2761Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params27622763Stopping CRS...2764Stopped CRS successfully27652766patch /soft/31718723/29938455 apply successful for home /u01/app/11.2.0/grid 2767patch /soft/31718723/31537677 apply successful for home /u01/app/11.2.0/grid 2768patch /soft/31718723/29509309 apply successful for home /u01/app/11.2.0/grid 27692770Starting CRS...2771Installing Trace File Analyzer2772CRS-4123: Oracle High Availability Services has been started.27732774opatch auto succeeded.27752776节点 192.168.6.34 ： 27772778Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /soft -patchn 31718723 -oh /u01/app/11.2.0/grid -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params27792780This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2023-05-04_19-36-11.log27812782This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:2783/u01/app/11.2.0/grid/cfgtoollogs/opatchauto2023-05-04_19-36-11.report.log278427852023-05-04 19:36:11: Starting Clusterware Patch Setup2786Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params27872788Stopping CRS...2789Stopped CRS successfully27902791patch /soft/31718723/29938455 apply successful for home /u01/app/11.2.0/grid 2792patch /soft/31718723/31537677 apply successful for home /u01/app/11.2.0/grid 2793patch /soft/31718723/29509309 apply successful for home /u01/app/11.2.0/grid 27942795Starting CRS...2796Installing Trace File Analyzer2797CRS-4123: Oracle High Availability Services has been started.27982799opatch auto succeeded.28002801节点 192.168.6.35 ： 28022803Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /soft -patchn 31718723 -oh /u01/app/11.2.0/grid -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params28042805This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2023-05-04_07-47-50.log28062807This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:2808/u01/app/11.2.0/grid/cfgtoollogs/opatchauto2023-05-04_07-47-50.report.log280928102023-05-04 07:47:50: Starting Clusterware Patch Setup2811Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params28122813Stopping CRS...2814Stopped CRS successfully28152816patch /soft/31718723/29938455 apply successful for home /u01/app/11.2.0/grid 2817patch /soft/31718723/31537677 apply successful for home /u01/app/11.2.0/grid 2818patch /soft/31718723/29509309 apply successful for home /u01/app/11.2.0/grid 28192820Starting CRS...2821Installing Trace File Analyzer2822CRS-4123: Oracle High Availability Services has been started.28232824opatch auto succeeded.28252826#==============================================================# 2827Grid 软件版本 2828#==============================================================# 282928302831SQL*Plus: Release 11.2.0.4.0 Production283228332834#==============================================================# 2835Grid 补丁信息 2836#==============================================================# 2837283829509309;ACFS Patch Set Update : 11.2.0.4.190716 (29509309)283931537677;Database Patch Set Update : 11.2.0.4.201020 (31537677)284029938455;OCW Patch Set Update : 11.2.0.4.191015 (29938455)28412842OPatch succeeded.284328442845#==============================================================# 2846ASM磁盘组创建 2847#==============================================================# 284828492850Disk Group DATA created successfully.28512852State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name2853MOUNTED EXTERN N 512 4096 1048576 102400 102176 0 102176 0 N DATA/2854MOUNTED EXTERN N 512 4096 1048576 30720 30193 0 30193 0 Y OCR/28552856#==============================================================# 2857Oracle 安装静默文件 2858#==============================================================# 28592860oracle.install.option=INSTALL_DB_SWONLY2861UNIX_GROUP_NAME=oinstall2862INVENTORY_LOCATION=/u01/app/oraInventory2863ORACLE_BASE=/u01/app/oracle2864oracle.install.db.InstallEdition=EE2865oracle.install.db.DBA_GROUP=dba2866oracle.install.db.OPER_GROUP=oper2867oracle.install.db.CLUSTER_NODES=luciferdb01,luciferdb02,luciferdb03,luciferdb04,luciferdb052868oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_02869SELECTED_LANGUAGES=en,zh_CN2870ORACLE_HOME=/u01/app/oracle/product/11.2.0/db2871DECLINE_SECURITY_UPDATES=true2872oracle.installer.autoupdates.option=SKIP_UPDATES287328742875#==============================================================# 2876静默安装数据库软件 2877#==============================================================# 28782879Starting Oracle Universal Installer...28802881Checking Temp space: must be greater than 120 MB. Actual 66476 MB Passed2882Checking swap space: must be greater than 150 MB. Actual 8184 MB Passed2883Preparing to launch Oracle Universal Installer from /tmp/OraInstall2023-05-04_07-59-59PM. Please wait ...You can find the log of this install session at:2884 /u01/app/oraInventory/logs/installActions2023-05-04_07-59-59PM.log28852886Prepare in progress.2887.................................................. 9% Done.28882889Prepare successful.28902891Copy files in progress.2892.................................................. 14% Done.2893.................................................. 19% Done.2894.................................................. 25% Done.2895.................................................. 30% Done.2896.................................................. 36% Done.2897.................................................. 41% Done.2898.................................................. 46% Done.2899.................................................. 51% Done.2900.................................................. 56% Done.29012902Copy files successful.2903..........2904Link binaries in progress.29052906Link binaries successful.2907.................................................. 77% Done.29082909Setup files in progress.2910.................................................. 94% Done.29112912Setup files successful.2913The installation of Oracle Database 11g was successful.2914Please check '/u01/app/oraInventory/logs/silentInstall2023-05-04_07-59-59PM.log' for more details.29152916Execute Root Scripts in progress.29172918As a root user, execute the following script(s):2919 1. /u01/app/oracle/product/11.2.0/db/root.sh29202921Execute /u01/app/oracle/product/11.2.0/db/root.sh on the following nodes: 2922[luciferdb01, luciferdb02, luciferdb03, luciferdb04, luciferdb05]29232924.................................................. 100% Done.29252926Execute Root Scripts successful.2927Successfully Setup Software.29282929#==============================================================# 2930Oracle 执行 root 脚本 2931#==============================================================# 29322933节点 192.168.6.31 ： 29342935Changing permissions of /u01/app/oraInventory.2936Adding read,write permissions for group.2937Removing read,write,execute permissions for world.29382939Changing groupname of /u01/app/oraInventory to oinstall.2940The execution of the script is complete.2941Check /u01/app/oracle/product/11.2.0/db/install/root_luciferdb01_2023-05-04_20-16-36.log for the output of root script29422943节点 192.168.6.32 ： 29442945Changing permissions of /u01/app/oraInventory.2946Adding read,write permissions for group.2947Removing read,write,execute permissions for world.29482949Changing groupname of /u01/app/oraInventory to oinstall.2950The execution of the script is complete.2951Check /u01/app/oracle/product/11.2.0/db/install/root_luciferdb02_2023-05-04_20-16-37.log for the output of root script29522953节点 192.168.6.33 ： 29542955Changing permissions of /u01/app/oraInventory.2956Adding read,write permissions for group.2957Removing read,write,execute permissions for world.29582959Changing groupname of /u01/app/oraInventory to oinstall.2960The execution of the script is complete.2961Check /u01/app/oracle/product/11.2.0/db/install/root_luciferdb03_2023-05-04_20-16-39.log for the output of root script29622963节点 192.168.6.34 ： 29642965Changing permissions of /u01/app/oraInventory.2966Adding read,write permissions for group.2967Removing read,write,execute permissions for world.29682969Changing groupname of /u01/app/oraInventory to oinstall.2970The execution of the script is complete.2971Check /u01/app/oracle/product/11.2.0/db/install/root_luciferdb04_2023-05-04_20-16-40.log for the output of root script29722973节点 192.168.6.35 ： 29742975Changing permissions of /u01/app/oraInventory.2976Adding read,write permissions for group.2977Removing read,write,execute permissions for world.29782979Changing groupname of /u01/app/oraInventory to oinstall.2980The execution of the script is complete.2981Check /u01/app/oracle/product/11.2.0/db/install/root_luciferdb05_2023-05-04_08-16-41.log for the output of root script29822983#==============================================================# 2984Oracle 软件安装补丁 2985#==============================================================# 29862987节点 192.168.6.31 ： 29882989Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/oracle/product/11.2.0/db/OPatch/crs/patch11203.pl -patchdir /soft -patchn 31718723 -oh /u01/app/oracle/product/11.2.0/db -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params29902991This is the main log file: /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatchauto2023-05-04_20-17-26.log29922993This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:2994/u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatchauto2023-05-04_20-17-26.report.log299529962023-05-04 20:17:26: Starting Clusterware Patch Setup2997Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params29982999Stopping RAC /u01/app/oracle/product/11.2.0/db ...3000Stopped RAC /u01/app/oracle/product/11.2.0/db successfully30013002patch /soft/31718723/29938455/custom/server/29938455 apply successful for home /u01/app/oracle/product/11.2.0/db 3003patch /soft/31718723/31537677 apply successful for home /u01/app/oracle/product/11.2.0/db 30043005Starting RAC /u01/app/oracle/product/11.2.0/db ...3006Started RAC /u01/app/oracle/product/11.2.0/db successfully30073008opatch auto succeeded.30093010节点 192.168.6.32 ： 30113012Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/oracle/product/11.2.0/db/OPatch/crs/patch11203.pl -patchdir /soft -patchn 31718723 -oh /u01/app/oracle/product/11.2.0/db -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params30133014This is the main log file: /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatchauto2023-05-04_20-25-51.log30153016This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:3017/u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatchauto2023-05-04_20-25-51.report.log301830192023-05-04 20:25:51: Starting Clusterware Patch Setup3020Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params30213022Stopping RAC /u01/app/oracle/product/11.2.0/db ...3023Stopped RAC /u01/app/oracle/product/11.2.0/db successfully30243025patch /soft/31718723/29938455/custom/server/29938455 apply successful for home /u01/app/oracle/product/11.2.0/db 3026patch /soft/31718723/31537677 apply successful for home /u01/app/oracle/product/11.2.0/db 30273028Starting RAC /u01/app/oracle/product/11.2.0/db ...3029Started RAC /u01/app/oracle/product/11.2.0/db successfully30303031opatch auto succeeded.30323033节点 192.168.6.33 ： 30343035Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/oracle/product/11.2.0/db/OPatch/crs/patch11203.pl -patchdir /soft -patchn 31718723 -oh /u01/app/oracle/product/11.2.0/db -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params30363037This is the main log file: /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatchauto2023-05-04_20-32-42.log30383039This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:3040/u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatchauto2023-05-04_20-32-42.report.log304130422023-05-04 20:32:42: Starting Clusterware Patch Setup3043Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params30443045Stopping RAC /u01/app/oracle/product/11.2.0/db ...3046Stopped RAC /u01/app/oracle/product/11.2.0/db successfully30473048patch /soft/31718723/29938455/custom/server/29938455 apply successful for home /u01/app/oracle/product/11.2.0/db 3049patch /soft/31718723/31537677 apply successful for home /u01/app/oracle/product/11.2.0/db 30503051Starting RAC /u01/app/oracle/product/11.2.0/db ...3052Started RAC /u01/app/oracle/product/11.2.0/db successfully30533054opatch auto succeeded.30553056节点 192.168.6.34 ： 30573058Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/oracle/product/11.2.0/db/OPatch/crs/patch11203.pl -patchdir /soft -patchn 31718723 -oh /u01/app/oracle/product/11.2.0/db -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params30593060This is the main log file: /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatchauto2023-05-04_20-39-17.log30613062This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:3063/u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatchauto2023-05-04_20-39-17.report.log306430652023-05-04 20:39:17: Starting Clusterware Patch Setup3066Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params30673068Stopping RAC /u01/app/oracle/product/11.2.0/db ...3069Stopped RAC /u01/app/oracle/product/11.2.0/db successfully30703071patch /soft/31718723/29938455/custom/server/29938455 apply successful for home /u01/app/oracle/product/11.2.0/db 3072patch /soft/31718723/31537677 apply successful for home /u01/app/oracle/product/11.2.0/db 30733074Starting RAC /u01/app/oracle/product/11.2.0/db ...3075Started RAC /u01/app/oracle/product/11.2.0/db successfully30763077opatch auto succeeded.30783079节点 192.168.6.35 ： 30803081Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/oracle/product/11.2.0/db/OPatch/crs/patch11203.pl -patchdir /soft -patchn 31718723 -oh /u01/app/oracle/product/11.2.0/db -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params30823083This is the main log file: /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatchauto2023-05-04_08-45-36.log30843085This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:3086/u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatchauto2023-05-04_08-45-36.report.log308730882023-05-04 08:45:36: Starting Clusterware Patch Setup3089Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params30903091Stopping RAC /u01/app/oracle/product/11.2.0/db ...3092Stopped RAC /u01/app/oracle/product/11.2.0/db successfully30933094patch /soft/31718723/29938455/custom/server/29938455 apply successful for home /u01/app/oracle/product/11.2.0/db 3095patch /soft/31718723/31537677 apply successful for home /u01/app/oracle/product/11.2.0/db 30963097Starting RAC /u01/app/oracle/product/11.2.0/db ...3098Started RAC /u01/app/oracle/product/11.2.0/db successfully30993100opatch auto succeeded.31013102#==============================================================# 3103OJVM 补丁安装 3104#==============================================================# 31053106节点 192.168.6.31 ： 31073108Oracle Interim Patch Installer version 11.2.0.3.313109Copyright (c) 2023, Oracle Corporation. All rights reserved.31103111PREREQ session31123113Oracle Home : /u01/app/oracle/product/11.2.0/db3114Central Inventory : /u01/app/oraInventory3115 from : /u01/app/oracle/product/11.2.0/db/oraInst.loc3116OPatch version : 11.2.0.3.313117OUI version : 11.2.0.4.03118Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2023-05-04_20-52-29PM_1.log31193120Invoking prereq "checkconflictagainstohwithdetail"31213122Prereq "checkConflictAgainstOHWithDetail" passed.31233124OPatch succeeded.3125Oracle Interim Patch Installer version 11.2.0.3.313126Copyright (c) 2023, Oracle Corporation. All rights reserved.312731283129Oracle Home : /u01/app/oracle/product/11.2.0/db3130Central Inventory : /u01/app/oraInventory3131 from : /u01/app/oracle/product/11.2.0/db/oraInst.loc3132OPatch version : 11.2.0.3.313133OUI version : 11.2.0.4.03134Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2023-05-04_20-52-32PM_1.log31353136Verifying environment and performing prerequisite checks...3137OPatch continues with these patches: 31668908 31383139Do you want to proceed? [y|n]3140Y (auto-answered by -silent)3141User Responded with: Y3142All checks passed.31433144Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.3145(Oracle Home = '/u01/app/oracle/product/11.2.0/db')314631473148Is the local system ready for patching? [y|n]3149Y (auto-answered by -silent)3150User Responded with: Y3151Backing up files...3152Applying interim patch '31668908' to OH '/u01/app/oracle/product/11.2.0/db'3153ApplySession: Optional component(s) [ oracle.sqlj, 11.2.0.4.0 ] , [ oracle.sqlj.companion, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.31543155Patching component oracle.javavm.server, 11.2.0.4.0...31563157Patching component oracle.precomp.common, 11.2.0.4.0...31583159Patching component oracle.rdbms, 11.2.0.4.0...31603161Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...31623163Patching component oracle.javavm.client, 11.2.0.4.0...31643165Patching component oracle.dbjava.jdbc, 11.2.0.4.0...31663167Patching component oracle.dbjava.ic, 11.2.0.4.0...3168Patch 31668908 successfully applied.3169Log file location: /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2023-05-04_20-52-32PM_1.log31703171OPatch succeeded.31723173节点 192.168.6.32 ： 31743175Oracle Interim Patch Installer version 11.2.0.3.313176Copyright (c) 2023, Oracle Corporation. All rights reserved.31773178PREREQ session31793180Oracle Home : /u01/app/oracle/product/11.2.0/db3181Central Inventory : /u01/app/oraInventory3182 from : /u01/app/oracle/product/11.2.0/db/oraInst.loc3183OPatch version : 11.2.0.3.313184OUI version : 11.2.0.4.03185Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2023-05-04_20-53-08PM_1.log31863187Invoking prereq "checkconflictagainstohwithdetail"31883189Prereq "checkConflictAgainstOHWithDetail" passed.31903191OPatch succeeded.3192Oracle Interim Patch Installer version 11.2.0.3.313193Copyright (c) 2023, Oracle Corporation. All rights reserved.319431953196Oracle Home : /u01/app/oracle/product/11.2.0/db3197Central Inventory : /u01/app/oraInventory3198 from : /u01/app/oracle/product/11.2.0/db/oraInst.loc3199OPatch version : 11.2.0.3.313200OUI version : 11.2.0.4.03201Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2023-05-04_20-53-10PM_1.log32023203Verifying environment and performing prerequisite checks...3204OPatch continues with these patches: 31668908 32053206Do you want to proceed? [y|n]3207Y (auto-answered by -silent)3208User Responded with: Y3209All checks passed.32103211Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.3212(Oracle Home = '/u01/app/oracle/product/11.2.0/db')321332143215Is the local system ready for patching? [y|n]3216Y (auto-answered by -silent)3217User Responded with: Y3218Backing up files...3219Applying interim patch '31668908' to OH '/u01/app/oracle/product/11.2.0/db'3220ApplySession: Optional component(s) [ oracle.sqlj, 11.2.0.4.0 ] , [ oracle.sqlj.companion, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.32213222Patching component oracle.javavm.server, 11.2.0.4.0...32233224Patching component oracle.precomp.common, 11.2.0.4.0...32253226Patching component oracle.rdbms, 11.2.0.4.0...32273228Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...32293230Patching component oracle.javavm.client, 11.2.0.4.0...32313232Patching component oracle.dbjava.jdbc, 11.2.0.4.0...32333234Patching component oracle.dbjava.ic, 11.2.0.4.0...3235Patch 31668908 successfully applied.3236Log file location: /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2023-05-04_20-53-10PM_1.log32373238OPatch succeeded.32393240节点 192.168.6.33 ： 32413242Oracle Interim Patch Installer version 11.2.0.3.313243Copyright (c) 2023, Oracle Corporation. All rights reserved.32443245PREREQ session32463247Oracle Home : /u01/app/oracle/product/11.2.0/db3248Central Inventory : /u01/app/oraInventory3249 from : /u01/app/oracle/product/11.2.0/db/oraInst.loc3250OPatch version : 11.2.0.3.313251OUI version : 11.2.0.4.03252Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2023-05-04_20-53-42PM_1.log32533254Invoking prereq "checkconflictagainstohwithdetail"32553256Prereq "checkConflictAgainstOHWithDetail" passed.32573258OPatch succeeded.3259Oracle Interim Patch Installer version 11.2.0.3.313260Copyright (c) 2023, Oracle Corporation. All rights reserved.326132623263Oracle Home : /u01/app/oracle/product/11.2.0/db3264Central Inventory : /u01/app/oraInventory3265 from : /u01/app/oracle/product/11.2.0/db/oraInst.loc3266OPatch version : 11.2.0.3.313267OUI version : 11.2.0.4.03268Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2023-05-04_20-53-44PM_1.log32693270Verifying environment and performing prerequisite checks...3271OPatch continues with these patches: 31668908 32723273Do you want to proceed? [y|n]3274Y (auto-answered by -silent)3275User Responded with: Y3276All checks passed.32773278Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.3279(Oracle Home = '/u01/app/oracle/product/11.2.0/db')328032813282Is the local system ready for patching? [y|n]3283Y (auto-answered by -silent)3284User Responded with: Y3285Backing up files...3286Applying interim patch '31668908' to OH '/u01/app/oracle/product/11.2.0/db'3287ApplySession: Optional component(s) [ oracle.sqlj, 11.2.0.4.0 ] , [ oracle.sqlj.companion, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.32883289Patching component oracle.javavm.server, 11.2.0.4.0...32903291Patching component oracle.precomp.common, 11.2.0.4.0...32923293Patching component oracle.rdbms, 11.2.0.4.0...32943295Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...32963297Patching component oracle.javavm.client, 11.2.0.4.0...32983299Patching component oracle.dbjava.jdbc, 11.2.0.4.0...33003301Patching component oracle.dbjava.ic, 11.2.0.4.0...3302Patch 31668908 successfully applied.3303Log file location: /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2023-05-04_20-53-44PM_1.log33043305OPatch succeeded.33063307节点 192.168.6.34 ： 33083309Oracle Interim Patch Installer version 11.2.0.3.313310Copyright (c) 2023, Oracle Corporation. All rights reserved.33113312PREREQ session33133314Oracle Home : /u01/app/oracle/product/11.2.0/db3315Central Inventory : /u01/app/oraInventory3316 from : /u01/app/oracle/product/11.2.0/db/oraInst.loc3317OPatch version : 11.2.0.3.313318OUI version : 11.2.0.4.03319Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2023-05-04_20-54-14PM_1.log33203321Invoking prereq "checkconflictagainstohwithdetail"33223323Prereq "checkConflictAgainstOHWithDetail" passed.33243325OPatch succeeded.3326Oracle Interim Patch Installer version 11.2.0.3.313327Copyright (c) 2023, Oracle Corporation. All rights reserved.332833293330Oracle Home : /u01/app/oracle/product/11.2.0/db3331Central Inventory : /u01/app/oraInventory3332 from : /u01/app/oracle/product/11.2.0/db/oraInst.loc3333OPatch version : 11.2.0.3.313334OUI version : 11.2.0.4.03335Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2023-05-04_20-54-17PM_1.log33363337Verifying environment and performing prerequisite checks...3338OPatch continues with these patches: 31668908 33393340Do you want to proceed? [y|n]3341Y (auto-answered by -silent)3342User Responded with: Y3343All checks passed.33443345Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.3346(Oracle Home = '/u01/app/oracle/product/11.2.0/db')334733483349Is the local system ready for patching? [y|n]3350Y (auto-answered by -silent)3351User Responded with: Y3352Backing up files...3353Applying interim patch '31668908' to OH '/u01/app/oracle/product/11.2.0/db'3354ApplySession: Optional component(s) [ oracle.sqlj, 11.2.0.4.0 ] , [ oracle.sqlj.companion, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.33553356Patching component oracle.javavm.server, 11.2.0.4.0...33573358Patching component oracle.precomp.common, 11.2.0.4.0...33593360Patching component oracle.rdbms, 11.2.0.4.0...33613362Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...33633364Patching component oracle.javavm.client, 11.2.0.4.0...33653366Patching component oracle.dbjava.jdbc, 11.2.0.4.0...33673368Patching component oracle.dbjava.ic, 11.2.0.4.0...3369Patch 31668908 successfully applied.3370Log file location: /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2023-05-04_20-54-17PM_1.log33713372OPatch succeeded.33733374节点 192.168.6.35 ： 33753376Oracle Interim Patch Installer version 11.2.0.3.313377Copyright (c) 2023, Oracle Corporation. All rights reserved.33783379PREREQ session33803381Oracle Home : /u01/app/oracle/product/11.2.0/db3382Central Inventory : /u01/app/oraInventory3383 from : /u01/app/oracle/product/11.2.0/db/oraInst.loc3384OPatch version : 11.2.0.3.313385OUI version : 11.2.0.4.03386Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2023-05-04_08-54-50AM_1.log33873388Invoking prereq "checkconflictagainstohwithdetail"33893390Prereq "checkConflictAgainstOHWithDetail" passed.33913392OPatch succeeded.3393Oracle Interim Patch Installer version 11.2.0.3.313394Copyright (c) 2023, Oracle Corporation. All rights reserved.339533963397Oracle Home : /u01/app/oracle/product/11.2.0/db3398Central Inventory : /u01/app/oraInventory3399 from : /u01/app/oracle/product/11.2.0/db/oraInst.loc3400OPatch version : 11.2.0.3.313401OUI version : 11.2.0.4.03402Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2023-05-04_08-54-53AM_1.log34033404Verifying environment and performing prerequisite checks...3405OPatch continues with these patches: 31668908 34063407Do you want to proceed? [y|n]3408Y (auto-answered by -silent)3409User Responded with: Y3410All checks passed.34113412Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.3413(Oracle Home = '/u01/app/oracle/product/11.2.0/db')341434153416Is the local system ready for patching? [y|n]3417Y (auto-answered by -silent)3418User Responded with: Y3419Backing up files...3420Applying interim patch '31668908' to OH '/u01/app/oracle/product/11.2.0/db'3421ApplySession: Optional component(s) [ oracle.sqlj, 11.2.0.4.0 ] , [ oracle.sqlj.companion, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.34223423Patching component oracle.javavm.server, 11.2.0.4.0...34243425Patching component oracle.precomp.common, 11.2.0.4.0...34263427Patching component oracle.rdbms, 11.2.0.4.0...34283429Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...34303431Patching component oracle.javavm.client, 11.2.0.4.0...34323433Patching component oracle.dbjava.jdbc, 11.2.0.4.0...34343435Patching component oracle.dbjava.ic, 11.2.0.4.0...3436Patch 31668908 successfully applied.3437Log file location: /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2023-05-04_08-54-53AM_1.log34383439OPatch succeeded.34403441#==============================================================# 3442Oracle 软件版本 3443#==============================================================# 344434453446SQL*Plus: Release 11.2.0.4.0 Production344734483449#==============================================================# 3450OPatch 补丁信息 3451#==============================================================# 3452345331668908;OJVM PATCH SET UPDATE 11.2.0.4.201020345431537677;Database Patch Set Update : 11.2.0.4.201020 (31537677)345529938455;OCW Patch Set Update : 11.2.0.4.191015 (29938455)34563457OPatch succeeded.345834593460#==============================================================# 3461创建数据库 3462#==============================================================# 34633464Copying database files34651% complete34663% complete34679% complete346815% complete346921% complete347027% complete347130% complete3472Creating and starting Oracle instance347332% complete347436% complete347540% complete347644% complete347745% complete347848% complete347950% complete3480Creating cluster database views348152% complete348270% complete3483Completing Database Creation348473% complete348576% complete348677% complete348778% complete348879% complete348988% complete349097% complete3491100% complete3492Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/oradb/oradb.log" for further details.34933494#==============================================================# 3495配置 OMF && 优化 RMAN 3496#==============================================================# 349734983499Recovery Manager: Release 11.2.0.4.0 - Production on Thu May 4 21:14:19 202335003501Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.35023503connected to target database: ORADB (DBID=2889241045)35043505RMAN> 3506using target database control file instead of recovery catalog3507new RMAN configuration parameters:3508CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATA/snapcf_fdcdb1.f';3509new RMAN configuration parameters are successfully stored35103511RMAN> 35123513Recovery Manager complete.35143515#==============================================================# 3516配置控制文件和重做日志 3517#==============================================================# 35183519静默配置控制文件和重做日志，请稍候： 352035213522数据库控制文件： 352335243525NAME3526----------------------------------------------------------------------------------------------------3527+DATA/oradb/controlfile/current.261.11359762773528+DATA/oradb/controlfile/current.260.113597627735293530数据库在线重做日志文件： 353135323533 THREAD# GROUP# MEMBER size(M)3534---------- ---------- ------------------------------------------------------------ ----------3535 1 2 +DATA/oradb/onlinelog/group_2.264.1135976281 503536 1 2 +DATA/oradb/onlinelog/group_2.265.1135976283 503537 1 1 +DATA/oradb/onlinelog/group_1.262.1135976281 503538 1 1 +DATA/oradb/onlinelog/group_1.263.1135976281 503539 1 15 +DATA/oradb/onlinelog/group_15.301.1135977273 503540 1 15 +DATA/oradb/onlinelog/group_15.300.1135977271 503541 1 11 +DATA/oradb/onlinelog/group_11.292.1135977263 503542 1 14 +DATA/oradb/onlinelog/group_14.298.1135977269 503543 1 13 +DATA/oradb/onlinelog/group_13.297.1135977269 503544 1 13 +DATA/oradb/onlinelog/group_13.296.1135977267 503545 1 12 +DATA/oradb/onlinelog/group_12.295.1135977267 503546 1 12 +DATA/oradb/onlinelog/group_12.294.1135977267 503547 1 11 +DATA/oradb/onlinelog/group_11.293.1135977265 503548 1 14 +DATA/oradb/onlinelog/group_14.299.1135977271 503549 2 4 +DATA/oradb/onlinelog/group_4.289.1135977191 503550 2 20 +DATA/oradb/onlinelog/group_20.310.1135977283 503551 2 19 +DATA/oradb/onlinelog/group_19.309.1135977283 503552 2 19 +DATA/oradb/onlinelog/group_19.308.1135977281 503553 2 18 +DATA/oradb/onlinelog/group_18.307.1135977281 503554 2 18 +DATA/oradb/onlinelog/group_18.306.1135977279 503555 2 17 +DATA/oradb/onlinelog/group_17.305.1135977279 503556 2 17 +DATA/oradb/onlinelog/group_17.304.1135977277 503557 2 16 +DATA/oradb/onlinelog/group_16.303.1135977277 503558 2 16 +DATA/oradb/onlinelog/group_16.302.1135977275 503559 2 20 +DATA/oradb/onlinelog/group_20.311.1135977285 503560 2 4 +DATA/oradb/onlinelog/group_4.288.1135977191 503561 2 3 +DATA/oradb/onlinelog/group_3.285.1135977187 503562 2 3 +DATA/oradb/onlinelog/group_3.286.1135977189 503563 3 5 +DATA/oradb/onlinelog/group_5.281.1135977185 503564 3 6 +DATA/oradb/onlinelog/group_6.284.1135977187 503565 3 6 +DATA/oradb/onlinelog/group_6.283.1135977185 503566 3 5 +DATA/oradb/onlinelog/group_5.280.1135977183 503567 4 8 +DATA/oradb/onlinelog/group_8.279.1135977181 503568 4 8 +DATA/oradb/onlinelog/group_8.278.1135977179 503569 4 7 +DATA/oradb/onlinelog/group_7.277.1135977179 503570 4 7 +DATA/oradb/onlinelog/group_7.275.1135977177 503571 5 10 +DATA/oradb/onlinelog/group_10.273.1135977175 503572 5 10 +DATA/oradb/onlinelog/group_10.274.1135977175 503573 5 9 +DATA/oradb/onlinelog/group_9.271.1135977173 503574 5 9 +DATA/oradb/onlinelog/group_9.272.1135977173 5035753576#==============================================================# 3577数据库参数配置 3578#==============================================================# 35793580数据库参数： 358135823583NAME SID SPVALUE VALUE3584-------------------------------------------------- ---------- -------------------------------------------------- --------------------------------------------------3585_b_tree_bitmap_plans * FALSE FALSE3586_datafile_write_errors_crash_instance * FALSE FALSE3587audit_file_dest * /u01/app/oracle/admin/oradb/adump /u01/app/oracle/admin/oradb/adump3588audit_trail * NONE NONE3589cluster_database * true TRUE3590compatible * 11.2.0.4.0 11.2.0.4.03591control_file_record_keep_time * 31 313592db_block_size * 8192 81923593db_create_file_dest * +DATA +DATA3594db_file_multiblock_read_count * 1283595db_files * 5000 2003596db_name * oradb oradb3597db_recovery_file_dest * +DATA +DATA3598db_recovery_file_dest_size * 5800722432 58007224323599db_writer_processes * 13600deferred_segment_creation * FALSE FALSE3601diagnostic_dest * /u01/app/oracle /u01/app/oracle3602dispatchers * (PROTOCOL=TCP) (SERVICE=oradbXDB) (PROTOCOL=TCP) (SERVICE=oradbXDB)3603enable_ddl_logging * TRUE FALSE3604event * 10949 trace name context forever,level 13605event * 28401 trace name context forever,level 13606fast_start_parallel_rollback * LOW3607log_archive_dest_1 * location=+DATA location=+DATA3608log_archive_format * %t_%s_%r.dbf %t_%s_%r.dbf3609max_dump_file_size * unlimited3610open_cursors * 1000 3003611optimizer_index_caching * 03612optimizer_mode * ALL_ROWS3613parallel_force_local * TRUE FALSE3614parallel_max_servers * 64 643615pga_aggregate_target * 1339031552 13390315523616processes * 2000 1503617remote_login_passwordfile * exclusive EXCLUSIVE3618resource_limit * TRUE FALSE3619resource_manager_plan * force:3620sec_case_sensitive_logon * FALSE TRUE3621session_cached_cursors * 300 503622sessions * 2483623sga_max_size * 5356126208 53687091203624sga_target * 5356126208 53687091203625spfile * +DATA/oradb/spfileoradb.ora3626statistics_level * TYPICAL3627undo_retention * 10800 90036283629恭喜！Oracle RAC 安装成功，现在是否重启主机：[Y/N]默认使用专业版脚本。脚本下载：ora100.com/shell-install