Oracle 18c PSU

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