Oracle has released a new PSU (Jan 2014) for the 11GR2Database which is described in the MOS Note1594621.1
Patch Set Update (PSU) patches are cumulative. That is,the content of all previous PSUs is included in the latest PSU patch.
Oracle recommends that you use the latest releasedOPatch version for 11.2, which is available for download from My Oracle Supportpatch6880880by selecting the 11.2.0.0.0 release.
To install the PSU 11.2.0.3.9 patch, the Oracle homemust have the 11.2.0.3.0 Database installed. Subsequent PSU patches can beinstalled on Oracle Database 11.2.0.3.0 or any PSU with a lower 5th numeralversion than the one being installed.
You can also check MOS Note1449750.111.2.0.3 Patch Set Updates – List of Fixes in eachPSU to which fixes are included in the PSU.
PatchPre-Installation Requirement
If you are installing the PSU to an environment thathas a Grid Infrastructure home, note the following:
·Grid Infrastructure PSU 11.2.0.3.9 Patch17735354should be applied to the Grid Infrastructure home and Database home using thereadme instructions provided with the patch.
·Ensure that the $PATH definition has thefollowing executables:make,ar,ld,andnm.
One-offPatch Conflict Detection and Resolution
Determinewhether any currently installed one-off patches conflict with the PSU patch asfollows:
unzipp17540582_11203_<platform>.zip
cd 17540582
opatch prereqCheckConflictAgainstOHWithDetail -ph ./
Thereport will indicate the patches that conflict with PSU 17540582 and thepatches for which PSU 17540582 is a superset.
Patch Installation
1. Database version
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE11.2.0.3.0Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
2. OS Version
SQL> !uname -a
Linux gdoraclemon.xxx.com 2.6.32-300.10.1.el5uek #1 SMPWed Feb 22 17:37:40 EST 2012 x86_64 x86_64 x86_64 GNU/Linux
3. Download the latest PSU (Jan2014) for 11.2.0.3
Patch17540582(11.2.0.3.9) fromsupport.oracle.com
4. Opatch Version
[oracle@gdoraclemon ~]$ export PATH=$ORACLE_HOME/OPatch:$PATH
[oracle@gdoraclemon ~]$ opatch version
OPatch Version: 11.2.0.3.6
OPatch succeeded.
5. Sessions Status
Check How Many sesion are ACTIVE, If any found AskApplication team to bring down all Applications/Processes
SQL> select username,count(*) from v$session whereusername is not null group by username;
USERNAMECOUNT(*)
------------------------------ ----------
SYS1
6. Invalid Objects
SQL> select owner,object_type,count(*) fromdba_objects where status='INVALID' group by owner,object_type order byowner,object_type;
OWNEROBJECT_TYPECOUNT(*)
------------------------------ -----------------------------
SYSMANMATERIALIZED VIEW1
7. Status of Oracle Services
[oracle@gdoraclemon ~]$ ps -ef | grep smon
oracle1638790230 05:20 pts/400:00:00 grep smon
[oracle@gdoraclemon ~]$ ps -ef | grep tns
oracle1638990230 05:20 pts/400:00:00 grep tns
8. Take Cold Backup of Database & Backup of (ORACLE_HOME& Inventory)
--Preferred to have a user-managed backup
9. Apply Opatch
export PATH=$ORACLE_HOME/OPatch:$PATH
·Setyour current directory to the directory where the patch is located and then runthe OPatch utility by entering the following commands:
unzip p17540582_11203_<platform>.zip
cd 17540582
opatch apply
Known Issues:
Review the log file and look for any warning or errors afterapplying the latest PSU Patch.
Example of the OPatch outputwhen patchingthe Oracle database 11.2.0.3 with the 11.2.0.3.9 PSU
--------------------------------------------------------------------------------
The following warnings have occurred during OPatch execution:
1) OUI-67215:
OPatch found the word"warning" in the stderr of the make command.
Please look at this stderr. You can re-run this make command.
Stderr output:
ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg'
/u01/app/oracle/product/11.2.0/db_1/precomp/lib/env_precomp.mk:2160:warning: ignoring old commands for target `pcscfg.cfg'
/u01/app/oracle/product/11.2.0/db_1/precomp/lib/ins_precomp.mk:19:warning: overriding commands for target `pcscfg.cfg'
/u01/app/oracle/product/11.2.0/db_1/precomp/lib/env_precomp.mk:2160:warning: ignoring old commands for target `pcscfg.cfg'
2) OUI-67215:
OPatch found the word "warning" in the stderr of the makecommand.
Please look at this stderr. You can re-run this make command.
Stderr output:
ins_emagent.mk:113: warning:overriding commands for target `nmosudo'
ins_emagent.mk:52: warning: ignoring old commands for target `nmosudo'
/u01/app/oracle/product/11.2.0/db_1/sysman/lib/ins_emagent.mk:113:warning: overriding commands for target `nmosudo'
/u01/app/oracle/product/11.2.0/db_1/sysman/lib/ins_emagent.mk:52:warning: ignoring old commands for target `nmosudo'
--------------------------------------------------------------------------------
The command relink however completes successfully.
Note: OPatch recognizes the messages as warning and successfully applies the PSU
As per MOS doc1593211.1and1448337.1, all thesewarnings are harmless and can be safely ignored.
10. Post Installation
·Database instance running on the Oraclehome being patched, connect to the database using SQL*Plus using SYSDBA and runthe catbundle.sql script as follows:
cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle.sql psu apply
SQL> QUIT
·Check the following log files in$ORACLE_HOME/cfgtoollogs/catbundle or $ORACLE_BASE/cfgtoollogs/catbundle forany errors:
catbundle_PSU_<database SID>_APPLY_<TIMESTAMP>.log
catbundle_PSU_<databaseSID>_GENERATE_<TIMESTAMP>.log
11. Check the status from registry$history
SQL> column version format a10
column action format a10
column bundle_series format a10
column comments format a25
select action, version, id, comments, bundle_seriesfrom registry$history where bundle_series like '%PSU%';
ACTIONVERSIONIDCOMMENTSBUNDLE_SER
---------- ---------- ---------- -----------------------------------
APPLY11.2.0.30 Patchset11.2.0.2.0PSU
APPLY11.2.0.30 Patchset11.2.0.2.0PSU
APPLY11.2.0.39 PSU 11.2.0.3.9PSU
12. Compile Invalid objects by executing “utlrp.sql”.
cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL>@utlrp.sql
13. OPatch status
[oracle@gdoraclemon ~]$ opatch lsinventory | grep17540582
Patch17540582: applied on Mon Jan20 05:36:09 PST 2014
Patch description:"Database Patch Set Update : 11.2.0.3.9 (17540582)"
13624984,16024441, 17333199, 13914613, 17540582, 14258925, 14222403
References:
ImportantMOS notes about patches, patch sets, PSU, SRU and bundle patches :
Introduction to Oracle Recommended Patches [756388.1]
This MOS notes is the main entry to the Oracle recommended patches. It includes further links to Oracle Database, Oracle Enterprise Manager, Oracle Fusion Middleware and other products.
Oracle Recommended Patches — Oracle Database [756671.1]
This notes includes the links for the latest recommended patches of Oracle Databases on Unix and Linux since Oracle 10.2.0.3
Oracle Database, Networking and Grid Agent Patches for Microsoft Platforms [161549.1]
As the name says, this note contains further links for recommended patches of Oracle Databases on Microsoft Windows
Quick Reference to Patch Numbers for Database PSU, SPU(CPU), Bundle Patches and Patchsets [1454618.1]
This MOS note is some kind of a master note for any PSU, CPU, Bundle Patches and Patchset. Here you’ll find any patch number without struggling yourself first through all the Oracle recommendations
Release Schedule of Current Database Releases [742060.1]
On this MOS Note you do not really find any patch numbers or names but you’ll find the release schedules of upcoming patch set. Ok you do not see an exact date. But at least the quarter of the year.