Oracle 19C RAC 19.14 不停机滚动升级至19.18操作记录.pdf

尚雷

All China Database Union

2218

42页

45次

2023-05-18

10墨值下载



一、RU信息概述

根据Oracle官网介绍，对于Oracle 19C，其通常会在每年1月、4月、7月、10月每个季度发布一个

RU，为使客户能够在其环境稳定之后即刻获得最新的安全相关修复，其在每年1月，4月，7月，10月还

为最近的两个RU提供RUR。

Oracle 在2023年1月份发布了19.18的RU，对应GI和DB其RU信息分别如下：

Oracle 19.18 GI的RU编号: 35037840, DB的RU 编号：34765931。

二、升级opatch

升级19.18，要求opatch版本不低于 12.2.0.1.34，本次从MOS上下载的opatch版本为12.2.0.1.37

2.1 升级opatch

备份之前建议分别对grid用户及oracle用户OPatch进行备份

2.2 查看opatch版本

三、运行opatch冲突检查

3.1 grid用户检查

# 升级前opatch版本检查

[grid@xxxx ~]$ opatch version

OPatch Version: 12.2.0.1.28

OPatch succeeded.

# grid用户

[root@xxx]# cd /u01/app/19.3.0/grid

[root@xxx]# mv OPatch OPatch_bak

# Oracle用户

[root@xxx]# cd /u01/app/oracle/product/19.3.0/db_1

[root@xxx]# mv OPatch OPatch_bak

# 升级grid用户opatch 【每个节点都需执行】

[root@xxx]# unzip /home/soft/p6880880_190000_Linux-x86-64.zip -d

/u01/app/19.3.0/grid

[root@xxx]# cd /u01/app/19.3.0/grid

[root@xxx]# chown -R grid:oinstall ./OPatch

# 升级oracle用户opatch 【每个节点都需执行】

[root@xxx]# unzip /home/soft/p6880880_190000_Linux-x86-64.zip -d

/u01/app/oracle/product/19.3.0/db_1

[root@xxx]# cd /u01/app/oracle/product/19.3.0/db_1

[root@xxx]# chown -R oracle:oinstall ./OPatch

# grid用户

[grid@xxx ~]$ $ORACLE_HOME/OPatch/opatch version

OPatch Version: 12.2.0.1.37

OPatch succeeded.

# oracle用户

[oracle@xxx ~]$ $ORACLE_HOME/OPatch/opatch version

OPatch Version: 12.2.0.1.37

OPatch succeeded.

1）$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir

/home/soft/34762026/34765931

[grid@xxx ~]$ $ORACLE_HOME/OPatch/opatch prereq

CheckConflictAgainstOHWithDetail -phBaseDir /home/soft/34762026/34765931

Oracle Interim Patch Installer version 12.2.0.1.28

PREREQ session

Oracle Home    : /u01/app/19.3.0/grid

Central Inventory : /u01/app/oraInventory

 from      : /u01/app/19.3.0/grid/oraInst.loc

OPatch version  : 12.2.0.1.28

OUI version    : 12.2.0.7.0

Log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2023-05-

15_10-20-00AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

===========日志内容如下

[May 15, 2023 10:20:01 AM] [INFO]  PREREQ session

[May 15, 2023 10:20:01 AM] [INFO]  CAS DynaORCL Loading :

                 CasClasspathLoader: Opatch path to be

searched for cas jars :/u01/app/19.3.0/grid/OPatch/jlib

                 CasClasspathLoader : Non CAS based Home

[May 15, 2023 10:20:01 AM] [INFO]  CUP_LOG: Trying to load HomeOperations

object

[May 15, 2023 10:20:01 AM] [INFO]  CUP_LOG: HomeOperations object created.

CUP1.0 is enabled

[May 15, 2023 10:20:01 AM] [INFO]  OPatch invoked as follows: 'prereq

CheckConflictAgainstOHWithDetail -phBaseDir /home/soft/34762026/34765931 -

invPtrLoc /u01/app/19.3.0/grid/oraInst.loc '

[May 15, 2023 10:20:01 AM] [INFO]  Runtime args: [-Xmx3072m, -

XX:+HeapDumpOnOutOfMemoryError, -

XX:HeapDumpPath=/u01/app/19.3.0/grid/cfgtoollogs/opatch, -

DCommonLog.LOG_SESSION_ID=, -DCommonLog.COMMAND_NAME=prereq, -

DOPatch.ORACLE_HOME=/

u01/app/19.3.0/grid, -DOPatch.DEBUG=false, -DOPatch.MAKE=false, -

DOPatch.RUNNING_DIR=/u01/app/19.3.0/grid/OPatch, -DOPatch.MW_HOME=, -

DOPatch.WL_HOME=, -DOPatch.COMMON_COMPONENTS_HOME=, -

DOPatch.OUI_LOCATION=/u01/app/19.3.0/grid/oui, -DO

Patch.FMW_COMPONENT_HOME=, -DOPatch.OPATCH_CLASSPATH=, -

DOPatch.WEBLOGIC_CLASSPATH=, -DOPatch.SKIP_OUI_VERSION_CHECK=, -

DOPatch.NEXTGEN_HOME_CHECK=false, -DOPatch.PARALLEL_ON_FMW_OH=]

[May 15, 2023 10:20:01 AM] [INFO]  Heap in use : 55 MB

                 Total memory: 962 MB

                 Free memory : 906 MB

                 Max memory : 2731 MB

[May 15, 2023 10:20:01 AM] [INFO]  Oracle Home    : /u01/app/19.3.0/grid

of 42

10墨值下载

oracle 19c 升级 oracle

文档被以下合辑收录

Oracle合集（共49篇）

Oracle学习记录

文档被以下合辑收录

相关文档

评论