openEuler 22.03 LTS SP3（华为欧拉）一键安装 Oracle 11GR2 RAC（231017）

Oracle 一键安装脚本，演示 openEuler 22.03 LTS SP3 一键安装 Oracle 11GR2 RAC（231017）过程（全程无需人工干预）：（脚本包括 <font color='red'ORALCE PSU/OJVM 等补丁自动安装</font） ⭐️ <font color='red'脚本下载地址</font：Shell脚本安装Oracle数据库https://www.

2024年4月7日阅读—点赞—收藏—

oracleracone-click-install

DBA 实战课程系统学习 Oracle DBA查看完整课程

前言

本章目标：掌握本章核心知识点 前置要求：完成前序章节学习 预计时长：60 分钟

Oracle 一键安装脚本，演示 openEuler 22.03 LTS SP3 一键安装 Oracle 11GR2 RAC（231017）过程（全程无需人工干预）：（脚本包括 ORALCE PSU/OJVM 等补丁自动安装）

⭐️ 脚本下载地址：Shell脚本安装Oracle数据库

脚本第三代支持 N 节点一键安装，不限制节点数！

安装准备

1、安装好操作系统，建议安装图形化
2、配置好网络
3、挂载本地 ISO 镜像源
4、上传软件安装包（安装基础包，补丁包：33991024，35574075，35685663，35940989、6880880）
5、上传一键安装脚本：OracleShellInstall

参考：

在 Oracle Linux 8 （openEuler 22.03 LTS SP3）安装 11GR2 RAC 数据库，需要安装 19.14 版本之后的 Grid 软件补丁，然后再安装 11GR2 数据：

✨ 偷懒可以直接下载本文安装包合集：openEuler 22.03 LTS SP3（华为欧拉）一键安装 Oracle 11GR2 RAC（231017）安装包合集（包含补丁！！！）

演示环境信息

++==📢注意：Oracle 11GR2 RAC 安装主机名不能有大写字符，否则安装失败！==++

Bash

1# 主机版本
2[root@openeuler01 soft]# cat /etc/openeuler-release 
3openEuler release 22.03 (LTS-SP3)
4
5# 网络信息
6## 节点一
7[root@openeuler01 soft]# ip a
82: ens33: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc fq_codel state UP group default qlen 1000
9    link/ether 00:0c:29:51:f8:ca brd ff:ff:ff:ff:ff:ff
10    inet 192.168.6.130/24 brd 192.168.6.255 scope global noprefixroute ens33
11       valid_lft forever preferred_lft forever
12    inet6 fe80::6bae:9840:87e5:b777/64 scope link noprefixroute 
13       valid_lft forever preferred_lft forever
143: ens37: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc fq_codel state UP group default qlen 1000
15    link/ether 00:0c:29:51:f8:de brd ff:ff:ff:ff:ff:ff
16    inet 1.1.1.1/24 brd 1.1.1.255 scope global noprefixroute ens37
17       valid_lft forever preferred_lft forever
18    inet6 fe80::7590:c66c:2046:880c/64 scope link noprefixroute 
19       valid_lft forever preferred_lft forever
20
21## 节点二
22[root@openeuler02 ~]# ip a
232: ens33: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc fq_codel state UP group default qlen 1000
24    link/ether 00:0c:29:6e:b2:2c brd ff:ff:ff:ff:ff:ff
25    inet 192.168.6.131/24 brd 192.168.6.255 scope global noprefixroute ens33
26       valid_lft forever preferred_lft forever
27    inet6 fe80::20c:29ff:fe6e:b22c/64 scope link noprefixroute 
28       valid_lft forever preferred_lft forever
293: ens37: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc fq_codel state UP group default qlen 1000
30    link/ether 00:0c:29:6e:b2:40 brd ff:ff:ff:ff:ff:ff
31    inet 1.1.1.2/24 brd 1.1.1.255 scope global noprefixroute ens37
32       valid_lft forever preferred_lft forever
33    inet6 fe80::683c:1c48:9251:7df7/64 scope link noprefixroute 
34       valid_lft forever preferred_lft forever
35
36# 挂载本地 ISO 镜像
37## 节点一
38[root@openeuler01 soft]# mount | grep iso | grep -v "/run/media"
39/dev/sr0 on /mnt type iso9660 (ro,relatime,nojoliet,check=s,map=n,blocksize=2048,iocharset=utf8)
40[root@openeuler01 soft]# df -h|grep /mnt
41/dev/sr0                     18G   18G     0 100% /mnt
42
43## 节点二
44[root@openeuler02 soft]# mount | grep iso | grep -v "/run/media"
45/dev/sr0 on /mnt type iso9660 (ro,relatime,nojoliet,check=s,map=n,blocksize=2048,iocharset=utf8)
46[root@openeuler02 soft]# df -h|grep /mnt
47/dev/sr0                     18G   18G     0 100% /mnt
48
49# starwind 共享磁盘挂载（有存储就不需要使用 starwind，直接存储上划盘挂载就可）
50yum install -y iscsi-initiator-utils*
51systemctl start iscsid.service
52systemctl enable iscsid.service
53iscsiadm -m discovery -t st -p 192.168.6.188
54## 挂载 ASM 磁盘
55iscsiadm -m node -T iqn.2008-08.com.starwindsoftware:192.168.6.188-lucifer -p 192.168.6.188 -l
56## 配置开机自动挂载
57iscsiadm -m node -T iqn.2008-08.com.starwindsoftware:192.168.6.188-lucifer -p 192.168.6.188 --op update -n node.startup -v automatic
58
59## 节点一
60[root@openeuler01 ~]# lsblk 
61NAME               MAJ:MIN RM  SIZE RO TYPE MOUNTPOINTS
62sda                  8:0    0  100G  0 disk 
63├─sda1               8:1    0    1G  0 part /boot
64└─sda2               8:2    0   99G  0 part 
65  ├─openeuler-root 253:0    0   91G  0 lvm  /
66  └─openeuler-swap 253:1    0    8G  0 lvm  [SWAP]
67sdb                  8:16   0   10G  0 disk 
68sdc                  8:32   0   50G  0 disk 
69sr0                 11:0    1 17.1G  0 rom  /mnt
70
71## 节点二
72[root@openeuler02 ~]# lsblk 
73NAME               MAJ:MIN RM  SIZE RO TYPE MOUNTPOINTS
74sda                  8:0    0  100G  0 disk 
75├─sda1               8:1    0    1G  0 part /boot
76└─sda2               8:2    0   99G  0 part 
77  ├─openeuler-root 253:0    0   91G  0 lvm  /
78  └─openeuler-swap 253:1    0    8G  0 lvm  [SWAP]
79sdb                  8:16   0   10G  0 disk 
80sdc                  8:32   0   50G  0 disk 
81sr0                 11:0    1 17.1G  0 rom  /mnt
82
83# 安装包存放在 /soft 目录下
84[root@openeuler01 ~]# cd /soft/
85[root@openeuler01 soft]# ll
86-rwx------. 1 root root 2889184573 Mar 29 15:00 LINUX.X64_193000_grid_home.zip
87-rwxr-xr-x. 1 root root     180800 Mar 29 14:59 OracleShellInstall
88-rwx------. 1 root root 1395582860 Mar 29 14:59 p13390677_112040_Linux-x86-64_1of7.zip
89-rwx------. 1 root root 1151304589 Mar 29 14:59 p13390677_112040_Linux-x86-64_2of7.zip
90-rwx------. 1 root root       8684 Mar 29 14:58 p33991024_11204220118_Generic.zip
91-rwx------. 1 root root  562188912 Mar 29 14:58 p35574075_112040_Linux-x86-64.zip
92-rwx------. 1 root root   86183099 Mar 29 14:58 p35685663_112040_Linux-x86-64.zip
93-rwx------. 1 root root 3153297056 Mar 29 15:00 p35940989_190000_Linux-x86-64.zip
94-rwx------. 1 root root  128433424 Mar 29 14:58 p6880880_112000_Linux-x86-64.zip
95-rwx------. 1 root root  127774864 Mar 29 14:59 p6880880_190000_Linux-x86-64.zip
96-rwx------. 1 root root     321590 Mar 20 13:58 rlwrap-0.44.tar.gz
97
98# 修改 root 密码，脚本不支持特殊字符，例如 @ 符号
99# 去除密码复杂度
100sed -i 's/^password\+[[:space:]]\+requisite[[:space:]]\+pam_pwquality.so/#&/g' /etc/pam.d/system-auth
101sed -i 's/use_authtok$//' /etc/pam.d/system-auth
102# 修改 root 密码
103[root@openeuler01 soft]# passwd root
104Changing password for user root.
105New password:
106Retype new password:
107passwd: all authentication tokens updated successfully.
108
109[root@openeuler02 ~]# passwd root
110Changing password for user root.
111New password:
112Retype new password:
113passwd: all authentication tokens updated successfully.

默认使用专业版脚本。脚本下载：ora100.com/shell-install 以上配置完成后，建议重启两台主机，重启后记得再次挂载 ISO：

Bash

1[root@openeuler01:/soft]$ mount /dev/cdrom /mnt/
2mount: /mnt: WARNING: source write-protected, mounted read-only.
3
4[root@openeuler02:/root]$ mount /dev/cdrom /mnt/
5mount: /mnt: WARNING: source write-protected, mounted read-only.

确保安装环境准备完成后，即可执行一键安装。

安装命令

使用标准生产环境安装参数（安装过程若失败，脚本支持重复执行安装）：

Bash

1# 根据脚本 README 或者 -h 命令提示，编辑好一键安装命令，进入 /soft 目录执行安装：
2./OracleShellInstall -n openeuler `# hostname prefix`\
3-hn openeuler01,openeuler02 `# rac node hostname`\
4-cn openeuler-cls `# cluster_name`\
5-rp oracle `# root password`\
6-gp oracle `# grid password`\
7-op oracle `# oracle password`\
8-lf ens33 `# local ip ifname`\
9-pf ens37 `# rac private ip ifname`\
10-ri 192.168.6.130,192.168.6.131 `# rac node public ip`\
11-vi 192.168.6.132,192.168.6.133 `# rac virtual ip`\
12-si 192.168.6.134 `# rac scan ip`\
13-od /dev/sdb `# rac ocr asm disk`\
14-dd /dev/sdc `# rac data asm disk`\
15-o lucifer `# dbname`\
16-ds AL32UTF8 `# database character`\
17-ns AL16UTF16 `# national character`\
18-redo 100 `# redo size`\
19-dp oracle `# sys/system password`\
20-gpa 35940989 `# grid PSU/RU`\
21-opa 35574075 `# db PSU/RU`\
22-jpa 35685663 `# OJVM PSU/RU`\
23-opd Y `# optimize db`\
24-giv 19 `# grid version`

默认使用专业版脚本。脚本下载：ora100.com/shell-install

选择需要安装的模式以及版本，即可开始安装：

安装过程

Bash

1   ███████                             ██          ████████ ██               ██  ██ ██                    ██              ██  ██
2  ██░░░░░██                           ░██         ██░░░░░░ ░██              ░██ ░██░██                   ░██             ░██ ░██
3 ██     ░░██ ██████  ██████    █████  ░██  █████ ░██       ░██       █████  ░██ ░██░██ ███████   ██████ ██████  ██████   ░██ ░██
4░██      ░██░░██░░█ ░░░░░░██  ██░░░██ ░██ ██░░░██░█████████░██████  ██░░░██ ░██ ░██░██░░██░░░██ ██░░░░ ░░░██░  ░░░░░░██  ░██ ░██
5░██      ░██ ░██ ░   ███████ ░██  ░░  ░██░███████░░░░░░░░██░██░░░██░███████ ░██ ░██░██ ░██  ░██░░█████   ░██    ███████  ░██ ░██
6░░██     ██  ░██    ██░░░░██ ░██   ██ ░██░██░░░░        ░██░██  ░██░██░░░░  ░██ ░██░██ ░██  ░██ ░░░░░██  ░██   ██░░░░██  ░██ ░██
7 ░░███████  ░███   ░░████████░░█████  ███░░██████ ████████ ░██  ░██░░██████ ███ ███░██ ███  ░██ ██████   ░░██ ░░████████ ███ ███
8  ░░░░░░░   ░░░     ░░░░░░░░  ░░░░░  ░░░  ░░░░░░ ░░░░░░░░  ░░   ░░  ░░░░░░ ░░░ ░░░ ░░ ░░░   ░░ ░░░░░░     ░░   ░░░░░░░░ ░░░ ░░░ 
9
10
11请选择安装模式 [单机(si)/单机ASM(sa)/集群(rac)] : rac
12
13数据库安装模式: rac                                                                              
14
15请选择数据库版本 [11/12/19/21] : 11
16
17数据库版本:     11                                                                               
18
19
20
21#==============================================================#                                                                                  
22配置本地 YUM 源                                                                                  
23#==============================================================#                                                                                  
24
25[openEuler]
26name=openEuler
27baseurl=file:////mnt
28enabled=1
29gpgcheck=1
30gpgkey=file:////mnt/RPM-GPG-KEY-openEuler
31
32#==============================================================#                                                                                  
33获取 ASM 磁盘 UUID && 格式化磁盘头                                                                                  
34#==============================================================#                                                                                  
35
36格式化 OCR 磁盘：/dev/sdb                                                                                  
37
381+0 records in
391+0 records out
401024 bytes (1.0 kB, 1.0 KiB) copied, 0.00418647 s, 245 kB/s
41
42OCR磁盘组的磁盘UUID： 2e87e4f535c397171                                                                
43
44格式化 DATA 磁盘：/dev/sdc                                                                                  
45
461+0 records in
471+0 records out
481024 bytes (1.0 kB, 1.0 KiB) copied, 0.00881888 s, 116 kB/s
49
50DATA磁盘组的磁盘UUID： 2f218dae15b551c5d                                                                
51
52#==============================================================#                                                                                  
53配置 root 用户互信                                                                                  
54#==============================================================#                                                                                  
55
56Generating public/private rsa key pair.
57Your identification has been saved in /root/.ssh/id_rsa
58Your public key has been saved in /root/.ssh/id_rsa.pub
59The key fingerprint is:
60SHA256:4n424QDugUwB1I7Jg2/uybw6syWK8xmg+Ixya0JUHxk root@openEuler01
61The key's randomart image is:
62+---[RSA 3072]----+
63|oo.  Eo          |
64|  .o o           |
65|o =.. .          |
66|.*....           |
67|o+.o .. S        |
68|oo= o....        |
69|=oo. ..o .       |
70|OO++..  =        |
71|B%%o  .o .       |
72+----[SHA256]-----+
73
74#==============================================================#                                                                                  
75打印系统信息                                                                                    
76#==============================================================#                                                                                  
77
78服务器时间:                                                                                      
79
80Fri Mar 29 03:08:56 PM CST 2024
81
82操作系统版本:                                                                                   
83
84NAME="openEuler"
85VERSION="22.03 (LTS-SP3)"
86ID="openEuler"
87VERSION_ID="22.03"
88PRETTY_NAME="openEuler 22.03 (LTS-SP3)"
89ANSI_COLOR="0;31"
90
91
92内核信息:                                                                                         
93
94Linux version 5.10.0-182.0.0.95.oe2203sp3.x86_64 (root@dc-64g.compass-ci) (gcc_old (GCC) 10.3.1, GNU ld (GNU Binutils) 2.37) #1 SMP Sat Dec 30 13:10:36 CST 2023
95
96服务器属性:                                                                                      
97
98vmware
99
100cpu信息:                                                                                            
101
102Architecture:                       x86_64
103CPU op-mode(s):                     32-bit, 64-bit
104Address sizes:                      43 bits physical, 48 bits virtual
105Byte Order:                         Little Endian
106CPU(s):                             8
107On-line CPU(s) list:                0-7
108Vendor ID:                          GenuineIntel
109BIOS Vendor ID:                     GenuineIntel
110Model name:                         Intel(R) Xeon(R) CPU E5-2630 v2 @ 2.60GHz
111BIOS Model name:                          Intel(R) Xeon(R) CPU E5-2630 v2 @ 2.60GHz
112CPU family:                         6
113Model:                              62
114Thread(s) per core:                 1
115Core(s) per socket:                 1
116Socket(s):                          8
117Stepping:                           4
118BogoMIPS:                           5187.49
119Flags:                              fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ss syscall nx rdtscp lm constant_tsc arch_perfmon nopl xtopology tsc_reliable nonstop_tsc cpuid pni pclmulqdq ssse3 cx16 pcid sse4_1 sse4_2 x2apic popcnt tsc_deadline_timer aes xsave avx f16c rdrand hypervisor lahf_lm cpuid_fault pti ssbd ibrs ibpb stibp fsgsbase tsc_adjust smep arat md_clear flush_l1d arch_capabilities
120Hypervisor vendor:                  VMware
121Virtualization type:                full
122L1d cache:                          256 KiB (8 instances)
123L1i cache:                          256 KiB (8 instances)
124L2 cache:                           2 MiB (8 instances)
125L3 cache:                           120 MiB (8 instances)
126NUMA node(s):                       1
127NUMA node0 CPU(s):                  0-7
128Vulnerability Gather data sampling: Not affected
129Vulnerability Itlb multihit:        KVM: Mitigation: VMX unsupported
130Vulnerability L1tf:                 Mitigation; PTE Inversion
131Vulnerability Mds:                  Mitigation; Clear CPU buffers; SMT Host state unknown
132Vulnerability Meltdown:             Mitigation; PTI
133Vulnerability Mmio stale data:      Unknown: No mitigations
134Vulnerability Retbleed:             Mitigation; IBRS
135Vulnerability Spec rstack overflow: Not affected
136Vulnerability Spec store bypass:    Mitigation; Speculative Store Bypass disabled via prctl and seccomp
137Vulnerability Spectre v1:           Mitigation; usercopy/swapgs barriers and __user pointer sanitization
138Vulnerability Spectre v2:           Mitigation; IBRS, IBPB conditional, STIBP disabled, RSB filling, PBRSB-eIBRS Not affected
139Vulnerability Srbds:                Not affected
140Vulnerability Tsx async abort:      Not affected
141
142内存信息:                                                                                         
143
144               total        used        free      shared  buff/cache   available
145Mem:            7433         527         126           8        7096        6906
146Swap:           8187           0        8187
147               total        used        free      shared  buff/cache   available
148Mem:           7.3Gi       527Mi       126Mi       8.7Mi       6.9Gi       6.7Gi
149Swap:          8.0Gi       524Ki       8.0Gi
150
151挂载信息:                                                                                         
152
153/dev/mapper/openeuler-root /                       ext4    defaults        1 1
154UUID=07e6a80f-f2f4-42f8-a1ad-df05bd354960 /boot                   ext4    defaults        1 2
155/dev/mapper/openeuler-swap none                    swap    defaults        0 0
156
157目录信息:                                                                                         
158
159Filesystem                  Size  Used Avail Use% Mounted on
160devtmpfs                    4.0M     0  4.0M   0% /dev
161tmpfs                       3.7G     0  3.7G   0% /dev/shm
162tmpfs                       1.5G  8.8M  1.5G   1% /run
163tmpfs                       4.0M     0  4.0M   0% /sys/fs/cgroup
164/dev/mapper/openeuler-root   90G   11G   74G  14% /
165tmpfs                       3.7G     0  3.7G   0% /tmp
166/dev/sda1                   974M  174M  733M  20% /boot
167/dev/sr0                     18G   18G     0 100% /mnt
168
169#==============================================================#                                                                                  
170禁用防火墙                                                                                       
171#==============================================================#                                                                                  
172
173○ firewalld.service - firewalld - dynamic firewall daemon
174     Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)
175     Active: inactive (dead)
176       Docs: man:firewalld(1)
177
178Mar 29 14:49:36 openEuler01 systemd[1]: Starting firewalld - dynamic firewall daemon...
179Mar 29 14:49:38 openEuler01 systemd[1]: Started firewalld - dynamic firewall daemon.
180Mar 29 15:08:56 openEuler01 systemd[1]: Stopping firewalld - dynamic firewall daemon...
181Mar 29 15:08:57 openEuler01 systemd[1]: firewalld.service: Deactivated successfully.
182Mar 29 15:08:57 openEuler01 systemd[1]: Stopped firewalld - dynamic firewall daemon.
183
184#==============================================================#                                                                                  
185禁用 SELinux                                                                                        
186#==============================================================#                                                                                  
187
188SELinux status:                 enabled
189SELinuxfs mount:                /sys/fs/selinux
190SELinux root directory:         /etc/selinux
191Loaded policy name:             targeted
192Current mode:                   permissive
193Mode from config file:          disabled
194Policy MLS status:              enabled
195Policy deny_unknown status:     allowed
196Memory protection checking:     actual (secure)
197Max kernel policy version:      33
198
199#==============================================================#                                                                                  
200配置 nsysctl.conf                                                                                   
201#==============================================================#                                                                                  
202
203NOZEROCONF=yes
204
205#==============================================================#                                                                                  
206YUM 静默安装依赖包                                                                                  
207#==============================================================#                                                                                  
208
209bc-1.07.1-12.oe2203sp3.x86_64
210binutils-2.37-24.oe2203sp3.x86_64
211package compat-libcap1 is not installed
212gcc-10.3.1-49.oe2203sp3.x86_64
213gcc-c++-10.3.1-49.oe2203sp3.x86_64
214package elfutils-libelf is not installed
215package elfutils-libelf-devel is not installed
216glibc-2.34-143.oe2203sp3.x86_64
217glibc-devel-2.34-143.oe2203sp3.x86_64
218libaio-0.3.113-9.oe2203sp3.x86_64
219libaio-devel-0.3.113-9.oe2203sp3.x86_64
220libgcc-10.3.1-49.oe2203sp3.x86_64
221libstdc++-10.3.1-49.oe2203sp3.x86_64
222libstdc++-devel-10.3.1-49.oe2203sp3.x86_64
223libxcb-1.15-1.oe2203sp3.x86_64
224libX11-1.7.2-8.oe2203sp3.x86_64
225libXau-1.0.10-1.oe2203sp3.x86_64
226libXi-1.8-2.oe2203sp3.x86_64
227libXrender-0.9.10-12.oe2203sp3.x86_64
228make-4.3-4.oe2203sp3.x86_64
229net-tools-2.10-3.oe2203sp3.x86_64
230smartmontools-7.2-2.oe2203sp3.x86_64
231sysstat-12.5.4-9.oe2203sp3.x86_64
232e2fsprogs-1.46.4-24.oe2203sp3.x86_64
233package e2fsprogs-libs is not installed
234unzip-6.0-50.oe2203sp3.x86_64
235openssh-clients-8.8p1-23.oe2203sp3.x86_64
236readline-8.1-3.oe2203sp3.x86_64
237readline-devel-8.1-3.oe2203sp3.x86_64
238psmisc-23.5-2.oe2203sp3.x86_64
239ksh-2020.0.0-10.oe2203sp3.x86_64
240nfs-utils-2.5.4-15.oe2203sp3.x86_64
241tar-1.34-5.oe2203sp3.x86_64
242package device-mapper-multipath is not installed
243avahi-0.8-18.oe2203sp3.x86_64
244ntp-4.2.8p15-13.oe2203sp3.x86_64
245chrony-4.1-6.oe2203sp3.x86_64
246libXtst-1.2.4-1.oe2203sp3.x86_64
247libXrender-devel-0.9.10-12.oe2203sp3.x86_64
248fontconfig-devel-2.13.94-3.oe2203sp3.x86_64
249policycoreutils-3.3-8.oe2203sp3.x86_64
250package policycoreutils-python is not installed
251libcap-devel-2.61-6.oe2203sp3.x86_64
252xorg-x11-utils-7.5-31.oe2203sp3.x86_64
253xorg-x11-xauth-1.1.2-1.oe2203sp3.x86_64
254glibc-compat-2.17-2.34-143.oe2203sp3.x86_64
255elfutils-0.185-18.oe2203sp3.x86_64
256elfutils-devel-0.185-18.oe2203sp3.x86_64
257libnsl2-devel-2.0.0-5.oe2203sp3.x86_64
258package librdmacm is not installed
259libnsl-2.34-143.oe2203sp3.x86_64
260package libibverbs is not installed
261package compat-openssl10 is not installed
262policycoreutils-python-utils-3.3-8.oe2203sp3.noarch
263
264#==============================================================#                                                                                  
265配置主机名                                                                                       
266#==============================================================#                                                                                  
267
268 Static hostname: openeuler01
269       Icon name: computer-vm
270         Chassis: vm
271      Machine ID: 141e08aec07949dbb1be4d025526e6de
272         Boot ID: 07e7a034d0d248988b39171ec1f10f2c
273  Virtualization: vmware
274Operating System: openEuler 22.03 (LTS-SP3)
275          Kernel: Linux 5.10.0-182.0.0.95.oe2203sp3.x86_64
276    Architecture: x86-64
277 Hardware Vendor: VMware, Inc.
278  Hardware Model: VMware Virtual Platform
279
280#==============================================================#                                                                                  
281配置 /etc/hosts 文件                                                                                  
282#==============================================================#                                                                                  
283
284127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
285::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
286192.168.6.130 openeuler01
287192.168.6.132 openeuler01-vip
2881.1.1.1 openeuler01-priv
289192.168.6.131 openeuler02
290192.168.6.133 openeuler02-vip
2911.1.1.2 openeuler02-priv
292192.168.6.134 openeuler-scan
293
294#==============================================================#                                                                                  
295创建用户和组                                                                                    
296#==============================================================#                                                                                  
297
298oracle 用户：                                                                                      
299
300uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba),54327(asmdba),54328(asmoper),54329(asmadmin)
301
302grid 用户：                                                                                        
303
304uid=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)
305
306
307#==============================================================#                                                                                  
308配置 Avahi-daemon 服务                                                                                  
309#==============================================================#                                                                                  
310
311○ avahi-daemon.service - Avahi mDNS/DNS-SD Stack
312     Loaded: loaded (/usr/lib/systemd/system/avahi-daemon.service; disabled; vendor preset: enabled)
313     Active: inactive (dead)
314TriggeredBy: ○ avahi-daemon.socket
315
316#==============================================================#                                                                                  
317配置透明大页 && NUMA && 磁盘 IO 调度器                                                                                  
318#==============================================================#                                                                                  
319
320args="ro resume=/dev/mapper/openeuler-swap rd.lvm.lv=openeuler/root rd.lvm.lv=openeuler/swap cgroup_disable=files apparmor=0 crashkernel=512M rhgb quiet numa=off transparent_hugepage=never elevator=deadline"
321-resume=/dev/mapper/openeuler-swap
322-args="ro
323args="ro resume=/dev/mapper/openeuler-swap rd.lvm.lv=openeuler/root rd.lvm.lv=openeuler/swap cgroup_disable=files apparmor=0 crashkernel=512M rhgb quiet numa=off transparent_hugepage=never elevator=deadline"
324-rhgb
325-crashkernel=512M
326
327#==============================================================#                                                                                  
328配置 sysctl.conf                                                                                    
329#==============================================================#                                                                                  
330
331kernel.sysrq = 0
332net.ipv4.ip_forward = 0
333net.ipv4.conf.all.send_redirects = 0
334net.ipv4.conf.default.send_redirects = 0
335net.ipv4.conf.all.accept_source_route = 0
336net.ipv4.conf.default.accept_source_route = 0
337net.ipv4.conf.all.accept_redirects = 0
338net.ipv4.conf.default.accept_redirects = 0
339net.ipv4.conf.all.secure_redirects = 0
340net.ipv4.conf.default.secure_redirects = 0
341net.ipv4.icmp_echo_ignore_broadcasts = 1
342net.ipv4.icmp_ignore_bogus_error_responses = 1
343net.ipv4.conf.all.rp_filter = 1
344net.ipv4.conf.default.rp_filter = 1
345net.ipv4.tcp_syncookies = 1
346kernel.dmesg_restrict = 1
347net.ipv6.conf.all.accept_redirects = 0
348net.ipv6.conf.default.accept_redirects = 0
349fs.aio-max-nr = 1048576
350fs.file-max = 6815744
351kernel.shmall = 2097152
352kernel.shmmax = 7795097599
353kernel.shmmni = 4096
354kernel.sem = 250 32000 100 128
355net.ipv4.ip_local_port_range = 9000 65500
356net.core.rmem_default = 262144
357net.core.rmem_max = 4194304
358net.core.wmem_default = 262144
359net.core.wmem_max = 1048576
360vm.min_free_kbytes = 30449
361net.ipv4.conf.ens33.rp_filter = 1
362vm.swappiness = 10
363kernel.panic_on_oops = 1
364kernel.randomize_va_space = 2
365kernel.numa_balancing = 0
366net.ipv4.conf.ens37.rp_filter = 2
367
368#==============================================================#                                                                                  
369配置 RemoveIPC                                                                                      
370#==============================================================#                                                                                  
371
372[Login]
373RemoveIPC=no
374
375#==============================================================#                                                                                  
376配置 /etc/security/limits.conf 和 /etc/pam.d/login                                                                                  
377#==============================================================#                                                                                  
378
379查看 /etc/security/limits.conf：                                                                                  
380
381oracle soft nofile 1024
382oracle hard nofile 65536
383oracle soft stack 10240
384oracle hard stack 32768
385oracle soft nproc 2047
386oracle hard nproc 16384
387oracle hard memlock unlimited
388oracle soft memlock unlimited
389grid soft nofile 1024
390grid hard nofile 65536
391grid soft stack 10240
392grid hard stack 32768
393grid soft nproc 2047
394grid hard nproc 16384
395
396查看 /etc/pam.d/login 文件：                                                                                  
397
398auth       substack     system-auth
399auth       include      postlogin
400account    required     pam_nologin.so
401account    include      system-auth
402password   include      system-auth
403session    required     pam_selinux.so close
404session    required     pam_loginuid.so
405session    required     pam_selinux.so open
406session    required     pam_namespace.so
407session    optional     pam_keyinit.so force revoke
408session    include      system-auth
409session    include      postlogin
410-session   optional     pam_ck_connector.so
411session required pam_limits.so
412session required /lib64/security/pam_limits.so
413
414#==============================================================#                                                                                  
415配置 /dev/shm                                                                                       
416#==============================================================#                                                                                  
417
418/dev/mapper/openeuler-root /                       ext4    defaults        1 1
419UUID=07e6a80f-f2f4-42f8-a1ad-df05bd354960 /boot                   ext4    defaults        1 2
420/dev/mapper/openeuler-swap none                    swap    defaults        0 0
421tmpfs /dev/shm tmpfs size=7612400k 0 0
422
423#==============================================================#                                                                                  
424安装 rlwrap 插件                                                                                  
425#==============================================================#                                                                                  
426
427成功安装 rlwrap： rlwrap 0.44                                                                      
428
429#==============================================================#                                                                                  
430Root 用户环境变量                                                                                  
431#==============================================================#                                                                                  
432
433if [ -f ~/.bashrc ]; then
434        . ~/.bashrc
435fi
436PATH=$PATH:$HOME/bin
437export PATH
438alias so='su - oracle'
439export PS1="[`whoami`@`hostname`:"'$PWD]$ '
440alias sg='su - grid'
441alias crsctl='/u01/app/19.3.0/grid/bin/crsctl'
442alias srvctl='/u01/app/19.3.0/grid/bin/srvctl'
443
444#==============================================================#                                                                                  
445Oracle 用户环境变量，实例名：lucifer1                                                                                  
446#==============================================================#                                                                                  
447
448[ -f ~/.bashrc ] && . ~/.bashrc
449umask 022
450export TMP=/tmp
451export TMPDIR=$TMP
452export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
453export ORACLE_BASE=/u01/app/oracle
454export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db
455export ORACLE_TERM=xterm
456export TNS_ADMIN=$ORACLE_HOME/network/admin
457export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
458export ORACLE_SID=lucifer1
459export PATH=/usr/sbin:$PATH
460export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/perl/bin:$PATH
461export PERL5LIB=$ORACLE_HOME/perl/lib
462alias sas='sqlplus / as sysdba'
463alias awr='sqlplus / as sysdba @?/rdbms/admin/awrrpt'
464alias ash='sqlplus / as sysdba @?/rdbms/admin/ashrpt'
465alias alert='vi $ORACLE_BASE/diag/rdbms/*/$ORACLE_SID/trace/alert_$ORACLE_SID.log'
466export PS1="[`whoami`@`hostname`:"'$PWD]$ '
467export CV_ASSUME_DISTID=OL7
468alias sqlplus='rlwrap sqlplus'
469alias rman='rlwrap rman'
470alias adrci='rlwrap adrci'
471
472#==============================================================#                                                                                  
473Grid 用户环境变量                                                                                  
474#==============================================================#                                                                                  
475
476[ -f ~/.bashrc ] && . ~/.bashrc
477umask 022
478export TMP=/tmp
479export TMPDIR=$TMP
480export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
481export ORACLE_BASE=/u01/app/grid
482export ORACLE_HOME=/u01/app/19.3.0/grid
483export ORACLE_TERM=xterm
484export TNS_ADMIN=$ORACLE_HOME/network/admin
485export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
486export ORACLE_SID=+ASM1
487export PATH=/usr/sbin:$PATH
488export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
489alias sas='sqlplus / as sysasm'
490export PS1="[`whoami`@`hostname`:"'$PWD]$ '
491export CV_ASSUME_DISTID=OL7
492alias sqlplus='rlwrap sqlplus'
493alias asmcmd='rlwrap asmcmd'
494alias adrci='rlwrap adrci'
495
496#==============================================================#                                                                                  
497配置 multipath 多路径                                                                                  
498#==============================================================#                                                                                  
499
5001469.451287 | asm_ocr_1: addmap [0 20971520 multipath 0 0 1 1 service-time 0 1 1 8:16 1]
5011469.645569 | asm_data_1: addmap [0 104857600 multipath 0 0 1 1 service-time 0 1 1 8:32 1]
502create: asm_ocr_1 (2e87e4f535c397171) undef ROCKET,IMAGEFILE
503size=10G features='0' hwhandler='0' wp=undef
504`-+- policy='service-time 0' prio=1 status=undef
505  `- 3:0:0:0 sdb 8:16 undef ready running
506create: asm_data_1 (2f218dae15b551c5d) undef ROCKET,IMAGEFILE
507size=50G features='0' hwhandler='0' wp=undef
508`-+- policy='service-time 0' prio=1 status=undef
509  `- 3:0:0:1 sdc 8:32 undef ready running
510
511#==============================================================#                                                                                  
512配置 UDEV 绑盘                                                                                    
513#==============================================================#                                                                                  
514
515KERNEL=="dm-*",ENV{DM_UUID}=="mpath-2e87e4f535c397171",SYMLINK+="asm_ocr_1",OWNER="grid",GROUP="asmadmin",MODE="0660"
516KERNEL=="dm-*",ENV{DM_UUID}=="mpath-2f218dae15b551c5d",SYMLINK+="asm_data_1",OWNER="grid",GROUP="asmadmin",MODE="0660"
517
518/dev/asm_data_1
519/dev/asm_ocr_1
520
521UDEV 配置完成!                                                                                    
522
523#==============================================================#                                                                                  
524配置 RAC 节点：192.168.6.131                                                                                  
525#==============================================================#                                                                                  
526
527正在节点：192.168.6.131 上执行脚本：                                                                                  
528
529   ███████                             ██          ████████ ██               ██  ██ ██                    ██              ██  ██
530  ██░░░░░██                           ░██         ██░░░░░░ ░██              ░██ ░██░██                   ░██             ░██ ░██
531 ██     ░░██ ██████  ██████    █████  ░██  █████ ░██       ░██       █████  ░██ ░██░██ ███████   ██████ ██████  ██████   ░██ ░██
532░██      ░██░░██░░█ ░░░░░░██  ██░░░██ ░██ ██░░░██░█████████░██████  ██░░░██ ░██ ░██░██░░██░░░██ ██░░░░ ░░░██░  ░░░░░░██  ░██ ░██
533░██      ░██ ░██ ░   ███████ ░██  ░░  ░██░███████░░░░░░░░██░██░░░██░███████ ░██ ░██░██ ░██  ░██░░█████   ░██    ███████  ░██ ░██
534░░██     ██  ░██    ██░░░░██ ░██   ██ ░██░██░░░░        ░██░██  ░██░██░░░░  ░██ ░██░██ ░██  ░██ ░░░░░██  ░██   ██░░░░██  ░██ ░██
535 ░░███████  ░███   ░░████████░░█████  ███░░██████ ████████ ░██  ░██░░██████ ███ ███░██ ███  ░██ ██████   ░░██ ░░████████ ███ ███
536  ░░░░░░░   ░░░     ░░░░░░░░  ░░░░░  ░░░  ░░░░░░ ░░░░░░░░  ░░   ░░  ░░░░░░ ░░░ ░░░ ░░ ░░░   ░░ ░░░░░░     ░░   ░░░░░░░░ ░░░ ░░░ 
537
538
539
540#==============================================================#                                                                                  
541配置本地 YUM 源                                                                                  
542#==============================================================#                                                                                  
543
544[openEuler]
545name=openEuler
546baseurl=file:////mnt
547enabled=1
548gpgcheck=1
549gpgkey=file:////mnt/RPM-GPG-KEY-openEuler
550
551#==============================================================#                                                                                  
552打印系统信息                                                                                    
553#==============================================================#                                                                                  
554
555服务器时间:                                                                                      
556
557Fri Mar 29 03:13:56 PM CST 2024
558
559操作系统版本:                                                                                   
560
561NAME="openEuler"
562VERSION="22.03 (LTS-SP3)"
563ID="openEuler"
564VERSION_ID="22.03"
565PRETTY_NAME="openEuler 22.03 (LTS-SP3)"
566ANSI_COLOR="0;31"
567
568
569内核信息:                                                                                         
570
571Linux version 5.10.0-182.0.0.95.oe2203sp3.x86_64 (root@dc-64g.compass-ci) (gcc_old (GCC) 10.3.1, GNU ld (GNU Binutils) 2.37) #1 SMP Sat Dec 30 13:10:36 CST 2023
572
573服务器属性:                                                                                      
574
575vmware
576
577cpu信息:                                                                                            
578
579Architecture:                       x86_64
580CPU op-mode(s):                     32-bit, 64-bit
581Address sizes:                      43 bits physical, 48 bits virtual
582Byte Order:                         Little Endian
583CPU(s):                             8
584On-line CPU(s) list:                0-7
585Vendor ID:                          GenuineIntel
586BIOS Vendor ID:                     GenuineIntel
587Model name:                         Intel(R) Xeon(R) CPU E5-2630 v2 @ 2.60GHz
588BIOS Model name:                          Intel(R) Xeon(R) CPU E5-2630 v2 @ 2.60GHz
589CPU family:                         6
590Model:                              62
591Thread(s) per core:                 1
592Core(s) per socket:                 1
593Socket(s):                          8
594Stepping:                           4
595BogoMIPS:                           5187.49
596Flags:                              fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ss syscall nx rdtscp lm constant_tsc arch_perfmon nopl xtopology tsc_reliable nonstop_tsc cpuid pni pclmulqdq ssse3 cx16 pcid sse4_1 sse4_2 x2apic popcnt tsc_deadline_timer aes xsave avx f16c rdrand hypervisor lahf_lm cpuid_fault pti ssbd ibrs ibpb stibp fsgsbase tsc_adjust smep arat md_clear flush_l1d arch_capabilities
597Hypervisor vendor:                  VMware
598Virtualization type:                full
599L1d cache:                          256 KiB (8 instances)
600L1i cache:                          256 KiB (8 instances)
601L2 cache:                           2 MiB (8 instances)
602L3 cache:                           120 MiB (8 instances)
603NUMA node(s):                       1
604NUMA node0 CPU(s):                  0-7
605Vulnerability Gather data sampling: Not affected
606Vulnerability Itlb multihit:        KVM: Mitigation: VMX unsupported
607Vulnerability L1tf:                 Mitigation; PTE Inversion
608Vulnerability Mds:                  Mitigation; Clear CPU buffers; SMT Host state unknown
609Vulnerability Meltdown:             Mitigation; PTI
610Vulnerability Mmio stale data:      Unknown: No mitigations
611Vulnerability Retbleed:             Mitigation; IBRS
612Vulnerability Spec rstack overflow: Not affected
613Vulnerability Spec store bypass:    Mitigation; Speculative Store Bypass disabled via prctl and seccomp
614Vulnerability Spectre v1:           Mitigation; usercopy/swapgs barriers and __user pointer sanitization
615Vulnerability Spectre v2:           Mitigation; IBRS, IBPB conditional, STIBP disabled, RSB filling, PBRSB-eIBRS Not affected
616Vulnerability Srbds:                Not affected
617Vulnerability Tsx async abort:      Not affected
618
619内存信息:                                                                                         
620
621               total        used        free      shared  buff/cache   available
622Mem:            7433         451        6664           8         574        6982
623Swap:           8187           0        8187
624               total        used        free      shared  buff/cache   available
625Mem:           7.3Gi       451Mi       6.5Gi       8.7Mi       574Mi       6.8Gi
626Swap:          8.0Gi          0B       8.0Gi
627
628挂载信息:                                                                                         
629
630/dev/mapper/openeuler-root /                       ext4    defaults        1 1
631UUID=3b8b94fa-6595-453b-938d-16b973646ae1 /boot                   ext4    defaults        1 2
632/dev/mapper/openeuler-swap none                    swap    defaults        0 0
633
634目录信息:                                                                                         
635
636Filesystem                  Size  Used Avail Use% Mounted on
637devtmpfs                    4.0M     0  4.0M   0% /dev
638tmpfs                       3.7G     0  3.7G   0% /dev/shm
639tmpfs                       1.5G  8.8M  1.5G   1% /run
640tmpfs                       4.0M     0  4.0M   0% /sys/fs/cgroup
641/dev/mapper/openeuler-root   90G  2.4G   83G   3% /
642tmpfs                       3.7G     0  3.7G   0% /tmp
643/dev/sda1                   974M  174M  733M  20% /boot
644/dev/sr0                     18G   18G     0 100% /mnt
645
646#==============================================================#                                                                                  
647禁用防火墙                                                                                       
648#==============================================================#                                                                                  
649
650○ firewalld.service - firewalld - dynamic firewall daemon
651     Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)
652     Active: inactive (dead)
653       Docs: man:firewalld(1)
654
655Mar 29 14:49:38 openEuler02 systemd[1]: Starting firewalld - dynamic firewall daemon...
656Mar 29 14:49:39 openEuler02 systemd[1]: Started firewalld - dynamic firewall daemon.
657Mar 29 15:13:56 openEuler02 systemd[1]: Stopping firewalld - dynamic firewall daemon...
658Mar 29 15:13:57 openEuler02 systemd[1]: firewalld.service: Deactivated successfully.
659Mar 29 15:13:57 openEuler02 systemd[1]: Stopped firewalld - dynamic firewall daemon.
660
661#==============================================================#                                                                                  
662禁用 SELinux                                                                                        
663#==============================================================#                                                                                  
664
665SELinux status:                 enabled
666SELinuxfs mount:                /sys/fs/selinux
667SELinux root directory:         /etc/selinux
668Loaded policy name:             targeted
669Current mode:                   permissive
670Mode from config file:          disabled
671Policy MLS status:              enabled
672Policy deny_unknown status:     allowed
673Memory protection checking:     actual (secure)
674Max kernel policy version:      33
675
676#==============================================================#                                                                                  
677配置 nsysctl.conf                                                                                   
678#==============================================================#                                                                                  
679
680NOZEROCONF=yes
681
682#==============================================================#                                                                                  
683YUM 静默安装依赖包                                                                                  
684#==============================================================#                                                                                  
685
686bc-1.07.1-12.oe2203sp3.x86_64
687binutils-2.37-24.oe2203sp3.x86_64
688package compat-libcap1 is not installed
689gcc-10.3.1-49.oe2203sp3.x86_64
690gcc-c++-10.3.1-49.oe2203sp3.x86_64
691package elfutils-libelf is not installed
692package elfutils-libelf-devel is not installed
693glibc-2.34-143.oe2203sp3.x86_64
694glibc-devel-2.34-143.oe2203sp3.x86_64
695libaio-0.3.113-9.oe2203sp3.x86_64
696libaio-devel-0.3.113-9.oe2203sp3.x86_64
697libgcc-10.3.1-49.oe2203sp3.x86_64
698libstdc++-10.3.1-49.oe2203sp3.x86_64
699libstdc++-devel-10.3.1-49.oe2203sp3.x86_64
700libxcb-1.15-1.oe2203sp3.x86_64
701libX11-1.7.2-8.oe2203sp3.x86_64
702libXau-1.0.10-1.oe2203sp3.x86_64
703libXi-1.8-2.oe2203sp3.x86_64
704libXrender-0.9.10-12.oe2203sp3.x86_64
705make-4.3-4.oe2203sp3.x86_64
706net-tools-2.10-3.oe2203sp3.x86_64
707smartmontools-7.2-2.oe2203sp3.x86_64
708sysstat-12.5.4-9.oe2203sp3.x86_64
709e2fsprogs-1.46.4-24.oe2203sp3.x86_64
710package e2fsprogs-libs is not installed
711unzip-6.0-50.oe2203sp3.x86_64
712openssh-clients-8.8p1-23.oe2203sp3.x86_64
713readline-8.1-3.oe2203sp3.x86_64
714readline-devel-8.1-3.oe2203sp3.x86_64
715psmisc-23.5-2.oe2203sp3.x86_64
716ksh-2020.0.0-10.oe2203sp3.x86_64
717nfs-utils-2.5.4-15.oe2203sp3.x86_64
718tar-1.34-5.oe2203sp3.x86_64
719package device-mapper-multipath is not installed
720avahi-0.8-18.oe2203sp3.x86_64
721ntp-4.2.8p15-13.oe2203sp3.x86_64
722chrony-4.1-6.oe2203sp3.x86_64
723libXtst-1.2.4-1.oe2203sp3.x86_64
724libXrender-devel-0.9.10-12.oe2203sp3.x86_64
725fontconfig-devel-2.13.94-3.oe2203sp3.x86_64
726policycoreutils-3.3-8.oe2203sp3.x86_64
727package policycoreutils-python is not installed
728libcap-devel-2.61-6.oe2203sp3.x86_64
729xorg-x11-utils-7.5-31.oe2203sp3.x86_64
730xorg-x11-xauth-1.1.2-1.oe2203sp3.x86_64
731glibc-compat-2.17-2.34-143.oe2203sp3.x86_64
732elfutils-0.185-18.oe2203sp3.x86_64
733elfutils-devel-0.185-18.oe2203sp3.x86_64
734libnsl2-devel-2.0.0-5.oe2203sp3.x86_64
735package librdmacm is not installed
736libnsl-2.34-143.oe2203sp3.x86_64
737package libibverbs is not installed
738package compat-openssl10 is not installed
739policycoreutils-python-utils-3.3-8.oe2203sp3.noarch
740
741#==============================================================#                                                                                  
742配置主机名                                                                                       
743#==============================================================#                                                                                  
744
745 Static hostname: openeuler02
746       Icon name: computer-vm
747         Chassis: vm
748      Machine ID: 0bd1701e143a461fa6e237ae9d4d9f5d
749         Boot ID: a2e49180dc274d06a9751930095c4228
750  Virtualization: vmware
751Operating System: openEuler 22.03 (LTS-SP3)
752          Kernel: Linux 5.10.0-182.0.0.95.oe2203sp3.x86_64
753    Architecture: x86-64
754 Hardware Vendor: VMware, Inc.
755  Hardware Model: VMware Virtual Platform
756
757#==============================================================#                                                                                  
758配置 /etc/hosts 文件                                                                                  
759#==============================================================#                                                                                  
760
761127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
762::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
763192.168.6.130 openeuler01
764192.168.6.132 openeuler01-vip
7651.1.1.1 openeuler01-priv
766192.168.6.131 openeuler02
767192.168.6.133 openeuler02-vip
7681.1.1.2 openeuler02-priv
769192.168.6.134 openeuler-scan
770
771#==============================================================#                                                                                  
772创建用户和组                                                                                    
773#==============================================================#                                                                                  
774
775oracle 用户：                                                                                      
776
777uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba),54327(asmdba),54328(asmoper),54329(asmadmin)
778
779grid 用户：                                                                                        
780
781uid=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)
782
783
784#==============================================================#                                                                                  
785配置 Avahi-daemon 服务                                                                                  
786#==============================================================#                                                                                  
787
788○ avahi-daemon.service - Avahi mDNS/DNS-SD Stack
789     Loaded: loaded (/usr/lib/systemd/system/avahi-daemon.service; disabled; vendor preset: enabled)
790     Active: inactive (dead)
791TriggeredBy: ○ avahi-daemon.socket
792
793#==============================================================#                                                                                  
794配置透明大页 && NUMA && 磁盘 IO 调度器                                                                                  
795#==============================================================#                                                                                  
796
797args="ro resume=/dev/mapper/openeuler-swap rd.lvm.lv=openeuler/root rd.lvm.lv=openeuler/swap cgroup_disable=files apparmor=0 crashkernel=512M rhgb quiet numa=off transparent_hugepage=never elevator=deadline"
798-resume=/dev/mapper/openeuler-swap
799-args="ro
800args="ro resume=/dev/mapper/openeuler-swap rd.lvm.lv=openeuler/root rd.lvm.lv=openeuler/swap cgroup_disable=files apparmor=0 crashkernel=512M rhgb quiet numa=off transparent_hugepage=never elevator=deadline"
801-rhgb
802-crashkernel=512M
803
804#==============================================================#                                                                                  
805配置 sysctl.conf                                                                                    
806#==============================================================#                                                                                  
807
808kernel.sysrq = 0
809net.ipv4.ip_forward = 0
810net.ipv4.conf.all.send_redirects = 0
811net.ipv4.conf.default.send_redirects = 0
812net.ipv4.conf.all.accept_source_route = 0
813net.ipv4.conf.default.accept_source_route = 0
814net.ipv4.conf.all.accept_redirects = 0
815net.ipv4.conf.default.accept_redirects = 0
816net.ipv4.conf.all.secure_redirects = 0
817net.ipv4.conf.default.secure_redirects = 0
818net.ipv4.icmp_echo_ignore_broadcasts = 1
819net.ipv4.icmp_ignore_bogus_error_responses = 1
820net.ipv4.conf.all.rp_filter = 1
821net.ipv4.conf.default.rp_filter = 1
822net.ipv4.tcp_syncookies = 1
823kernel.dmesg_restrict = 1
824net.ipv6.conf.all.accept_redirects = 0
825net.ipv6.conf.default.accept_redirects = 0
826fs.aio-max-nr = 1048576
827fs.file-max = 6815744
828kernel.shmall = 2097152
829kernel.shmmax = 7795085311
830kernel.shmmni = 4096
831kernel.sem = 250 32000 100 128
832net.ipv4.ip_local_port_range = 9000 65500
833net.core.rmem_default = 262144
834net.core.rmem_max = 4194304
835net.core.wmem_default = 262144
836net.core.wmem_max = 1048576
837vm.min_free_kbytes = 30449
838net.ipv4.conf.ens33.rp_filter = 1
839vm.swappiness = 10
840kernel.panic_on_oops = 1
841kernel.randomize_va_space = 2
842kernel.numa_balancing = 0
843net.ipv4.conf.ens37.rp_filter = 2
844
845#==============================================================#                                                                                  
846配置 RemoveIPC                                                                                      
847#==============================================================#                                                                                  
848
849[Login]
850RemoveIPC=no
851
852#==============================================================#                                                                                  
853配置 /etc/security/limits.conf 和 /etc/pam.d/login                                                                                  
854#==============================================================#                                                                                  
855
856查看 /etc/security/limits.conf：                                                                                  
857
858oracle soft nofile 1024
859oracle hard nofile 65536
860oracle soft stack 10240
861oracle hard stack 32768
862oracle soft nproc 2047
863oracle hard nproc 16384
864oracle hard memlock unlimited
865oracle soft memlock unlimited
866grid soft nofile 1024
867grid hard nofile 65536
868grid soft stack 10240
869grid hard stack 32768
870grid soft nproc 2047
871grid hard nproc 16384
872
873查看 /etc/pam.d/login 文件：                                                                                  
874
875auth       substack     system-auth
876auth       include      postlogin
877account    required     pam_nologin.so
878account    include      system-auth
879password   include      system-auth
880session    required     pam_selinux.so close
881session    required     pam_loginuid.so
882session    required     pam_selinux.so open
883session    required     pam_namespace.so
884session    optional     pam_keyinit.so force revoke
885session    include      system-auth
886session    include      postlogin
887-session   optional     pam_ck_connector.so
888session required pam_limits.so
889session required /lib64/security/pam_limits.so
890
891#==============================================================#                                                                                  
892配置 /dev/shm                                                                                       
893#==============================================================#                                                                                  
894
895/dev/mapper/openeuler-root /                       ext4    defaults        1 1
896UUID=3b8b94fa-6595-453b-938d-16b973646ae1 /boot                   ext4    defaults        1 2
897/dev/mapper/openeuler-swap none                    swap    defaults        0 0
898tmpfs /dev/shm tmpfs size=7612388k 0 0
899
900#==============================================================#                                                                                  
901安装 rlwrap 插件                                                                                  
902#==============================================================#                                                                                  
903
904成功安装 rlwrap： rlwrap 0.44                                                                      
905
906#==============================================================#                                                                                  
907Root 用户环境变量                                                                                  
908#==============================================================#                                                                                  
909
910if [ -f ~/.bashrc ]; then
911        . ~/.bashrc
912fi
913PATH=$PATH:$HOME/bin
914export PATH
915alias so='su - oracle'
916export PS1="[`whoami`@`hostname`:"'$PWD]$ '
917alias sg='su - grid'
918alias crsctl='/u01/app/19.3.0/grid/bin/crsctl'
919alias srvctl='/u01/app/19.3.0/grid/bin/srvctl'
920
921#==============================================================#                                                                                  
922Oracle 用户环境变量，实例名：lucifer2                                                                                  
923#==============================================================#                                                                                  
924
925[ -f ~/.bashrc ] && . ~/.bashrc
926umask 022
927export TMP=/tmp
928export TMPDIR=$TMP
929export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
930export ORACLE_BASE=/u01/app/oracle
931export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db
932export ORACLE_TERM=xterm
933export TNS_ADMIN=$ORACLE_HOME/network/admin
934export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
935export ORACLE_SID=lucifer2
936export PATH=/usr/sbin:$PATH
937export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/perl/bin:$PATH
938export PERL5LIB=$ORACLE_HOME/perl/lib
939alias sas='sqlplus / as sysdba'
940alias awr='sqlplus / as sysdba @?/rdbms/admin/awrrpt'
941alias ash='sqlplus / as sysdba @?/rdbms/admin/ashrpt'
942alias alert='vi $ORACLE_BASE/diag/rdbms/*/$ORACLE_SID/trace/alert_$ORACLE_SID.log'
943export PS1="[`whoami`@`hostname`:"'$PWD]$ '
944export CV_ASSUME_DISTID=OL7
945alias sqlplus='rlwrap sqlplus'
946alias rman='rlwrap rman'
947alias adrci='rlwrap adrci'
948
949#==============================================================#                                                                                  
950Grid 用户环境变量                                                                                  
951#==============================================================#                                                                                  
952
953[ -f ~/.bashrc ] && . ~/.bashrc
954umask 022
955export TMP=/tmp
956export TMPDIR=$TMP
957export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
958export ORACLE_BASE=/u01/app/grid
959export ORACLE_HOME=/u01/app/19.3.0/grid
960export ORACLE_TERM=xterm
961export TNS_ADMIN=$ORACLE_HOME/network/admin
962export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
963export ORACLE_SID=+ASM2
964export PATH=/usr/sbin:$PATH
965export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
966alias sas='sqlplus / as sysasm'
967export PS1="[`whoami`@`hostname`:"'$PWD]$ '
968export CV_ASSUME_DISTID=OL7
969alias sqlplus='rlwrap sqlplus'
970alias asmcmd='rlwrap asmcmd'
971alias adrci='rlwrap adrci'
972
973#==============================================================#                                                                                  
974配置 multipath 多路径                                                                                  
975#==============================================================#                                                                                  
976
9771765.943440 | asm_ocr_1: addmap [0 20971520 multipath 0 0 1 1 service-time 0 1 1 8:16 1]
9781766.204540 | asm_data_1: addmap [0 104857600 multipath 0 0 1 1 service-time 0 1 1 8:32 1]
979create: asm_ocr_1 (2e87e4f535c397171) undef ROCKET,IMAGEFILE
980size=10G features='0' hwhandler='0' wp=undef
981`-+- policy='service-time 0' prio=1 status=undef
982  `- 3:0:0:0 sdb 8:16 undef ready running
983create: asm_data_1 (2f218dae15b551c5d) undef ROCKET,IMAGEFILE
984size=50G features='0' hwhandler='0' wp=undef
985`-+- policy='service-time 0' prio=1 status=undef
986  `- 3:0:0:1 sdc 8:32 undef ready running
987
988#==============================================================#                                                                                  
989配置 UDEV 绑盘                                                                                    
990#==============================================================#                                                                                  
991
992KERNEL=="dm-*",ENV{DM_UUID}=="mpath-2e87e4f535c397171",SYMLINK+="asm_ocr_1",OWNER="grid",GROUP="asmadmin",MODE="0660"
993KERNEL=="dm-*",ENV{DM_UUID}=="mpath-2f218dae15b551c5d",SYMLINK+="asm_data_1",OWNER="grid",GROUP="asmadmin",MODE="0660"
994
995/dev/asm_data_1
996/dev/asm_ocr_1
997
998UDEV 配置完成!                                                                                    
999
1000配置 RAC 节点：192.168.6.131 结束!                                                                                  
1001
1002#==============================================================#                                                                                  
1003配置 GRID 用户 SSH 互信                                                                                  
1004#==============================================================#                                                                                  
1005
1006Generating public/private rsa key pair.
1007Your identification has been saved in /home/grid/.ssh/id_rsa
1008Your public key has been saved in /home/grid/.ssh/id_rsa.pub
1009The key fingerprint is:
1010SHA256:y7Hmr8fLTuQsIl+R0BrljMRKpJ78CVn4YlDUV5mnwqU grid@openeuler01
1011The key's randomart image is:
1012+---[RSA 3072]----+
1013| .oo....oo       |
1014| . oo.o*+ .      |
1015|. o..++o+o       |
1016| + =. E+..       |
1017|  O . ..S .      |
1018| . + . . O       |
1019|    + . B.+      |
1020|     o = +o      |
1021|      . o==.     |
1022+----[SHA256]-----+
1023
1024#==============================================================#                                                                                  
1025配置 ORACLE 用户 SSH 互信                                                                                  
1026#==============================================================#                                                                                  
1027
1028Generating public/private rsa key pair.
1029Your identification has been saved in /home/oracle/.ssh/id_rsa
1030Your public key has been saved in /home/oracle/.ssh/id_rsa.pub
1031The key fingerprint is:
1032SHA256:9MGel36DBMDynQztOGkEn80kfybfS+B+rnpF+YZzRB8 oracle@openeuler01
1033The key's randomart image is:
1034+---[RSA 3072]----+
1035|      .oo..      |
1036|      ..+X.    E.|
1037|       ++BO.+  oo|
1038|       .*o=X +o o|
1039|       .S.+ *.o+ |
1040|           = o+.+|
1041|            +.=+ |
1042|            .+ . |
1043|          .o...  |
1044+----[SHA256]-----+
1045
1046#==============================================================#                                                                                  
1047静默解压缩 Grid 软件包                                                                                  
1048#==============================================================#                                                                                  
1049
1050正在静默解压缩 Grid 软件包，请稍等：                                                                                  
1051
1052.---- -. -. .  .   .        .
1053( .',----- - - ' '      '                                         __
1054 \_/      ;--:-          __--------------------___  ____=========_||___
1055__U__n_^_''__[.  ooo___  | |_!_||_!_||_!_||_!_| |   |..|_i_|..|_i_|..|
1056c(_ ..(_ ..(_ ..( /,,,,,,] | |___||___||___||___| |   |                |
1057,_\___________'_|,L______],|______________________|_i,!________________!_i
1058/;_(@)(@)==(@)(@)   (o)(o)      (o)^(o)--(o)^(o)          (o)(o)-(o)(o)
1059""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"'""
1060
1061
1062静默解压 Grid 软件安装包： /soft/LINUX.X64_193000_grid_home.zip                                                                                  
1063
1064静默解压 OPatch 软件补丁包： /soft/p6880880_190000_Linux-x86-64.zip                                                                                  
1065
1066静默解压 Grid 软件补丁包： /soft/p35940989_190000_Linux-x86-64.zip                                                                                  
1067
1068#==============================================================#                                                                                  
1069静默解压 Oracle 软件包                                                                                  
1070#==============================================================#                                                                                  
1071
1072正在静默解压缩 Oracle 软件包，请稍等：                                                                                  
1073
1074.---- -. -. .  .   .        .
1075( .',----- - - ' '      '                                         __
1076 \_/      ;--:-          __--------------------___  ____=========_||___
1077__U__n_^_''__[.  ooo___  | |_!_||_!_||_!_||_!_| |   |..|_i_|..|_i_|..|
1078c(_ ..(_ ..(_ ..( /,,,,,,] | |___||___||___||___| |   |                |
1079,_\___________'_|,L______],|______________________|_i,!________________!_i
1080/;_(@)(@)==(@)(@)   (o)(o)      (o)^(o)--(o)^(o)          (o)(o)-(o)(o)
1081""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"'""
1082
1083静默解压 Oracle 软件安装包： /soft/p13390677_112040_Linux-x86-64_1of7.zip,/soft/p13390677_112040_Linux-x86-64_2of7.zip                                                                                  
1084
1085静默解压 Oracle 软件补丁包： /soft/p35574075_112040_Linux-x86-64.zip                                                                                  
1086
1087静默解压 Oracle 软件补丁包：/soft/p33991024_11204220118_Generic.zip                                                                                  
1088
1089静默解压 OJVM 软件补丁包： /soft/p35685663_112040_Linux-x86-64.zip                                                                                  
1090
1091#==============================================================#                                                                                  
1092Grid 安装静默文件                                                                                  
1093#==============================================================#                                                                                  
1094
1095INVENTORY_LOCATION=/u01/app/oraInventory
1096oracle.install.option=CRS_CONFIG
1097ORACLE_BASE=/u01/app/grid
1098oracle.install.asm.OSDBA=asmdba
1099oracle.install.asm.OSOPER=asmoper
1100oracle.install.asm.OSASM=asmadmin
1101oracle.install.crs.config.gpnp.scanName=openeuler-scan
1102oracle.install.crs.config.gpnp.scanPort=1521
1103oracle.install.crs.config.clusterName=openeuler-cls
1104oracle.install.crs.config.gpnp.configureGNS=false
1105oracle.install.crs.config.clusterNodes=openeuler01:openeuler01-vip,openeuler02:openeuler02-vip
1106oracle.install.crs.config.networkInterfaceList=ens33:192.168.6.0:1,ens37:1.1.1.0:5
1107oracle.install.crs.config.useIPMI=false
1108oracle.install.asm.SYSASMPassword=oracle
1109oracle.install.asm.diskGroup.name=OCR
1110oracle.install.asm.diskGroup.redundancy=EXTERNAL
1111oracle.install.asm.diskGroup.disks=/dev/asm_ocr_1
1112oracle.install.asm.diskGroup.diskDiscoveryString=/dev/asm*
1113oracle.install.asm.monitorPassword=oracle
1114oracle.install.crs.config.ClusterConfiguration=STANDALONE
1115oracle.install.crs.config.configureAsExtendedCluster=false
1116oracle.install.crs.configureGIMR=false
1117oracle.install.asm.storageOption=ASM
1118oracle.install.asm.diskGroup.AUSize=4
1119oracle.install.asm.configureAFD=false
1120oracle.install.crs.config.ignoreDownNodes=false
1121oracle.install.config.managementOption=NONE
1122oracle.install.crs.rootconfig.executeRootScript=false
1123oracle.install.responseFileVersion=/oracle/install/rspfmt_crsinstall_response_schema_v19.0.0
1124oracle.install.crs.config.scanType=LOCAL_SCAN
1125
1126#==============================================================#                                                                                  
1127静默安装 Grid 软件                                                                                  
1128#==============================================================#                                                                                  
1129
1130Preparing the home to patch...
1131Applying the patch /soft/35940989...
1132Successfully applied the patch.
1133The log can be found at: /tmp/GridSetupActions2024-03-29_03-24-27PM/installerPatchActions_2024-03-29_03-24-27PM.log
1134Launching Oracle Grid Infrastructure Setup Wizard...
1135
1136[WARNING] [INS-30011] The SYS password entered does not conform to the Oracle recommended standards.
1137   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].
1138   ACTION: Provide a password that conforms to the Oracle recommended standards.
1139[WARNING] [INS-30011] The ASMSNMP password entered does not conform to the Oracle recommended standards.
1140   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].
1141   ACTION: Provide a password that conforms to the Oracle recommended standards.
1142The response file for this session can be found at:
1143 /u01/app/19.3.0/grid/install/response/grid_2024-03-29_03-24-27PM.rsp
1144
1145You can find the log of this install session at:
1146 /tmp/GridSetupActions2024-03-29_03-24-27PM/gridSetupActions2024-03-29_03-24-27PM.log
1147
1148As a root user, execute the following script(s):
1149        1. /u01/app/oraInventory/orainstRoot.sh
1150        2. /u01/app/19.3.0/grid/root.sh
1151
1152Execute /u01/app/oraInventory/orainstRoot.sh on the following nodes: 
1153[openeuler01, openeuler02]
1154Execute /u01/app/19.3.0/grid/root.sh on the following nodes: 
1155[openeuler01, openeuler02]
1156
1157Run the script on the local node first. After successful completion, you can start the script in parallel on all other nodes.
1158
1159Successfully Setup Software.
1160As install user, execute the following command to complete the configuration.
1161        /u01/app/19.3.0/grid/gridSetup.sh -executeConfigTools -responseFile /soft/grid.rsp [-silent]
1162
1163
1164Moved the install session logs to:
1165 /u01/app/oraInventory/logs/GridSetupActions2024-03-29_03-24-27PM
1166
1167#==============================================================#                                                                                  
1168执行 root 脚本                                                                                    
1169#==============================================================#                                                                                  
1170
1171节点 192.168.6.130 ：                                                                                  
1172
1173Changing permissions of /u01/app/oraInventory.
1174Adding read,write permissions for group.
1175Removing read,write,execute permissions for world.
1176
1177Changing groupname of /u01/app/oraInventory to oinstall.
1178The execution of the script is complete.
1179Check /u01/app/19.3.0/grid/install/root_openeuler01_2024-03-29_15-56-43-828462409.log for the output of root script
1180
1181节点 192.168.6.131 ：                                                                                  
1182
1183Changing permissions of /u01/app/oraInventory.
1184Adding read,write permissions for group.
1185Removing read,write,execute permissions for world.
1186
1187Changing groupname of /u01/app/oraInventory to oinstall.
1188The execution of the script is complete.
1189Check /u01/app/19.3.0/grid/install/root_openeuler02_2024-03-29_16-05-40-207970145.log for the output of root script
1190
1191#==============================================================#                                                                                  
1192Grid 软件版本                                                                                     
1193#==============================================================#                                                                                  
1194
1195
1196SQL*Plus: Release 19.0.0.0.0 - Production
1197Version 19.22.0.0.0
1198
1199
1200#==============================================================#                                                                                  
1201Grid 补丁信息                                                                                     
1202#==============================================================#                                                                                  
1203
120436115038;TOMCAT RELEASE UPDATE 19.0.0.0.0 (36115038)
120535967489;OCW RELEASE UPDATE 19.22.0.0.0 (35967489)
120635956421;ACFS RELEASE UPDATE 19.22.0.0.0 (35956421)
120735943157;Database Release Update : 19.22.0.0.240116 (35943157)
120833575402;DBWLM RELEASE UPDATE 19.0.0.0.0 (33575402)
1209
1210OPatch succeeded.
1211
1212
1213#==============================================================#                                                                                  
1214ASM 磁盘组创建                                                                                   
1215#==============================================================#                                                                                  
1216
1217State    Type    Rebal  Sector  Logical_Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
1218MOUNTED  EXTERN  N         512             512   4096  1048576     51200    51092                0           51092              0             N  DATA/
1219MOUNTED  EXTERN  N         512             512   4096  4194304     10240     9900                0            9900              0             Y  OCR/
1220
1221#==============================================================#                                                                                  
1222Grid 资源检查                                                                                     
1223#==============================================================#                                                                                  
1224
1225--------------------------------------------------------------------------------
1226Name           Target  State        Server                   State details       
1227--------------------------------------------------------------------------------
1228Local Resources
1229--------------------------------------------------------------------------------
1230ora.LISTENER.lsnr
1231               ONLINE  ONLINE       openeuler01              STABLE
1232               ONLINE  ONLINE       openeuler02              STABLE
1233ora.chad
1234               ONLINE  ONLINE       openeuler01              STABLE
1235               ONLINE  ONLINE       openeuler02              STABLE
1236ora.net1.network
1237               ONLINE  ONLINE       openeuler01              STABLE
1238               ONLINE  ONLINE       openeuler02              STABLE
1239ora.ons
1240               ONLINE  ONLINE       openeuler01              STABLE
1241               ONLINE  ONLINE       openeuler02              STABLE
1242--------------------------------------------------------------------------------
1243Cluster Resources
1244--------------------------------------------------------------------------------
1245ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1246      1        ONLINE  ONLINE       openeuler01              STABLE
1247      2        ONLINE  ONLINE       openeuler02              STABLE
1248ora.DATA.dg(ora.asmgroup)
1249      1        ONLINE  ONLINE       openeuler01              STABLE
1250      2        ONLINE  ONLINE       openeuler02              STABLE
1251ora.LISTENER_SCAN1.lsnr
1252      1        ONLINE  ONLINE       openeuler01              STABLE
1253ora.OCR.dg(ora.asmgroup)
1254      1        ONLINE  ONLINE       openeuler01              STABLE
1255      2        ONLINE  ONLINE       openeuler02              STABLE
1256ora.asm(ora.asmgroup)
1257      1        ONLINE  ONLINE       openeuler01              STABLE
1258      2        ONLINE  ONLINE       openeuler02              Started,STABLE
1259ora.asmnet1.asmnetwork(ora.asmgroup)
1260      1        ONLINE  ONLINE       openeuler01              STABLE
1261      2        ONLINE  ONLINE       openeuler02              STABLE
1262ora.cvu
1263      1        ONLINE  ONLINE       openeuler01              STABLE
1264ora.openeuler01.vip
1265      1        ONLINE  ONLINE       openeuler01              STABLE
1266ora.openeuler02.vip
1267      1        ONLINE  ONLINE       openeuler02              STABLE
1268ora.qosmserver
1269      1        ONLINE  ONLINE       openeuler01              STABLE
1270ora.scan1.vip
1271      1        ONLINE  ONLINE       openeuler01              STABLE
1272--------------------------------------------------------------------------------
1273
1274
1275#==============================================================#                                                                                  
1276Oracle 安装静默文件                                                                                  
1277#==============================================================#                                                                                  
1278
1279oracle.install.option=INSTALL_DB_SWONLY
1280UNIX_GROUP_NAME=oinstall
1281INVENTORY_LOCATION=/u01/app/oraInventory
1282ORACLE_BASE=/u01/app/oracle
1283oracle.install.db.InstallEdition=EE
1284oracle.install.db.DBA_GROUP=dba
1285oracle.install.db.OPER_GROUP=oper
1286oracle.install.db.CLUSTER_NODES=openeuler01,openeuler02
1287oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0
1288SELECTED_LANGUAGES=en,zh_CN
1289ORACLE_HOME=/u01/app/oracle/product/11.2.0/db
1290DECLINE_SECURITY_UPDATES=true
1291oracle.installer.autoupdates.option=SKIP_UPDATES
1292
1293#==============================================================#                                                                                  
1294静默安装数据库软件                                                                                  
1295#==============================================================#                                                                                  
1296
1297Starting Oracle Universal Installer...
1298
1299Checking Temp space: must be greater than 120 MB.   Actual 3716 MB    Passed
1300Checking swap space: must be greater than 150 MB.   Actual 8158 MB    Passed
1301Preparing to launch Oracle Universal Installer from /tmp/OraInstall2024-03-29_04-14-32PM. Please wait ...You can find the log of this install session at:
1302 /u01/app/oraInventory/logs/installActions2024-03-29_04-14-32PM.log
1303
1304Prepare in progress.
1305..................................................   9% Done.
1306
1307Prepare successful.
1308
1309Copy files in progress.
1310..................................................   14% Done.
1311..................................................   19% Done.
1312..................................................   25% Done.
1313..................................................   30% Done.
1314..................................................   36% Done.
1315..................................................   41% Done.
1316..................................................   46% Done.
1317..................................................   51% Done.
1318..................................................   56% Done.
1319
1320Copy files successful.
1321..........
1322Link binaries in progress.
1323
1324Link binaries successful.
1325..................................................   77% Done.
1326
1327Setup files in progress.
1328..................................................   94% Done.
1329
1330Setup files successful.
1331The installation of Oracle Database 11g was successful.
1332Please check '/u01/app/oraInventory/logs/silentInstall2024-03-29_04-14-32PM.log' for more details.
1333
1334Execute Root Scripts in progress.
1335
1336As a root user, execute the following script(s):
1337        1. /u01/app/oracle/product/11.2.0/db/root.sh
1338
1339Execute /u01/app/oracle/product/11.2.0/db/root.sh on the following nodes: 
1340[openeuler01, openeuler02]
1341
1342..................................................   100% Done.
1343
1344Execute Root Scripts successful.
1345Successfully Setup Software.
1346
1347#==============================================================#                                                                                  
1348执行 root 脚本                                                                                    
1349#==============================================================#                                                                                  
1350
1351节点 192.168.6.130 ：                                                                                  
1352
1353Changing permissions of /u01/app/oraInventory.
1354Adding read,write permissions for group.
1355Removing read,write,execute permissions for world.
1356
1357Changing groupname of /u01/app/oraInventory to oinstall.
1358The execution of the script is complete.
1359Check /u01/app/oracle/product/11.2.0/db/install/root_openeuler01_2024-03-29_16-27-59.log for the output of root script
1360
1361节点 192.168.6.131 ：                                                                                  
1362
1363Changing permissions of /u01/app/oraInventory.
1364Adding read,write permissions for group.
1365Removing read,write,execute permissions for world.
1366
1367Changing groupname of /u01/app/oraInventory to oinstall.
1368The execution of the script is complete.
1369Check /u01/app/oracle/product/11.2.0/db/install/root_openeuler02_2024-03-29_16-27-30.log for the output of root script
1370
1371#==============================================================#                                                                                  
1372Oracle 软件安装补丁                                                                                  
1373#==============================================================#                                                                                  
1374
1375节点 192.168.6.130 ：                                                                                  
1376
1377Oracle Interim Patch Installer version 11.2.0.3.44
1378Copyright (c) 2024, Oracle Corporation.  All rights reserved.
1379
1380PREREQ session
1381
1382Oracle Home       : /u01/app/oracle/product/11.2.0/db
1383Central Inventory : /u01/app/oraInventory
1384   from           : /u01/app/oracle/product/11.2.0/db/oraInst.loc
1385OPatch version    : 11.2.0.3.44
1386OUI version       : 11.2.0.4.0
1387Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-29_16-28-13PM_1.log
1388
1389Invoking prereq "checkconflictagainstohwithdetail"
1390
1391Prereq "checkConflictAgainstOHWithDetail" passed.
1392
1393OPatch succeeded.
1394Oracle Interim Patch Installer version 11.2.0.3.44
1395Copyright (c) 2024, Oracle Corporation.  All rights reserved.
1396
1397
1398Oracle Home       : /u01/app/oracle/product/11.2.0/db
1399Central Inventory : /u01/app/oraInventory
1400   from           : /u01/app/oracle/product/11.2.0/db/oraInst.loc
1401OPatch version    : 11.2.0.3.44
1402OUI version       : 11.2.0.4.0
1403Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-29_16-28-24PM_1.log
1404
1405Verifying environment and performing prerequisite checks...
1406OPatch continues with these patches:   17478514  18031668  18522509  19121551  19769489  20299013  20760982  21352635  21948347  22502456  23054359  24006111  24732075  25869727  26609445  26392168  26925576  27338049  27734982  28204707  28729262  29141056  29497421  29913194  30298532  30670774  31103343  31537677  31983472  32328626  32758711  33128584  33477185  33711103  34057724  34386237  34677698  34998337  35269283  35574075  
1407
1408Do you want to proceed? [y|n]
1409Y (auto-answered by -silent)
1410User Responded with: Y
1411All checks passed.
1412
1413Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
1414(Oracle Home = '/u01/app/oracle/product/11.2.0/db')
1415
1416
1417Is the local system ready for patching? [y|n]
1418Y (auto-answered by -silent)
1419User Responded with: Y
1420Backing up files...
1421Applying sub-patch '17478514' to OH '/u01/app/oracle/product/11.2.0/db'
1422
1423Patching component oracle.rdbms, 11.2.0.4.0...
1424
1425Patching component oracle.rdbms.rsf, 11.2.0.4.0...
1426
1427Patching component oracle.sdo, 11.2.0.4.0...
1428
1429Patching component oracle.sysman.agent, 10.2.0.4.5...
1430
1431Patching component oracle.xdk, 11.2.0.4.0...
1432
1433Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
1434
1435Patching component oracle.sdo.locator, 11.2.0.4.0...
1436
1437Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...
1438
1439Patching component oracle.xdk.rsf, 11.2.0.4.0...
1440
1441Patching component oracle.rdbms.rman, 11.2.0.4.0...
1442Applying sub-patch '18031668' to OH '/u01/app/oracle/product/11.2.0/db'
1443
1444Patching component oracle.rdbms, 11.2.0.4.0...
1445
1446Patching component oracle.rdbms.rsf, 11.2.0.4.0...
1447
1448Patching component oracle.ldap.rsf, 11.2.0.4.0...
1449
1450Patching component oracle.rdbms.crs, 11.2.0.4.0...
1451
1452Patching component oracle.precomp.common, 11.2.0.4.0...
1453
1454Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...
1455
1456Patching component oracle.rdbms.deconfig, 11.2.0.4.0...
1457
1458Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
1459
1460Patching component oracle.rdbms.rman, 11.2.0.4.0...
1461Applying sub-patch '18522509' to OH '/u01/app/oracle/product/11.2.0/db'
1462
1463Patching component oracle.rdbms.rsf, 11.2.0.4.0...
1464
1465Patching component oracle.rdbms, 11.2.0.4.0...
1466
1467Patching component oracle.precomp.common, 11.2.0.4.0...
1468
1469Patching component oracle.rdbms.rman, 11.2.0.4.0...
1470
1471Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
1472
1473Patching component oracle.rdbms.deconfig, 11.2.0.4.0...
1474Applying sub-patch '19121551' to OH '/u01/app/oracle/product/11.2.0/db'
1475
1476Patching component oracle.precomp.common, 11.2.0.4.0...
1477
1478Patching component oracle.sysman.console.db, 11.2.0.4.0...
1479
1480Patching component oracle.rdbms.rsf, 11.2.0.4.0...
1481
1482Patching component oracle.rdbms.rman, 11.2.0.4.0...
1483
1484Patching component oracle.rdbms, 11.2.0.4.0...
1485
1486Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
1487
1488Patching component oracle.ordim.client, 11.2.0.4.0...
1489
1490Patching component oracle.ordim.jai, 11.2.0.4.0...
1491Applying sub-patch '19769489' to OH '/u01/app/oracle/product/11.2.0/db'
1492ApplySession: Optional component(s) [ oracle.sysman.agent, 11.2.0.4.0 ]  not present in the Oracle Home or a higher version is found.
1493
1494Patching component oracle.precomp.common, 11.2.0.4.0...
1495
1496Patching component oracle.ovm, 11.2.0.4.0...
1497
1498Patching component oracle.xdk, 11.2.0.4.0...
1499
1500Patching component oracle.rdbms.util, 11.2.0.4.0...
1501
1502Patching component oracle.rdbms, 11.2.0.4.0...
1503
1504Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
1505
1506Patching component oracle.xdk.parser.java, 11.2.0.4.0...
1507
1508Patching component oracle.oraolap, 11.2.0.4.0...
1509
1510Patching component oracle.rdbms.rsf, 11.2.0.4.0...
1511
1512Patching component oracle.xdk.rsf, 11.2.0.4.0...
1513
1514Patching component oracle.rdbms.rman, 11.2.0.4.0...
1515
1516Patching component oracle.rdbms.deconfig, 11.2.0.4.0...
1517Applying sub-patch '20299013' to OH '/u01/app/oracle/product/11.2.0/db'
1518
1519Patching component oracle.rdbms.dv, 11.2.0.4.0...
1520
1521Patching component oracle.rdbms.oci, 11.2.0.4.0...
1522
1523Patching component oracle.precomp.common, 11.2.0.4.0...
1524
1525Patching component oracle.sysman.agent, 10.2.0.4.5...
1526
1527Patching component oracle.xdk, 11.2.0.4.0...
1528
1529Patching component oracle.sysman.common, 10.2.0.4.5...
1530
1531Patching component oracle.rdbms, 11.2.0.4.0...
1532
1533Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
1534
1535Patching component oracle.xdk.parser.java, 11.2.0.4.0...
1536
1537Patching component oracle.sysman.console.db, 11.2.0.4.0...
1538
1539Patching component oracle.xdk.rsf, 11.2.0.4.0...
1540
1541Patching component oracle.rdbms.rsf, 11.2.0.4.0...
1542
1543Patching component oracle.sysman.common.core, 10.2.0.4.5...
1544
1545Patching component oracle.rdbms.rman, 11.2.0.4.0...
1546
1547Patching component oracle.rdbms.deconfig, 11.2.0.4.0...
1548Applying sub-patch '20760982' to OH '/u01/app/oracle/product/11.2.0/db'
1549
1550Patching component oracle.sysman.console.db, 11.2.0.4.0...
1551
1552Patching component oracle.rdbms, 11.2.0.4.0...
1553
1554Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
1555
1556Patching component oracle.rdbms.rsf, 11.2.0.4.0...
1557Applying sub-patch '21352635' to OH '/u01/app/oracle/product/11.2.0/db'
1558
1559Patching component oracle.sysman.agent, 10.2.0.4.5...
1560
1561Patching component oracle.rdbms.rsf, 11.2.0.4.0...
1562
1563Patching component oracle.rdbms.rman, 11.2.0.4.0...
1564
1565Patching component oracle.rdbms, 11.2.0.4.0...
1566Applying sub-patch '21948347' to OH '/u01/app/oracle/product/11.2.0/db'
1567ApplySession: Optional component(s) [ oracle.tfa, 11.2.0.4.0 ]  not present in the Oracle Home or a higher version is found.
1568
1569Patching component oracle.sysman.agent, 10.2.0.4.5...
1570
1571Patching component oracle.ovm, 11.2.0.4.0...
1572
1573Patching component oracle.xdk, 11.2.0.4.0...
1574
1575Patching component oracle.rdbms, 11.2.0.4.0...
1576
1577Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...
1578
1579Patching component oracle.xdk.parser.java, 11.2.0.4.0...
1580
1581Patching component oracle.sysman.console.db, 11.2.0.4.0...
1582
1583Patching component oracle.xdk.rsf, 11.2.0.4.0...
1584
1585Patching component oracle.rdbms.rsf, 11.2.0.4.0...
1586
1587Patching component oracle.sysman.oms.core, 10.2.0.4.5...
1588Applying sub-patch '22502456' to OH '/u01/app/oracle/product/11.2.0/db'
1589ApplySession: Optional component(s) [ oracle.tfa, 11.2.0.4.0 ]  not present in the Oracle Home or a higher version is found.
1590
1591Patching component oracle.precomp.common, 11.2.0.4.0...
1592
1593Patching component oracle.oraolap.dbscripts, 11.2.0.4.0...
1594
1595Patching component oracle.rdbms.olap, 11.2.0.4.0...
1596
1597Patching component oracle.oraolap, 11.2.0.4.0...
1598
1599Patching component oracle.rdbms.rsf, 11.2.0.4.0...
1600
1601Patching component oracle.rdbms.rman, 11.2.0.4.0...
1602
1603Patching component oracle.rdbms, 11.2.0.4.0...
1604
1605Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
1606Applying sub-patch '23054359' to OH '/u01/app/oracle/product/11.2.0/db'
1607
1608Patching component oracle.rdbms.dv, 11.2.0.4.0...
1609
1610Patching component oracle.rdbms, 11.2.0.4.0...
1611
1612Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
1613
1614Patching component oracle.rdbms.rsf, 11.2.0.4.0...
1615Applying sub-patch '24006111' to OH '/u01/app/oracle/product/11.2.0/db'
1616
1617Patching component oracle.sqlplus.ic, 11.2.0.4.0...
1618
1619Patching component oracle.sqlplus, 11.2.0.4.0...
1620
1621Patching component oracle.rdbms.rsf, 11.2.0.4.0...
1622
1623Patching component oracle.rdbms, 11.2.0.4.0...
1624
1625Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
1626Applying sub-patch '24732075' to OH '/u01/app/oracle/product/11.2.0/db'
1627
1628Patching component oracle.precomp.common, 11.2.0.4.0...
1629
1630Patching component oracle.sysman.plugin.db.main.agent, 11.2.0.4.0...
1631
1632Patching component oracle.sqlplus.ic, 11.2.0.4.0...
1633
1634Patching component oracle.sqlplus, 11.2.0.4.0...
1635
1636Patching component oracle.rdbms.rsf, 11.2.0.4.0...
1637
1638Patching component oracle.rdbms, 11.2.0.4.0...
1639
1640Patching component oracle.rdbms.util, 11.2.0.4.0...
1641
1642Patching component oracle.ordim.client, 11.2.0.4.0...
1643
1644Patching component oracle.ordim.jai, 11.2.0.4.0...
1645
1646Patching component oracle.ordim.server, 11.2.0.4.0...
1647Applying sub-patch '25869727' to OH '/u01/app/oracle/product/11.2.0/db'
1648ApplySession: Optional component(s) [ oracle.oid.client, 11.2.0.4.0 ]  not present in the Oracle Home or a higher version is found.
1649
1650Patching component oracle.ldap.rsf, 11.2.0.4.0...
1651
1652Patching component oracle.oracore.rsf, 11.2.0.4.0...
1653
1654Patching component oracle.rdbms, 11.2.0.4.0...
1655
1656Patching component oracle.rdbms.rsf, 11.2.0.4.0...
1657
1658Patching component oracle.rdbms.rman, 11.2.0.4.0...
1659Applying sub-patch '26609445' to OH '/u01/app/oracle/product/11.2.0/db'
1660
1661Patching component oracle.oracore.rsf, 11.2.0.4.0...
1662
1663Patching component oracle.rdbms, 11.2.0.4.0...
1664Applying sub-patch '26392168' to OH '/u01/app/oracle/product/11.2.0/db'
1665ApplySession: Optional component(s) [ oracle.oid.client, 11.2.0.4.0 ]  not present in the Oracle Home or a higher version is found.
1666
1667Patching component oracle.network.rsf, 11.2.0.4.0...
1668
1669Patching component oracle.ldap.client, 11.2.0.4.0...
1670
1671Patching component oracle.sysman.agent, 10.2.0.4.5...
1672
1673Patching component oracle.xdk, 11.2.0.4.0...
1674
1675Patching component oracle.rdbms, 11.2.0.4.0...
1676
1677Patching component oracle.network.listener, 11.2.0.4.0...
1678
1679Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
1680
1681Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...
1682
1683Patching component oracle.xdk.parser.java, 11.2.0.4.0...
1684
1685Patching component oracle.xdk.rsf, 11.2.0.4.0...
1686
1687Patching component oracle.rdbms.rsf, 11.2.0.4.0...
1688
1689Patching component oracle.rdbms.rman, 11.2.0.4.0...
1690Applying sub-patch '26925576' to OH '/u01/app/oracle/product/11.2.0/db'
1691
1692Patching component oracle.rdbms, 11.2.0.4.0...
1693
1694Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
1695
1696Patching component oracle.rdbms.rman, 11.2.0.4.0...
1697
1698Patching component oracle.rdbms.rsf, 11.2.0.4.0...
1699Applying sub-patch '27338049' to OH '/u01/app/oracle/product/11.2.0/db'
1700
1701Patching component oracle.assistants.server, 11.2.0.4.0...
1702
1703Patching component oracle.rdbms.rsf, 11.2.0.4.0...
1704
1705Patching component oracle.rdbms, 11.2.0.4.0...
1706
1707Patching component oracle.rdbms.rman, 11.2.0.4.0...
1708
1709Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
1710Applying sub-patch '27734982' to OH '/u01/app/oracle/product/11.2.0/db'
1711
1712Patching component oracle.ctx, 11.2.0.4.0...
1713
1714Patching component oracle.rdbms.rsf, 11.2.0.4.0...
1715
1716Patching component oracle.ctx.rsf, 11.2.0.4.0...
1717
1718Patching component oracle.rdbms, 11.2.0.4.0...
1719
1720Patching component oracle.rdbms.rman, 11.2.0.4.0...
1721Applying sub-patch '28204707' to OH '/u01/app/oracle/product/11.2.0/db'
1722Applying changes to emctl script on the home: /u01/app/oracle/product/11.2.0/db ...
1723
1724Patching component oracle.rdbms, 11.2.0.4.0...
1725
1726Patching component oracle.oracore.rsf, 11.2.0.4.0...
1727
1728Patching component oracle.rdbms.rsf, 11.2.0.4.0...
1729
1730Patching component oracle.ldap.rsf, 11.2.0.4.0...
1731
1732Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...
1733
1734Patching component oracle.network.rsf, 11.2.0.4.0...
1735
1736Patching component oracle.sysman.agent, 10.2.0.4.5...
1737
1738Patching component oracle.sysman.console.db, 11.2.0.4.0...
1739
1740Patching component oracle.ldap.security.osdt, 11.2.0.4.0...
1741
1742Patching component oracle.ldap.owm, 11.2.0.4.0...
1743
1744Patching component oracle.sqlplus.rsf, 11.2.0.4.0...
1745
1746Patching component oracle.ctx, 11.2.0.4.0...
1747Applying sub-patch '28729262' to OH '/u01/app/oracle/product/11.2.0/db'
1748INFO: Script isn't applicable to this port!
1749
1750Patching component oracle.rdbms, 11.2.0.4.0...
1751
1752Patching component oracle.rdbms.rsf, 11.2.0.4.0...
1753
1754Patching component oracle.rdbms.util, 11.2.0.4.0...
1755
1756Patching component oracle.ldap.rsf, 11.2.0.4.0...
1757
1758Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...
1759
1760Patching component oracle.network.rsf, 11.2.0.4.0...
1761
1762Patching component oracle.rdbms.rman, 11.2.0.4.0...
1763
1764Patching component oracle.ctx, 11.2.0.4.0...
1765Applying sub-patch '29141056' to OH '/u01/app/oracle/product/11.2.0/db'
1766
1767Patching component oracle.rdbms, 11.2.0.4.0...
1768
1769Patching component oracle.rdbms.rman, 11.2.0.4.0...
1770
1771Patching component oracle.oracore.rsf, 11.2.0.4.0...
1772
1773Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
1774
1775Patching component oracle.rdbms.rsf, 11.2.0.4.0...
1776Applying sub-patch '29497421' to OH '/u01/app/oracle/product/11.2.0/db'
1777
1778Patching component oracle.rdbms, 11.2.0.4.0...
1779
1780Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
1781
1782Patching component oracle.rdbms.rman, 11.2.0.4.0...
1783
1784Patching component oracle.rdbms.rsf, 11.2.0.4.0...
1785
1786Patching component oracle.ldap.rsf, 11.2.0.4.0...
1787
1788Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...
1789
1790Patching component oracle.oracore.rsf, 11.2.0.4.0...
1791
1792Patching component oracle.ctx, 11.2.0.4.0...
1793Applying sub-patch '29913194' to OH '/u01/app/oracle/product/11.2.0/db'
1794
1795Patching component oracle.rdbms, 11.2.0.4.0...
1796
1797Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
1798
1799Patching component oracle.rdbms.rsf, 11.2.0.4.0...
1800
1801Patching component oracle.network.rsf, 11.2.0.4.0...
1802
1803Patching component oracle.ldap.rsf, 11.2.0.4.0...
1804
1805Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...
1806
1807Patching component oracle.rdbms.util, 11.2.0.4.0...
1808Applying sub-patch '30298532' to OH '/u01/app/oracle/product/11.2.0/db'
1809ApplySession: Optional component(s) [ oracle.rdbms.tg4tera, 11.2.0.4.0 ] , [ oracle.rdbms.tg4sybs, 11.2.0.4.0 ] , [ oracle.rdbms.tg4ifmx, 11.2.0.4.0 ] , [ oracle.rdbms.tg4db2, 11.2.0.4.0 ] , [ oracle.rdbms.tg4msql, 11.2.0.4.0 ]  not present in the Oracle Home or a higher version is found.
1810
1811Patching component oracle.rdbms.rsf, 11.2.0.4.0...
1812
1813Patching component oracle.rdbms, 11.2.0.4.0...
1814
1815Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
1816
1817Patching component oracle.rdbms.hsodbc, 11.2.0.4.0...
1818
1819Patching component oracle.ldap.rsf, 11.2.0.4.0...
1820
1821Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...
1822Applying sub-patch '30670774' to OH '/u01/app/oracle/product/11.2.0/db'
1823
1824Patching component oracle.rdbms.rsf, 11.2.0.4.0...
1825
1826Patching component oracle.rdbms, 11.2.0.4.0...
1827
1828Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
1829
1830Patching component oracle.network.rsf, 11.2.0.4.0...
1831
1832Patching component oracle.ldap.rsf, 11.2.0.4.0...
1833
1834Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...
1835
1836Patching component oracle.swd.oui, 11.2.0.4.0...
1837
1838Patching component oracle.ctx, 11.2.0.4.0...
1839Applying sub-patch '31103343' to OH '/u01/app/oracle/product/11.2.0/db'
1840
1841Patching component oracle.rdbms, 11.2.0.4.0...
1842
1843Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
1844
1845Patching component oracle.rdbms.rsf, 11.2.0.4.0...
1846Applying sub-patch '31537677' to OH '/u01/app/oracle/product/11.2.0/db'
1847
1848Patching component oracle.rdbms, 11.2.0.4.0...
1849
1850Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
1851
1852Patching component oracle.rdbms.rsf, 11.2.0.4.0...
1853
1854Patching component oracle.rdbms.dv, 11.2.0.4.0...
1855
1856Patching component oracle.rdbms.rman, 11.2.0.4.0...
1857
1858Patching component oracle.ldap.rsf, 11.2.0.4.0...
1859
1860Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...
1861
1862Patching component oracle.oracore.rsf, 11.2.0.4.0...
1863
1864Patching component oracle.rdbms.util, 11.2.0.4.0...
1865
1866Patching component oracle.dbdev, 11.2.0.4.0...
1867
1868Patching component oracle.ctx, 11.2.0.4.0...
1869
1870Patching component oracle.buildtools.rsf, 11.2.0.4.0...
1871Applying sub-patch '31983472' to OH '/u01/app/oracle/product/11.2.0/db'
1872
1873Patching component oracle.rdbms.rsf, 11.2.0.4.0...
1874
1875Patching component oracle.rdbms, 11.2.0.4.0...
1876
1877Patching component oracle.ctx, 11.2.0.4.0...
1878Applying sub-patch '32328626' to OH '/u01/app/oracle/product/11.2.0/db'
1879
1880Patching component oracle.rdbms, 11.2.0.4.0...
1881
1882Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
1883
1884Patching component oracle.rdbms.rsf, 11.2.0.4.0...
1885
1886Patching component oracle.rdbms.dv, 11.2.0.4.0...
1887
1888Patching component oracle.rdbms.rman, 11.2.0.4.0...
1889
1890Patching component oracle.ldap.rsf, 11.2.0.4.0...
1891
1892Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...
1893Applying sub-patch '32758711' to OH '/u01/app/oracle/product/11.2.0/db'
1894
1895Patching component oracle.rdbms, 11.2.0.4.0...
1896
1897Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
1898
1899Patching component oracle.ctx, 11.2.0.4.0...
1900
1901Patching component oracle.network.rsf, 11.2.0.4.0...
1902Applying sub-patch '33128584' to OH '/u01/app/oracle/product/11.2.0/db'
1903
1904Patching component oracle.rdbms, 11.2.0.4.0...
1905
1906Patching component oracle.rdbms.rsf, 11.2.0.4.0...
1907
1908Patching component oracle.ctx, 11.2.0.4.0...
1909Applying sub-patch '33477185' to OH '/u01/app/oracle/product/11.2.0/db'
1910
1911Patching component oracle.rdbms, 11.2.0.4.0...
1912
1913Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
1914
1915Patching component oracle.rdbms.rsf, 11.2.0.4.0...
1916
1917Patching component oracle.network.rsf, 11.2.0.4.0...
1918
1919Patching component oracle.rdbms.dv, 11.2.0.4.0...
1920Applying sub-patch '33711103' to OH '/u01/app/oracle/product/11.2.0/db'
1921ApplySession: Optional component(s) [ oracle.rdbms.tg4tera, 11.2.0.4.0 ] , [ oracle.rdbms.tg4sybs, 11.2.0.4.0 ] , [ oracle.rdbms.tg4msql, 11.2.0.4.0 ] , [ oracle.rdbms.tg4ifmx, 11.2.0.4.0 ] , [ oracle.rdbms.tg4db2, 11.2.0.4.0 ]  not present in the Oracle Home or a higher version is found.
1922
1923Patching component oracle.rdbms.rsf, 11.2.0.4.0...
1924
1925Patching component oracle.rdbms, 11.2.0.4.0...
1926
1927Patching component oracle.rdbms.rsf, 11.2.0.4.0...
1928
1929Patching component oracle.network.rsf, 11.2.0.4.0...
1930
1931Patching component oracle.rdbms.hsodbc, 11.2.0.4.0...
1932
1933Patching component oracle.rdbms.hs_common, 11.2.0.4.0...
1934
1935Patching component oracle.buildtools.rsf, 11.2.0.4.0...
1936
1937Patching component oracle.buildtools.rsf, 11.2.0.4.0...
1938Applying sub-patch '34057724' to OH '/u01/app/oracle/product/11.2.0/db'
1939ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.4.0 ]  not present in the Oracle Home or a higher version is found.
1940
1941Patching component oracle.rdbms, 11.2.0.4.0...
1942
1943Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
1944
1945Patching component oracle.rdbms.rsf, 11.2.0.4.0...
1946
1947Patching component oracle.network.rsf, 11.2.0.4.0...
1948
1949Patching component oracle.ldap.rsf, 11.2.0.4.0...
1950
1951Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...
1952
1953Patching component oracle.swd.oui.core, 11.2.0.4.0...
1954Applying sub-patch '34386237' to OH '/u01/app/oracle/product/11.2.0/db'
1955ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.4.0 ]  not present in the Oracle Home or a higher version is found.
1956
1957Patching component oracle.rdbms, 11.2.0.4.0...
1958
1959Patching component oracle.rdbms.rsf, 11.2.0.4.0...
1960
1961Patching component oracle.network.rsf, 11.2.0.4.0...
1962
1963Patching component oracle.swd.oui.core, 11.2.0.4.0...
1964
1965Patching component oracle.ctx, 11.2.0.4.0...
1966Applying sub-patch '34677698' to OH '/u01/app/oracle/product/11.2.0/db'
1967ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.4.0 ]  not present in the Oracle Home or a higher version is found.
1968
1969Patching component oracle.rdbms, 11.2.0.4.0...
1970
1971Patching component oracle.rdbms.rsf, 11.2.0.4.0...
1972
1973Patching component oracle.javavm.containers, 11.2.0.4.0...
1974Applying sub-patch '34998337' to OH '/u01/app/oracle/product/11.2.0/db'
1975ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.4.0 ]  not present in the Oracle Home or a higher version is found.
1976
1977Patching component oracle.rdbms, 11.2.0.4.0...
1978
1979Patching component oracle.rdbms.rsf, 11.2.0.4.0...
1980Applying sub-patch '35269283' to OH '/u01/app/oracle/product/11.2.0/db'
1981ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.4.0 ]  not present in the Oracle Home or a higher version is found.
1982
1983Patching component oracle.rdbms, 11.2.0.4.0...
1984
1985Patching component oracle.network.rsf, 11.2.0.4.0...
1986
1987Patching component oracle.rdbms.rsf, 11.2.0.4.0...
1988
1989Patching component oracle.dbdev, 11.2.0.4.0...
1990Applying sub-patch '35574075' to OH '/u01/app/oracle/product/11.2.0/db'
1991ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.4.0 ]  not present in the Oracle Home or a higher version is found.
1992
1993Patching component oracle.rdbms, 11.2.0.4.0...
1994
1995Patching component oracle.rdbms.rsf, 11.2.0.4.0...
1996
1997Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
1998
1999Patching component oracle.network.rsf, 11.2.0.4.0...
2000
2001Patching component oracle.rdbms.rsf, 11.2.0.4.0...
2002
2003Patching component oracle.sysman.oms.core, 10.2.0.4.5...
2004
2005Patching component oracle.marvel, 11.2.0.4.0...
2006
2007Patching component oracle.javavm.containers, 11.2.0.4.0...
2008
2009Patching component oracle.dbjava.ucp, 11.2.0.4.0...
2010
2011Patching component oracle.owb.rsf, 11.2.0.4.0...
2012
2013Patching component oracle.sysman.ccr, 10.3.8.1.0...
2014
2015Patching component oracle.sysman.ccr.client, 10.3.2.1.0...
2016
2017Patching component oracle.sysman.common, 10.2.0.4.5...
2018
2019Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
2020
2021Patching component oracle.javavm.containers, 11.2.0.4.0...
2022Composite patch 35574075 successfully applied.
2023Log file location: /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-29_16-28-24PM_1.log
2024
2025OPatch succeeded.
2026
2027节点 192.168.6.131 ：                                                                                  
2028
2029Oracle Interim Patch Installer version 11.2.0.3.44
2030Copyright (c) 2024, Oracle Corporation.  All rights reserved.
2031
2032PREREQ session
2033
2034Oracle Home       : /u01/app/oracle/product/11.2.0/db
2035Central Inventory : /u01/app/oraInventory
2036   from           : /u01/app/oracle/product/11.2.0/db/oraInst.loc
2037OPatch version    : 11.2.0.3.44
2038OUI version       : 11.2.0.4.0
2039Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-29_16-42-10PM_1.log
2040
2041Invoking prereq "checkconflictagainstohwithdetail"
2042
2043Prereq "checkConflictAgainstOHWithDetail" passed.
2044
2045OPatch succeeded.
2046Oracle Interim Patch Installer version 11.2.0.3.44
2047Copyright (c) 2024, Oracle Corporation.  All rights reserved.
2048
2049
2050Oracle Home       : /u01/app/oracle/product/11.2.0/db
2051Central Inventory : /u01/app/oraInventory
2052   from           : /u01/app/oracle/product/11.2.0/db/oraInst.loc
2053OPatch version    : 11.2.0.3.44
2054OUI version       : 11.2.0.4.0
2055Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-29_16-42-15PM_1.log
2056
2057Verifying environment and performing prerequisite checks...
2058OPatch continues with these patches:   17478514  18031668  18522509  19121551  19769489  20299013  20760982  21352635  21948347  22502456  23054359  24006111  24732075  25869727  26609445  26392168  26925576  27338049  27734982  28204707  28729262  29141056  29497421  29913194  30298532  30670774  31103343  31537677  31983472  32328626  32758711  33128584  33477185  33711103  34057724  34386237  34677698  34998337  35269283  35574075  
2059
2060Do you want to proceed? [y|n]
2061Y (auto-answered by -silent)
2062User Responded with: Y
2063All checks passed.
2064
2065Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
2066(Oracle Home = '/u01/app/oracle/product/11.2.0/db')
2067
2068
2069Is the local system ready for patching? [y|n]
2070Y (auto-answered by -silent)
2071User Responded with: Y
2072Backing up files...
2073Applying sub-patch '17478514' to OH '/u01/app/oracle/product/11.2.0/db'
2074
2075Patching component oracle.rdbms, 11.2.0.4.0...
2076
2077Patching component oracle.rdbms.rsf, 11.2.0.4.0...
2078
2079Patching component oracle.sdo, 11.2.0.4.0...
2080
2081Patching component oracle.sysman.agent, 10.2.0.4.5...
2082
2083Patching component oracle.xdk, 11.2.0.4.0...
2084
2085Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
2086
2087Patching component oracle.sdo.locator, 11.2.0.4.0...
2088
2089Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...
2090
2091Patching component oracle.xdk.rsf, 11.2.0.4.0...
2092
2093Patching component oracle.rdbms.rman, 11.2.0.4.0...
2094Applying sub-patch '18031668' to OH '/u01/app/oracle/product/11.2.0/db'
2095
2096Patching component oracle.rdbms, 11.2.0.4.0...
2097
2098Patching component oracle.rdbms.rsf, 11.2.0.4.0...
2099
2100Patching component oracle.ldap.rsf, 11.2.0.4.0...
2101
2102Patching component oracle.rdbms.crs, 11.2.0.4.0...
2103
2104Patching component oracle.precomp.common, 11.2.0.4.0...
2105
2106Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...
2107
2108Patching component oracle.rdbms.deconfig, 11.2.0.4.0...
2109
2110Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
2111
2112Patching component oracle.rdbms.rman, 11.2.0.4.0...
2113Applying sub-patch '18522509' to OH '/u01/app/oracle/product/11.2.0/db'
2114
2115Patching component oracle.rdbms.rsf, 11.2.0.4.0...
2116
2117Patching component oracle.rdbms, 11.2.0.4.0...
2118
2119Patching component oracle.precomp.common, 11.2.0.4.0...
2120
2121Patching component oracle.rdbms.rman, 11.2.0.4.0...
2122
2123Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
2124
2125Patching component oracle.rdbms.deconfig, 11.2.0.4.0...
2126Applying sub-patch '19121551' to OH '/u01/app/oracle/product/11.2.0/db'
2127
2128Patching component oracle.precomp.common, 11.2.0.4.0...
2129
2130Patching component oracle.sysman.console.db, 11.2.0.4.0...
2131
2132Patching component oracle.rdbms.rsf, 11.2.0.4.0...
2133
2134Patching component oracle.rdbms.rman, 11.2.0.4.0...
2135
2136Patching component oracle.rdbms, 11.2.0.4.0...
2137
2138Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
2139
2140Patching component oracle.ordim.client, 11.2.0.4.0...
2141
2142Patching component oracle.ordim.jai, 11.2.0.4.0...
2143Applying sub-patch '19769489' to OH '/u01/app/oracle/product/11.2.0/db'
2144ApplySession: Optional component(s) [ oracle.sysman.agent, 11.2.0.4.0 ]  not present in the Oracle Home or a higher version is found.
2145
2146Patching component oracle.precomp.common, 11.2.0.4.0...
2147
2148Patching component oracle.ovm, 11.2.0.4.0...
2149
2150Patching component oracle.xdk, 11.2.0.4.0...
2151
2152Patching component oracle.rdbms.util, 11.2.0.4.0...
2153
2154Patching component oracle.rdbms, 11.2.0.4.0...
2155
2156Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
2157
2158Patching component oracle.xdk.parser.java, 11.2.0.4.0...
2159
2160Patching component oracle.oraolap, 11.2.0.4.0...
2161
2162Patching component oracle.rdbms.rsf, 11.2.0.4.0...
2163
2164Patching component oracle.xdk.rsf, 11.2.0.4.0...
2165
2166Patching component oracle.rdbms.rman, 11.2.0.4.0...
2167
2168Patching component oracle.rdbms.deconfig, 11.2.0.4.0...
2169Applying sub-patch '20299013' to OH '/u01/app/oracle/product/11.2.0/db'
2170
2171Patching component oracle.rdbms.dv, 11.2.0.4.0...
2172
2173Patching component oracle.rdbms.oci, 11.2.0.4.0...
2174
2175Patching component oracle.precomp.common, 11.2.0.4.0...
2176
2177Patching component oracle.sysman.agent, 10.2.0.4.5...
2178
2179Patching component oracle.xdk, 11.2.0.4.0...
2180
2181Patching component oracle.sysman.common, 10.2.0.4.5...
2182
2183Patching component oracle.rdbms, 11.2.0.4.0...
2184
2185Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
2186
2187Patching component oracle.xdk.parser.java, 11.2.0.4.0...
2188
2189Patching component oracle.sysman.console.db, 11.2.0.4.0...
2190
2191Patching component oracle.xdk.rsf, 11.2.0.4.0...
2192
2193Patching component oracle.rdbms.rsf, 11.2.0.4.0...
2194
2195Patching component oracle.sysman.common.core, 10.2.0.4.5...
2196
2197Patching component oracle.rdbms.rman, 11.2.0.4.0...
2198
2199Patching component oracle.rdbms.deconfig, 11.2.0.4.0...
2200Applying sub-patch '20760982' to OH '/u01/app/oracle/product/11.2.0/db'
2201
2202Patching component oracle.sysman.console.db, 11.2.0.4.0...
2203
2204Patching component oracle.rdbms, 11.2.0.4.0...
2205
2206Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
2207
2208Patching component oracle.rdbms.rsf, 11.2.0.4.0...
2209Applying sub-patch '21352635' to OH '/u01/app/oracle/product/11.2.0/db'
2210
2211Patching component oracle.sysman.agent, 10.2.0.4.5...
2212
2213Patching component oracle.rdbms.rsf, 11.2.0.4.0...
2214
2215Patching component oracle.rdbms.rman, 11.2.0.4.0...
2216
2217Patching component oracle.rdbms, 11.2.0.4.0...
2218Applying sub-patch '21948347' to OH '/u01/app/oracle/product/11.2.0/db'
2219ApplySession: Optional component(s) [ oracle.tfa, 11.2.0.4.0 ]  not present in the Oracle Home or a higher version is found.
2220
2221Patching component oracle.sysman.agent, 10.2.0.4.5...
2222
2223Patching component oracle.ovm, 11.2.0.4.0...
2224
2225Patching component oracle.xdk, 11.2.0.4.0...
2226
2227Patching component oracle.rdbms, 11.2.0.4.0...
2228
2229Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...
2230
2231Patching component oracle.xdk.parser.java, 11.2.0.4.0...
2232
2233Patching component oracle.sysman.console.db, 11.2.0.4.0...
2234
2235Patching component oracle.xdk.rsf, 11.2.0.4.0...
2236
2237Patching component oracle.rdbms.rsf, 11.2.0.4.0...
2238
2239Patching component oracle.sysman.oms.core, 10.2.0.4.5...
2240Applying sub-patch '22502456' to OH '/u01/app/oracle/product/11.2.0/db'
2241ApplySession: Optional component(s) [ oracle.tfa, 11.2.0.4.0 ]  not present in the Oracle Home or a higher version is found.
2242
2243Patching component oracle.precomp.common, 11.2.0.4.0...
2244
2245Patching component oracle.oraolap.dbscripts, 11.2.0.4.0...
2246
2247Patching component oracle.rdbms.olap, 11.2.0.4.0...
2248
2249Patching component oracle.oraolap, 11.2.0.4.0...
2250
2251Patching component oracle.rdbms.rsf, 11.2.0.4.0...
2252
2253Patching component oracle.rdbms.rman, 11.2.0.4.0...
2254
2255Patching component oracle.rdbms, 11.2.0.4.0...
2256
2257Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
2258Applying sub-patch '23054359' to OH '/u01/app/oracle/product/11.2.0/db'
2259
2260Patching component oracle.rdbms.dv, 11.2.0.4.0...
2261
2262Patching component oracle.rdbms, 11.2.0.4.0...
2263
2264Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
2265
2266Patching component oracle.rdbms.rsf, 11.2.0.4.0...
2267Applying sub-patch '24006111' to OH '/u01/app/oracle/product/11.2.0/db'
2268
2269Patching component oracle.sqlplus.ic, 11.2.0.4.0...
2270
2271Patching component oracle.sqlplus, 11.2.0.4.0...
2272
2273Patching component oracle.rdbms.rsf, 11.2.0.4.0...
2274
2275Patching component oracle.rdbms, 11.2.0.4.0...
2276
2277Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
2278Applying sub-patch '24732075' to OH '/u01/app/oracle/product/11.2.0/db'
2279
2280Patching component oracle.precomp.common, 11.2.0.4.0...
2281
2282Patching component oracle.sysman.plugin.db.main.agent, 11.2.0.4.0...
2283
2284Patching component oracle.sqlplus.ic, 11.2.0.4.0...
2285
2286Patching component oracle.sqlplus, 11.2.0.4.0...
2287
2288Patching component oracle.rdbms.rsf, 11.2.0.4.0...
2289
2290Patching component oracle.rdbms, 11.2.0.4.0...
2291
2292Patching component oracle.rdbms.util, 11.2.0.4.0...
2293
2294Patching component oracle.ordim.client, 11.2.0.4.0...
2295
2296Patching component oracle.ordim.jai, 11.2.0.4.0...
2297
2298Patching component oracle.ordim.server, 11.2.0.4.0...
2299Applying sub-patch '25869727' to OH '/u01/app/oracle/product/11.2.0/db'
2300ApplySession: Optional component(s) [ oracle.oid.client, 11.2.0.4.0 ]  not present in the Oracle Home or a higher version is found.
2301
2302Patching component oracle.ldap.rsf, 11.2.0.4.0...
2303
2304Patching component oracle.oracore.rsf, 11.2.0.4.0...
2305
2306Patching component oracle.rdbms, 11.2.0.4.0...
2307
2308Patching component oracle.rdbms.rsf, 11.2.0.4.0...
2309
2310Patching component oracle.rdbms.rman, 11.2.0.4.0...
2311Applying sub-patch '26609445' to OH '/u01/app/oracle/product/11.2.0/db'
2312
2313Patching component oracle.oracore.rsf, 11.2.0.4.0...
2314
2315Patching component oracle.rdbms, 11.2.0.4.0...
2316Applying sub-patch '26392168' to OH '/u01/app/oracle/product/11.2.0/db'
2317ApplySession: Optional component(s) [ oracle.oid.client, 11.2.0.4.0 ]  not present in the Oracle Home or a higher version is found.
2318
2319Patching component oracle.network.rsf, 11.2.0.4.0...
2320
2321Patching component oracle.ldap.client, 11.2.0.4.0...
2322
2323Patching component oracle.sysman.agent, 10.2.0.4.5...
2324
2325Patching component oracle.xdk, 11.2.0.4.0...
2326
2327Patching component oracle.rdbms, 11.2.0.4.0...
2328
2329Patching component oracle.network.listener, 11.2.0.4.0...
2330
2331Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
2332
2333Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...
2334
2335Patching component oracle.xdk.parser.java, 11.2.0.4.0...
2336
2337Patching component oracle.xdk.rsf, 11.2.0.4.0...
2338
2339Patching component oracle.rdbms.rsf, 11.2.0.4.0...
2340
2341Patching component oracle.rdbms.rman, 11.2.0.4.0...
2342Applying sub-patch '26925576' to OH '/u01/app/oracle/product/11.2.0/db'
2343
2344Patching component oracle.rdbms, 11.2.0.4.0...
2345
2346Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
2347
2348Patching component oracle.rdbms.rman, 11.2.0.4.0...
2349
2350Patching component oracle.rdbms.rsf, 11.2.0.4.0...
2351Applying sub-patch '27338049' to OH '/u01/app/oracle/product/11.2.0/db'
2352
2353Patching component oracle.assistants.server, 11.2.0.4.0...
2354
2355Patching component oracle.rdbms.rsf, 11.2.0.4.0...
2356
2357Patching component oracle.rdbms, 11.2.0.4.0...
2358
2359Patching component oracle.rdbms.rman, 11.2.0.4.0...
2360
2361Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
2362Applying sub-patch '27734982' to OH '/u01/app/oracle/product/11.2.0/db'
2363
2364Patching component oracle.ctx, 11.2.0.4.0...
2365
2366Patching component oracle.rdbms.rsf, 11.2.0.4.0...
2367
2368Patching component oracle.ctx.rsf, 11.2.0.4.0...
2369
2370Patching component oracle.rdbms, 11.2.0.4.0...
2371
2372Patching component oracle.rdbms.rman, 11.2.0.4.0...
2373Applying sub-patch '28204707' to OH '/u01/app/oracle/product/11.2.0/db'
2374Applying changes to emctl script on the home: /u01/app/oracle/product/11.2.0/db ...
2375
2376Patching component oracle.rdbms, 11.2.0.4.0...
2377
2378Patching component oracle.oracore.rsf, 11.2.0.4.0...
2379
2380Patching component oracle.rdbms.rsf, 11.2.0.4.0...
2381
2382Patching component oracle.ldap.rsf, 11.2.0.4.0...
2383
2384Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...
2385
2386Patching component oracle.network.rsf, 11.2.0.4.0...
2387
2388Patching component oracle.sysman.agent, 10.2.0.4.5...
2389
2390Patching component oracle.sysman.console.db, 11.2.0.4.0...
2391
2392Patching component oracle.ldap.security.osdt, 11.2.0.4.0...
2393
2394Patching component oracle.ldap.owm, 11.2.0.4.0...
2395
2396Patching component oracle.sqlplus.rsf, 11.2.0.4.0...
2397
2398Patching component oracle.ctx, 11.2.0.4.0...
2399Applying sub-patch '28729262' to OH '/u01/app/oracle/product/11.2.0/db'
2400INFO: Script isn't applicable to this port!
2401
2402Patching component oracle.rdbms, 11.2.0.4.0...
2403
2404Patching component oracle.rdbms.rsf, 11.2.0.4.0...
2405
2406Patching component oracle.rdbms.util, 11.2.0.4.0...
2407
2408Patching component oracle.ldap.rsf, 11.2.0.4.0...
2409
2410Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...
2411
2412Patching component oracle.network.rsf, 11.2.0.4.0...
2413
2414Patching component oracle.rdbms.rman, 11.2.0.4.0...
2415
2416Patching component oracle.ctx, 11.2.0.4.0...
2417Applying sub-patch '29141056' to OH '/u01/app/oracle/product/11.2.0/db'
2418
2419Patching component oracle.rdbms, 11.2.0.4.0...
2420
2421Patching component oracle.rdbms.rman, 11.2.0.4.0...
2422
2423Patching component oracle.oracore.rsf, 11.2.0.4.0...
2424
2425Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
2426
2427Patching component oracle.rdbms.rsf, 11.2.0.4.0...
2428Applying sub-patch '29497421' to OH '/u01/app/oracle/product/11.2.0/db'
2429
2430Patching component oracle.rdbms, 11.2.0.4.0...
2431
2432Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
2433
2434Patching component oracle.rdbms.rman, 11.2.0.4.0...
2435
2436Patching component oracle.rdbms.rsf, 11.2.0.4.0...
2437
2438Patching component oracle.ldap.rsf, 11.2.0.4.0...
2439
2440Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...
2441
2442Patching component oracle.oracore.rsf, 11.2.0.4.0...
2443
2444Patching component oracle.ctx, 11.2.0.4.0...
2445Applying sub-patch '29913194' to OH '/u01/app/oracle/product/11.2.0/db'
2446
2447Patching component oracle.rdbms, 11.2.0.4.0...
2448
2449Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
2450
2451Patching component oracle.rdbms.rsf, 11.2.0.4.0...
2452
2453Patching component oracle.network.rsf, 11.2.0.4.0...
2454
2455Patching component oracle.ldap.rsf, 11.2.0.4.0...
2456
2457Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...
2458
2459Patching component oracle.rdbms.util, 11.2.0.4.0...
2460Applying sub-patch '30298532' to OH '/u01/app/oracle/product/11.2.0/db'
2461ApplySession: Optional component(s) [ oracle.rdbms.tg4tera, 11.2.0.4.0 ] , [ oracle.rdbms.tg4sybs, 11.2.0.4.0 ] , [ oracle.rdbms.tg4ifmx, 11.2.0.4.0 ] , [ oracle.rdbms.tg4db2, 11.2.0.4.0 ] , [ oracle.rdbms.tg4msql, 11.2.0.4.0 ]  not present in the Oracle Home or a higher version is found.
2462
2463Patching component oracle.rdbms.rsf, 11.2.0.4.0...
2464
2465Patching component oracle.rdbms, 11.2.0.4.0...
2466
2467Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
2468
2469Patching component oracle.rdbms.hsodbc, 11.2.0.4.0...
2470
2471Patching component oracle.ldap.rsf, 11.2.0.4.0...
2472
2473Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...
2474Applying sub-patch '30670774' to OH '/u01/app/oracle/product/11.2.0/db'
2475
2476Patching component oracle.rdbms.rsf, 11.2.0.4.0...
2477
2478Patching component oracle.rdbms, 11.2.0.4.0...
2479
2480Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
2481
2482Patching component oracle.network.rsf, 11.2.0.4.0...
2483
2484Patching component oracle.ldap.rsf, 11.2.0.4.0...
2485
2486Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...
2487
2488Patching component oracle.swd.oui, 11.2.0.4.0...
2489
2490Patching component oracle.ctx, 11.2.0.4.0...
2491Applying sub-patch '31103343' to OH '/u01/app/oracle/product/11.2.0/db'
2492
2493Patching component oracle.rdbms, 11.2.0.4.0...
2494
2495Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
2496
2497Patching component oracle.rdbms.rsf, 11.2.0.4.0...
2498Applying sub-patch '31537677' to OH '/u01/app/oracle/product/11.2.0/db'
2499
2500Patching component oracle.rdbms, 11.2.0.4.0...
2501
2502Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
2503
2504Patching component oracle.rdbms.rsf, 11.2.0.4.0...
2505
2506Patching component oracle.rdbms.dv, 11.2.0.4.0...
2507
2508Patching component oracle.rdbms.rman, 11.2.0.4.0...
2509
2510Patching component oracle.ldap.rsf, 11.2.0.4.0...
2511
2512Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...
2513
2514Patching component oracle.oracore.rsf, 11.2.0.4.0...
2515
2516Patching component oracle.rdbms.util, 11.2.0.4.0...
2517
2518Patching component oracle.dbdev, 11.2.0.4.0...
2519
2520Patching component oracle.ctx, 11.2.0.4.0...
2521
2522Patching component oracle.buildtools.rsf, 11.2.0.4.0...
2523Applying sub-patch '31983472' to OH '/u01/app/oracle/product/11.2.0/db'
2524
2525Patching component oracle.rdbms.rsf, 11.2.0.4.0...
2526
2527Patching component oracle.rdbms, 11.2.0.4.0...
2528
2529Patching component oracle.ctx, 11.2.0.4.0...
2530Applying sub-patch '32328626' to OH '/u01/app/oracle/product/11.2.0/db'
2531
2532Patching component oracle.rdbms, 11.2.0.4.0...
2533
2534Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
2535
2536Patching component oracle.rdbms.rsf, 11.2.0.4.0...
2537
2538Patching component oracle.rdbms.dv, 11.2.0.4.0...
2539
2540Patching component oracle.rdbms.rman, 11.2.0.4.0...
2541
2542Patching component oracle.ldap.rsf, 11.2.0.4.0...
2543
2544Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...
2545Applying sub-patch '32758711' to OH '/u01/app/oracle/product/11.2.0/db'
2546
2547Patching component oracle.rdbms, 11.2.0.4.0...
2548
2549Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
2550
2551Patching component oracle.ctx, 11.2.0.4.0...
2552
2553Patching component oracle.network.rsf, 11.2.0.4.0...
2554Applying sub-patch '33128584' to OH '/u01/app/oracle/product/11.2.0/db'
2555
2556Patching component oracle.rdbms, 11.2.0.4.0...
2557
2558Patching component oracle.rdbms.rsf, 11.2.0.4.0...
2559
2560Patching component oracle.ctx, 11.2.0.4.0...
2561Applying sub-patch '33477185' to OH '/u01/app/oracle/product/11.2.0/db'
2562
2563Patching component oracle.rdbms, 11.2.0.4.0...
2564
2565Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
2566
2567Patching component oracle.rdbms.rsf, 11.2.0.4.0...
2568
2569Patching component oracle.network.rsf, 11.2.0.4.0...
2570
2571Patching component oracle.rdbms.dv, 11.2.0.4.0...
2572Applying sub-patch '33711103' to OH '/u01/app/oracle/product/11.2.0/db'
2573ApplySession: Optional component(s) [ oracle.rdbms.tg4tera, 11.2.0.4.0 ] , [ oracle.rdbms.tg4sybs, 11.2.0.4.0 ] , [ oracle.rdbms.tg4msql, 11.2.0.4.0 ] , [ oracle.rdbms.tg4ifmx, 11.2.0.4.0 ] , [ oracle.rdbms.tg4db2, 11.2.0.4.0 ]  not present in the Oracle Home or a higher version is found.
2574
2575Patching component oracle.rdbms.rsf, 11.2.0.4.0...
2576
2577Patching component oracle.rdbms, 11.2.0.4.0...
2578
2579Patching component oracle.rdbms.rsf, 11.2.0.4.0...
2580
2581Patching component oracle.network.rsf, 11.2.0.4.0...
2582
2583Patching component oracle.rdbms.hsodbc, 11.2.0.4.0...
2584
2585Patching component oracle.rdbms.hs_common, 11.2.0.4.0...
2586
2587Patching component oracle.buildtools.rsf, 11.2.0.4.0...
2588
2589Patching component oracle.buildtools.rsf, 11.2.0.4.0...
2590Applying sub-patch '34057724' to OH '/u01/app/oracle/product/11.2.0/db'
2591ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.4.0 ]  not present in the Oracle Home or a higher version is found.
2592
2593Patching component oracle.rdbms, 11.2.0.4.0...
2594
2595Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
2596
2597Patching component oracle.rdbms.rsf, 11.2.0.4.0...
2598
2599Patching component oracle.network.rsf, 11.2.0.4.0...
2600
2601Patching component oracle.ldap.rsf, 11.2.0.4.0...
2602
2603Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...
2604
2605Patching component oracle.swd.oui.core, 11.2.0.4.0...
2606Applying sub-patch '34386237' to OH '/u01/app/oracle/product/11.2.0/db'
2607ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.4.0 ]  not present in the Oracle Home or a higher version is found.
2608
2609Patching component oracle.rdbms, 11.2.0.4.0...
2610
2611Patching component oracle.rdbms.rsf, 11.2.0.4.0...
2612
2613Patching component oracle.network.rsf, 11.2.0.4.0...
2614
2615Patching component oracle.swd.oui.core, 11.2.0.4.0...
2616
2617Patching component oracle.ctx, 11.2.0.4.0...
2618Applying sub-patch '34677698' to OH '/u01/app/oracle/product/11.2.0/db'
2619ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.4.0 ]  not present in the Oracle Home or a higher version is found.
2620
2621Patching component oracle.rdbms, 11.2.0.4.0...
2622
2623Patching component oracle.rdbms.rsf, 11.2.0.4.0...
2624
2625Patching component oracle.javavm.containers, 11.2.0.4.0...
2626Applying sub-patch '34998337' to OH '/u01/app/oracle/product/11.2.0/db'
2627ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.4.0 ]  not present in the Oracle Home or a higher version is found.
2628
2629Patching component oracle.rdbms, 11.2.0.4.0...
2630
2631Patching component oracle.rdbms.rsf, 11.2.0.4.0...
2632Applying sub-patch '35269283' to OH '/u01/app/oracle/product/11.2.0/db'
2633ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.4.0 ]  not present in the Oracle Home or a higher version is found.
2634
2635Patching component oracle.rdbms, 11.2.0.4.0...
2636
2637Patching component oracle.network.rsf, 11.2.0.4.0...
2638
2639Patching component oracle.rdbms.rsf, 11.2.0.4.0...
2640
2641Patching component oracle.dbdev, 11.2.0.4.0...
2642Applying sub-patch '35574075' to OH '/u01/app/oracle/product/11.2.0/db'
2643ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.4.0 ]  not present in the Oracle Home or a higher version is found.
2644
2645Patching component oracle.rdbms, 11.2.0.4.0...
2646
2647Patching component oracle.rdbms.rsf, 11.2.0.4.0...
2648
2649Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
2650
2651Patching component oracle.network.rsf, 11.2.0.4.0...
2652
2653Patching component oracle.rdbms.rsf, 11.2.0.4.0...
2654
2655Patching component oracle.sysman.oms.core, 10.2.0.4.5...
2656
2657Patching component oracle.marvel, 11.2.0.4.0...
2658
2659Patching component oracle.javavm.containers, 11.2.0.4.0...
2660
2661Patching component oracle.dbjava.ucp, 11.2.0.4.0...
2662
2663Patching component oracle.owb.rsf, 11.2.0.4.0...
2664
2665Patching component oracle.sysman.ccr, 10.3.8.1.0...
2666
2667Patching component oracle.sysman.ccr.client, 10.3.2.1.0...
2668
2669Patching component oracle.sysman.common, 10.2.0.4.5...
2670
2671Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
2672
2673Patching component oracle.javavm.containers, 11.2.0.4.0...
2674Composite patch 35574075 successfully applied.
2675Log file location: /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-29_16-42-15PM_1.log
2676
2677OPatch succeeded.
2678
2679#==============================================================#                                                                                  
2680Oracle 软件安装补丁 33991024                                                                                  
2681#==============================================================#                                                                                  
2682
2683节点 192.168.6.130 ：                                                                                  
2684
2685Oracle Interim Patch Installer version 11.2.0.3.44
2686Copyright (c) 2024, Oracle Corporation.  All rights reserved.
2687
2688PREREQ session
2689
2690Oracle Home       : /u01/app/oracle/product/11.2.0/db
2691Central Inventory : /u01/app/oraInventory
2692   from           : /u01/app/oracle/product/11.2.0/db/oraInst.loc
2693OPatch version    : 11.2.0.3.44
2694OUI version       : 11.2.0.4.0
2695Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-29_16-56-32PM_1.log
2696
2697Invoking prereq "checkconflictagainstohwithdetail"
2698
2699Prereq "checkConflictAgainstOHWithDetail" passed.
2700
2701OPatch succeeded.
2702Oracle Interim Patch Installer version 11.2.0.3.44
2703Copyright (c) 2024, Oracle Corporation.  All rights reserved.
2704
2705
2706Oracle Home       : /u01/app/oracle/product/11.2.0/db
2707Central Inventory : /u01/app/oraInventory
2708   from           : /u01/app/oracle/product/11.2.0/db/oraInst.loc
2709OPatch version    : 11.2.0.3.44
2710OUI version       : 11.2.0.4.0
2711Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-29_16-56-37PM_1.log
2712
2713Verifying environment and performing prerequisite checks...
2714OPatch continues with these patches:   33991024  
2715
2716Do you want to proceed? [y|n]
2717Y (auto-answered by -silent)
2718User Responded with: Y
2719All checks passed.
2720
2721Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
2722(Oracle Home = '/u01/app/oracle/product/11.2.0/db')
2723
2724
2725Is the local system ready for patching? [y|n]
2726Y (auto-answered by -silent)
2727User Responded with: Y
2728Backing up files...
2729Applying interim patch '33991024' to OH '/u01/app/oracle/product/11.2.0/db'
2730
2731Patching component oracle.rdbms.rsf, 11.2.0.4.0...
2732
2733Patching component oracle.buildtools.rsf, 11.2.0.4.0...
2734
2735Patching component oracle.has.db, 11.2.0.4.0...
2736Patch 33991024 successfully applied.
2737Log file location: /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-29_16-56-37PM_1.log
2738
2739OPatch succeeded.
2740
2741Oracle 执行 relink：                                                                                  
2742
2743writing relink log to: /u01/app/oracle/product/11.2.0/db/install/relink.log
2744
2745节点 192.168.6.131 ：                                                                                  
2746
2747Oracle Interim Patch Installer version 11.2.0.3.44
2748Copyright (c) 2024, Oracle Corporation.  All rights reserved.
2749
2750PREREQ session
2751
2752Oracle Home       : /u01/app/oracle/product/11.2.0/db
2753Central Inventory : /u01/app/oraInventory
2754   from           : /u01/app/oracle/product/11.2.0/db/oraInst.loc
2755OPatch version    : 11.2.0.3.44
2756OUI version       : 11.2.0.4.0
2757Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-29_16-57-44PM_1.log
2758
2759Invoking prereq "checkconflictagainstohwithdetail"
2760
2761Prereq "checkConflictAgainstOHWithDetail" passed.
2762
2763OPatch succeeded.
2764Oracle Interim Patch Installer version 11.2.0.3.44
2765Copyright (c) 2024, Oracle Corporation.  All rights reserved.
2766
2767
2768Oracle Home       : /u01/app/oracle/product/11.2.0/db
2769Central Inventory : /u01/app/oraInventory
2770   from           : /u01/app/oracle/product/11.2.0/db/oraInst.loc
2771OPatch version    : 11.2.0.3.44
2772OUI version       : 11.2.0.4.0
2773Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-29_16-57-49PM_1.log
2774
2775Verifying environment and performing prerequisite checks...
2776OPatch continues with these patches:   33991024  
2777
2778Do you want to proceed? [y|n]
2779Y (auto-answered by -silent)
2780User Responded with: Y
2781All checks passed.
2782
2783Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
2784(Oracle Home = '/u01/app/oracle/product/11.2.0/db')
2785
2786
2787Is the local system ready for patching? [y|n]
2788Y (auto-answered by -silent)
2789User Responded with: Y
2790Backing up files...
2791Applying interim patch '33991024' to OH '/u01/app/oracle/product/11.2.0/db'
2792
2793Patching component oracle.rdbms.rsf, 11.2.0.4.0...
2794
2795Patching component oracle.buildtools.rsf, 11.2.0.4.0...
2796
2797Patching component oracle.has.db, 11.2.0.4.0...
2798Patch 33991024 successfully applied.
2799Log file location: /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-29_16-57-49PM_1.log
2800
2801OPatch succeeded.
2802
2803节点 192.168.6.131 ：Oracle 执行 relink：                                                                                  
2804
2805writing relink log to: /u01/app/oracle/product/11.2.0/db/install/relink.log
2806
2807#==============================================================#                                                                                  
2808OJVM 补丁安装                                                                                     
2809#==============================================================#                                                                                  
2810
2811节点 192.168.6.130 ：                                                                                  
2812
2813Oracle Interim Patch Installer version 11.2.0.3.44
2814Copyright (c) 2024, Oracle Corporation.  All rights reserved.
2815
2816PREREQ session
2817
2818Oracle Home       : /u01/app/oracle/product/11.2.0/db
2819Central Inventory : /u01/app/oraInventory
2820   from           : /u01/app/oracle/product/11.2.0/db/oraInst.loc
2821OPatch version    : 11.2.0.3.44
2822OUI version       : 11.2.0.4.0
2823Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-29_17-00-08PM_1.log
2824
2825Invoking prereq "checkconflictagainstohwithdetail"
2826
2827Prereq "checkConflictAgainstOHWithDetail" passed.
2828
2829OPatch succeeded.
2830Oracle Interim Patch Installer version 11.2.0.3.44
2831Copyright (c) 2024, Oracle Corporation.  All rights reserved.
2832
2833
2834Oracle Home       : /u01/app/oracle/product/11.2.0/db
2835Central Inventory : /u01/app/oraInventory
2836   from           : /u01/app/oracle/product/11.2.0/db/oraInst.loc
2837OPatch version    : 11.2.0.3.44
2838OUI version       : 11.2.0.4.0
2839Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-29_17-00-13PM_1.log
2840
2841Verifying environment and performing prerequisite checks...
2842OPatch continues with these patches:   35685663  
2843
2844Do you want to proceed? [y|n]
2845Y (auto-answered by -silent)
2846User Responded with: Y
2847All checks passed.
2848
2849Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
2850(Oracle Home = '/u01/app/oracle/product/11.2.0/db')
2851
2852
2853Is the local system ready for patching? [y|n]
2854Y (auto-answered by -silent)
2855User Responded with: Y
2856Backing up files...
2857Applying interim patch '35685663' to OH '/u01/app/oracle/product/11.2.0/db'
2858ApplySession: 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.
2859
2860Patching component oracle.javavm.server, 11.2.0.4.0...
2861
2862Patching component oracle.precomp.common, 11.2.0.4.0...
2863
2864Patching component oracle.rdbms, 11.2.0.4.0...
2865
2866Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
2867
2868Patching component oracle.javavm.client, 11.2.0.4.0...
2869
2870Patching component oracle.dbjava.jdbc, 11.2.0.4.0...
2871
2872Patching component oracle.dbjava.ic, 11.2.0.4.0...
2873Patch 35685663 successfully applied.
2874Log file location: /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-29_17-00-13PM_1.log
2875
2876OPatch succeeded.
2877
2878节点 192.168.6.131 ：                                                                                  
2879
2880Oracle Interim Patch Installer version 11.2.0.3.44
2881Copyright (c) 2024, Oracle Corporation.  All rights reserved.
2882
2883PREREQ session
2884
2885Oracle Home       : /u01/app/oracle/product/11.2.0/db
2886Central Inventory : /u01/app/oraInventory
2887   from           : /u01/app/oracle/product/11.2.0/db/oraInst.loc
2888OPatch version    : 11.2.0.3.44
2889OUI version       : 11.2.0.4.0
2890Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-29_17-00-26PM_1.log
2891
2892Invoking prereq "checkconflictagainstohwithdetail"
2893
2894Prereq "checkConflictAgainstOHWithDetail" passed.
2895
2896OPatch succeeded.
2897Oracle Interim Patch Installer version 11.2.0.3.44
2898Copyright (c) 2024, Oracle Corporation.  All rights reserved.
2899
2900
2901Oracle Home       : /u01/app/oracle/product/11.2.0/db
2902Central Inventory : /u01/app/oraInventory
2903   from           : /u01/app/oracle/product/11.2.0/db/oraInst.loc
2904OPatch version    : 11.2.0.3.44
2905OUI version       : 11.2.0.4.0
2906Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-29_17-00-30PM_1.log
2907
2908Verifying environment and performing prerequisite checks...
2909OPatch continues with these patches:   35685663  
2910
2911Do you want to proceed? [y|n]
2912Y (auto-answered by -silent)
2913User Responded with: Y
2914All checks passed.
2915
2916Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
2917(Oracle Home = '/u01/app/oracle/product/11.2.0/db')
2918
2919
2920Is the local system ready for patching? [y|n]
2921Y (auto-answered by -silent)
2922User Responded with: Y
2923Backing up files...
2924Applying interim patch '35685663' to OH '/u01/app/oracle/product/11.2.0/db'
2925ApplySession: 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.
2926
2927Patching component oracle.javavm.server, 11.2.0.4.0...
2928
2929Patching component oracle.precomp.common, 11.2.0.4.0...
2930
2931Patching component oracle.rdbms, 11.2.0.4.0...
2932
2933Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
2934
2935Patching component oracle.javavm.client, 11.2.0.4.0...
2936
2937Patching component oracle.dbjava.jdbc, 11.2.0.4.0...
2938
2939Patching component oracle.dbjava.ic, 11.2.0.4.0...
2940Patch 35685663 successfully applied.
2941Log file location: /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-29_17-00-30PM_1.log
2942
2943OPatch succeeded.
2944
2945#==============================================================#                                                                                  
2946Oracle 软件版本                                                                                   
2947#==============================================================#                                                                                  
2948
2949
2950SQL*Plus: Release 11.2.0.4.0 Production
2951
2952
2953#==============================================================#                                                                                  
2954Oracle 补丁信息                                                                                   
2955#==============================================================#                                                                                  
2956
295735685663;OJVM PATCH SET UPDATE 11.2.0.4.231017
295833991024;11204CERT ON OL8: LINKING ERRORS DURING 11204 FOR DB INSTALL ON OL8.2
295935574075;Database Patch Set Update : 11.2.0.4.231017 (35574075)
2960
2961OPatch succeeded.
2962
2963
2964#==============================================================#                                                                                  
2965静默建库命令：lucifer                                                                                  
2966#==============================================================#                                                                                  
2967
2968dbca -silent -createDatabase \
2969-templateName General_Purpose.dbc \
2970-responseFile NO_VALUE \
2971-gdbname lucifer \
2972-sid lucifer \
2973-sysPassword oracle \
2974-systemPassword oracle \
2975-redoLogFileSize 100 \
2976-diskGroupName DATA \
2977-storageType ASM \
2978-listeners LISTENER \
2979-nodeinfo openeuler01,openeuler02 \
2980-characterSet AL32UTF8 \
2981-nationalCharacterSet AL16UTF16 \
2982-emConfiguration NONE \
2983-automaticMemoryManagement false \
2984-totalMemory 3716 \
2985-databaseType OLTP                                                                                  
2986
2987#==============================================================#                                                                                  
2988创建数据库实例：lucifer                                                                                  
2989#==============================================================#                                                                                  
2990
2991Copying database files
29921% complete
29933% complete
29949% complete
299515% complete
299621% complete
299727% complete
299830% complete
2999Creating and starting Oracle instance
300032% complete
300136% complete
300240% complete
300344% complete
300445% complete
300548% complete
300650% complete
3007Creating cluster database views
300852% complete
300970% complete
3010Completing Database Creation
301173% complete
301276% complete
301377% complete
301478% complete
301579% complete
301680% complete
301781% complete
301890% complete
301999% complete
3020100% complete
3021Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/lucifer/lucifer.log" for further details.
3022
3023#==============================================================#                                                                                  
3024配置 OMF && 优化 RMAN                                                                                  
3025#==============================================================#                                                                                  
3026
3027
3028Recovery Manager: Release 11.2.0.4.0 - Production on Fri Mar 29 17:19:51 2024
3029
3030Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
3031
3032connected to target database: LUCIFER (DBID=4020789513)
3033
3034RMAN> 
3035using target database control file instead of recovery catalog
3036new RMAN configuration parameters:
3037CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATA/snapcf_fdcdb1.f';
3038new RMAN configuration parameters are successfully stored
3039
3040RMAN> 
3041RMAN configuration parameters for database with db_unique_name LUCIFER are:
3042CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATA/snapcf_fdcdb1.f';
3043
3044RMAN> 
3045
3046Recovery Manager complete.
3047
3048NAME                                 TYPE        VALUE
3049------------------------------------ ----------- ------------------------------
3050db_create_file_dest                  string      +DATA
3051
3052#==============================================================#                                                                                  
3053配置 Oracle 数据库控制文件复用                                                                                  
3054#==============================================================#                                                                                  
3055
3056
3057Recovery Manager: Release 11.2.0.4.0 - Production on Fri Mar 29 17:21:07 2024
3058
3059Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
3060
3061connected to target database: LUCIFER (not mounted)
3062
3063RMAN> 
3064Starting restore at 29-MAR-24
3065using target database control file instead of recovery catalog
3066allocated channel: ORA_DISK_1
3067channel ORA_DISK_1: SID=156 instance=lucifer1 device type=DISK
3068
3069channel ORA_DISK_1: copied control file copy
3070Finished restore at 29-MAR-24
3071
3072
3073Recovery Manager complete.
3074
3075数据库控制文件：                                                                                  
3076
3077
3078NAME
3079----------------------------------------------------------------------------------------------------
3080+DATA/lucifer/controlfile/current.260.1164906249
3081+DATA/lucifer/controlfile/control02.ctl
3082
3083#==============================================================#                                                                                  
3084配置在线重做日志                                                                                  
3085#==============================================================#                                                                                  
3086
3087数据库在线重做日志文件：                                                                                  
3088
3089
3090   THREAD#     GROUP# MEMBER                                                                                                                      size(M)
3091---------- ---------- ------------------------------------------------------------------------------------------------------------------------ ----------
3092         1          1 +DATA/lucifer/onlinelog/group_1.261.1164906251                                                                                  100
3093         1          2 +DATA/lucifer/onlinelog/group_2.262.1164906253                                                                                  100
3094         1         11 +DATA/lucifer/onlinelog/group_11.272.1164907323                                                                                 100
3095         1         12 +DATA/lucifer/onlinelog/group_12.273.1164907325                                                                                 100
3096         1         13 +DATA/lucifer/onlinelog/group_13.274.1164907331                                                                                 100
3097         1         14 +DATA/lucifer/onlinelog/group_14.275.1164907333                                                                                 100
3098         1         15 +DATA/lucifer/onlinelog/group_15.276.1164907335                                                                                 100
3099         2          3 +DATA/lucifer/onlinelog/group_3.265.1164907119                                                                                  100
3100         2          4 +DATA/lucifer/onlinelog/group_4.266.1164907121                                                                                  100
3101         2         21 +DATA/lucifer/onlinelog/group_21.277.1164907337                                                                                 100
3102         2         22 +DATA/lucifer/onlinelog/group_22.278.1164907339                                                                                 100
3103         2         23 +DATA/lucifer/onlinelog/group_23.279.1164907339                                                                                 100
3104         2         24 +DATA/lucifer/onlinelog/group_24.280.1164907343                                                                                 100
3105         2         25 +DATA/lucifer/onlinelog/group_25.281.1164907345                                                                                 100
3106
3107#==============================================================#                                                                                  
3108配置 Oracle 数据库开机自启                                                                                  
3109#==============================================================#                                                                                  
3110
3111
3112#==============================================================#                                                                                  
3113配置 RMAN 备份任务                                                                                  
3114#==============================================================#                                                                                  
3115
3116## OracleBegin
311700 02 * * * /home/oracle/scripts/del_arch_lucifer.sh
3118#00 00 * * 0 /home/oracle/scripts/dbbackup_lv0_lucifer.sh
3119#00 00 * * 1,2,3,4,5,6 /home/oracle/scripts/dbbackup_lv1_lucifer.sh
3120
3121#==============================================================#                                                                                  
3122优化数据库参数                                                                                  
3123#==============================================================#                                                                                  
3124
3125数据库参数：                                                                                    
3126
3127
3128NAME                                               SID        SPVALUE                                                                          VALUE
3129-------------------------------------------------- ---------- -------------------------------------------------------------------------------- --------------------------------------------------------------------------------
3130_b_tree_bitmap_plans                               *          FALSE                                                                            FALSE
3131_datafile_write_errors_crash_instance              *          FALSE                                                                            FALSE
3132audit_file_dest                                    *          /u01/app/oracle/admin/lucifer/adump                                              /u01/app/oracle/admin/lucifer/adump
3133audit_trail                                        *          NONE                                                                             DB
3134cluster_database                                   *          true                                                                             TRUE
3135compatible                                         *          11.2.0.4.0                                                                       11.2.0.4.0
3136control_file_record_keep_time                      *          31                                                                               31
3137db_block_size                                      *          8192                                                                             8192
3138db_create_file_dest                                *          +DATA                                                                            +DATA
3139db_file_multiblock_read_count                      *                                                                                           128
3140db_files                                           *          5000                                                                             200
3141db_name                                            *          lucifer                                                                          lucifer
3142db_writer_processes                                *                                                                                           1
3143deferred_segment_creation                          *          FALSE                                                                            FALSE
3144diagnostic_dest                                    *          /u01/app/oracle                                                                  /u01/app/oracle
3145dispatchers                                        *          (PROTOCOL=TCP) (SERVICE=luciferXDB)                                              (PROTOCOL=TCP) (SERVICE=luciferXDB)
3146enable_ddl_logging                                 *          TRUE                                                                             FALSE
3147event                                              *          10949 trace name context forever,level 1
3148event                                              *          28401 trace name context forever,level 1
3149fast_start_parallel_rollback                       *                                                                                           LOW
3150log_archive_dest_1                                 *          location=+DATA                                                                   location=+DATA
3151log_archive_format                                 *          %t_%s_%r.dbf                                                                     %t_%s_%r.dbf
3152max_dump_file_size                                 *                                                                                           unlimited
3153open_cursors                                       *          1000                                                                             300
3154optimizer_index_caching                            *                                                                                           0
3155optimizer_mode                                     *                                                                                           ALL_ROWS
3156parallel_force_local                               *          TRUE                                                                             FALSE
3157parallel_max_servers                               *          64                                                                               64
3158pga_aggregate_target                               *          1246756864                                                                       779091968
3159processes                                          *          2000                                                                             150
3160remote_login_passwordfile                          *          exclusive                                                                        EXCLUSIVE
3161resource_limit                                     *          TRUE                                                                             FALSE
3162resource_manager_plan                              *          force:
3163sec_case_sensitive_logon                           *          FALSE                                                                            TRUE
3164session_cached_cursors                             *          300                                                                              50
3165sessions                                           *                                                                                           248
3166sga_max_size                                       *          4988076032                                                                       3120562176
3167sga_target                                         *          4988076032                                                                       3120562176
3168spfile                                             *                                                                                           +DATA/lucifer/spfilelucifer.ora
3169statistics_level                                   *                                                                                           TYPICAL
3170undo_retention                                     *          10800                                                                            900
3171
3172#==============================================================#                                                                                  
3173配置 glogin.sql                                                                                     
3174#==============================================================#                                                                                  
3175
3176define _editor=vi
3177set serveroutput on size 1000000
3178set pagesize 9999
3179set long 99999
3180set trimspool on
3181col name format a80
3182set termout off
3183define gname=idle
3184column global_name new_value gname
3185select lower(user) || '@' || substr( global_name, 1, decode( dot, 0, length(global_name), dot-1) ) global_name from (select global_name, instr(global_name,'.') dot from global_name );
3186ALTER SESSION SET nls_date_format = 'YYYY-MM-DD HH24:MI:SS';
3187set sqlprompt '&gname _DATE> '
3188set termout on
3189
3190恭喜！Oracle RAC 安装成功，现在是否重启主机：[Y/N] Y

检查集群状态：

Bash

1[grid@openeuler01:/home/grid]$ crsctl stat res -t
2--------------------------------------------------------------------------------
3Name           Target  State        Server                   State details       
4--------------------------------------------------------------------------------
5Local Resources
6--------------------------------------------------------------------------------
7ora.LISTENER.lsnr
8               ONLINE  ONLINE       openeuler01              STABLE
9               ONLINE  ONLINE       openeuler02              STABLE
10ora.chad
11               ONLINE  ONLINE       openeuler01              STABLE
12               ONLINE  ONLINE       openeuler02              STABLE
13ora.net1.network
14               ONLINE  ONLINE       openeuler01              STABLE
15               ONLINE  ONLINE       openeuler02              STABLE
16ora.ons
17               ONLINE  ONLINE       openeuler01              STABLE
18               ONLINE  ONLINE       openeuler02              STABLE
19--------------------------------------------------------------------------------
20Cluster Resources
21--------------------------------------------------------------------------------
22ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
23      1        ONLINE  ONLINE       openeuler01              STABLE
24      2        ONLINE  ONLINE       openeuler02              STABLE
25ora.DATA.dg(ora.asmgroup)
26      1        ONLINE  ONLINE       openeuler01              STABLE
27      2        ONLINE  ONLINE       openeuler02              STABLE
28ora.LISTENER_SCAN1.lsnr
29      1        ONLINE  ONLINE       openeuler02              STABLE
30ora.OCR.dg(ora.asmgroup)
31      1        ONLINE  ONLINE       openeuler01              STABLE
32      2        ONLINE  ONLINE       openeuler02              STABLE
33ora.asm(ora.asmgroup)
34      1        ONLINE  ONLINE       openeuler01              Started,STABLE
35      2        ONLINE  ONLINE       openeuler02              Started,STABLE
36ora.asmnet1.asmnetwork(ora.asmgroup)
37      1        ONLINE  ONLINE       openeuler01              STABLE
38      2        ONLINE  ONLINE       openeuler02              STABLE
39ora.cvu
40      1        ONLINE  ONLINE       openeuler02              STABLE
41ora.lucifer.db
42      1        ONLINE  ONLINE       openeuler01              Open,HOME=/u01/app/o
43                                                             racle/product/11.2.0
44                                                             /db,STABLE
45      2        ONLINE  ONLINE       openeuler02              Open,HOME=/u01/app/o
46                                                             racle/product/11.2.0
47                                                             /db,STABLE
48ora.openeuler01.vip
49      1        ONLINE  ONLINE       openeuler01              STABLE
50ora.openeuler02.vip
51      1        ONLINE  ONLINE       openeuler02              STABLE
52ora.qosmserver
53      1        ONLINE  ONLINE       openeuler02              STABLE
54ora.scan1.vip
55      1        ONLINE  ONLINE       openeuler02              STABLE
56--------------------------------------------------------------------------------

openEuler 22.03 LTS SP3（华为欧拉）一键安装 Oracle 11GR2 RAC（231017） - DBA 学习之路