数据库版本：12.2.0.1.0

RUR:p28251142_122010_Linux-x86-64.zip

12.2.0.1 Grid Infrastructure Release Update Revision (Revision)
Release Date    Version    Download Link
17-Jul-2018    GI Jan2017 Release Update Revision 12.2.0.1.180717    Patch 28251142
17-Jul-2018    GI Apr2017 Release Update Revision 12.2.0.1.180717    Patch 28251239
17-Apr-2018    GI Oct2017 Release Update Revision 12.2.0.1.180417    Patch 27696758
17-Apr-2018    GI Jan2017 Release Update Revision 12.2.0.1.180417    Patch 27696736
16-Jan-2018    GI Jul2017 Release Update Revision 12.2.0.1.180116    Patch 27224023
16-Jan-2018    GI Oct2017 Release Update Revision 12.2.0.1.180116    Patch 27224075
17-Oct-2017    GI Jul2017 Release Update Revision 12.2.0.1.171017    

1,opatch 版本确定

grid
[grid@prod04 ~]$ /u01/app/grid_home/OPatch/opatch version
OPatch Version: 12.2.0.1.14

database
[oracle@prod04 soft]$ /u01/app/oracle/product/12.2.0/dbhome_1/OPatch/opatch version

OPatch Version: 12.2.0.1.14

2,grid 用户解压补丁

3，RUR 安装

[root@prod04 ~]# /u01/app/grid_home/OPatch/opatchauto apply /soft/28251142 -nonrolling

遇到报错，补丁安装

4，故障解决方法

$GRID_HOME/bin/clscfg -localpatch
$GRID_HOME/crs/install/rootcrs.sh  -lock

启动故障报错：

手动启动has报错：

[root@prod04 ~]# /u01/app/grid_home/bin/crsctl start crs

CRS-6706: Oracle Clusterware Release patch level ('3106313030') does not match Software patch level ('0'). Oracle Clusterware cannot be started.

CRS-4000: Command Start failed, or completed with errors


执行如下2条命令，集群软件正常启动：

[root@prod04 ~]# /u01/app/grid_home/bin/clscfg -localpatch

Creating OCR keys for user 'root', privgrp 'root'..

Operation successful.

[root@prod04 ~]# /u01/app/grid_home/crs/install/rootcrs.sh -lock

Using configuration parameter file: /u01/app/grid_home/crs/install/crsconfig_params

The log of current session can be found at:

  /u01/app/grid/crsdata/prod04/crsconfig/crslock_prod04_2018-08-09_01-47-23PM.log

2018/08/09 13:47:27 CLSRSC-329: Replacing Clusterware entries in file 'oracle-ohasd.service'

[root@prod04 ~]# /u01/app/grid_home/bin/crsctl start crs

CRS-4123: Oracle High Availability Services has been started.

5，数据库应用补丁

[oracle@prod04 ~]$ sqlplus / as sysdba


SQL*Plus: Release 12.2.0.1.0 Production on Thu Aug 9 13:50:22 2018


Copyright (c) 1982, 2016, Oracle.  All rights reserved.


Connected to an idle instance.


SQL> startup



ORACLE instance started.


Total System Global Area 2466250752 bytes

Fixed Size 
        
    8795760 bytes

Variable Size 
        
  738199952 bytes

Database Buffers 
    
1711276032 bytes

Redo Buffers 
        
    7979008 bytes

Database mounted.

Database opened.

SQL> SQL> SQL> alter pluggable database all open;

show pdbs;


Pluggable database altered.


SQL> 

    CON_ID CON_NAME 
            
  OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------


    
2 PDB$SEED 
            
  READ ONLY  NO


    
3 PDB01 
            
  READ WRITE NO

SQL> select patch_id,action,status,BUNDLE_SERIES from dba_registry_sqlpatch;


no rows selected

SQL> exit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

[oracle@prod04 ~]$ 

[oracle@prod04 ~]$ cd /u01/app/oracle/product/12.2.0/dbhome_1/OPatch/

[oracle@prod04 OPatch]$ 

[oracle@prod04 OPatch]$ ./datapatch -verbose

SQL Patching tool version 12.2.0.1.0 Production on Thu Aug  9 13:54:35 2018

Copyright (c) 2012, 2018, Oracle.  All rights reserved.


Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_38873_2018_08_09_13_54_35/sqlpatch_invocation.log


Connecting to database...OK

Note:  Datapatch will only apply or rollback SQL fixes for PDBs

       that are in an open state, no patches will be applied to closed PDBs.

       Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation

       (Doc ID 1585822.1)

Bootstrapping registry and package to current versions...done

Determining current state...done


Current state of SQL patches:

Bundle series 12.2.0.1.180717DBJAN2018RUR:

  ID 180717 in the binary registry and not installed in any PDB


Adding patches to installation queue and performing prereq checks...

Installation queue:

  For the following PDBs: CDB$ROOT PDB$SEED PDB01

    Nothing to roll back

    The following patches will be applied:

      27872031 (DATABASE JAN 2018 RELEASE UPDATE REVISION 12.2.0.1.180717)


Installing patches...

Patch installation complete.  Total patches installed: 3


Validating logfiles...

Patch 27872031 apply (pdb CDB$ROOT): SUCCESS

  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/27872031/22311840/27872031_apply_CDB_CDBROOT_2018Aug09_13_55_39.log (no errors)

Patch 27872031 apply (pdb PDB$SEED): SUCCESS

  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/27872031/22311840/27872031_apply_CDB_PDBSEED_2018Aug09_13_58_16.log (no errors)

Patch 27872031 apply (pdb PDB01): SUCCESS

  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/27872031/22311840/27872031_apply_CDB_PDB01_2018Aug09_13_58_16.log (no errors)

SQL Patching tool complete on Thu Aug  9 13:59:54 2018

select patch_id,action,status,BUNDLE_SERIES from dba_registry_sqlpatch;