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.