🔖asm oracle oracle 19c rac

2023-08-13 20:15阅读: 839评论: 0推荐: 0

使用 ASM 和版本升级安装 Oracle 19C RAC 的分步指南

一、概述

本文档将指导您在 Linux 平台上使用 ASM 逐步安装 Oracle 19C RAC。这里讨论每一步。我们将RAC安装与ASM配合并进行版本升级。

遵循的步骤 –

服务器配置
配置 Oracle ASM
预检查 RAC 设置
为 RAC 安装 GRID 基础设施
安装Oracle 19C数据库
版本升级/PSU补丁应用

二、过程

2.1 修改服务器hosts文件

“/etc/hosts”文件必须包含服务器的完全限定名称。请以 root 用户身份在“/etc/hostname”文件中设置正确的主机名。

#Public IP

10.201.33.38 AUS-LNDBASMT-001.dbanalyser.com AUS-LNDBASMT-001

10.201.33.39 AUS-LNDBASMT-002.dbanalyser.com AUS-LNDBASMT-002

#Virtual IP

10.201.33.70 AUS-LNDBASMT-001-vip.dbanalyser.com AUS-LNDBASMT-001-vip

10.201.33.71 AUS-LNDBASMT-002-vip.dbanalyser.com AUS-LNDBASMT-002-vip

#Private IP

10.201.224.125 AUS-LNDBASMT-001-priv.dbanalyser.com AUS-LNDBASMT-001-priv

10.201.224.126 AUS-LNDBASMT-002-priv.dbanalyser.com AUS-LNDBASMT-002-priv

#Scan

10.201.33.72 AUS-LNDBASMT-scan.dbanalyser.com AUS-LNDBASMT-SCAN

10.201.33.73 AUS-LNDBASMT-scan.dbanalyser.com AUS-LNDBASMT-SCAN

10.201.33.74 AUS-LNDBASMT-scan.dbanalyser.com AUS-LNDBASMT-SCAN

2.2 Oracle 安装先决条件

执行自动或手动设置以完成基本的先决步骤。所有安装都需要额外的设置。

2.2.1 自动设置

如果您使用的是 RHEL7 或 CentOS7，则可以从 OL7 存储库获取 PRM 并安装它。它将从您的普通存储库中提取依赖项。

1	`# yum install -y https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm`

对于 RHEL8 或 CentOS8 –

1 2	`curl -o oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL8/appstream/x86_64/getPackage/oracle-database-preinstall-19c-` `1.0-2.el8.x86_64.rpm` `yum -y localinstall oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm`

2.2.2 手动服务器配置

1、禁用防火墙

需要通过以下命令禁用服务器的防火墙。

1 2	`systemctl stop firewalld` `systemctl disable firewalld`

2、在“/etc/sysctl.conf”文件中添加或修改以下行

fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
kernel.panic_on_oops = 1
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.conf.all.rp_filter = 2
net.ipv4.conf.default.rp_filter = 2
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500

运行以下命令之一来更改当前内核参数。

1	`/sbin/sysctl` `-p`

3、将以下行添加到“/etc/security/limits.conf 文件”

oracle   soft   nofile    1024
oracle   hard   nofile    65536
oracle   soft   nproc    16384
oracle   hard   nproc    16384
oracle   soft   stack    10240
oracle   hard   stack    32768
oracle   hard   memlock    134217728
oracle   soft   memlock    134217728

4、创建用户和组

groupadd -g 1000 oinstall
groupadd -g 1100 asmadmin
groupadd -g 1200 dba
groupadd -g 1300 asmdba
groupadd -g 1301 asmoper 
groupadd -g 1400 oper
 
/usr/sbin/useradd -u 1001 -g oinstall -G asmadmin,asmdba,asmoper grid
/usr/sbin/useradd -u 1000 -g oinstall -G dba,asmdba,oper oracle
echo "grid" | passwd --stdin grid
echo "oracle" | passwd --stdin oracle

5、设置用户bash_file

--oracle用户

cat >> .bash_profile << EOF
# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_HOSTNAME=rac1<-->rac2; export ORACLE_HOSTNAME
ORACLE_UNQNAME=orcl; export ORACLE_UNQNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
DB_HOME=$ORACLE_BASE/product/19c/db_1; export DB_HOME
ORACLE_HOME=$DB_HOME; export ORACLE_HOME
ORACLE_SID=orcl1<-->orcl2; export ORACLE_SID   
ORACLE_TERM=xterm; export ORACLE_TERM
BASE_PATH=/usr/sbin:$PATH; export BASE_PATH
PATH=$ORACLE_HOME/bin:$BASE_PATH; export PATH
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export PS1=[`hostname`'@$PWD']$
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
EOF
exit

--grid用户的bash_file

#grid
su - grid
.bash_profile 
ORACLE_SID=+ASM1<-->+ASM2; export ORACLE_SID   
ORACLE_HOME=/u01/app/19c/grid; export ORACLE_HOME
BASE_PATH=/usr/sbin:$PATH; export BASE_PATH
PATH=$ORACLE_HOME/bin:$BASE_PATH; export PATH
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export PS1=[`hostname`'@$PWD']$
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

6、安装以下 RPM 软件包

yum install -y bc    
yum install -y binutils
#yum install -y compat-libcap1
yum install -y compat-libstdc++-33
#yum install -y dtrace-modules
#yum install -y dtrace-modules-headers
#yum install -y dtrace-modules-provider-headers
#yum install -y dtrace-utils
yum install -y elfutils-libelf
yum install -y elfutils-libelf-devel
yum install -y fontconfig-devel
yum install -y glibc
yum install -y glibc-devel
yum install -y ksh
yum install -y libaio
yum install -y libaio-devel
#yum install -y libdtrace-ctf-devel
yum install -y libXrender
yum install -y libXrender-devel
yum install -y libX11
yum install -y libXau
yum install -y libXi
yum install -y libXtst
yum install -y libgcc
yum install -y librdmacm-devel
yum install -y libstdc++
yum install -y libstdc++-devel
yum install -y libxcb
yum install -y make
yum install -y net-tools # Clusterware
yum install -y nfs-utils # ACFS
yum install -y python # ACFS
yum install -y python-configshell # ACFS
yum install -y python-rtslib # ACFS
yum install -y python-six # ACFS
yum install -y targetcli # ACFS
yum install -y smartmontools
yum install -y sysstat
yum install -y unixODBC
 
# New for OL8
yum install -y libnsl
yum install -y libnsl.i686
yum install -y libnsl2
yum install -y libnsl2.i686

7、网络配置

vi /etc/sysconfig/network
# Recommended value for NOZEROCONF
NOZEROCONF=yes

2.3 为 ASM 配置安装附加 RPM

kmod-oracleasm-2.0.8-17.el7.x86_64
oracleasmlib-2.0.12-1.el7.x86_64.rpm
oracleasm-support-2.1.8-3.el7.x86_64.rpm

2.4 两个节点配置 Oracle ASM

oracleasm configure -i 
Configuring the Oracle ASM library driver. 
This will configure the on-boot properties of the Oracle ASM library driver.  The following questions will determine whether the driver is loaded on boot and what permissions it will have.  The current values will be shown in brackets (‘[]’).  Hitting <ENTER> without typing an answer will keep that current value.  Ctrl-C will abort.
Default user to own the driver interface []: oracle
Default group to own the driver interface []: oinstall
Scan for Oracle ASM disks on boot (y/n) [y]: y 
Writing Oracle ASM library driver configuration: done

oracleasm start

2.4.1 ASM 中的磁盘创建

fdisk /dev/sdf 
Welcome to fdisk (util-linux 2.23.2). 
Changes will remain in memory only, until you decide to write them. Be careful before using the write command. 
Command (m for help): n 
Partition type: 
p   primary (1 primary, 0 extended, 3 free) e   extended 
Select (default p): 
Using default response p 
Partition number (2-4, default 2): d 
Partition number (2-4, default 2): 2 
No free sectors available 
Command (m for help): d 
Selected partition 1 
Partition 1 is deleted 
Command (m for help): n 
Partition type:
p   primary (0 primary, 0 extended, 4 free)  e   extended 
Select (default p)
Using default response partition number (1-4, default 1): 
First sector (2048-20971519, default 2048): 
Last sector, +sectors or +size{K,M,G} (2048-20971519, default 20971519): 
Using default value 20971519 
Partition 1 of type Linux and of size 10 GiB is set 
Command (m for help): w 
The partition table has been altered! 
Calling ioctl() to re-read partition table. 
Syncing disks. 

/etc/init.d/oracleasm status 
Checking if ASM is loaded: yes
Checking if /dev/oracleasm is mounted: yes 

/etc/init.d/oracleasm createdisk DATAVOL1 /dev/sdf1 
Marking disk “DATAVOL1” as an ASM disk:                    [  OK  ] 

/etc/init.d/oracleasm listdisks 
DATAVOL1

像这样我们需要根据需要创建其他磁盘。

2.4.2 从其他节点检查ASM磁盘

oracleasm scandisks

oracleasm listdisks

2.5 创建目录并更改权限

mkdir -p  /u01/app/19c/grid
chown -R grid:oinstall /u01
mkdir -p /u01/app/oracle/product/19c/db_1
chown -R oracle:oinstall /u01/app/oracle
chmod -R 775 /u01/

2.6 节点之间SSH设置

unzip /d01/app/19c/grid/LINUX.X64_193000_grid_home.zip 
cd $GRID_HOME/deinstall 
./sshUserSetup.sh -user oracle -hosts " AUS-LNDBASMT-001 AUS-LNDBASMT-002" -noPromptPassphrase

2.7 使用 CLUVFY 进行预检查

使用 CLUVFY 命令检查集群安装准备情况并在出现任何问题时进行纠正。

1 2	`cd` `$GRID_HOME` `./runcluvfy.sh stage -pre crsinst -n AUS-LNDBASMT-001,AUS-LNDBASMT-002`

2.8 为 RAC 安装 19C GRID

1 2	`cd` `/d01/app/19c/grid/` `./gridSetup.sh`

GRID 设置向导已启动...

现在请按照如下所述的步骤操作 –

选择“为新集群配置 Oracle Grid Infrastructure”选项，然后单击“下一步”按钮。

单击“下一步”按钮，选择“配置 Oracle 独立集群”选项。

输入集群名称、SCAN 名称和 SCAN 端口，然后单击“下一步”按钮。

注意–集群名称长度应在 15 个字符以内，否则安装将失败。

在“集群节点信息”屏幕上，单击“添加”按钮。输入集群中第二个节点的详细信息，然后单击“确定”按钮。单击“SSH 连接...”按钮并输入“oracle”用户的密码。单击“设置”按钮配置 SSH 连接，完成后单击“测试”按钮进行测试。测试完成后，单击“下一步”按钮。

检查公共和专用网络是否指定正确。如果显示 NAT 接口，请记住将其标记为“请勿使用”。单击“下一步”按钮。

单击“下一步”按钮，选择“使用 Oracle Flex ASM 进行存储”选项。

选择“是”并单击下一步

如果您希望为 GIMR 创建单独的磁盘，请选择“是”，然后单击“下一步”。否则单击“否”。

注意：如果您希望在单独的磁盘上创建 GIMR，则磁盘大小必须至少为 32G。

首先使用更改发现路径浏览路径 /dev/oracleasm/disks*。将冗余设置为“正常”，单击“5GB DISK”用于 OCR 和 Voting 磁盘配置，然后单击“下一步”按钮

如果您需要创建 GIMR。请记住这不是强制性的。

输入凭据并单击“下一步”按钮。

单击“下一步”按钮接受默认 IPMI 选项。

不要在 EM 注册。单击“下一步”按钮。

我们使用单个用户和组管理 ASM 添加数据库，因此将组设置为“oinstall”并单击“下一步”按钮。单击“是”按钮接受后续对话框中的警告。

输入 Oracle Base 位置“/d01/app/oracle”，然后单击“下一步”按钮。我们已经为后面的数据库安装预先创建了目录，因此忽略随后有关Oracle Base不为空的警告，单击“是”按钮。

单击“下一步”按钮接受默认清单目录。

如果您希望根脚本自动运行，请输入相关凭据。单击“下一步”按钮。

等待先决条件检查完成。如果您有任何问题，请使用“修复并再次检查”按钮。完成可能的修复后，选中“全部忽略”复选框，然后单击“下一步”按钮。对于此类安装，“网络时间协议 (NTP)”测试可能会失败。还行吧。它可以被修复。

如果您对摘要信息感到满意，请单击“安装”按钮。

现在GRID安装完成了。

通过发出以下命令检查正在运行的进程

ps -ef|grep d.bin
 $GRID_HOME/crsctl stat res -t –> 此命令将显示两个节点正在运行的服务

2.9 安装 Oracle 软件二进制文件

将软件文件解压到您的 DB 主目录中

1	`unzip LINUX.X64_193000_db_home.zip`

运行以下命令来设置显示

1	`./runInstaller`

选择仅安装软件选项，然后单击下一步按钮。

单击“下一步”按钮选择 Oracle Real Application Clusters 数据库安装选项。

确保选择了两个节点，然后单击“下一步”按钮。

选择企业版选项，然后单击下一步按钮。

输入 /u01/app/orabase 作为 Oracle 库，输入 /u01/app/oracle/product/19c/db_1 作为软件位置，然后单击 Next 按钮。

自动运行配置脚本 - 将其留空。

然后单击安装按钮。出现提示时，为两个节点运行 root.sh。现在19C软件二进制安装已经完成。

2.10 创建数据库

由于我们已经创建了所需的磁盘组（例如 DATA 和 FRA），现在我们正在继续创建数据库。

cd $ORACLE_HOME/bin

./dbca

请按照屏幕截图进行操作。

选择创建数据库并点击“下一步”

选择高级配置，点击“下一步”

选择通用或事务处理，然后单击“下一步”

确保两个节点都被选中

提供数据库名称、SID，然后单击“下一步”

选择数据库文件位置，然后单击“下一步”

选择 FRA 位置、大小，然后单击“下一步”

分配适当的内存和其他必要的详细信息，然后单击“下一步”

选择下方并点击“下一步”

为所有用户提供相同的密码，然后单击“下一步”

单击下一步，将创建数据库。

2.11 RAC 设置的安装后检查

通过触发以下命令检查 RAC 的状态 –

$GRID_HOME/crsctl stat res -t
srvctl config database -d infra 
srvctl status database -d infra 
srvctl config scan

2.12 数据库从 19.3 升级到 19.5

对于版本升级，我们需要在两个节点上一一打补丁。

1、停止oracle实例

srvctl stop instance -db POCDB -node aus-lndbasmt-001
 
srvctl status database -db pocdb

Instance POCDB1 is not running on node aus-lndbasmt-001

Instance POCDB2 is running on node aus-lndbasmt-002

2、Opatch版本及oracle补丁应用情况　

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

262

263

264

265

266

267

268

269

270

271

272

273

274

275

276

277

278

279

280

281

282

283

284

285

286

287

288

289

290

291

./Opatch version
 
OPatch Version: 12.2.0.1.17
 
OPatch succeeded.
 
[oracle@AUS-LNDBASMT-001 OPatch]$ ./Opatch lsinventory -oh /oracle/Oracle_Software/19cDB
 
Oracle Interim Patch Installer version 12.2.0.1.17
 
Copyright (c) 2020, Oracle Corporation.  All rights reserved.
 
Oracle Home       : /oracle/Oracle_Software/19cDB
 
Central Inventory : /oracle/u01/app/oraInventory
 
   from           : /oracle/Oracle_Software/19cDB/oraInst.loc
 
OPatch version    : 12.2.0.1.17
 
OUI version       : 12.2.0.7.0
 
Log file location : /oracle/Oracle_Software/19cDB/cfgtoollogs/opatch/opatch2020-07-31_12-19-31PM_1.log
 
Lsinventory Output file location : /oracle/Oracle_Software/19cDB/cfgtoollogs/opatch/lsinv/lsinventory2020-07-31_12-19-31PM.txt
 
——————————————————————————–
 
Local Machine Information::
 
Hostname: AUS-LNDBASMT-001.wiley.com
 
ARU platform id: 226
 
ARU platform description:: Linux x86-64
 
Installed Top-level Products (1):
 
Oracle Database 19c                                                  19.0.0.0.0
 
There are 1 products installed in this Oracle Home.
 
Interim patches (2) :
 
Patch  29585399     : applied on Thu Apr 18 03:21:33 EDT 2019
 
Unique Patch ID:  22840393
 
Patch description:  “OCW RELEASE UPDATE 19.3.0.0.0 (29585399)”
 
   Created on 9 Apr 2019, 19:12:47 hrs PST8PDT
 
   Bugs fixed:
 
     27222128, 27572040, 27604329, 27760043, 27877830, 28302580, 28470673
 
     28621543, 28642469, 28699321, 28710663, 28755846, 28772816, 28785321
 
     28800508, 28808652, 28815557, 28847541, 28847572, 28870496, 28871040
 
     28874416, 28877252, 28881191, 28881848, 28888083, 28911140, 28925250
 
     28925460, 28935956, 28940472, 3, 28942694, 28951332, 28963036, 28968779
 
     28980448, 28995287, 29003207, 29003617, 29016294, 29018680, 29024876
 
     29026154, 29027933, 29047127, 29052850, 29058476, 29111631, 29112455
 
     29117337, 29123444, 29125708, 29125786, 29129476, 29131772, 29132456
 
     29139727, 29146157, 29147849, 29149170, 29152603, 29152752, 29154631
 
     29154636, 29154829, 29159216, 29159661, 29160462, 29161923, 29169540
 
     29169739, 29170717, 29173618, 29181568, 29182920, 29183298, 29186091
 
     29191827, 29201143, 29201695, 29209545, 29210577, 29210610, 29210624
 
     29210683, 29213641, 29219627, 29224294, 29225861, 29229839, 29235934
 
     29242906, 29243749, 29244495, 29244766, 29244968, 29248723, 29249583
 
     29251564, 29255616, 29260224, 29261695, 29271019, 29273360, 29282090
 
     29282666, 29285453, 29285621, 29290235, 29292232, 29293806, 29294753
 
     29299830, 29307090, 29307109, 29311336, 29329675, 29330791, 29339299
 
     29357821, 29360467, 29360775, 29367971, 29368725, 29379299, 29379381
 
     29380527, 29381000, 29382296, 29391301, 29393649, 29402110, 29411931
 
     29413360, 29457319, 29465047
 
Patch  29517242     : applied on Thu Apr 18 03:21:17 EDT 2019
 
Unique Patch ID:  22862832
 
Patch description:  “Database Release Update : 19.3.0.0.190416 (29517242)”
 
   Created on 17 Apr 2019, 23:27:10 hrs PST8PDT
 
   Bugs fixed:
 
     29515240, 14735102, 19697993, 20313356, 21965541, 25806201, 25883179
 
     25986062, 26476244, 26611353, 26872233, 27369515, 27423500, 27666312
 
     27710072, 27846298, 27957203, 28064977, 28072567, 28129791, 28181021
 
     28210681, 28279456, 28313275, 28350595, 28371123, 28379065, 28431445
 
     28463226, 28489419, 28502773, 28513333, 28534475, 28561704, 28569897
 
     28572533, 28572544, 28587723, 28593682, 28594086, 28597221, 28601957
 
     28605066, 28606598, 28625862, 28627033, 28636532, 28643718, 28644549
 
     28645570, 28646200, 28646939, 28649388, 28655209, 28663782, 28673945
 
     28692275, 28694872, 28696373, 28705231, 28710385, 28710734, 28714461
 
     28718469, 28730079, 28740708, 28760206, 28772390, 28774416, 28777214
 
     28789531, 28791852, 28795551, 28802734, 28804517, 28810381, 28811560
 
     28815123, 28815355, 28819640, 28824482, 28833912, 28835937, 28862532
 
     28863432, 28873575, 28876253, 28876639, 28884931, 28888327, 28892794
 
     28897512, 28899663, 28901126, 28905457, 28907196, 28912691, 28915561
 
     28917080, 28918429, 28919145, 28922227, 28922532, 28922608, 28925634
 
     28925880, 28933158, 28936114, 28937717, 28938698, 28940179, 28940281
 
     28941901, 28942455, 28945421, 28945994, 28951533, 28952168, 28954762
 
     28955606, 28957292, 28957723, 28962775, 28965231, 28966444, 28974083
 
     28977322, 28983095, 28983486, 28986326, 28986481, 28988482, 28989306
 
     28993295, 28994307, 28996376, 29000000, 29001888, 29002927, 29003738
 
     29006318, 29006621, 29007321, 29007775, 29008035, 29011936, 29013475
 
     29014076, 29015118, 29017265, 29018655, 29019121, 29021063, 29021352
 
     29024552, 29026582, 29026606, 29027456, 29027694, 29027940, 29031575
 
     29031600, 29032234, 29032457, 29032607, 29033052, 29033145, 29033200
 
     29033280, 29034587, 29037290, 29038528, 29039089, 29039510, 29043554
 
     29043651, 29043725, 29044763, 29044954, 29047850, 29048289, 29048498
 
     29048605, 29050560, 29050765, 29051702, 29052726, 29053783, 29056024
 
     29056270, 29056560, 29059011, 29061959, 29062692, 29062848, 29062860
 
     29062868, 29110526, 29110783, 29110790, 29110797, 29110802, 29110805
 
     29111598, 29113282, 29113305, 29117526, 29117642, 29119077, 29120223
 
     29122224, 29122254, 29123297, 29123432, 29123482, 29124368, 29125380
 
     29126345, 29127957, 29128935, 29129450, 29129497, 29129712, 29130219
 
     29131539, 29132938, 29134447, 29136111, 29138641, 29141316, 29141341
 
     29141685, 29142667, 29144995, 29145214, 29145730, 29149829, 29150338
 
     29151520, 29152357, 29155099, 29157389, 29158680, 29158899, 29159909
 
     29159936, 29160174, 29162095, 29163415, 29163437, 29163524, 29163567
 
     29167111, 29167342, 29167374, 29167940, 29168219, 29168433, 29169073
 
     29169215, 29171942, 29172618, 29172826, 29173140, 29173373, 29173817
 
     29174004, 29176318, 29177466, 29177543, 29177886, 29178385, 29180313
 
     29180455, 29180559, 29180893, 29181153, 29181231, 29181620, 29181743
 
     29181923, 29182019, 29183912, 29184297, 29184666, 29185193, 29186456
 
     29189302, 29189307, 29189889, 29190235, 29190474, 29190740, 29191541
 
     29192419, 29192468, 29192685, 29193207, 29194205, 29194367, 29194493
 
     29194827, 29195279, 29195337, 29195758, 29196725, 29199635, 29199733
 
     29200316, 29200700, 29201494, 29201539, 29202104, 29202850, 29203122
 
     29203166, 29203425, 29203443, 29203604, 29205281, 29205323, 29205419
 
     29205463, 29205767, 29205918, 29206109, 29206605, 29207073, 29208260
 
     29208732, 29211457, 29211724, 29212012, 29212433, 29212611, 29213351
 
     29213775, 29213850, 29213879, 29214561, 29214960, 29216746, 29216984
 
     29217294, 29217472, 29217828, 29217848, 29218570, 29219205, 29219273
 
     29220079, 29221248, 29221891, 29222031, 29222784, 29223833, 29223859
 
     29223967, 29224065, 29224605, 29225076, 29227602, 29228869, 29229164
 
     29229754, 29229844, 29229955, 29230252, 29230565, 29231133, 29232117
 
     29232154, 29234123, 29237538, 29240307, 29241345, 29242017, 29242884
 
     29243958, 29245137, 29245160, 29246163, 29247415, 29247712, 29247906
 
     29248552, 29248835, 29248858, 29249991, 29250059, 29251259, 29253184
 
     29253871, 29254031, 29254930, 29255178, 29255273, 29255431, 29255435
 
     29256426, 29259119, 29259320, 29261906, 29262512, 29262887, 29265448
 
     29266248, 29266899, 29267292, 29268412, 29269171, 29270585, 29273539
 
     29273735, 29273847, 29274428, 29274564, 29274627, 29275461, 29278218
 
     29279658, 29279751, 29279854, 29282898, 29285503, 29285788, 29285956
 
     29286037, 29287130, 29287705, 29292837, 29293072, 29297863, 29297915
 
     29298220, 29299049, 29299082, 29299844, 29301566, 29302963, 29303918
 
     29304781, 29311588, 29312310, 29312734, 29312753, 29313347, 29313417
 
     29313525, 29314539, 29318410, 29319441, 29321489, 29323946, 29324568
 
     29325087, 29325105, 29325257, 29325993, 29327044, 29329087, 29331209
 
     29331380, 29331493, 29332771, 29333500, 29337310, 29338315, 29338453
 
     29338780, 29338913, 29339155, 29341209, 29343086, 29346943, 29347620
 
     29348176, 29350052, 29351386, 29351716, 29351749, 29352867, 29353271
 
     29355654, 29356547, 29356752, 29358828, 29360672, 29361801, 29363151
 
     29364171, 29364177, 29367019, 29367561, 29368253, 29373418, 29373588
 
     29374179, 29377986, 29378029, 29379978, 29382784, 29385652, 29386502
 
     29386635, 29386660, 29387274, 29388094, 29388524, 29388830, 29389889
 
     29390435, 29394140, 29394749, 29397954, 29398863, 29399100, 29399121
 
     29405012, 29405651, 29412066, 29412269, 29417884, 29423826, 29429264
 
     29429566, 29431485, 29435652, 29438736, 29439522, 29450421, 29451386
 
     29452576, 29452953, 29457807, 29460252, 29462957, 29486181, 29507616
 
     29521748, 29530812, 29531654, 29557336, 29558975, 29601461
 
——————————————————————————–
 
OPatch succeeded.
 
cd /oracle/patch/30125133/
 
/oracle/Oracle_Software/19cDB/OPatch/opatch query -is_rolling_patch
 
Oracle Interim Patch Installer version 12.2.0.1.17
 
Copyright (c) 2020, Oracle Corporation.  All rights reserved.
 
Oracle Home       : /oracle/Oracle_Software/19cDB
 
Central Inventory : /oracle/u01/app/oraInventory
 
   from           : /oracle/Oracle_Software/19cDB/oraInst.loc
 
OPatch version    : 12.2.0.1.17
 
OUI version       : 12.2.0.7.0
 
Log file location : /oracle/Oracle_Software/19cDB/cfgtoollogs/opatch/opatch2020-07-31_12-21-23PM_1.log
 
——————————————————————————–
 
 Patch is a rolling patch: true
 
 Patch is a FMW rolling patch: false
 
OPatch succeeded.

3、应用补丁

/oracle/Oracle_Software/19cDB/OPatch/opatch apply

Oracle Interim Patch Installer version 12.2.0.1.17

Copyright (c) 2020, Oracle Corporation.  All rights reserved.

Oracle Home       : /oracle/Oracle_Software/19cDB

Central Inventory : /oracle/u01/app/oraInventory

   from           : /oracle/Oracle_Software/19cDB/oraInst.loc

OPatch version    : 12.2.0.1.17

OUI version       : 12.2.0.7.0

Log file location : /oracle/Oracle_Software/19cDB/cfgtoollogs/opatch/opatch2020-07-31_12-22-07PM_1.log

Verifying environment and performing prerequisite checks…

OPatch continues with these patches:   30125133 

Do you want to proceed? [y|n]

y

User Responded with: Y

All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.

(Oracle Home = ‘/oracle/Oracle_Software/19cDB’)

Is the local system ready for patching? [y|n]

y

User Responded with: Y

Backing up files…

Applying interim patch ‘30125133’ to OH ‘/oracle/Oracle_Software/19cDB’

ApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.options.olap.awm, 19.0.0.0.0 ] , [ oracle.oraolap.mgmt, 19.0.0.0.0 ] , [ oracle.assistants.usm, 19.0.0.0.0 ] , [ oracle.assistants.asm, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms, 19.0.0.0.0…

Patching component oracle.rdbms.rsf, 19.0.0.0.0…

Patching component oracle.assistants.acf, 19.0.0.0.0…

Patching component oracle.assistants.deconfig, 19.0.0.0.0…

Patching component oracle.assistants.server, 19.0.0.0.0…

Patching component oracle.buildtools.rsf, 19.0.0.0.0…

Patching component oracle.ctx, 19.0.0.0.0…

Patching component oracle.ldap.rsf, 19.0.0.0.0…

Patching component oracle.network.rsf, 19.0.0.0.0…

Patching component oracle.rdbms.dbscripts, 19.0.0.0.0…

Patching component oracle.sdo, 19.0.0.0.0…

Patching component oracle.sqlplus, 19.0.0.0.0…

Patching component oracle.ldap.rsf.ic, 19.0.0.0.0…

Patching component oracle.rdbms.rman, 19.0.0.0.0…

Patching component oracle.ctx.atg, 19.0.0.0.0…

Patching component oracle.rdbms.oci, 19.0.0.0.0…

Patching component oracle.rdbms.util, 19.0.0.0.0…

Patching component oracle.xdk, 19.0.0.0.0…

Patching component oracle.ovm, 19.0.0.0.0…

Patching component oracle.network.listener, 19.0.0.0.0…

Patching component oracle.rdbms.install.plugins, 19.0.0.0.0…

Patching component oracle.dbjava.jdbc, 19.0.0.0.0…

Patching component oracle.dbdev, 19.0.0.0.0…

Patching component oracle.rdbms.deconfig, 19.0.0.0.0…

Patching component oracle.nlsrtl.rsf, 19.0.0.0.0…

Patching component oracle.oraolap.dbscripts, 19.0.0.0.0…

Patching component oracle.install.deinstalltool, 19.0.0.0.0…

Patching component oracle.dbjava.ic, 19.0.0.0.0…

Patching component oracle.sdo.locator, 19.0.0.0.0…

Patching component oracle.rdbms.scheduler, 19.0.0.0.0…

Patching component oracle.rdbms.dv, 19.0.0.0.0…

Patching component oracle.ons, 19.0.0.0.0…

Patching component oracle.ldap.security.osdt, 19.0.0.0.0…

Patching component oracle.ctx.rsf, 19.0.0.0.0…

Patching component oracle.duma, 19.0.0.0.0…

Patching component oracle.ldap.owm, 19.0.0.0.0…

Patching component oracle.oracore.rsf, 19.0.0.0.0…

Patching component oracle.rdbms.install.seeddb, 19.0.0.0.0…

Patching component oracle.odbc, 19.0.0.0.0…

Patching component oracle.sdo.locator.jrf, 19.0.0.0.0…

Patching component oracle.network.client, 19.0.0.0.0…

Patching component oracle.sqlplus.ic, 19.0.0.0.0…

Patching component oracle.dbjava.ucp, 19.0.0.0.0…

Patching component oracle.xdk.rsf, 19.0.0.0.0…

Patching component oracle.marvel, 19.0.0.0.0…

Patching component oracle.xdk.parser.java, 19.0.0.0.0…

Patching component oracle.rdbms.rsf.ic, 19.0.0.0.0…

Patching component oracle.nlsrtl.rsf.core, 19.0.0.0.0…

Patching component oracle.precomp.common, 19.0.0.0.0…

Patching component oracle.precomp.lang, 19.0.0.0.0…

Patch 30125133 successfully applied.

Sub-set patch [29517242] has become inactive due to the application of a super-set patch [30125133].

Please refer to Doc ID 2161861.1 for any possible further required actions.

Log file location: /oracle/Oracle_Software/19cDB/cfgtoollogs/opatch/opatch2020-07-31_12-22-07PM_1.log

OPatch succeeded.


4、启动oracle实列并验证补丁

srvctl start instance -db POCDB -node aus-lndbasmt-001

srvctl status database -db pocdb

Instance POCDB1 is not running on node aus-lndbasmt-001

Instance POCDB2 is not running on node aus-lndbasmt-002

[oracle@AUS-LNDBASMT-001 30125133]$ sqlplus “/ as sysdba”

SQL*Plus: Release 19.0.0.0.0 – Production on Fri Jul 31 12:30:38 2020

Version 19.5.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production

Version 19.5.0.0.0

SQL> select * from v$version;

BANNER

——————————————————————————–

BANNER_FULL

—————————————————————————————————————————————————————-

BANNER_LEGACY                                                                                                                                      CON_ID

——————————————————————————– ———-

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production

Version 19.5.0.0.0

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production                                  0

SQL> exit

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production

Version 19.5.0.0.0

在两个节点中执行上述步骤后，如果发现任何无效对象，则应运行 utlrp.sql 来重新验证这些对象。

cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> @utlrp.sql

三、附录

3.1 下载软件

Oracle Database 19c 第 3 版 Linux x86-64软件下载链接 –

https://www.oracle.com/database/technologies/oracle-database-software-downloads.html

groupadd -g 1000 oinstallgroupadd -g 1100 asmadmingroupadd -g 1200 dbagroupadd -g 1300 asmdbagroupadd -g 1301 asmoper groupadd -g 1400 oper
/usr/sbin/useradd -u 1001 -g oinstall -G asmadmin,asmdba,asmoper grid/usr/sbin/useradd -u 1000 -g oinstall -G dba,asmdba,oper oracleecho "grid" | passwd --stdin gridecho "oracle" | passwd --stdin oracle