数据库版本：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
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;
