Oracle 11.2.0.4 RAC psu補丁升級至11.2.0.4.2
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/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- Oracle 11.2.0.4 RAC安裝最新PSU補丁Oracle
- ORACLE 10G RAC 升級補丁Oracle 10g
- OJVM+GI PSU補丁升級JVM
- Oracle 10.2.0.5升級至11.2.0.4Oracle
- 資料庫PSU的補丁升級 從10.2.0.5.2(10248542)升級至10.2.0.5.12(16619894)打補丁記錄資料庫
- Oracle補丁術語介紹 PSU CPU補丁Oracle
- Oracle 11g RAC自動打GI PSU補丁Oracle
- oracle_如何打11GR2 RAC PSU補丁Oracle
- oracle rac 11.2.0.3 升級到11.2.0.4Oracle
- zt_oracle psu_cpu_bundle補丁patch升級upgrade相關概念Oracle
- 單機 Oracle 11g(11.2.0.4)手動打補丁PSU(11.2.0.4.8)Oracle
- Oracle：Oracle RAC 11.2.0.4 升級為 19cOracle
- 12. Oracle版本、補丁及升級——12.2. 補丁及補丁集Oracle
- 【kingsql分享】Oracle 18c RAC補丁升級實戰【DBRU】SQLOracle
- Oracle資料庫升級與補丁Oracle資料庫
- ORACLE 11g 升級補丁（Patch）Oracle
- Oracle RAC更新補丁Oracle
- Oracle 11.2.0.4打PSU至11.2.0.4.170718Oracle
- Oracle 11g RAC自動打GI PSU補丁(11.2.0.4.8)Oracle
- 12. Oracle版本、補丁及升級——12.3. 升級Oracle
- Oracle資料庫PSU補丁安裝Oracle資料庫
- oracle 補丁種類和升級方法以及oracle RAC Rolling Patch 說明Oracle
- Oracle 11g RAC 環境打PSU補丁的詳細步驟Oracle
- Weblogic 補丁升級慢Web
- 【UP_ORACLE】使用AutoUpgrade工具升級Oracle 11.2.0.4至12.2.0.1Oracle
- oracle 11.2.0.4的補丁有大問題Oracle
- 探索Oracle之資料庫升級一 升級補丁修復概述Oracle資料庫
- [Oracle] CPU/PSU補丁安裝詳細教程Oracle
- 11.2.0.3 database異機升級至11.2.0.4Database
- Oracle RAC 10.2.0.5升級到11.2.0.4遇到的問題Oracle
- Oracle PSU （Patch Set Update）- 10g補丁列表及如何檢視補丁Oracle
- 資料庫Oracle 11g RAC手動打GI PSU補丁(11.2.0.4.8)資料庫Oracle
- 【PATCH】Oracle12c升級補丁初體驗Oracle
- ORACLE 10gR2 RAC升級至10.2.0.4Oracle 10g
- Oracle 資料庫 PSU 的補丁號變化Oracle資料庫
- Oracle DG/ADG上CPU/PSU補丁安裝Oracle
- 指令碼 - Oracle10g PSU後升級資料字典（RAC）指令碼Oracle
- ORACLE windows和linux環境下 10g升級到11.2.0.4 並安裝11.2.0.4.19補丁OracleWindowsLinux