ITPub博客

首页 > 数据库 > Oracle > Oracle 18c PSU

Oracle 18c PSU

原创 Oracle 作者:dmcatding 时间:2019-04-26 14:32:33 0 删除 编辑

1、18C RAC安装完毕后进行补丁修复,也就是更新PSU;

按照README要求:

OPatch 工具版本要求: 12.2.0.1.16 及以上版本

当前版本:OPatch Version: 12.2.0.1.14


下载地址:

https://updates.oracle.com/download/6880880.html


选择版本:  My Oracle Support patch  6880880  by selecting ARU link for the 18.0.0.0.0 release

备份之前的OPatch目录,把此压缩包解压到$ORACLE_HOME目录中;


$ unzip <OPATCH-ZIP> -d <ORACLE_HOME>

$ <ORACLE_HOME>/OPatch/opatch version

再次确认更新后的工具版本:OPatch Version: 12.2.0.1.17


2、下载Patch 29301682 - GI Release Update 18.6.0.0.190416

#使用grid用户解压到临时目录:


$ unzip p29301682_180000_Linux-x86-64.zip


#GI_HOME和DB_HOME均不共享,依次在两节点执行如下命令:

# <GI_HOME>/OPatch/opatchauto apply <UNZIPPED_PATCH_LOCATION>/29301682

补丁执行用户:root


[root@rac18c1 ~]# $ORACLE_HOME/OPatch/opatchauto apply /u01/soft/29301682/


OPatchauto session is initiated at Fri Apr 26 13:48:46 2019


System initialization log file is /u01/app/18.3.0/grid/cfgtoollogs/opatchautodb/systemconfig2019-04-26_01-48-51PM.log.


会话日志文件是/u01/app/18.3.0/grid/cfgtoollogs/opatchauto/opatchauto2019-04-26_01-49-56PM.log

此会话的 ID 为 DUAD


Executing OPatch prereq operations to verify patch applicability on home /u01/app/18.3.0/grid

Patch applicability verified successfully on home /u01/app/18.3.0/grid



Bringing down CRS service on home /u01/app/18.3.0/grid

CRS service brought down successfully on home /u01/app/18.3.0/grid



Start applying binary patch on home /u01/app/18.3.0/grid

Binary patch applied successfully on home /u01/app/18.3.0/grid



Starting CRS service on home /u01/app/18.3.0/grid

CRS service started successfully on home /u01/app/18.3.0/grid


OPatchAuto 成功。


--------------------------------Summary--------------------------------


Patching is completed successfully. Please find the summary as follows:


Host:rac18c1

CRS Home:/u01/app/18.3.0/grid

Version:18.0.0.0.0

Summary:


==Following patches were SUCCESSFULLY applied:


Patch: /u01/soft/29301682/28435192

Log: /u01/app/18.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-04-26_13-55-05下午_1.log


Patch: /u01/soft/29301682/28547619

Log: /u01/app/18.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-04-26_13-55-05下午_1.log


Patch: /u01/soft/29301682/29301631

Log: /u01/app/18.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-04-26_13-55-05下午_1.log


Patch: /u01/soft/29301682/29301643

Log: /u01/app/18.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-04-26_13-55-05下午_1.log


Patch: /u01/soft/29301682/29302264

Log: /u01/app/18.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-04-26_13-55-05下午_1.log




OPatchauto session completed at Fri Apr 26 14:07:53 2019

Time taken to complete the session 19 minutes, 7 seconds


#节点1执行完毕,在节点2执行:升级失败告终!!

MOS上有一篇文章提到这个问题 

CRS-6706: Oracle Clusterware Release patch level (‘nnn’) does not match Software patch level (‘mmm’) (文档 ID 1639285.1)

节点2因为执行RU脚本失败,但与之前的版本又不一致,所有在重启CRS后,无法启动。

官网给的解决方案,执行如下命令:

For 12.1 version :

Execute"<GI_HOME>/crs/install/rootcrs.sh -patch" as <root_user> on the problematic node and the patch level should be corrected.

For 12.2

Execute

"<GI_HOME>/crs/install/rootcrs.pl -prepatch"  

"<GI_HOME>/crs/install/rootcrs.pl -postpatch"and as <root_user> on the problematic node and the patch level should be corrected.


For Oracle Grid Infrastructure for a standalone server

Log in as root

# <GI_HOME>/crs/install/roothas.sh -unlock
# <GI_HOME>/crs/install/roothas.sh -patch


执行如上命令依然报错,因为我安装的18.3所以执行如下命令,成功

[root@rac18c2 crs]# /u01/app/18.3.0/grid/crs/install/rootcrs.sh -postpatch

#回退命令:

[root@rac18c2 ~]# $ORACLE_HOME/OPatch/opatchauto  rollback  /u01/soft/29301682/

#再次重新执行,成功

[root@rac18c2 ~]# $ORACLE_HOME/OPatch/opatchauto apply /u01/soft/29301682/


#此次18C 补丁升级完毕。

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30327022/viewspace-2642624/,如需转载,请注明出处,否则将追究法律责任。

上一篇: Oracle 18c
下一篇: Oracle PSU 简介
请登录后发表评论 登录
全部评论

注册时间:2015-07-04

  • 博文量
    48
  • 访问量
    49142