前段時間測試單機資料庫升級補丁，那麼在RAC中怎麼自動為叢集軟體、資料庫升級補丁呢，下面讓我們來看看。

環境：redhat6.3_x64+Oracle11g RAC (11.2.0.4.0)

所需補丁包：p6880880_112000_Linux-x86-64.zip p20996923_112040_Linux-x86-64.zip

補丁資訊：p20996923_112040_Linux-x86-64.zip==> GI PSUs are cumulative and include the Database PSU and associated CPU program security content
p6880880_112000_Linux-x86-64.zip==> You must use the OPatch utility version 11.2.0.3.6 or later to apply this patch. (11.2.0.3.10)

將兩個包上傳至RAC各節點，解壓。

unzip p6880880_112000_Linux-x86-64.zip | unzip p20996923_112040_Linux-x86-64.zip

溫馨提示：在做資料庫的任何操作，都建議在操作前備份資料庫，以免造成不必要損失。

將新的目錄 OPatch 分別複製到各個節點的GRID、Oracle主目錄中，cp -rf OPatch $GRID_HOME、$ORACLE_HOME(建議提前備份）
檢視opatch 資訊：

點選(此處)摺疊或開啟

[grid@rac01 OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.10
Copyright (c) 2015, Oracle Corporation. All rights reserved.
Oracle Home : /grid/crs_home/product/11.2.0
Central Inventory : /grid/oraInventory
from : /grid/crs_home/product/11.2.0/oraInst.loc
OPatch version : 11.2.0.3.10
OUI version : 11.2.0.4.0
Log file location : /grid/crs_home/product/11.2.0/cfgtoollogs/opatch/opatch2015-07-31_14-31-35PM_1.log
Lsinventory Output file location : /grid/crs_home/product/11.2.0/cfgtoollogs/opatch/lsinv/lsinventory2015-07-31_14-31-35PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: rac01
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Grid Infrastructure 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 = rac01
Remote node = rac02
--------------------------------------------------------------------------------
OPatch succeeded.

透過grid使用者建立ocm配置檔案，各個節點都需要（也可以複製到其他節點）：

點選(此處)摺疊或開啟

[grid@rac01 bin]$ pwd
/grid/crs_home/product/11.2.0/OPatch/ocm/bin
[grid@rac01 bin]$ ./emocmrsp -no_banner -output /grid/soft/ocm.rsp

檢查每個節點grid、oracle的patch的相容性。例如

點選(此處)摺疊或開啟

[grid@rac01 ~]$ cd /grid/crs_home/product/11.2.0/OPatch/
[grid@rac01 OPatch]$ ./opatch lsinventory -detail -oh $ORACLE_HOME
Oracle Interim Patch Installer version 11.2.0.3.10
Copyright (c) 2015, Oracle Corporation. All rights reserved.
Oracle Home : /grid/crs_home/product/11.2.0
Central Inventory : /grid/oraInventory
from : /grid/crs_home/product/11.2.0/oraInst.loc
OPatch version : 11.2.0.3.10
OUI version : 11.2.0.4.0
Log file location : /grid/crs_home/product/11.2.0/cfgtoollogs/opatch/opatch2015-07-31_15-05-07PM_1.log
Lsinventory Output file location : /grid/crs_home/product/11.2.0/cfgtoollogs/opatch/lsinv/lsinventory2015-07-31_15-05-07PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: rac01
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Grid Infrastructure 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.
Installed Products (89):
Agent Required Support Files 10.2.0.4.5
Assistant Common Files 11.2.0.4.0
Automatic Storage Management Assistant 11.2.0.4.0
Bali Share 1.1.18.0.0
Buildtools Common Files 11.2.0.4.0
Character Set Migration Utility 11.2.0.4.0
Cluster Ready Services Files 11.2.0.4.0
Cluster Verification Utility Common Files 11.2.0.4.0
Cluster Verification Utility Files 11.2.0.4.0
Database SQL Scripts 11.2.0.4.0
Deinstallation Tool 11.2.0.4.0
Enterprise Manager Common Core Files 10.2.0.4.5
Enterprise Manager Common Files 10.2.0.4.5
Enterprise Manager plugin Common Files 11.2.0.4.0
Expat libraries 2.0.1.0.1
HAS Common Files 11.2.0.4.0
HAS Files for DB 11.2.0.4.0
Installation Common Files 11.2.0.4.0
Installation Plugin Files 11.2.0.4.0
Installer SDK Component 11.2.0.4.0
Java Development Kit 1.5.0.51.10
LDAP Required Support Files 11.2.0.4.0
OLAP SQL Scripts 11.2.0.4.0
Oracle Advanced Security 11.2.0.4.0
Oracle Clusterware RDBMS Files 11.2.0.4.0
Oracle Configuration Manager Deconfiguration 10.3.1.0.0
Oracle Containers for Java 11.2.0.4.0
Oracle Core Required Support Files 11.2.0.4.0
Oracle Database 11g 11.2.0.4.0
Oracle Database 11g Multimedia Files 11.2.0.4.0
Oracle Database Deconfiguration 11.2.0.4.0
Oracle Database User Interface 2.2.13.0.0
Oracle Database Utilities 11.2.0.4.0
Oracle DBCA Deconfiguration 11.2.0.4.0
Oracle Extended Windowing Toolkit 3.4.47.0.0
Oracle Globalization Support 11.2.0.4.0
Oracle Globalization Support 11.2.0.4.0
Oracle Grid Infrastructure 11g 11.2.0.4.0
Oracle Help For Java 4.2.9.0.0
Oracle Ice Browser 5.2.3.6.0
Oracle Internet Directory Client 11.2.0.4.0
Oracle Java Client 11.2.0.4.0
Oracle JDBC/OCI Instant Client 11.2.0.4.0
Oracle JDBC/THIN Interfaces 11.2.0.4.0
Oracle JFC Extended Windowing Toolkit 4.2.36.0.0
Oracle JVM 11.2.0.4.0
Oracle LDAP administration 11.2.0.4.0
Oracle Locale Builder 11.2.0.4.0
Oracle Multimedia 11.2.0.4.0
Oracle Multimedia Client Option 11.2.0.4.0
Oracle Multimedia Java Advanced Imaging 11.2.0.4.0
Oracle Multimedia Locator 11.2.0.4.0
Oracle Multimedia Locator RDBMS Files 11.2.0.4.0
Oracle Net 11.2.0.4.0
Oracle Net Listener 11.2.0.4.0
Oracle Net Required Support Files 11.2.0.4.0
Oracle Netca Client 11.2.0.4.0
Oracle Notification Service 11.2.0.3.0
Oracle Notification Service (eONS) 11.2.0.4.0
Oracle One-Off Patch Installer 11.2.0.3.4
Oracle Quality of Service Management (Client) 11.2.0.4.0
Oracle Quality of Service Management (Server) 11.2.0.4.0
Oracle RAC Deconfiguration 11.2.0.4.0
Oracle RAC Required Support Files-HAS 11.2.0.4.0
Oracle Recovery Manager 11.2.0.4.0
Oracle Security Developer Tools 11.2.0.4.0
Oracle Text Required Support Files 11.2.0.4.0
Oracle Universal Installer 11.2.0.4.0
Oracle USM Deconfiguration 11.2.0.4.0
Oracle Wallet Manager 11.2.0.4.0
Parser Generator Required Support Files 11.2.0.4.0
Perl Interpreter 5.10.0.0.2
Perl Modules 5.10.0.0.1
PL/SQL 11.2.0.4.0
PL/SQL Embedded Gateway 11.2.0.4.0
Platform Required Support Files 11.2.0.4.0
Precompiler Required Support Files 11.2.0.4.0
RDBMS Required Support Files 11.2.0.4.0
RDBMS Required Support Files for Instant Client 11.2.0.4.0
RDBMS Required Support Files Runtime 11.2.0.4.0
Required Support Files 11.2.0.4.0
Secure Socket Layer 11.2.0.4.0
SQL*Plus 11.2.0.4.0
SQL*Plus Files for Instant Client 11.2.0.4.0
SQL*Plus Required Support Files 11.2.0.4.0
SSL Required Support Files for InstantClient 11.2.0.4.0
Universal Storage Manager Files 11.2.0.4.0
XDK Required Support Files 11.2.0.4.0
XML Parser for Java 11.2.0.4.0
There are 89 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
Rac system comprising of multiple nodes
Local node = rac01
Remote node = rac02
--------------------------------------------------------------------------------
OPatch succeeded.
[grid@rac01 OPatch]$

檢查透過後，停止資料庫： srvctl stop database -d racdb

以root使用者開始執行下面語句，每個節點都需要執行（依次）:

點選(此處)摺疊或開啟

[root@rac01 ~]# export GI_HOME=/grid/crs_home/product/11.2.0
[root@rac01 ~]# $GI_HOME/OPatch/opatch auto /grid/soft/20996923 -ocmrf /grid/soft/ocm.rsp
Executing /grid/crs_home/product/11.2.0/perl/bin/perl /grid/crs_home/product/11.2.0/OPatch/crs/patch11203.pl -patchdir /grid/soft -patchn 20996923 -ocmrf /grid/soft/ocm.rsp -paramfile /grid/crs_home/product/11.2.0/crs/install/crsconfig_params
This is the main log file: /grid/crs_home/product/11.2.0/cfgtoollogs/opatchauto2015-08-03_09-20-46.log
This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/grid/crs_home/product/11.2.0/cfgtoollogs/opatchauto2015-08-03_09-20-46.report.log
2015-08-03 09:20:46: Starting Clusterware Patch Setup
Using configuration parameter file: /grid/crs_home/product/11.2.0/crs/install/crsconfig_params
Stopping RAC /oracle/app/oracle/product/11.2.0 ...
Stopped RAC /oracle/app/oracle/product/11.2.0 successfully
patch /grid/soft/20996923/20760982 apply successful for home /oracle/app/oracle/product/11.2.0
patch /grid/soft/20996923/20831122/custom/server/20831122 apply successful for home /oracle/app/oracle/product/11.2.0
Stopping CRS...
Stopped CRS successfully
patch /grid/soft/20996923/20760982 apply successful for home /grid/crs_home/product/11.2.0
patch /grid/soft/20996923/20831122 apply successful for home /grid/crs_home/product/11.2.0
patch /grid/soft/20996923/20299019 apply successful for home /grid/crs_home/product/11.2.0
Starting CRS...
Installing Trace File Analyzer
CRS-4123: Oracle High Availability Services has been started.
Starting RAC /oracle/app/oracle/product/11.2.0 ...
Started RAC /oracle/app/oracle/product/11.2.0 successfully
opatch auto succeeded.
[root@rac01 ~]#

下面是後臺輸出日誌，由於日誌太多，擷取部分日誌資訊：

點選(此處)摺疊或開啟

...................
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 17478514 18031668 18522509 19121551 19769489 20299013 20760982
Do you want to proceed? [y|n]
Y (auto-answered by -silent)
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/oracle/app/oracle/product/11.2.0')
Is the local system ready for patching? [y|n]
Y (auto-answered by -silent)
User Responded with: Y
Backing up files...
Applying sub-patch '17478514' to OH '/oracle/app/oracle/product/11.2.0'
Patching component oracle.rdbms, 11.2.0.4.0...
...........
..........
2015-08-03 09:30:30: Unlock crshome...
2015-08-03 09:30:30: crshome passed is
2015-08-03 09:30:30: Exclude file used is /grid/crs_home/product/11.2.0/OPatch/crs/installPatch.excl
2015-08-03 09:30:30: Home location in olr.loc is /grid/crs_home/product/11.2.0
2015-08-03 09:30:30: unlock crs home is /grid/crs_home/product/11.2.0
2015-08-03 09:30:30: Executing /grid/crs_home/product/11.2.0/bin/crsctl stop crs -f
2015-08-03 09:30:30: Executing cmd: /grid/crs_home/product/11.2.0/bin/crsctl stop crs -f
2015-08-03 09:34:05: Command output:
> CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac01'
> CRS-2673: Attempting to stop 'ora.crsd' on 'rac01'
> CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac01'
> CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'rac01'
.............

下面是後臺執行具體操作

點選(此處)摺疊或開啟

[grid@rac01 opatch]$ tail -f /grid/crs_home/product/11.2.0/cfgtoollogs/opatchauto2015-08-03_09-20-46.report.log
crs_home=/grid/crs_home/product/11.2.0 version=11.2.0.4.0 owner=grid opatch_ver=11.2.0.3.10
rac_home=/oracle/app/oracle/product/11.2.0 version=11.2.0.4.0 owner=oracle opatch_ver=11.2.0.3.10
*********** Steps to be executed as owner unless specified as root ***********
1: /oracle/app/oracle/product/11.2.0/OPatch/opatch prereq CheckComponents -ph /grid/soft/20996923/20760982 -oh /oracle/app/oracle/product/11.2.0 -customLogDir /grid/crs_home/product/11.2.0/cfgtoollogs/opatchauto/core
2: /oracle/app/oracle/product/11.2.0/OPatch/opatch prereq CheckComponents -ph /grid/soft/20996923/20831122/custom/server/20831122 -oh /oracle/app/oracle/product/11.2.0 -customLogDir /grid/crs_home/product/11.2.0/cfgtoollogs/opatchauto/core
3: /oracle/app/oracle/product/11.2.0/OPatch/opatch prereq CheckConflictAgainstOH -ph /grid/soft/20996923/20760982 -oh /oracle/app/oracle/product/11.2.0 -customLogDir /grid/crs_home/product/11.2.0/cfgtoollogs/opatchauto/core
4: /oracle/app/oracle/product/11.2.0/OPatch/opatch prereq CheckConflictAgainstOH -ph /grid/soft/20996923/20831122/custom/server/20831122 -oh /oracle/app/oracle/product/11.2.0 -customLogDir /grid/crs_home/product/11.2.0/cfgtoollogs/opatchauto/core
5: /grid/crs_home/product/11.2.0/OPatch/opatch prereq CheckComponents -ph /grid/soft/20996923/20760982 -oh /grid/crs_home/product/11.2.0 -customLogDir /grid/crs_home/product/11.2.0/cfgtoollogs/opatchauto/core
6: /grid/crs_home/product/11.2.0/OPatch/opatch prereq CheckComponents -ph /grid/soft/20996923/20831122 -oh /grid/crs_home/product/11.2.0 -customLogDir /grid/crs_home/product/11.2.0/cfgtoollogs/opatchauto/core
7: /grid/crs_home/product/11.2.0/OPatch/opatch prereq CheckComponents -ph /grid/soft/20996923/20299019 -oh /grid/crs_home/product/11.2.0 -customLogDir /grid/crs_home/product/11.2.0/cfgtoollogs/opatchauto/core
8: /grid/crs_home/product/11.2.0/OPatch/opatch prereq CheckConflictAgainstOH -ph /grid/soft/20996923/20760982 -oh /grid/crs_home/product/11.2.0 -customLogDir /grid/crs_home/product/11.2.0/cfgtoollogs/opatchauto/core
9: /grid/crs_home/product/11.2.0/OPatch/opatch prereq CheckConflictAgainstOH -ph /grid/soft/20996923/20831122 -oh /grid/crs_home/product/11.2.0 -customLogDir /grid/crs_home/product/11.2.0/cfgtoollogs/opatchauto/core
10: /grid/crs_home/product/11.2.0/OPatch/opatch prereq CheckConflictAgainstOH -ph /grid/soft/20996923/20299019 -oh /grid/crs_home/product/11.2.0 -customLogDir /grid/crs_home/product/11.2.0/cfgtoollogs/opatchauto/core
11: /oracle/app/oracle/product/11.2.0/bin/emctl stop dbconsole
12: /oracle/app/oracle/product/11.2.0/bin/emctl stop agent
13: /oracle/app/oracle/product/11.2.0/OPatch/opatch prereq CheckApplicable -ph /grid/soft/20996923/20760982 -oh /oracle/app/oracle/product/11.2.0 -customLogDir /grid/crs_home/product/11.2.0/cfgtoollogs/opatchauto/core
14: /oracle/app/oracle/product/11.2.0/OPatch/opatch prereq CheckApplicable -ph /grid/soft/20996923/20831122/custom/server/20831122 -oh /oracle/app/oracle/product/11.2.0 -customLogDir /grid/crs_home/product/11.2.0/cfgtoollogs/opatchauto/core
15: /oracle/app/oracle/product/11.2.0/bin/srvctl stop home -o /oracle/app/oracle/product/11.2.0 -s /oracle/app/oracle/product/11.2.0/srvm/admin/stophome.txt -n rac01 -f
16: /grid/soft/20996923/20831122/custom/server/20831122/custom/scripts/prepatch.sh -dbhome /oracle/app/oracle/product/11.2.0
17: /oracle/app/oracle/product/11.2.0/OPatch/opatch napply /grid/soft/20996923/20760982 -local -silent -ocmrf /grid/soft/ocm.rsp -oh /oracle/app/oracle/product/11.2.0 -invPtrLoc /oracle/app/oracle/product/11.2.0/oraInst.loc
18: /oracle/app/oracle/product/11.2.0/OPatch/opatch napply /grid/soft/20996923/20831122/custom/server/20831122 -local -silent -ocmrf /grid/soft/ocm.rsp -oh /oracle/app/oracle/product/11.2.0 -invPtrLoc /oracle/app/oracle/product/11.2.0/oraInst.loc
19: /grid/soft/20996923/20831122/custom/server/20831122/custom/scripts/postpatch.sh -dbhome /oracle/app/oracle/product/11.2.0
20: /grid/crs_home/product/11.2.0/crs/install/rootcrs.pl -unlock : run as root
21: /sbin/fuser -k /grid/crs_home/product/11.2.0/bin/crsctl.bin : run as root
22: /grid/crs_home/product/11.2.0/OPatch/opatch prereq CheckApplicable -ph /grid/soft/20996923/20760982 -oh /grid/crs_home/product/11.2.0 -customLogDir /grid/crs_home/product/11.2.0/cfgtoollogs/opatchauto/core
23: /grid/crs_home/product/11.2.0/OPatch/opatch prereq CheckApplicable -ph /grid/soft/20996923/20831122 -oh /grid/crs_home/product/11.2.0 -customLogDir /grid/crs_home/product/11.2.0/cfgtoollogs/opatchauto/core
24: /grid/crs_home/product/11.2.0/OPatch/opatch prereq CheckApplicable -ph /grid/soft/20996923/20299019 -oh /grid/crs_home/product/11.2.0 -customLogDir /grid/crs_home/product/11.2.0/cfgtoollogs/opatchauto/core
25: /grid/crs_home/product/11.2.0/OPatch/opatch napply /grid/soft/20996923/20760982 -local -silent -ocmrf /grid/soft/ocm.rsp -oh /grid/crs_home/product/11.2.0 -invPtrLoc /grid/crs_home/product/11.2.0/oraInst.loc
26: /grid/crs_home/product/11.2.0/OPatch/opatch napply /grid/soft/20996923/20831122 -local -silent -ocmrf /grid/soft/ocm.rsp -oh /grid/crs_home/product/11.2.0 -invPtrLoc /grid/crs_home/product/11.2.0/oraInst.loc
27: /grid/crs_home/product/11.2.0/OPatch/opatch napply /grid/soft/20996923/20299019 -local -silent -ocmrf /grid/soft/ocm.rsp -oh /grid/crs_home/product/11.2.0 -invPtrLoc /grid/crs_home/product/11.2.0/oraInst.loc
28: /grid/crs_home/product/11.2.0/bin/emctl start dbconsole
29: /grid/crs_home/product/11.2.0/rdbms/install/rootadd_rdbms.sh : run as root
30: /grid/crs_home/product/11.2.0/crs/install/rootcrs.pl -patch : run as root
31: /oracle/app/oracle/product/11.2.0/bin/emctl start dbconsole
32: /oracle/app/oracle/product/11.2.0/bin/emctl start agent
33: /oracle/app/oracle/product/11.2.0/bin/srvctl start home -o /oracle/app/oracle/product/11.2.0 -s /oracle/app/oracle/product/11.2.0/srvm/admin/stophome.txt -n rac01

再各個節點執行完自動升級後，啟動資料庫:srvctl start database -d racdb

執行下面語句，在每個節點

點選(此處)摺疊或開啟

SQL> @?/rdbms/admin/catbundle.sql psu apply
PL/SQL procedure successfully completed.
Function created.
Function created.
PL/SQL procedure successfully completed.
..............
SQL> INSERT INTO registry$history
2 (action_time, action,
3 namespace, version, id,
4 bundle_series, comments)
5 VALUES
6 (SYSTIMESTAMP, 'APPLY',
7 SYS_CONTEXT('REGISTRY$CTX','NAMESPACE'),
8 '11.2.0.4',
9 7,
10 'PSU',
11 'PSU 11.2.0.4.7');
1 row created.
SQL> COMMIT;
Commit complete.
SQL> SPOOL off
SQL> SET echo off
Check the following log file for errors:
/oracle/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_RACDB_APPLY_2015Aug03_09_58_09.log

檢查資料庫資訊：

點選(此處)摺疊或開啟

SQL> select * from dba_registry_history;
ACTION_TIME ACTION NAMESPACE VERSION ID BUNDLE_SERIES COMMENTS
------------------------------ ---------------- ---------- ---------- ---------- --------------- --------------------------
2014-09-28 05:52:58.357412 APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0
2015-08-03 09:59:48.521212 APPLY SERVER 11.2.0.4 7 PSU PSU 11.2.0.4.7
2015-08-03 10:00:11.433233 APPLY SERVER 11.2.0.4 7 PSU PSU 11.2.0.4.7

檢視grid 版本資訊

點選(此處)摺疊或開啟

[grid@rac01 OPatch]$ ./opatch lsinventory -detail -oh $ORACLE_HOME | grep -i patch
Oracle Interim Patch Installer version 11.2.0.3.10
OPatch version : 11.2.0.3.10
Log file location : /grid/crs_home/product/11.2.0/cfgtoollogs/opatch/opatch2015-08-03_10-49-36AM_1.log
Lsinventory Output file location : /grid/crs_home/product/11.2.0/cfgtoollogs/opatch/lsinv/lsinventory2015-08-03_10-49-36AM.txt
Oracle One-Off Patch Installer 11.2.0.3.4
Interim patches (3) :
Patch 20299019 : applied on Mon Aug 03 09:43:14 CST 2015
Unique Patch ID: 18573450
Patch description: "ACFS Patch set update : 11.2.0.4.6 (20299019)"
Patch Location in Inventory:
Patch Location in Storage area:
/grid/crs_home/product/11.2.0/.patch_storage/20299019_Mar_27_2015_15_26_30
Patch 20831122 : applied on Mon Aug 03 09:41:03 CST 2015
Unique Patch ID: 18923533
Patch description: "OCW Patch Set Update : 11.2.0.4.7 (20831122)"
crspatch.pm --> ORACLE_HOME/crs/install/crspatch.pm
Patch Location in Inventory:
Patch Location in Storage area:
/grid/crs_home/product/11.2.0/.patch_storage/20831122_Jul_1_2015_06_26_45
Patch 20760982 : applied on Mon Aug 03 09:39:05 CST 2015
Unique Patch ID: 18908105
Patch description: "Database Patch Set Update : 11.2.0.4.7 (20760982)"
Sub-patch 20299013; "Database Patch Set Update : 11.2.0.4.6 (20299013)"
Sub-patch 19769489; "Database Patch Set Update : 11.2.0.4.5 (19769489)"
Sub-patch 19121551; "Database Patch Set Update : 11.2.0.4.4 (19121551)"
Sub-patch 18522509; "Database Patch Set Update : 11.2.0.4.3 (18522509)"
Sub-patch 18031668; "Database Patch Set Update : 11.2.0.4.2 (18031668)"
Sub-patch 17478514; "Database Patch Set Update : 11.2.0.4.1 (17478514)"
bug16595641.sql --> ORACLE_HOME/patch/scripts/bug16595641.sql
bug17088068.sql --> ORACLE_HOME/patch/scripts/bug17088068.sql
bug17381384.sql --> ORACLE_HOME/patch/scripts/bug17381384.sql
bug19289642.sql --> ORACLE_HOME/patch/scripts/bug19289642.sql
sdopatch.sql --> ORACLE_HOME/md/admin/sdopatch.sql
Patch Location in Inventory:
Patch Location in Storage area:
/grid/crs_home/product/11.2.0/.patch_storage/20760982_Jun_4_2015_00_23_20
OPatch succeeded.
[grid@rac01 OPatch]$

至此，oracle11g rac 打補丁完成，透過一條命令，我們就可以為gird、database升級，方面高效，透過後臺日志，我們可以看到，它的每一步操作，能夠讓我們更好的掌握升級、瞭解其過程。

文盲筱燁，2015年8月3日

【RAC】oracle11g_rac_auto_update_opatch

相關文章