//
// Patch 20485724 - Oracle Grid Infrastructure Patch Set Update 12.1.0.2.3 (Apr2015) 安装过程
//
使用opatchauto将12.1.0.2.0 RAC(含ACFS)升级至最新PSU 12.1.0.2.3的过程:
###更新grid、oracle用户下的opatch至新版本
su - oracle
cd /opatch/"12.1.0.2.3"
unzip p6880880_121010_AIX64-5L.zip -d $ORACLE_HOME
grid@qc550705:/opatch/12.1.0.2.3>opatchauto version
OPatchauto version: 12.1.0.1.8 <--- apply 12.1.0.2.3 psu要求使用12.1.0.1.6及以上版本的opatch,否则会报一些莫名奇妙的错误
OPlan version: 12.1.0.2.2
OsysModel build: Wed Jul 01 06:20:29 PDT 2015
opatchauto succeeded.
另外bash必须装好
###创建OCM response file
如果没有创建过的话可以参考 966023.1
su - oracle
cd $ORACLE_HOME/ccr/bin
./emocmrsp
oracle@qc550705:/oracle/app/oracle/product/12.1.0.2/db_1/ccr/bin>ls -rlt ocm.rsp
-rw-r--r-- 1 oracle oinstall 623 Aug 07 12:34 ocm.rsp
cp ocm.rsp /home/oracle/ocm.rsp
###保存oracle和grid用户的opatch lsinventory输出,确保命令输出最后一行是"OPatch succeeded"
su - oracle
opatch lsinventory -detail -oh $ORACLE_HOME > /home/oracle/opatch_oracle.0707
su - grid
opatch lsinventory -detail -oh $ORACLE_HOME > /home/grid/opatch_grid.0707
如果有两个节点那么两个节点都要运行,且要把补丁copy到两个节点下,补丁目录需要约15G大小
###使用grid用户解压补丁
su - grid
cd "/opatch/12.1.0.2.3"
unzip p20485724_121020_AIX64-5L.zip
###检测是否存在patch conflict, root用户执行,两个节点都要执行
cd "/opatch/12.1.0.2.3"
opatchauto apply 20485724 -analyze -ocmrf /home/oracle/ocm.rsp
OPatch Automation Tool
Copyright (c)2014, Oracle Corporation. All rights reserved.
OPatchauto Version : 12.1.0.1.8
OUI Version : 12.1.0.2.0
Running from : /oracle/app/grid/product/12.1.0.2/grid_1
opatchauto log file: /oracle/app/grid/product/12.1.0.2/grid_1/cfgtoollogs/opatchauto/20485724/opa
NOTE: opatchauto is running in ANALYZE mode. There will be no change to your system.
OCM RSP file has been ignored in analyze mode.
Parameter Validation: Successful
Could not generate patching steps for the following databases as they do not run from the current host.
Database Name:
Oracle Home: /oracle/app/oracle/product/12.1.0/db_1
Host: qc550705 qc550707
To generate the patching steps for the above databases, execute it on host where the databases are running.
Configuration Validation: Successful
Patch Location: 20485724
Grid Infrastructure Patch(es): 19872484 20299018 20299022 20299023
DB Patch(es): 20299022 20299023
Patch Validation: Successful
Grid Infrastructure home:
/oracle/app/grid/product/12.1.0.2/grid_1
DB home(s):
/oracle/app/oracle/product/12.1.0.2/db_1
Analyzing patch(es) on "/oracle/app/oracle/product/12.1.0.2/db_1" ...
Patch "20485724/20299022" successfully analyzed on "/oracle/app/oracle/product/12.1.0.2/db_1" for apply.
Patch "20485724/20299023" successfully analyzed on "/oracle/app/oracle/product/12.1.0.2/db_1" for apply.
Analyzing patch(es) on "/oracle/app/grid/product/12.1.0.2/grid_1" ...
Patch "20485724/19872484" successfully analyzed on "/oracle/app/grid/product/12.1.0.2/grid_1" for apply.
Patch "20485724/20299018" successfully analyzed on "/oracle/app/grid/product/12.1.0.2/grid_1" for apply.
Patch "20485724/20299022" successfully analyzed on "/oracle/app/grid/product/12.1.0.2/grid_1" for apply.
Patch "20485724/20299023" successfully analyzed on "/oracle/app/grid/product/12.1.0.2/grid_1" for apply.
SQL changes, if any, are analyzed successfully on the following database(s): cdb550
Apply Summary:
Following patch(es) are successfully analyzed:
GI Home: /oracle/app/grid/product/12.1.0.2/grid_1: 19872484,20299018,20299022,20299023
DB Home: /oracle/app/oracle/product/12.1.0.2/db_1: 20299022,20299023
opatchauto succeeded.
###检测无冲突后,进入opatchauto安装补丁的步骤
这个环境内容比较丰富:除了DB、ASM、还有ACFS存在
root@qc550705:/>crsctl status res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ACFSDG.ACFSVOL1.advm
ONLINE ONLINE qc550705 Volume device /dev/a
sm/acfsvol1-48 is on
line,STABLE
ONLINE ONLINE qc550707 Volume device /dev/a
sm/acfsvol1-48 is on
line,STABLE
ora.ACFSDG.ACFSVOL3.advm
ONLINE ONLINE qc550705 Volume device /dev/a
sm/acfsvol3-48 is on
line,STABLE
ONLINE ONLINE qc550707 Volume device /dev/a
sm/acfsvol3-48 is on
line,STABLE
ora.ACFSDG.ACFSVOL_STD1.advm
OFFLINE OFFLINE qc550705 STABLE
ONLINE ONLINE qc550707 Volume device /dev/a
sm/acfsvol_std1-48 i
s online,STABLE
ora.ACFSDG.dg
ONLINE ONLINE qc550705 STABLE
ONLINE ONLINE qc550707 STABLE
ora.ASMNET1LSNR_ASM.lsnr
ONLINE ONLINE qc550705 STABLE
ONLINE ONLINE qc550707 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE qc550705 STABLE
ONLINE ONLINE qc550707 STABLE
ora.SYSDG.dg
ONLINE ONLINE qc550705 STABLE
ONLINE ONLINE qc550707 STABLE
ora.acfsdg.acfsvol1.acfs
ONLINE ONLINE qc550705 mounted on /acfs1,ST
ABLE
OFFLINE OFFLINE qc550707 volume /acfs1 offlin
e,STABLE
ora.acfsdg.acfsvol3.acfs
ONLINE ONLINE qc550705 mounted on /acfs3,ST
ABLE
OFFLINE OFFLINE qc550707 volume /acfs3 offlin
e,STABLE
ora.net1.network
ONLINE ONLINE qc550705 STABLE
ONLINE ONLINE qc550707 STABLE
ora.ons
ONLINE ONLINE qc550705 STABLE
ONLINE ONLINE qc550707 STABLE
ora.proxy_advm
ONLINE ONLINE qc550705 STABLE
ONLINE ONLINE qc550707 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE qc550707 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE qc550707 169.254.54.109,STABL
E
ora.acfsdb.acfsdb_svc.svc
1 OFFLINE OFFLINE STABLE
2 OFFLINE OFFLINE STABLE
ora.acfsdb.db
1 OFFLINE OFFLINE STABLE
2 OFFLINE OFFLINE STABLE
ora.acfsdg.acfsvol_std1.acfs
1 OFFLINE OFFLINE volume /acfsstd1 off
line,STABLE
ora.asm
1 ONLINE ONLINE qc550705 STABLE
2 ONLINE ONLINE qc550707 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.cdb550.cdb550svc.svc
1 OFFLINE OFFLINE STABLE
2 ONLINE ONLINE qc550705 STABLE
ora.cdb550.db
1 ONLINE ONLINE qc550707 Open,STABLE
2 ONLINE ONLINE qc550705 Open,STABLE
ora.cvu
1 OFFLINE OFFLINE STABLE
ora.mgmtdb
1 ONLINE ONLINE qc550707 Open,STABLE
ora.oc4j
1 ONLINE ONLINE qc550707 STABLE
ora.qc550705.vip
1 ONLINE ONLINE qc550705 STABLE
ora.qc550707.vip
1 ONLINE ONLINE qc550707 STABLE
ora.scan1.vip
1 ONLINE ONLINE qc550707 STABLE
--------------------------------------------------------------------------------
下列步骤适用于grid home & db home not shared,使用了ACFS的情况下,Patching Oracle RAC Database Homes and the GI Home Together
也就是使用了ACFS、DB_HOME和GRID_HOME不共享安装目录的情况下,使用opatchauto同时对DB_HOME和GRID_HOME进行打补丁的操作
For each node, perform the following steps:
---(1) .On the local node, unmount the ACFS file systems.(下述所有命令都用root执行)
crsctl stat res -w "TYPE = ora.acfs.type" -p | grep VOLUME
srvctl stop filesystem -d /dev/asm/acfsvol1-48 -n qc550705
srvctl stop filesystem -d /dev/asm/acfsvol1-48 -n qc550707
srvctl stop filesystem -d /dev/asm/acfsvol3-48 -n qc550705
srvctl stop filesystem -d /dev/asm/acfsvol3-48 -n qc550707
srvctl stop filesystem -d /dev/asm/acfsvol_std1-48 -n qc550707
**If the ACFS file system is not used for Oracle Database software and is registered in the ACFS registry, perform the following steps
/sbin/acfsutil registry
/bin/umount XX
/sbin/acfsutil info fs
acfsutil info fs: ACFS-03036: no mounted ACFS file systems <--显示这行才OK,继续下面的步骤
---(2).On the local node, apply the patch to the GI home and to the Database home.
As root user, execute the following command:
cd "/opatch/12.1.0.2.3"
opatchauto apply 20485724 -ocmrf /home/oracle/ocm.rsp
OPatch Automation Tool
Copyright (c)2014, Oracle Corporation. All rights reserved.
OPatchauto Version : 12.1.0.1.8
OUI Version : 12.1.0.2.0
Running from : /oracle/app/grid/product/12.1.0.2/grid_1
opatchauto log file: /oracle/app/grid/product/12.1.0.2/grid_1/cfgtoollogs/opatchauto/20485724/opatch_gi_2015-09-01_14-47-56_deploy.log
Parameter Validation: Successful
Could not generate patching steps for the following databases as they do not run from the current host.
Database Name:
Oracle Home: /oracle/app/oracle/product/12.1.0/db_1
Host: qc550705 qc550707
To generate the patching steps for the above databases, execute it on host where the databases are running.
Configuration Validation: Successful
Patch Location: 20485724
Grid Infrastructure Patch(es): 19872484 20299018 20299022 20299023
DB Patch(es): 20299022 20299023
Patch Validation: Successful
Grid Infrastructure home:
/oracle/app/grid/product/12.1.0.2/grid_1
DB home(s):
/oracle/app/oracle/product/12.1.0.2/db_1
Performing prepatch operations on CRS Home... Failed
Command "/oracle/app/grid/product/12.1.0.2/grid_1/perl/bin/perl -I/oracle/app/grid/product/12.1.0.2/grid_1/perl/lib -I/oracle/app/grid/product/12.1.0.2/grid_1/OPatch/opatchautotemp_qc550705/patchwork/crs/install /oracle/app/grid/product/12.1.0.2/grid_1/OPatch/opatchautotemp_qc550705/patchwork/crs/install/rootcrs.pl -prepatch" execution failed:
Died at /oracle/app/grid/product/12.1.0.2/grid_1/OPatch/opatchautotemp_qc550705/patchwork/crs/install/crspatch.pm line 773.
For more details, please refer to the log file "/oracle/app/grid/product/12.1.0.2/grid_1/cfgtoollogs/opatchauto/20485724/opatch_gi_2015-09-01_14-47-56_deploy.debug.log".
Apply Summary:
Following patch(es) failed to be installed:
GI Home: /oracle/app/grid/product/12.1.0.2/grid_1: 19872484,20299018,20299022,20299023
DB Home: /oracle/app/oracle/product/12.1.0.2/db_1: 20299022,20299023
Command failure exception
opatchauto failed with error code 2.
上述报错在MOS 1943498.1里找到了解决方法:
crsctl stop rollingpatch <---禁止rolling patch方式
root@qc550705:/>crsctl stop rollingpatch <-----有报错不用理会
CRS-1169: The cluster is consistent and the cluster active patch level is [0].
CRS-4000: Command Stop failed, or completed with errors.
再次apply patch
cd "/opatch/12.1.0.2.3"
opatchauto apply 20485724 -ocmrf /oracle/app/oracle/product/12.1.0.2/db_1/ccr/bin/ocm.rsp
OPatch Automation Tool
Copyright (c)2014, Oracle Corporation. All rights reserved.
OPatchauto Version : 12.1.0.1.8
OUI Version : 12.1.0.2.0
Running from : /oracle/app/grid/product/12.1.0.2/grid_1
opatchauto log file: /oracle/app/grid/product/12.1.0.2/grid_1/cfgtoollogs/opatchauto/20485724/opatch_gi_2015-09-01_15-56-52_deploy.log
Parameter Validation: Successful
Could not generate patching steps for the following databases as they do not run from the current host.
Database Name:
Oracle Home: /oracle/app/oracle/product/12.1.0/db_1
Host: qc550705 qc550707
To generate the patching steps for the above databases, execute it on host where the databases are running.
Configuration Validation: Successful
Patch Location: 20485724
Grid Infrastructure Patch(es): 19872484 20299018 20299022 20299023
DB Patch(es): 20299022 20299023
Patch Validation: Successful
Grid Infrastructure home:
/oracle/app/grid/product/12.1.0.2/grid_1
DB home(s):
/oracle/app/oracle/product/12.1.0.2/db_1
Performing prepatch operations on CRS Home... Successful
Applying patch(es) to "/oracle/app/oracle/product/12.1.0.2/db_1" ...
Patch "20485724/20299022" applied to "/oracle/app/oracle/product/12.1.0.2/db_1" with warning.
Patch "20485724/20299023" applied to "/oracle/app/oracle/product/12.1.0.2/db_1" with warning.
Applying patch(es) to "/oracle/app/grid/product/12.1.0.2/grid_1" ...
Patch "20485724/19872484" applied to "/oracle/app/grid/product/12.1.0.2/grid_1" with warning.
Patch "20485724/20299018" applied to "/oracle/app/grid/product/12.1.0.2/grid_1" with warning.
Patch "20485724/20299022" applied to "/oracle/app/grid/product/12.1.0.2/grid_1" with warning.
Patch "20485724/20299023" applied to "/oracle/app/grid/product/12.1.0.2/grid_1" with warning.
至此grid和db的patch都已经结束了
但在postpatch阶段又报了一个错误:
Performing postpatch operations on CRS Home... Failed
Command "/oracle/app/grid/product/12.1.0.2/grid_1/perl/bin/perl -I/oracle/app/grid/product/12.1.0.2/grid_1/perl/lib -I/oracle/app/grid/product/12.1.0.2/grid_1/OPatch/opatchautotemp_qc550705/patchwork/crs/install /oracle/app/grid/product/12.1.0.2/grid_1/OPatch/opatchautotemp_qc550705/patchwork/crs/install/rootcrs.pl -postpatch" execution failed:
Died at /oracle/app/grid/product/12.1.0.2/grid_1/OPatch/opatchautotemp_qc550705/patchwork/crs/install/crspatch.pm line 988.
For more details, please refer to the log file "/oracle/app/grid/product/12.1.0.2/grid_1/cfgtoollogs/opatchauto/20485724/opatch_gi_2015-09-01_15-56-52_deploy.debug.log".
Apply Summary:
Following patch(es) are successfully installed:
DB Home: /oracle/app/oracle/product/12.1.0.2/db_1:
opatchauto ran into some warnings during patch installation (Please see log file for details):
GI Home: /oracle/app/grid/product/12.1.0.2/grid_1: 19872484,20299018,20299022,20299023
DB Home: /oracle/app/oracle/product/12.1.0.2/db_1: 20299022,20299023
Command failure exception
opatchauto failed with error code 2.
根据提示到opatch_gi_2015-09-01_15-56-52_deploy.debug.log里找到了可能的错误原因:
mkdir /oracle/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_9109634_2015_09_01_16_40_56: The file access permissions do not
allow the specified action. at /oracle/app/grid/product/12.1.0.2/grid_1/sqlpatch/sqlpatch.pm line 466
2015/09/01 16:40:56 CLSRSC-488: Patching the Grid Infrastructure Management Repository database failed.
给grid用户赋予在/oracle/app/oracle/cfgtoollogs/sqlpatch/目录下建目录的权限后,使用opatchauto resume继续刚才的postpatch步骤
opatchauto resume <---opatchauto的断点续做功能相当的方便
OPatch Automation Tool
Copyright (c)2014, Oracle Corporation. All rights reserved.
OPatchauto Version : 12.1.0.1.8
OUI Version : 12.1.0.2.0
Running from : /oracle/app/grid/product/12.1.0.2/grid_1
OPatchauto will attempt to resume the last run session. This might take several minutes...
opatchauto log file: /oracle/app/grid/product/12.1.0.2/grid_1/cfgtoollogs/opatchauto/20485724/opatch_gi_2015-09-02_09-39-22_deploy.log
Executing command:
/oracle/app/grid/product/12.1.0.2/grid_1/perl/bin/perl -I/oracle/app/grid/product/12.1.0.2/grid_1/perl/lib -I/oracle/app/grid/product/12.1.0.2/grid_1/OPatch/opatchautotemp_qc550705/patchwork/crs/install /oracle/app/grid/product/12.1.0.2/grid_1/OPatch/opatchautotemp_qc550705/patchwork/crs/install/rootcrs.pl -postpatch
as owner "root"
... above command successful.
Executing command:
echo "DECLARE l_count NUMBER(4) :=0; BEGIN SELECT count(*) INTO l_count FROM CDB_PDBS; IF l_count >1 then EXECUTE IMMEDIATE 'alter pluggable database ALL DISCARD STATE'; END IF; commit; END;" > /tmp/OraDB12Home2_oracle.sql
as owner "oracle"
... above command successful.
Executing command:
/bin/bash -c 'ORACLE_HOME=/oracle/app/oracle/product/12.1.0.2/db_1 ORACLE_SID=cdb5501 /oracle/app/oracle/product/12.1.0.2/db_1/OPatch/datapatch'
as owner "oracle"
... above command successful.
OPatchauto was able to resume from the previous patching session and complete successfully.
至此大功告成,grid与db的补丁信息如下
<<<< DB patchifo >>>>
oracle@qc550705:/home/oracle>opatch lsinventory
Oracle Interim Patch Installer version 12.1.0.1.8
Copyright (c) 2015, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/app/oracle/product/12.1.0.2/db_1
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/oracle/product/12.1.0.2/db_1/oraInst.loc
OPatch version : 12.1.0.1.8
OUI version : 12.1.0.2.0
Log file location : /oracle/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2015-09-02_10-10-02AM_1.log
Lsinventory Output file location : /oracle/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/lsinv/lsinventory2015-09-02_10-10-02AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: qc550705
ARU platform id: 212
ARU platform description:: IBM_AIX
Installed Top-level Products (1):
Oracle Database 12c 12.1.0.2.0
There are 1 products installed in this Oracle Home.
Interim patches (2) :
Patch 20299023 : applied on Tue Sep 01 16:03:23 GMT+08:00 2015
Unique Patch ID: 18697840
Patch description: "Database Patch Set Update : 12.1.0.2.3 (20299023)"
Created on 17 Mar 2015, 07:39:38 hrs PST8PDT
Sub-patch 19769480; "Database Patch Set Update : 12.1.0.2.2 (19769480)"
Bugs fixed:
19524384, 16359751, 19149990, 19054077, 19124589, 19644859, 19385656
19176326, 18610915, 17274537, 19174942, 19390567, 18618122, 18948177
20074391, 19309466, 19597583, 19035573, 18674047, 18456643, 19018447
19536415, 19018206, 18436647, 18354830, 19028800, 19048007, 19174430
19430401, 19044962, 19189525, 19684504, 18964939, 19670108, 19280225
20235511, 19512341, 19706965, 19501299, 19723336, 19143550, 19176223
19303936, 19195895, 19012119, 18967382, 19708632, 19619732, 18849537
19134173, 19304354, 18202441, 20440930, 19468347, 19873610, 19439759
19440586, 19001359, 19065677, 19052488, 19065556, 19074147, 19382851
19676905, 20425790, 19915271, 19978542, 18607546, 19329654, 19577410
18856999, 19016730, 19197175, 19896336, 19291380, 19487147, 16870214
19371175, 19841800, 18952989, 19791377, 19155797, 19023822, 19189317
19185876, 19081128, 17835294, 19649152, 19627012, 19409212, 19518079
19279273, 18885870, 14643995, 18940497, 18921743, 18990693, 18681056
18964978, 19532017, 18288842, 19076343, 19075256, 19561643, 19183343
19658708, 18791688, 19434529, 19024808, 19050649, 20347562, 18909599
19606174, 20348653, 19238590, 19637186, 19058490, 19865345, 19022470
19928926, 19068970, 19067244, 19289642, 19248799, 19068610, 19157754
19335438, 18250893, 19520602, 19174521, 19597439, 19730508, 19769480
18417036, 19001390, 20284155, 19805359, 18845653, 18306996, 18674024
18988834, 19687159, 19154375, 19178851, 19358317, 19393542, 19077215
19180770, 19272708, 19547370, 16619249, 19315691
Patch 20299022 : applied on Tue Sep 01 16:02:40 GMT+08:00 2015
Unique Patch ID: 18592321
Patch description: "OCW Patch Set Update : 12.1.0.2.3 (20299022)"
Created on 8 Apr 2015, 08:47:24 hrs PST8PDT
Bugs fixed:
18589889, 19139608, 19280860, 19061429, 19133945, 19341538, 18946768
19135521, 19361757, 19187207, 19302350, 19130141, 19530755, 19699720
19168690, 19266658, 18899171, 19244316, 19653795, 18330979, 19471722
18634372, 19027351, 18707416, 19184188, 19131709, 20235486, 19925992
20006646, 18991776, 18439295, 19380733, 18943696, 19550195, 18135723
19163425, 20014326, 19524857, 18849021, 18890943, 18861196, 19154753
17940721, 19522313, 18748932, 18835283, 19184765, 19499021, 19046190
19051385, 19682695, 19050688, 19831611, 19226141, 19053891, 18871287
18998228, 18922918, 18980002, 19683886, 18956780, 18777835, 19026993
17338864, 18261648, 19513650, 19702758, 18952577, 17447588, 19414274
20752167, 19262534, 19147513, 19473088, 19178517, 19529729, 19455563
19319904, 18703978, 20340620, 18536826, 19703246, 19292605, 19192901
20660273, 20011635, 19479503, 19029647, 19179158, 18901356, 19140712
18964974, 18835366, 19184276, 19013789, 19207286, 20510208, 20001507
18950232, 20079414, 19680763, 19259765, 19148791, 19556820, 19449737
18962892, 19187515, 19513888, 19230771, 19853036, 19453778, 19551830
19068333, 18520351, 18843572, 19185148, 18945435, 19232454, 18541110
18834955, 19319192, 19204743, 19178629, 19304104, 19140891, 19270660
19457575, 19021575, 19069755, 18715884, 19584688, 18798573, 19812592
19018001, 19325701, 19292272, 19270956, 19222693, 18700893, 19662663
18406774, 19010177, 18910576, 18907170, 19700294, 19164099, 19331454
18955644, 18508710, 18798432, 19146822, 19589221, 19537762, 16286734
18762843, 19045143, 18945249, 19146980, 19184799, 19205086, 20091753
18862203, 19537547, 19281106, 19031737, 19079087, 18968981, 19148367
19150517, 20231741, 19217019, 18730096, 18975620, 19205617, 19513351
18843054, 19150313, 18708349, 18953639, 19067804, 19371270, 19203996
20038431, 19054979, 19209951, 19318983, 19154673, 18752378, 19150088
19013444, 19234177, 18998379, 20157569, 18999857, 19273577, 19075747
19367276, 19632437, 19612597, 19874047, 19288396, 18990354, 19557558
19427050, 19127078, 18910443, 20053557, 20033787, 19315567, 19148982
18290252, 18813323, 19777496, 19500293, 18643483, 19277814, 18523468
19134098, 19071526, 18965694, 19226858, 18850051, 19602208, 20061168
18417590, 19370739, 18920408, 19609388, 18636884, 18776786, 18989446
19148793, 19043795, 19585454, 19955755, 18317489, 18260170, 18919682
19807548, 18678829, 19124972, 19147509, 18849896, 18910748, 19273758
18953878, 19076165, 19704993, 18999195, 19498411, 18759724, 19459023
20276459, 19066844, 17208793, 19234907, 13843841, 19538714, 19383028
19649640, 19062675, 19513969, 18859710, 19504641, 19341481, 20293730
19986391, 18304090, 19343245, 19314048, 18834934, 19473851, 19241655
18242738, 19458082, 19470791, 18894342, 18372060, 19522067, 18953889
18827679, 19259290, 19140711, 19023430, 19045388, 19241857, 19076778
19522571, 18875012, 18861564, 19066699, 19273760, 19225265, 18819158
19068003, 18937186, 19049721, 19368917, 19635215, 18868829, 19141785
19885321, 19163887, 19820247, 18715868, 18852058, 19538241, 19804032
Rac system comprising of multiple nodes
Local node = qc550705
Remote node = qc550707
--------------------------------------------------------------------------------
OPatch succeeded.
<<<< GRID patchifo >>>>
grid@qc550705:/home/grid>opatch lsinventory
Oracle Interim Patch Installer version 12.1.0.1.8
Copyright (c) 2015, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/app/grid/product/12.1.0.2/grid_1
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/grid/product/12.1.0.2/grid_1/oraInst.loc
OPatch version : 12.1.0.1.8
OUI version : 12.1.0.2.0
Log file location : /oracle/app/grid/product/12.1.0.2/grid_1/cfgtoollogs/opatch/opatch2015-09-02_09-59-32AM_1.log
Lsinventory Output file location : /oracle/app/grid/product/12.1.0.2/grid_1/cfgtoollogs/opatch/lsinv/lsinventory2015-09-02_09-59-32AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: qc550705
ARU platform id: 212
ARU platform description:: IBM_AIX
Installed Top-level Products (1):
Oracle Grid Infrastructure 12c 12.1.0.2.0
There are 1 products installed in this Oracle Home.
Interim patches (4) :
Patch 20299023 : applied on Tue Sep 01 16:26:51 GMT+08:00 2015
Unique Patch ID: 18697840
Patch description: "Database Patch Set Update : 12.1.0.2.3 (20299023)"
Created on 17 Mar 2015, 07:39:38 hrs PST8PDT
Sub-patch 19769480; "Database Patch Set Update : 12.1.0.2.2 (19769480)"
Bugs fixed:
19524384, 16359751, 19149990, 19054077, 19124589, 19644859, 19385656
19176326, 18610915, 17274537, 19174942, 19390567, 18618122, 18948177
20074391, 19309466, 19597583, 19035573, 18674047, 18456643, 19018447
19536415, 19018206, 18436647, 18354830, 19028800, 19048007, 19174430
19430401, 19044962, 19189525, 19684504, 18964939, 19670108, 19280225
20235511, 19512341, 19706965, 19501299, 19723336, 19143550, 19176223
19303936, 19195895, 19012119, 18967382, 19708632, 19619732, 18849537
19134173, 19304354, 18202441, 20440930, 19468347, 19873610, 19439759
19440586, 19001359, 19065677, 19052488, 19065556, 19074147, 19382851
19676905, 20425790, 19915271, 19978542, 18607546, 19329654, 19577410
18856999, 19016730, 19197175, 19896336, 19291380, 19487147, 16870214
19371175, 19841800, 18952989, 19791377, 19155797, 19023822, 19189317
19185876, 19081128, 17835294, 19649152, 19627012, 19409212, 19518079
19279273, 18885870, 14643995, 18940497, 18921743, 18990693, 18681056
18964978, 19532017, 18288842, 19076343, 19075256, 19561643, 19183343
19658708, 18791688, 19434529, 19024808, 19050649, 20347562, 18909599
19606174, 20348653, 19238590, 19637186, 19058490, 19865345, 19022470
19928926, 19068970, 19067244, 19289642, 19248799, 19068610, 19157754
19335438, 18250893, 19520602, 19174521, 19597439, 19730508, 19769480
18417036, 19001390, 20284155, 19805359, 18845653, 18306996, 18674024
18988834, 19687159, 19154375, 19178851, 19358317, 19393542, 19077215
19180770, 19272708, 19547370, 16619249, 19315691
Patch 20299022 : applied on Tue Sep 01 16:18:07 GMT+08:00 2015
Unique Patch ID: 18592321
Patch description: "OCW Patch Set Update : 12.1.0.2.3 (20299022)"
Created on 8 Apr 2015, 08:47:24 hrs PST8PDT
Bugs fixed:
18589889, 19139608, 19280860, 19061429, 19133945, 19341538, 18946768
19135521, 19361757, 19187207, 19302350, 19130141, 19530755, 19699720
19168690, 19266658, 18899171, 19244316, 19653795, 18330979, 19471722
18634372, 19027351, 18707416, 19184188, 19131709, 20235486, 19925992
20006646, 18991776, 18439295, 19380733, 18943696, 19550195, 18135723
19163425, 20014326, 19524857, 18849021, 18890943, 18861196, 19154753
17940721, 19522313, 18748932, 18835283, 19184765, 19499021, 19046190
19051385, 19682695, 19050688, 19831611, 19226141, 19053891, 18871287
18998228, 18922918, 18980002, 19683886, 18956780, 18777835, 19026993
17338864, 18261648, 19513650, 19702758, 18952577, 17447588, 19414274
20752167, 19262534, 19147513, 19473088, 19178517, 19529729, 19455563
19319904, 18703978, 20340620, 18536826, 19703246, 19292605, 19192901
20660273, 20011635, 19479503, 19029647, 19179158, 18901356, 19140712
18964974, 18835366, 19184276, 19013789, 19207286, 20510208, 20001507
18950232, 20079414, 19680763, 19259765, 19148791, 19556820, 19449737
18962892, 19187515, 19513888, 19230771, 19853036, 19453778, 19551830
19068333, 18520351, 18843572, 19185148, 18945435, 19232454, 18541110
18834955, 19319192, 19204743, 19178629, 19304104, 19140891, 19270660
19457575, 19021575, 19069755, 18715884, 19584688, 18798573, 19812592
19018001, 19325701, 19292272, 19270956, 19222693, 18700893, 19662663
18406774, 19010177, 18910576, 18907170, 19700294, 19164099, 19331454
18955644, 18508710, 18798432, 19146822, 19589221, 19537762, 16286734
18762843, 19045143, 18945249, 19146980, 19184799, 19205086, 20091753
18862203, 19537547, 19281106, 19031737, 19079087, 18968981, 19148367
19150517, 20231741, 19217019, 18730096, 18975620, 19205617, 19513351
18843054, 19150313, 18708349, 18953639, 19067804, 19371270, 19203996
20038431, 19054979, 19209951, 19318983, 19154673, 18752378, 19150088
19013444, 19234177, 18998379, 20157569, 18999857, 19273577, 19075747
19367276, 19632437, 19612597, 19874047, 19288396, 18990354, 19557558
19427050, 19127078, 18910443, 20053557, 20033787, 19315567, 19148982
18290252, 18813323, 19777496, 19500293, 18643483, 19277814, 18523468
19134098, 19071526, 18965694, 19226858, 18850051, 19602208, 20061168
18417590, 19370739, 18920408, 19609388, 18636884, 18776786, 18989446
19148793, 19043795, 19585454, 19955755, 18317489, 18260170, 18919682
19807548, 18678829, 19124972, 19147509, 18849896, 18910748, 19273758
18953878, 19076165, 19704993, 18999195, 19498411, 18759724, 19459023
20276459, 19066844, 17208793, 19234907, 13843841, 19538714, 19383028
19649640, 19062675, 19513969, 18859710, 19504641, 19341481, 20293730
19986391, 18304090, 19343245, 19314048, 18834934, 19473851, 19241655
18242738, 19458082, 19470791, 18894342, 18372060, 19522067, 18953889
18827679, 19259290, 19140711, 19023430, 19045388, 19241857, 19076778
19522571, 18875012, 18861564, 19066699, 19273760, 19225265, 18819158
19068003, 18937186, 19049721, 19368917, 19635215, 18868829, 19141785
19885321, 19163887, 19820247, 18715868, 18852058, 19538241, 19804032
Patch 20299018 : applied on Tue Sep 01 16:12:55 GMT+08:00 2015
Unique Patch ID: 18592319
Patch description: "ACFS Patch Set Update : 12.1.0.2.3 (20299018)"
Created on 8 Apr 2015, 18:11:07 hrs PST8PDT
Bugs fixed:
19452723, 19078259, 19919907, 18900953, 20010980, 19127216, 18934139
19844362, 19335268, 19526234, 18951113, 18899600, 18851012, 19149476
19517835, 19526283, 19428756, 19183802, 19013966, 19051391, 19690653
19195735, 19355146, 19001684, 19509898, 19053182, 19644505, 19593769
19610001, 19475588, 19353057, 18957085, 19279106, 19270227, 19201087
20098064, 19184398, 19610022, 19901825, 20140148, 19649858, 19450090
19502657, 19859183, 18321597, 19469788, 19557156, 18877486, 19528981
18510745, 18915417, 18955907, 19134464, 19060056
Patch 19872484 : applied on Tue Sep 01 16:12:37 GMT+08:00 2015
Unique Patch ID: 18377292
Patch description: "WLM Patch Set Update: 12.1.0.2.2 (19872484)"
Created on 12 Dec 2014, 08:18:20 hrs PST8PDT
Bugs fixed:
19016964, 19582630
Patch level status of Cluster nodes :
Patching Level Nodes
-------------- -----
0 qc550707 <---qc550707还没打
2733550117 qc550705
但是别忘了我们之前使用crsctl stop rollingpatch禁用了滚动更新,还要对另一个节点qc550707进行相同的打补丁操作:
su - root
chmod g+w /oracle/app/oracle/cfgtoollogs/sqlpatch
crsctl stop rollingpatch
su - oracle
cd /oracle/app/oracle/product/12.1.0.2/db_1/ccr/bin
./emocmrsp
cp ocm.rsp /home/oracle/
su - root
cd "/opatch/12.1.0.2.3"
opatchauto apply 20485724 -ocmrf /home/oracle/ocm.rsp
总结:
12c的opatchauto提高了补丁应用的自动化程度,但本身bug也比较多,在自动化应用补丁的过程中会遇到这样那样的问题,应用较新的补丁也必须配合以相应新版本的opatchauto,打PSU前一定要仔细阅读补丁说明,因为对于不同的环境特别是RAC环境下实施步骤可能大相庭径。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/53956/viewspace-1789203/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/53956/viewspace-1789203/