OPatch/Patch Questions/Issues for Oracle Clusterware/ RAC Environments_1339140.1
FAQ: OPatch/Patch Questions/Issues for Oracle Clusterware (Grid Infrastructure or CRS) and RAC Environments (Doc ID 1339140.1)
In this Document
Applies to:Oracle Database - Enterprise Edition - Version 10.1.0.2 and laterInformation in this document applies to any platform. @ Purpose
This note lists the top opatch or patch related questions or problems in Oracle Clusterware (11gR2 Grid Infrastructure or pre-11.2 CRS) and RAC environments. Questions and Answers
Oracle Home TypeWhat type of home do I have?In a pre-11.2 Clusterware environment you will have:
In a 11.2 Grid Infrastructure environment you will have:
Types of PatchesWhat Types of Patches are available for Oracle Clusterware, Grid Infrastructure and/or the Database?Generally patches for Clusterware, Grid Infrastructure and/or the Database are catagorized into the following:
Patchsets Q&AWhat's a Patchset?Compared to all other patch types, a Patchset is released the least frequently. It contains fixes for most known issues for the release and potentially also introduces new features. A patchset is cumulative and when applied it changes the fourth digit of the product release banner - for example, 10.2.0.5 is 4th patch set for 10.2, and 11.2.0.2 is the 1st patch set for 11.2.
A patchset must be installed via the Oracle Universal Installer (OUI) and is generally considered an "upgrade". Patch Set Updates (PSUs) Q&AWhat's a Patch Set Update (PSU)?As the name implies PSUs are patches that are applied on top of a given patchset release. They are released on a quarterly basis and contain fixes for known critical issues for the patchset. PSUs are subject to thorough testing and do not include changes that would alter the functionality of the software. With this in mind, PSUs are designed to provide "low risk" and "high value" allowing for customers to more easily adopt proactive patching strategies. Consider the following PSU facts:
Generally speaking PSU are released on quarterly basis for both Clusterware/Grid Infrastructure and Database. There's cases where a Clusterware PSUs is not released for corresponding Database PSU. For example, there's database PSU 10.2.0.5.4 but no CRS PSU 10.2.0.5.4. Will the 5th digit of the version be changed after PSU is applied?A PSU will not physically update the 5th-digit of the release information, the updates to the 5th digit in the release are for Documentation purposes only. So the third GI PSU that was released for 11.2.0.2 will have a documentation version of 11.2.0.2.3. You will NOT see this change reflected in the actual software version if you query it from the inventory, clusterware or database. What's included in a GI PSU ?
Unlike other Grid Infrastructure patches (discussed later), 11gR2 GI PSUs contains both GI PSU and Database PSU (YES, both GI and DB PSU) for a particular quarter. For example, 11.2.0.2.2 GI PSU contains both the 11.2.0.2.2 GI PSU and the 11.2.0.2.2 Database PSU.
Document 405820.1 - 10.2 CRS PSU Known issues
Document 810663.1 - 11.1 CRS PSU Known issues Document 1082394.1 - 11.2.0.1 GI PSU Known issues
Document 1272288.1 - 11.2.0.2 GI PSU Known Issues
Interim patches (2) :
Patch 9654983 : applied on Thu Feb 02 20:36:47 PST 2012 Patch 9655006 : applied on Thu Feb 02 20:35:53 PST 2012
List of Bugs fixed by Installed Patches:
Bug Fixed by Installed at Description Patch --- -------- ------------ ----------- 7519406 9654983 Thu Feb 02 20:36:47 PST 2012 'J000' TRACE FILE REGARDING GATHER_STATS_JOB INTER .. 9783609 9655006 Thu Feb 02 20:35:53 PST 2012 CRS 11.2.0.1.0 Bundle Can a Database PSU be applied to a clusterware home? No, only CRS PSUs, GI PSUs or other Clusterware/GI patches can be applied to a Clusterware/GI home. Critical Patch Updates (CPUs) Q&AWhat are Critical Patch Updates (CPUs)?CPU Patches are collection of high-priority fixes for security related issues and are only applicable to the Database Home (and pre-11.2 ASM Home(s)) . CPUs are released quarterly on the same cycle as PSUs and are cumulative with respect to prior security fixes but may contain other fixes in order to address patch conflicts with non-security patches. PSUs always contain the CPU for that respective quarter. PSUs and CPUs are NOT compatible meaning if you apply the 11.2.0.2.2 Database PSU and then want to apply the 11.2.0.2 July CPU this would result in the rollback of the 11.2.0.2.2 Database PSU. That said, once a PSU patching strategy is adopted it must be maintained. PSU patching is preferred over CPU Patching. Bundle Patches Q&AWhat's the difference between a Clusterware/Grid Infrastructure bundle patch and a PSU?
A Clusterware or Grid Infrastructure (GI) patch can be in the form of bundle or Patchset Update (PSU). The biggest difference between a GI/Clusterware bundle and a PSU is that PSUs are bound to a quarterly release schedule while a bundle may be released at any time throughout the course of a given quarter. If a GI/Clusterware bundle is released in a given quarter, the fixes in that bundle will be included in the PSU that will be released for that quarter. This concept allows for development to provide critical bug fixes in a more granular timeline if necessary. Interim (one-off) Patch Q&AWhat's an interim patch (one-off patch)?
An interim patch contains fixes for one or in some cases several bugs (merge patch). General Patch Q&AWhat's the difference between Clusterware/Grid Infrastructure patches and Database patches?
Generally speaking Clusterware/Grid Infrastructure patches modify files that belong to the Clusterware or Grid Infrastructure product, while Database patches change files that belong to the database product. As they apply to different sets of files, they do not conflict with each other.
Clusterware and Grid Infrastructure patches have at least two portions, one for the clusterware home, and the other for the Database home(s). Those two portions have same version number. The clusterware home portion is in the top level directory of the unzipped location, while the other portion is in custom/server/ Which Patch Applies to Which HomeWhat's Oracle's patching recommendation?Oracle recommends to apply the latest patchset and latest PSU as a general best practice. Which oracle home does a patch apply to?
A home must meet the patch version specification to be applicable. How do I tell from the patch readme which home the patch applies to?
The patch README usually tells which home it applies to.
# Product Patched : ORCL_PF ==> Applies to database and pre-11.2 ASM home
# Product Patched : RDBMS ==> Applies to database and pre-11.2 ASM home # Product Patched : CRS/RDBMS ==> Applies to both clusterware and database homes Oracle Database 11g Release 11.2.0.2.3 ==> Applies to database home. Oracle Clusterware 11g Release 2 (11.2.0.2.2) ==> Applies to both clusterware and database homes Do Exadata patches apply to GI or RAC homes?General speaking, Exadata patches should only be applied to Exadata environments. Can I upgrade the Clusterware or Grid Infrastructure to a higher version while leaving database at a lower version?
Do I need downtime to apply a Clusterware or Grid Infrastructure patch?If the Clusterware/Grid Infrastructure home is not shared (common), Clusterware/Grid Infrastructure patches can be applied in rolling fashion so no downtime (of the entire cluster) is needed. Which PSU patch applies to what home in mixed environments (clusterware and database at different version)?Example 1:
11.2.0.2 GI + 11.2.0.2 DB, 11.1.0.7 DB and 10.2.0.5 DB
In this environment, 11.2.0.2 GI PSU applies to both 11.2.0.2 GI and 11.2.0.2 DB home(DB PSU does not apply to any home), 11.1.0.7 CRS PSU and 11.1.0.7 database PSU applies to 11.1.0.7 DB home, and 10.2.0.5 CRS PSU and 10.2.0.5 database PSU applies to 10.2.0.5 DB home.
11.1.0.7 CRS + 11.1.0.7 CRS, 10.2.0.5 DB
In this environment, 11.1.0.7 CRS PSU applies to 11.1.0.7 CRS home, 11.1.0.7 CRS PSU and 11.1.0.7 database PSU applies to 11.1.0.7 database home, 10.2.0.5 CRS PSU and 10.2.0.5 DB PSU applies to 10.2.0.5 DB home. OPatch Q&AHow to find out the opatch version?To find out the opatch version perform the following as the Oracle software owner:
% export ORACLE_HOME=
% $ORACLE_HOME/OPatch/opatch version
How do I install the latest OPatch release?Prior to applying a patch to a system it is HIGHLY recommended (often required) to download and install the latest version of the OPatch utility into every ORACLE_HOME on every cluster node that is to be patched. The latest version of OPatch can be found on MOS under Patch 6880880. Be sure to download the release of OPatch that is applicable for your platform and major release (e.g. Linux-x86-64 11.2.0.0.0). Once OPatch has been downloaded and staged on your target system(s) it can be installed by executing the following as the Oracle Software installation owner:
% export ORACLE_HOME=
% unzip -d $ORACLE_HOME p6880880_112000_Linux-x86-64.zip
Why is "opatch auto" not patching my RAC database home?Why is "opatch auto" not patching my RAC database home, refer to note 1479651.1
What's the difference between manual opatch apply and opatch auto?
In a single instance environment to apply database patch it is very simple. Shutdown all processes running from a home to be patched and invoke "opatch apply" or "opatch napply". Very simple. How do I apply a Grid Infrastructure patch before the root script (root.sh or rootupgrade.sh) is executed?Refer to note 1410202.1 for details. How to apply a patch after the root script (root.sh or rootupgrade.sh) has failed?
In some cases root script fails because of missing patch (e.g. Document 1212703.1 Oracle Grid Infrastructure 11.2.0.2 Installation or Upgrade may fail due to Multicasting Requirement).
# find $GRID_HOME -user root
# $GI_HOME/perl/bin/perl $GI_HOME/crs/install/rootcrs.pl -unlock
How to apply a Clusterware or Grid Infrastructure patch manually?It's recommended to use OPatch auto when applicable; but in the case that OPatch auto does not apply or fails to apply the patch, refer to patch README and the following notes for manual patch instructions. The following notes may also be of use when in this situation:
Document 1089476.1 - Patch 11gR2 Grid Infrastructure Standalone (Oracle Restart)
Document 1064804.1 - Apply Grid Infrastructure/CRS Patch in Mixed environment
ExamplesOPatch Auto Example to Apply a GI PSU (includes Database PSU)
Note: This example only covers the application of the patch iteslf. It does NOT cover the additional database, ACFS or any other component specific steps required for the PSU installation. That said you must ALWAYS consult the patch README prior to attempting to install any patch.
% mkdir /u01/stage/gipsu3
Note: The directory must be readable, writable by root, grid and all database users.
% unzip -d /u01/stage/gipsu3 p12419353_112020_Linux-x86-64.zip
% $GI_HOME/OPatch/opatch lsinventory -detail -oh
Note: If any errors or inconsistencies are returned corrective action MUST be taken prior to applying the patch.
# cd /u01/stage/gipsu3
# export GI_HOME=/ocw/grid # $GI_HOME/OPatch/opatch auto /u01/stage/gipsu3
Note: You can optionally apply the patch to an individual 11.2.0.2 home by specifying the -oh
# $GI_HOME/OPatch/opatch auto /u01/stage/gipsu3 -oh /u01/stage/gipsu3 This would apply the 11.2.0.2.3 GI PSU to ONLY the 11.2.0.2 GI Home.
% $GI_HOME/OPatch/opatch lsinventory -detail -oh
Note: The patch README should be consulted for additional instructions!
% cd $ORACLE_HOME/rdbms/admin
% sqlplus /nolog SQL> CONNECT / AS SYSDBA SQL> STARTUP SQL> @catbundle.sql psu apply SQL> QUIT
EXAMPLE: Apply a CRS patch manuallyThe example assumes the following:
Note: This example only covers the application of the patch iteslf. It does NOT cover the additional databaseor any other component specific steps required for the patch installation. That said you must ALWAYS consult the patch README prior to attempting to install any patch.
% mkdir /u01/stage/crspsu7
% unzip -d /u01/stage/crspsu7 p11724953_11107_Solaris-64.zip
% $CRS_HOME/OPatch/opatch lsinventory -detail -oh
As oracle from the ORACLE_HOME in which the resource is running:
% $ORACLE_HOME/bin/srvctl stop instance -i % $ASM_HOME/bin/srvctl stop asm -n % $CRS_HOME/bin/srvctl stop nodeapps -n As root: # $CRS_HOME/bin/crsctl stop crs
# /u01/stage/crspsu7/11724953/custom/scripts/prerootpatch.sh -crshome /ocw/crs -crsuser oracle
Note: the crsuser is not "root", it is the software install owner, this is a commonly made mistake
% /u01/stage/crspsu7/11724953/custom/scripts/prepatch.sh -crshome /ocw/crs
% /u01/stage/crspsu7/11724953/custom/server/11724953/custom/scripts/prepatch.sh -dbhome /db/11.1/asm
% /u01/stage/crspsu7/11724953/custom/server/11724953/custom/scripts/prepatch.sh -dbhome /db/11.1/db1 % /u01/stage/crspsu7/11724953/custom/server/11724953/custom/scripts/prepatch.sh -dbhome /db/11.1/db2
% export ORACLE_HOME=/ocw/crs
% $ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /u01/stage/crspsu7/11724953
% export ORACLE_HOME=/db/11.1/asm
% $ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /u01/stage/crspsu7/11724953/11724953/custom/server/11724953/ % export ORACLE_HOME=/db/11.1/db1 % $ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /u01/stage/crspsu7/11724953/11724953/custom/server/11724953/ % export ORACLE_HOME=/db/11.1/db2 % $ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /u01/stage/crspsu7/11724953/11724953/custom/server/11724953/
% /u01/stage/crspsu7/11724953/custom/scripts/postpatch.sh -crshome /ocw/crs
% u01/stage/crspsu7/11724953/custom/server/11724953/custom/scripts/postpatch.sh -dbhome /db/11.1/asm
% u01/stage/crspsu7/11724953/custom/server/11724953/custom/scripts/postpatch.sh -dbhome /db/11.1/db1 % u01/stage/crspsu7/11724953/custom/server/11724953/custom/scripts/postpatch.sh -dbhome /db/11.1/db2
# u01/stage/crspsu7/11724953/custom/scripts/postrootpatch.sh -crshome /ocw/crs
% $CRS_HOME/OPatch/opatch lsinventory -detail -oh
% $ORACLE_HOME/bin/srvctl start instance -i
% $ASM_HOME/bin/srvctl start asm -n % $CRS_HOME/bin/srvctl start nodeapps -n
EXAMPLE: Applying a GI PSU patch manually
Note: This example only covers the application of the patch iteslf. It does NOT cover the additional databaseor any other component specific steps required for the patch installation. That said you must ALWAYS consult the patch README prior to attempting to install any patch.
% mkdir /u01/stage/gipsu3
Note: The directory must be readable, writable by root, grid and all database users.
% unzip -d /u01/stage/gipsu3 p12419353_112020_Linux-x86-64.zip
% $GI_HOME/OPatch/opatch lsinventory -detail -oh
Note: If any errors or inconsistencies are returned corrective action MUST be taken prior to applying the patch.
% $GI_HOME/bin/srvctl stop home -o /db/11.2/db1 -s /tmp/statefile_db1.out -n
% $GI_HOME/bin/srvctl stop home -o /db/11.2/db2 -s /tmp/statefile_db2.out -n
# export ORACLE_HOME=/ocw/grid
# $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/crs/install/rootcrs.pl -unlock ## execute this in Grid Infrastructure cluster, for Oracle Restart see the note below.
Note: If you are in a Oracle Restart environment, you will need to use the roothas.pl script instead of the rootcrs.pl script as follows:
# $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/crs/install/roothas.pl -unlock
% /u01/stage/gipsu3/12419353/custom/server/12419353/custom/scripts/prepatch.sh -dbhome /db/11.2/db1
% /u01/stage/gipsu3/12419353/custom/server/12419353/custom/scripts/prepatch.sh -dbhome /db/11.2/db2
% export ORACLE_HOME=/ocw/grid
% $ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /u01/stage/gipsu3/12419353 % $ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /u01/stage/gipsu3/12419331
% export ORACLE_HOME=/db/11.2/db1
% $ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /u01/stage/gipsu3/12419353/custom/server/12419353 % $ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /u01/stage/gipsu3/12419331 % export ORACLE_HOME=/db/11.2/db2 % $ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /u01/stage/gipsu3/12419353/custom/server/12419353 % $ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /u01/stage/gipsu3/12419331
% /u01/stage/gipsu3/12419353/custom/server/12419353/custom/scripts/postpatch.sh -dbhome /db/11.2/db1
% /u01/stage/gipsu3/12419353/custom/server/12419353/custom/scripts/postpatch.sh -dbhome /db/11.2/db2
# export ORACLE_HOME=/ocw/grid
# $ORACLE_HOME/rdbms/install/rootadd_rdbms.sh
# export ORACLE_HOME=/ocw/grid
# $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/crs/install/rootcrs.pl -patch ## execute this in Grid Infrastructure cluster, for Oracle Restart see the note below.
Note: If you are in a Oracle Restart environment, you will need to use the roothas.pl script instead of the rootcrs.pl script as follows:
# $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/crs/install/roothas.pl -patch
# $GI_HOME/bin/srvctl start home -o /db/11.2/db1 -s /tmp/statefile_db1.out -n # $GI_HOME/bin/srvctl start home -o /db/11.2/db2 -s /tmp/statefile_db2.out -n
% $GI_HOME/OPatch/opatch lsinventory -detail -oh
Note: The patch README should be consulted for additional instructions!
% cd $ORACLE_HOME/rdbms/admin
% sqlplus /nolog SQL> CONNECT / AS SYSDBA SQL> STARTUP SQL> @catbundle.sql psu apply SQL> QUIT
Common OPatch Failures and TroubleshootingWhat files to review if opatch auto fails?
The key to OPatch Auto troubleshooting is understanding where and how the OPatch Auto logs are generated. When OPatch auto is invoked, it will generate a opatchauto "opatch apply" or "opatch napply" failure if clusterware home is not unlockedIf "opatch napply" or "opatch apply" is executed without unlocking clusterware home first, the following will be reported:
ApplySession failed: ApplySession failed to prepare the system. ApplySession was not able to create the patch_storage area: /ocw/grid/.patch_storage/
.. OPatch failed with error code 73 OR chmod: changing permissions of `/ocw/grid/bin': Operation not permitted .. mv: cannot move `/ocw/grid/bin/oracle' to `/ocw/grid/bin/oracleO': Permission denied ..
OPatch reports: "Prerequisite check CheckSystemSpace failed"
On AIX, due to unpublished bug 9780505 opatch needs about 22GB of free disk space in $GRID_HOME to apply a GI PSU/Bundle compared to about 4.4GB on other platforms. "opatch util cleanup -oh Common causes of "The opatch version check failed"ZOP-49: Not able to execute the prereq. OPatch cannot inform if the patch satisfies minimum version requirement.
OPatch reports: "Patch nnn requires component(s) that are not installed in OracleHome"
These not-installed components are oracle.crs: Common causes of "The opatch Component check failed"
Refer to Document 1169036.1 for troubleshooting instructions. Common causes of "The opatch Conflict check failed"
Common causes of "The opatch Applicable check failed"ZOP-46: The patch(es) are not applicable on the Oracle Home because some patch actions are not applicable. All required components, however, are installed.
Prereq "checkApplicable" for patch 13653086 failed.
ZOP-46: The patch(es) are not applicable on the Oracle Home because some patch actions are not applicable. All required components, however, are installed. Prereq "checkApplicable" for patch 13653086 failed. .. Copy Action: Desctination File "/u02/grid/11.2.0/bin/crsd.bin" is not writeable. 'oracle.crs, 11.2.0.2.0': Cannot copy file from 'crsd.bin' to '/u02/grid/11.2.0/bin/crsd.bin'
For other potential causes, review opatch logfile. The OPatch log file can be found in $ORACLE_HOME/cfgtoollogs/opatch.
Common causes of "patch
|
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17252115/viewspace-1256482/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORACLE RAC clusterwareOracle
- $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithOracleAI
- Split Brain in Oracle Clusterware and Real Application ClusterAIOracleAPP
- Oracle 21C Clusterware Technology StackOracle
- Oracle的OPatch補丁更新Oracle
- Oracle更新Opatch故障處理Oracle
- RAC和ASM環境下打patchASM
- Oracle RAC 第二節點打補丁報錯 oui-patch.xml (Permission denied)OracleUIXML
- oracle RACOracle
- Oracle Critical Patch Update for October 2022Oracle
- Oracle RAC Cache Fusion 系列十七:Oracle RAC DRMOracle
- 【mos 1265700.1】Oracle Patch Assurance - Data Guard Standby-First Patch ApplyOracleAPP
- ORACLE 12C opatch fuser與ChecksystemCommandAvailable failedOracleAI
- Oracle 11.2 DataGuard RAC To RAC搭建Oracle
- Oracle RAC CacheFusion 系列十五:Oracle RAC CRServer Part TwoOracleServer
- Oracle RAC Cache Fusion系列十八:Oracle RAC Statisticsand Wait EventsOracleAI
- Oracle RAC Cache Fusion 系列十四:Oracle RAC CR Server Part OneOracleServer
- Oracle RAC Cache Fusion 系列十:Oracle RAC Enqueues And Lock Part 1OracleENQ
- 【RAC】Oracle RAC如何修改心跳網路Oracle
- Oracle RAC Wait EventsOracleAI
- oracle rac 增加磁碟Oracle
- Interview-QuestionsView
- Laravel interview questionsLaravelView
- 【RAC】Oracle rac 如何修改公網及vipOracle
- Opatch - Where Can I Find the Latest Version of Opatch?
- Oracle RAC Cache Fusion 系列九:Oracle RAC 分散式資源管理(二)Oracle分散式
- Oracle RAC Cache Fusion 系列八:Oracle RAC 分散式資源管理(一)Oracle分散式
- ORACLE ONLINE PATCH & ORA-00600[kcbgtcr_13]Oracle
- Oracle RAC+DG搭建Oracle
- Oracle RAC更新補丁Oracle
- Oracle RAC新增節點Oracle
- 4.2.1.12 規劃 Oracle RACOracle
- Oracle RAC自啟動Oracle
- Networker備份oracle racOracle
- Oracle:RAC 程式簡介Oracle
- G003-ORACLE-INS-RAC-01 ORACLE 19C RAC Ins ON OEL 7.8Oracle
- 【BUILD_ORACLE】Oracle 19c RAC搭建(六)建立RAC資料庫UIOracle資料庫
- PHP Interview Questions (11)PHPView
- SAP WM Interview QuestionsView