Oracle 11.2.0.4 RAC psu補丁升級至11.2.0.4.2

parknkjun發表於2014-12-12

1.當前資料庫環境:
兩節點RAC
OS Redhat 6.4 64bit
Grid software 11.2.0.4
Oracle software 11.2.0.4
準備補丁安裝包如下:
p6880880_112000_Linux-x86-64.zip
p18139609_112040_Linux-x86-64.zip
2.檢查當前資料庫的版本
[oracle@jzh03 OPatch]$ ./opatch version
OPatch Version: 11.2.0.3.4
OPatch succeeded.
[oracle@jzh03 OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation.  All rights reserved.
Oracle Home       : /s01/app/oracle/product/11.2.0/db_1
Central Inventory : /s01/app/oraInventory
from           : /s01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version    : 11.2.0.3.4
OUI version       : 11.2.0.4.0
Log file location : /s01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2014-12-12_10-39-59AM_1.log
Lsinventory Output file location : /s01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2014-12-12_10-39-59AM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 11g                                                  11.2.0.4.0
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
Rac system comprising of multiple nodes
Local node = jzh03
Remote node = jzh04
--------------------------------------------------------------------------------
OPatch succeeded.
3.更新OPatch version、ocm configuration
分別在節點1,2上用grid和oracle使用者執行
Mv $ORACLE_HOME/OPatch /$ORACLE_HOME/OPatch.bak
[grid@jzh03 db_1]# mv OPatch/ OPatch.bak
[grid@jzh04 db_1]# mv OPatch/ OPatch.bak
4.分別在節點1,2上用grid和oracle使用者執行
[grid@jzh03 u01]$ unzip p6880880_112000_Linux-x86-64.zip -d $ORACLE_HOME
[grid@jzh04 u01]$ unzip p6880880_112000_Linux-x86-64.zip -d $ORACLE_HOME
 [oracle@jzh03 OPatch]$ ./opatch version
OPatch Version: 11.2.0.3.6
OPatch succeeded.
5.解壓檔案
[oracle@jzh03 u01]$ unzip p18139609_112040_Linux-x86-64.zip
6.檢查需要打的補丁與現有補丁是否衝突
[oracle@jzh03 u01]$ cd 18139609/
[oracle@jzh03 18139609]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation.  All rights reserved.
PREREQ session
Oracle Home       : /s01/app/oracle/product/11.2.0/db_1
Central Inventory : /s01/app/oraInventory
from           : /s01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version    : 11.2.0.3.6
OUI version       : 11.2.0.4.0
Log file location : /s01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2014-12-12_11-27-46AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
7.停crs服務
[grid@jzh03 ~]$ crs_stop -all
CRS-2500: Cannot stop resource 'ora.gsd' as it is not running
CRS-2789: Cannot stop resource 'ora.gsd' as it is not running on server 'jzh04'
Attempting to stop `ora.registry.acfs` on member `jzh04`
Attempting to stop `ora.registry.acfs` on member `jzh03`
Attempting to stop `ora.cvu` on member `jzh03`
Attempting to stop `ora.ons` on member `jzh03`
Attempting to stop `ora.LISTENER.lsnr` on member `jzh03`
Attempting to stop `ora.LISTENER_SCAN1.lsnr` on member `jzh03`
CRS-2789: Cannot stop resource 'ora.gsd' as it is not running on server 'jzh03'
Attempting to stop `ora.LISTENER.lsnr` on member `jzh04`
Attempting to stop `ora.ons` on member `jzh04`
8.更新補丁,以root使用者執行:
[root@jzh03 18139609]# export ORACLE_HOME=/s01/app/grid/product/11.2.0/db_1
[root@jzh03 18139609]# $ORACLE_HOME/OPatch/opatch auto -oh $ORACLE_HOME/ -ocmrf $ORACLE_HOME/OPatch/ocm/bin/emocmrsp
Executing /s01/app/grid/product/11.2.0/db_1/perl/bin/perl /s01/app/grid/product/11.2.0/db_1/OPatch/crs/patch11203.pl -patchdir /u01 -patchn 18139609 -oh /s01/app/grid/product/11.2.0/db_1/ -ocmrf /s01/app/grid/product/11.2.0/db_1/OPatch/ocm/bin/emocmrsp -paramfile /s01/app/grid/product/11.2.0/db_1/crs/install/crsconfig_params
 This is the main log file: /s01/app/grid/product/11.2.0/db_1/cfgtoollogs/opatchauto2014-12-12_15-00-38.log
 This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/s01/app/grid/product/11.2.0/db_1/cfgtoollogs/opatchauto2014-12-12_15-00-38.report.log
 2014-12-12 15:00:38: Starting Clusterware Patch Setup
Using configuration parameter file: /s01/app/grid/product/11.2.0/db_1/crs/install/crsconfig_params
Stopping CRS...
Stopped CRS successfully
patch /u01/18139609/18031668  apply successful for home  /s01/app/grid/product/11.2.0/db_1
patch /u01/18139609/18031740  apply successful for home  /s01/app/grid/product/11.2.0/db_1
patch /u01/18139609/18031731  apply successful for home  /s01/app/grid/product/11.2.0/db_1
Starting CRS...
Installing Trace File Analyzer
CRS-4123: Oracle High Availability Services has been started.
opatch auto succeeded.
[root@jzh03 18139609]# export ORACLE_HOME=/s01/app/oracle/product/11.2.0/db_1
[root@jzh03 18139609]# $ORACLE_HOME/OPatch/opatch auto -oh $ORACLE_HOME/ -ocmrf $ORACLE_HOME/OPatch/ocm/bin/emocmrsp
 Executing /s01/app/grid/product/11.2.0/db_1/perl/bin/perl /s01/app/oracle/product/11.2.0/db_1/OPatch/crs/patch11203.pl -patchdir /u01 -patchn 18139609 -oh /s01/app/oracle/product/11.2.0/db_1/ -ocmrf /s01/app/oracle/product/11.2.0/db_1/OPatch/ocm/bin/emocmrsp -paramfile /s01/app/grid/product/11.2.0/db_1/crs/install/crsconfig_params
This is the main log file: /s01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatchauto2014-12-12_15-13-01.log
This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/s01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatchauto2014-12-12_15-13-01.report.log
2014-12-12 15:13:01: Starting Clusterware Patch Setup
Using configuration parameter file: /s01/app/grid/product/11.2.0/db_1/crs/install/crsconfig_params
Stopping RAC /s01/app/oracle/product/11.2.0/db_1 ...
Stopped RAC /s01/app/oracle/product/11.2.0/db_1 successfully
patch /u01/18139609/18031668  apply successful for home  /s01/app/oracle/product/11.2.0/db_1
patch /u01/18139609/18031740/custom/server/18031740  apply successful for home  /s01/app/oracle/product/11.2.0/db_1
Starting RAC /s01/app/oracle/product/11.2.0/db_1 ...
Started RAC /s01/app/oracle/product/11.2.0/db_1 successfully
opatch auto succeeded.
9.登陸資料庫執行指令碼
cd $ORACLE_HOME/rdbms/admin
[oracle@jzh03 admin]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Fri Dec 12 15:31:25 2014
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL> @catbundle.sql psu apply
10.驗證
$ORACLE_HOME/OPatch/opatch lspatches
18031740;OCW Patch Set Update : 11.2.0.4.2 (18031740)
18031668;Database Patch Set Update : 11.2.0.4.2 (18031668)
或者:
[oracle@jzh03 admin]$ $ORACLE_HOME/OPatch/opatch lsinventory a-ll
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation.  All rights reserved.
Oracle Home       : /s01/app/oracle/product/11.2.0/db_1
Central Inventory : /s01/app/oraInventory
from           : /s01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version    : 11.2.0.3.6
OUI version       : 11.2.0.4.0
Log file location : /s01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2014-12-12_15-35-06PM_1.log
Lsinventory Output file location : /s01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2014-12-12_15-35-06PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 11g                                                  11.2.0.4.0
There are 1 product(s) installed in this Oracle Home.
Interim patches (2) :
Patch  18031740     : applied on Fri Dec 12 15:14:29 CST 2014
Unique Patch ID:  17253722
Patch description:  "OCW Patch Set Update : 11.2.0.4.2 (18031740)"
Created on 19 Mar 2014, 09:06:31 hrs PST8PDT
Bugs fixed:
18328800, 16613232, 14525998, 14693336, 17273020, 17238586, 12928658
17391726, 17750548, 17387214, 18229842, 17172091, 17001914, 16346413
17155238, 17551223, 15832129, 17305100, 17483479, 17039197, 16317771
17292250, 17500165, 16206997, 17481314, 16876500, 17405302, 17065496
18343490, 13991403
Patch  18031668     : applied on Fri Dec 12 15:13:50 CST 2014
Unique Patch ID:  17255543
Patch description:  "Database Patch Set Update : 11.2.0.4.2 (18031668)"
Created on 20 Feb 2014, 05:15:58 hrs PST8PDT
Sub-patch  17478514; "Database Patch Set Update : 11.2.0.4.1 (17478514)"
Bugs fixed:
17288409, 16399083, 17205719, 17811429, 10136473, 16472716, 17614227
17050888, 17040764, 17865671, 17325413, 14010183, 17726838, 13364795
17389192, 17612828, 17080436, 16613964, 17284817, 17441661, 17761775
17721717, 16721594, 17390431, 18203837, 17551709, 17344412, 16043574
17446237, 16863422, 18139690, 17071721, 17501491, 17610798, 17239687
17752121, 17468141, 17602269, 18203835, 17375354, 17313525, 17811456
16731148, 14133975, 18203838, 16956380, 17385178, 17235750, 13866822
17394950, 17478514, 17027426, 12905058, 14338435, 16450169, 13944971
18094246, 16929165, 16785708, 17265217, 17465741, 16220077, 16180763
16069901, 17546973, 16285691, 17323222, 18180390, 17088068, 16875449
17016369, 17443671, 16228604, 17811438, 17811447, 16837842, 18031668
16912439, 17332800, 17393683, 17622427, 17545847, 17186905, 16943711
16850630, 17082359, 17346671, 14852021, 17783588, 17437634, 16618694
17341326, 17296856, 17546761, 17716305
Rac system comprising of multiple nodes
Local node = jzh03
Remote node = jzh04
至此,PSU補丁升級完成!



來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10271187/viewspace-1365985/,如需轉載,請註明出處,否則將追究法律責任。

相關文章