Note: This is a new host that has not yet been created. If the database already exists, you need to perform the database refreshing operation!
Environment: SUSE Linux Enterprise Server 11 sp1 (x86_64)
Upgrade the Oracle database from 11.2.0.3.0 to 11.2.0.3.7 PSU (latest). The patch is 16619892.
P16619892_112030_Linux-x86-64.zip
Recommended reading: Considerations for upgrading the memory of the Oracle Database Server
Decompress the package with an oracle user:
Oracle @ tb-dinggou3 :~ /Softs> unzip p16619892_112030_Linux-x86-64.zip
Oracle @ tb-dinggou3 :~ /Softs> ls
16619892 p16619892_112030_Linux-x86-64.zip
Oracle @ tb-dinggou3 :~ /Softs> cd 16619892/
Oracle @ tb-dinggou3 :~ /Softs/16619892> ls
13343438 13696216 13923374 14275605 14727310 16056266 16619892 patchmd. xml README.html README.txt
This PSU has requirements on OPatch. You must use OPatch in Versions later than 11.2.0.3.0. The patch number of this OPatch is 6880880. Download the OPatch patch:
P6880880_112000_Linux-x86-64.zip
Then replace OPatch:
Oracle @ tb-dinggou3 :~ /Softs> cd $ ORACLE_HOME
Oracle @ tb-dinggou3:/opt/oracle/product/11gR2/db> mv OPatch OPatch_bak
Oracle @ tb-dinggou3:/opt/oracle/product/11gR2/db> unzip p6880880_112000_Linux-x86-64.zip
Oracle @ tb-dinggou3:/opt/oracle/product/11gR2/db> opatch version
OPatch Version: 11.2.0.3.4
Patch conflict check:
Oracle @ tb-dinggou3 :~ /Softs/16619892> opatch prereq CheckConflictAgainstOHWithDetail-ph ./
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home:/opt/oracle/product/11gR2/db
Central Inventory:/opt/oraInventory
From:/opt/oracle/product/11gR2/db/oraInst. loc
OPatch version: 11.2.0.3.4
OUI version: 11.2.0.3.0
Log file location:/opt/oracle/product/11gR2/db/export toollogs/opatch/opatch2013-08-20_04-52-55AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
No patch conflict.
Patch application:
Oracle @ tb-dinggou3 :~ /Softs/16619892> opatch apply
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home:/opt/oracle/product/11gR2/db
Central Inventory:/opt/oraInventory
From:/opt/oracle/product/11gR2/db/oraInst. loc
OPatch version: 11.2.0.3.4
OUI version: 11.2.0.3.0
Log file location:/opt/oracle/product/11gR2/db/export toollogs/opatch/opatch2013-08-20_04-53-08AM_1.log
Verifying environment and padding Ming prerequisite checks...
OPatch continues with these patches: 13343438 13696216 13923374 14275605 14727310 16056266
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
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/opt/oracle/product/11gR2/db ')
Is the local system ready for patching? [Y | n]
Y
User Responded with: Y
Backing up files...
Applying sub-patch '000000' to oh'/opt/oracle/product/11gR2/db'
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 '000000' to oh'/opt/oracle/product/11gR2/db'
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 '000000' to oh'/opt/oracle/product/11gR2/db'
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 '000000' to oh'/opt/oracle/product/11gR2/db'
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 '000000' to oh'/opt/oracle/product/11gR2/db'
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 '000000' to oh'/opt/oracle/product/11gR2/db'
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 '000000' to oh'/opt/oracle/product/11gR2/db'
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'
/Opt/oracle/product/11gR2/db/precomp/lib/env_precomp.mk: 2160: warning: ignoring old commands for target 'pcscfg. cfg'
/Opt/oracle/product/11gR2/db/precomp/lib/ins_precomp.mk: 19: warning: overriding commands for target 'pcscfg. cfg'
/Opt/oracle/product/11gR2/db/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'
/Opt/oracle/product/11gR2/db/sysman/lib/ins_emagent.mk: 113: warning: overriding commands for target 'nmosudo'
/Opt/oracle/product/11gR2/db/sysman/lib/ins_emagent.mk: 52: warning: ignoring old commands for target 'nmosudo'
Composite patch 16619892 successfully applied.
OPatch Session completed with warnings.
Log file location:/opt/oracle/product/11gR2/db/export toollogs/opatch/opatch2013-08-20_04-53-08AM_1.log
OPatch completed with warnings.