12.2.0.1 Grid RUR 安装

RU安装参考：http://blog.itpub.net/20747382/viewspace-2199389/ 数据库版本： 12.2.0.1.0（已经安装p26133434_122010_Linux-x86-64） RUR:p26133434_122010_Linux-x86-64.zip 1,Opatch 版本检查 [grid@prod04 soft]$ /u01/app/grid/OPatch/opatch version OPatch Version: 12.2.0.1.14 OPatch succeeded. [grid@prod04 soft]$ /u01/app/oracle/product/12.2.0/dbhome_1/OPatch/opatch version OPatch Version: 12.2.0.1.14 OPatch succeeded. 2，补丁安装 [root@prod04 ~]# /u01/app/grid/OPatch/opatchauto apply /soft/28251142 OPatchauto session is initiated at Wed Aug  8 12:28:08 2018 System initialization log file is /u01/app/grid/cfgtoollogs/opatchautodb/systemconfig2018-08-08_12-28-14PM.log. Session log file is /u01/app/grid/cfgtoollogs/opatchauto/opatchauto2018-08-08_12-28-26PM.log The id for this session is XX8F OPATCHAUTO-72141: Grid patching cannot be performed in rolling mode. OPATCHAUTO-72141: Grid is installed only on a single node. OPATCHAUTO-72141: Execute opatchauto in non-rolling mode. OPatchAuto failed. OPatchauto session completed at Wed Aug  8 12:28:42 2018 Time taken to complete the session 0 minute, 35 seconds  opatchauto failed with error code 42 [root@prod04 ~]# /u01/app/grid/OPatch/opatchauto apply /soft/28251142 -nonrolling OPatchauto session is initiated at Wed Aug  8 12:28:53 2018 System initialization log file is /u01/app/grid/cfgtoollogs/opatchautodb/systemconfig2018-08-08_12-28-57PM.log. Session log file is /u01/app/grid/cfgtoollogs/opatchauto/opatchauto2018-08-08_12-29-05PM.log The id for this session is ZCJ5 Executing OPatch prereq operations to verify patch applicability on home /u01/app/grid Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12.2.0/dbhome_1 Patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/dbhome_1 Patch applicability verified successfully on home /u01/app/grid Verifying SQL patch applicability on home /u01/app/oracle/product/12.2.0/dbhome_1 SQL patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/dbhome_1 Preparing to bring down database service on home /u01/app/oracle/product/12.2.0/dbhome_1 Successfully prepared home /u01/app/oracle/product/12.2.0/dbhome_1 to bring down database service Bringing down database service on home /u01/app/oracle/product/12.2.0/dbhome_1 Following database(s) and/or service(s) are stopped and will be restarted later during the session: cdb Database service successfully brought down on home /u01/app/oracle/product/12.2.0/dbhome_1 Bringing down CRS service on home /u01/app/grid Prepatch operation log file location: /u01/app/grid_base/crsdata/prod04/crsconfig/crspatch_prod04_2018-08-08_12-31-44AM.log CRS service brought down successfully on home /u01/app/grid Performing prepatch operation on home /u01/app/oracle/product/12.2.0/dbhome_1 Perpatch operation completed successfully on home /u01/app/oracle/product/12.2.0/dbhome_1 Start applying binary patch on home /u01/app/oracle/product/12.2.0/dbhome_1 Binary patch applied successfully on home /u01/app/oracle/product/12.2.0/dbhome_1 Performing postpatch operation on home /u01/app/oracle/product/12.2.0/dbhome_1 Postpatch operation completed successfully on home /u01/app/oracle/product/12.2.0/dbhome_1 Start applying binary patch on home /u01/app/grid Binary patch applied successfully on home /u01/app/grid Starting CRS service on home /u01/app/grid Postpatch operation log file location: /u01/app/grid_base/crsdata/prod04/crsconfig/crspatch_prod04_2018-08-08_12-42-15AM.log CRS service started successfully on home /u01/app/grid Starting database service on home /u01/app/oracle/product/12.2.0/dbhome_1 Database service successfully started on home /u01/app/oracle/product/12.2.0/dbhome_1 Preparing home /u01/app/oracle/product/12.2.0/dbhome_1 after database service restarted No step execution required.........   Trying to apply SQL patch on home /u01/app/oracle/product/12.2.0/dbhome_1 SQL patch applied successfully on home /u01/app/oracle/product/12.2.0/dbhome_1 OPatchAuto successful. --------------------------------Summary-------------------------------- Patching is completed successfully. Please find the summary as follows: Host:prod04 RAC Home:/u01/app/oracle/product/12.2.0/dbhome_1 Version:12.2.0.1.0 Summary: ==Following patches were SKIPPED: Patch: /soft/28251142/27128906 Reason: This patch is not applicable to this specified target type - "rac_database" Patch: /soft/28251142/26839277 Reason: This patch is not applicable to this specified target type - "rac_database" Patch: /soft/28251142/27144050 Reason: This patch is not applicable to this specified target type - "rac_database" ==Following patches were SUCCESSFULLY applied: Patch: /soft/28251142/27872031 Log: /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-08-08_12-33-05PM_1.log Patch: /soft/28251142/28222334 Log: /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-08-08_12-33-05PM_1.log Host:prod04 CRS Home:/u01/app/grid Version:12.2.0.1.0 Summary: ==Following patches were SUCCESSFULLY applied: Patch: /soft/28251142/26839277 Log: /u01/app/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-08-08_12-35-28PM_1.log Patch: /soft/28251142/27128906 Log: /u01/app/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-08-08_12-35-28PM_1.log Patch: /soft/28251142/27144050 Log: /u01/app/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-08-08_12-35-28PM_1.log Patch: /soft/28251142/27872031 Log: /u01/app/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-08-08_12-35-28PM_1.log Patch: /soft/28251142/28222334 Log: /u01/app/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-08-08_12-35-28PM_1.log OPatchauto session completed at Wed Aug  8 13:02:46 2018 Time taken to complete the session 33 minutes, 54 seconds [root@prod04 ~]#  3，补丁确认 之前几经安装了26133434 RU,安装28251142 RUR之后， 之前数据库补丁回滚。 #database [oracle@prod04 ~]$ /u01/app/oracle/product/12.2.0/dbhome_1/OPatch/opatch lspatches 28222334;OCW JAN 2018 RELEASE UPDATE REVISION 12.2.0.1.0(ID:180620) (28222334) 27872031 ;Database Jan 2018 Release Update Revision : 12.2.0.1.180717 (27872031) OPatch succeeded. #grid [grid@prod04 ~]$ /u01/app/grid/OPatch/opatch lspatches 28222334;OCW JAN 2018 RELEASE UPDATE REVISION 12.2.0.1.0(ID:180620) (28222334) 27872031;Database Jan 2018 Release Update Revision : 12.2.0.1.180717 (27872031) 27144050;Tomcat Release Update 12.2.0.1.0(ID:171023.0830) (27144050) 27128906;ACFS Release Update : 12.2.0.1.0 (27128906) 26839277;DBWLM RELEASE UPDATE 12.2.0.1.0(ID:170913) (26839277) OPatch succeeded.