11.2.0.3.7 (July 2013) Database Patch Set Update (PSU)


Security

This Patch is superseded by 11.2.0.3.8. Read here for more Information.

Oracle has released a new PSU (July 2013) for the 11GR2 Database which is described in the MOS Note 16619892.8

This Update also fixes some BUGs on Oracle Database Appliance System. The Patch is a cumulative and also includes all fixes from 11.2.0.3.6. Oracle recommends to use the latest OPatch utility which is currently 11.2.0.3.4. Check Patch 6880880 for the latest release.

Don`t forget to check MOS Note 1454618.1 for other PSU Patch Numbers like GI or Windows. My colleague has also published an article with some general information here.

You can also check MOS Note 1449750.1 11.2.0.3 Patch Set Updates – List of Fixes in each PSU to which fixes are included in the PSU.

Here is a small example how to apply this patch. Please keep in mind that you configuration can be different so read and follow the documentation provieded by Oracle.

[oracle@server1 16619892]$ /u01/app/oracle/product/11.2.0/db_ee_1/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-07-19_23-10-02PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   13343438  13696216  13923374  14275605  14727310  16056266  16619892  

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 '13343438' to OH '/u01/app/oracle/product/11.2.0/db_ee_1'

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

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...

Verifying the update...
Applying sub-patch '13696216' to OH '/u01/app/oracle/product/11.2.0/db_ee_1'

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

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.sdo.locator, 11.2.0.3.0...

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

Patching component oracle.sysman.oms.core, 10.2.0.4.4...

Verifying the update...
Applying sub-patch '13923374' to OH '/u01/app/oracle/product/11.2.0/db_ee_1'
ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.

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

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...

Patching component oracle.network.rsf, 11.2.0.3.0...

Patching component oracle.network.listener, 11.2.0.3.0...

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

Verifying the update...
Applying sub-patch '14275605' to OH '/u01/app/oracle/product/11.2.0/db_ee_1'
ApplySession: Optional component(s) [ oracle.precomp.lang, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.network.client, 11.2.0.3.0...

Patching component oracle.network.rsf, 11.2.0.3.0...

Patching component oracle.precomp.common, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...

Patching component oracle.rdbms.rman, 11.2.0.3.0...

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

Patching component oracle.rdbms.util, 11.2.0.3.0...

Verifying the update...
Applying sub-patch '14727310' to OH '/u01/app/oracle/product/11.2.0/db_ee_1'

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...

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

Patching component oracle.sdo.locator, 11.2.0.3.0...

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

Patching component oracle.sysman.oms.core, 10.2.0.4.4...

Verifying the update...
Applying sub-patch '16056266' to OH '/u01/app/oracle/product/11.2.0/db_ee_1'
ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.network.listener, 11.2.0.3.0...

Patching component oracle.network.rsf, 11.2.0.3.0...

Patching component oracle.ovm, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.rman, 11.2.0.3.0...

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

Patching component oracle.sdo.locator, 11.2.0.3.0...

Patching component oracle.rdbms.deconfig, 11.2.0.3.0...

Verifying the update...
Applying sub-patch '16619892' to OH '/u01/app/oracle/product/11.2.0/db_ee_1'
ApplySession: Optional component(s) [ oracle.precomp.lang, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.marvel, 11.2.0.3.0...

Patching component oracle.precomp.common, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.rman, 11.2.0.3.0...

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

Patching component oracle.sysman.agent, 10.2.0.4.3...

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

Patching component oracle.sysman.repository.core, 10.2.0.4.4...

Patching component oracle.xdk, 11.2.0.3.0...

Patching component oracle.xdk.parser.java, 11.2.0.3.0...

Patching component oracle.xdk.rsf, 11.2.0.3.0...

Verifying the update...

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_ee_1/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg'
/u01/app/oracle/product/11.2.0/db_ee_1/precomp/lib/ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg'
/u01/app/oracle/product/11.2.0/db_ee_1/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg'

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_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_ee_1/sysman/lib/ins_emagent.mk:113: warning: overriding commands for target `nmosudo'
/u01/app/oracle/product/11.2.0/db_ee_1/sysman/lib/ins_emagent.mk:52: warning: ignoring old commands for target `nmosudo'

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-07-19_23-10-02PM/rac/copy_files.txt"
     DP = "/u01/app/oracle/product/11.2.0/db_ee_1/.patch_storage/NApply/2013-07-19_23-10-02PM/rac/copy_dirs.txt"
     MP = "/u01/app/oracle/product/11.2.0/db_ee_1/.patch_storage/NApply/2013-07-19_23-10-02PM/rac/make_cmds.txt"
     RC = "/u01/app/oracle/product/11.2.0/db_ee_1/.patch_storage/NApply/2013-07-19_23-10-02PM/rac/remote_cmds.txt"

Instantiating the file "/u01/app/oracle/product/11.2.0/db_ee_1/.patch_storage/NApply/2013-07-19_23-10-02PM/rac/copy_files.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/oracle/product/11.2.0/db_ee_1/.patch_storage/NApply/2013-07-19_23-10-02PM/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-07-19_23-10-02PM/rac/copy_dirs.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/oracle/product/11.2.0/db_ee_1/.patch_storage/NApply/2013-07-19_23-10-02PM/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-07-19_23-10-02PM/rac/make_cmds.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/oracle/product/11.2.0/db_ee_1/.patch_storage/NApply/2013-07-19_23-10-02PM/rac/make_cmds.txt" with actual path.
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 

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/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 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 inid 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_server.mk itnslsnr 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/precomp/lib; /usr/bin/make -f ins_precomp.mk proc 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/precomp/lib; /usr/bin/make -f ins_precomp.mk procob 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/plsql/lib; /usr/bin/make -f ins_plsql.mk iwrap 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 irman 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 iplshprof 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 iamdu 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 ikfed 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/sysman/lib; /usr/bin/make -f ins_emagent.mk e2eme 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 16619892 successfully applied.
OPatch Session completed with warnings.
Log file location: /u01/app/oracle/product/11.2.0/db_ee_1/cfgtoollogs/opatch/opatch2013-07-19_23-10-02PM_1.log

OPatch completed with warnings.
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