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

# <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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30327022/viewspace-2642624/