11.2.0.3.8 (October 2013) Database Patch Set Update (PSU)


pflaster_Fotor

This Patch is superseded by CPU Jan 2014 Read here for more Information.

Oracle has released a new PSU (October 2013) for the 11GR2 Database and 12C Database.

You can read MOS Note 11.2.0.3 Patch Set Updates – List of Fixes in each PSU (Doc ID 1449750.1)  for more Information what has changed in this Update.

Also check the Blog from GUMPX which describes a good overview for this update.

Don`t forget to check MOS Note 1454618.1 for other PSU Patch Numbers like GI or Windows.

Here is a small example how to apply this patch on a database home (remember to patch you GI or Oracle Restart first). Please keep in mind that you configuration can be different so read and follow the documentation provided by Oracle.

Check your OPatch Version

[oracle@server1 16902043]$ /u01/app/oracle/product/11.2.0/db_ee_2/OPatch/opatch version
OPatch Version: 11.2.0.3.4

[oracle@server1 16902043]$ $ORACLE_HOME/OPatch/opatch apply
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/11.2.0/db_ee_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0/db_ee_1/oraInst.loc
OPatch version    : 11.2.0.3.4
OUI version       : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0/db_ee_1/cfgtoollogs/opatch/opatch2013-10-27_10-09-47AM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   16902043  

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name: 

You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]:  y

This node is part of an Oracle Real Application Cluster.
Remote nodes: 'server2' 
Local node: 'server1'
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/11.2.0/db_ee_1')

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying sub-patch '16902043' to OH '/u01/app/oracle/product/11.2.0/db_ee_1'
ApplySession: Optional component(s) [ oracle.idm.oid, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.ldap.rsf, 11.2.0.3.0...

Patching component oracle.ldap.rsf.ic, 11.2.0.3.0...

Patching component oracle.owb.rsf, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.sysman.console.db, 11.2.0.3.0...

Verifying the update...

Patching in rolling mode.

The node 'server2' will be patched next.

Please shutdown Oracle instances running out of this ORACLE_HOME on 'server2'.
(Oracle Home = '/u01/app/oracle/product/11.2.0/db_ee_1')

Is the node ready for patching? [y|n]
y
User Responded with: Y
Updating nodes 'server2' 
   Apply-related files are:
     FP = "/u01/app/oracle/product/11.2.0/db_ee_1/.patch_storage/NApply/2013-10-27_10-09-47AM/rac/copy_files.txt"
     DP = "/u01/app/oracle/product/11.2.0/db_ee_1/.patch_storage/NApply/2013-10-27_10-09-47AM/rac/copy_dirs.txt"
     MP = "/u01/app/oracle/product/11.2.0/db_ee_1/.patch_storage/NApply/2013-10-27_10-09-47AM/rac/make_cmds.txt"
     RC = "/u01/app/oracle/product/11.2.0/db_ee_1/.patch_storage/NApply/2013-10-27_10-09-47AM/rac/remote_cmds.txt"

Instantiating the file "/u01/app/oracle/product/11.2.0/db_ee_1/.patch_storage/NApply/2013-10-27_10-09-47AM/rac/copy_files.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/oracle/product/11.2.0/db_ee_1/.patch_storage/NApply/2013-10-27_10-09-47AM/rac/copy_files.txt" with actual path.
Propagating files to remote nodes...
Instantiating the file "/u01/app/oracle/product/11.2.0/db_ee_1/.patch_storage/NApply/2013-10-27_10-09-47AM/rac/copy_dirs.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/oracle/product/11.2.0/db_ee_1/.patch_storage/NApply/2013-10-27_10-09-47AM/rac/copy_dirs.txt" with actual path.
Propagating directories to remote nodes...
Instantiating the file "/u01/app/oracle/product/11.2.0/db_ee_1/.patch_storage/NApply/2013-10-27_10-09-47AM/rac/make_cmds.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/oracle/product/11.2.0/db_ee_1/.patch_storage/NApply/2013-10-27_10-09-47AM/rac/make_cmds.txt" with actual path.
Running command on remote node 'server2': 
cd /u01/app/oracle/product/11.2.0/db_ee_1/rdbms/lib; /usr/bin/make -f ins_rdbms.mk irenamedg ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_ee_1 || echo REMOTE_MAKE_FAILED::>&2 

Running command on remote node 'server2': 
cd /u01/app/oracle/product/11.2.0/db_ee_1/rdbms/lib; /usr/bin/make -f ins_rdbms.mk ioracle ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_ee_1 || echo REMOTE_MAKE_FAILED::>&2 

Running command on remote node 'server2': 
cd /u01/app/oracle/product/11.2.0/db_ee_1/rdbms/lib; /usr/bin/make -f ins_rdbms.mk client_sharedlib ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_ee_1 || echo REMOTE_MAKE_FAILED::>&2 

Running command on remote node 'server2': 
cd /u01/app/oracle/product/11.2.0/db_ee_1/network/lib; /usr/bin/make -f ins_net_client.mk client_sharedlib ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_ee_1 || echo REMOTE_MAKE_FAILED::>&2 

RC file not exist.  There are no commands to be run on the remote nodes.

The node 'server2' has been patched.  You can restart Oracle instances on it.

Composite patch 16902043 successfully applied.
Log file location: /u01/app/oracle/product/11.2.0/db_ee_1/cfgtoollogs/opatch/opatch2013-10-27_10-09-47AM_1.log

OPatch succeeded.

If you have done all above without any error you need upgrade you database itself. To do this load the catbundle.sql in your database.

[oracle@server1 db_ee_1]$ cd $ORACLE_HOME/rdbms/admin
[oracle@server1 admin]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Sun Oct 27 10:52:49 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> @catbundle psu apply

Check the Logfile ($ORACLE_HOME/cfgtoollogs/catbundle/catbundle_PSU_DB11EE_APPLY_.log for any erros.

If you have also a RMAN catalog running remember to update it also.

As always, comments are welcome.

Advertisements

Kommentar verfassen

Trage deine Daten unten ein oder klicke ein Icon um dich einzuloggen:

WordPress.com-Logo

Du kommentierst mit Deinem WordPress.com-Konto. Abmelden / Ändern )

Twitter-Bild

Du kommentierst mit Deinem Twitter-Konto. Abmelden / Ändern )

Facebook-Foto

Du kommentierst mit Deinem Facebook-Konto. Abmelden / Ändern )

Google+ Foto

Du kommentierst mit Deinem Google+-Konto. Abmelden / Ändern )

Verbinde mit %s