2014-07-17,电信某系统要做数据迁移特实施一套单机为目的系统。以下是从11.2.0.3.0单机PSU到11.2.0.3.11的过程以及遇到的问题。
根据mos推荐的补丁, 2014-07-17最新发布的11.2.0.3.11补丁。根据readme。
1、更新OPatch
You must use the OPatch utility version 11.2.0.3.0 or later to apply this patch. Oracle recommends that you use the latest released OPatch version for 11.2, which is available for download from My Oracle Support patch6880880 by selecting the 11.2.0.0.0 release.
2、步骤
A/解压unzip p18522512_112030_Linux-x86-64.zip
B/
[oracle@oradb 18522512]$ ls
13343438 13923374 14727310 16619892 17540582 18522512 README.html
13696216 14275605 16056266 16902043 18031683 patchmd.xml README.txt
C/
[oracle@oradb 18522512]$ /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.6
OUI version : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2014-07-17_21-51-23PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
</pre><pre code_snippet_id="429359" snippet_file_name="blog_20140718_4_5101494" name="code" class="sql">[oracle@oradb 18522512]$ /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch apply
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.6
OUI version : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2014-07-17_21-51-57PM_1.log
Verifying environment and performing prerequisite checks...
Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:
Following executables are active :
/u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr
Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:
Following executables are active :
/u01/app/oracle/product/11.2.0/dbhome_1/lib/libclntsh.so.11.1
UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.Prerequisite check "CheckActiveFilesAndExecutables" failed.
Log file location: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2014-07-17_21-51-57PM_1.log
OPatch failed with error code 73
这个时候看到
Following executables are active :
/u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr
Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:
解决方法:
[oracle@oradb 18522512]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 17-JUL-2014 22:28:44
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oradb)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 17-JUL-2014 19:48:37
Uptime 0 days 2 hr. 40 min. 8 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/oradb/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oradb)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully
[oracle@oradb 18522512]$ lsnrctl stop
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 17-JUL-2014 22:28:48
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oradb)(PORT=1521)))
The command completed successfully
然后:
[oracle@oradb 18522512]$ /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch apply
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.6
OUI version : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2014-07-17_22-28-53PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 13343438 13696216 13923374 14275605 14727310 16056266 16619892 16902043 17540582 18031683 18522512
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 = '/u01/app/oracle/product/11.2.0/dbhome_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/dbhome_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/dbhome_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/dbhome_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/dbhome_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/dbhome_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/dbhome_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/dbhome_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...
Applying sub-patch '16902043' to OH '/u01/app/oracle/product/11.2.0/dbhome_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...
Applying sub-patch '17540582' to OH '/u01/app/oracle/product/11.2.0/dbhome_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.rdbms, 11.2.0.3.0...
Patching component oracle.rdbms.rsf, 11.2.0.3.0...
Patching component oracle.sdo, 11.2.0.3.0...
Patching component oracle.ldap.rsf, 11.2.0.3.0...
Patching component oracle.precomp.common, 11.2.0.3.0...
Patching component oracle.ordim.client, 11.2.0.3.0...
Patching component oracle.rdbms.util, 11.2.0.3.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...
Patching component oracle.sdo.locator, 11.2.0.3.0...
Patching component oracle.rdbms.rman, 11.2.0.3.0...
Patching component oracle.ordim.jai, 11.2.0.3.0...
Verifying the update...
Applying sub-patch '18031683' to OH '/u01/app/oracle/product/11.2.0/dbhome_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.rdbms.rsf, 11.2.0.3.0...
Patching component oracle.rdbms, 11.2.0.3.0...
Patching component oracle.ldap.rsf, 11.2.0.3.0...
Patching component oracle.precomp.common, 11.2.0.3.0...
Patching component oracle.rdbms.rman, 11.2.0.3.0...
Patching component oracle.rdbms.util, 11.2.0.3.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...
Verifying the update...
Applying sub-patch '18522512' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms.rsf, 11.2.0.3.0...
Patching component oracle.rdbms, 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.rman, 11.2.0.3.0...
Patching component oracle.rdbms.dbscripts, 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/dbhome_1/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg'
/u01/app/oracle/product/11.2.0/dbhome_1/precomp/lib/ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg'
/u01/app/oracle/product/11.2.0/dbhome_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/dbhome_1/sysman/lib/ins_emagent.mk:113: warning: overriding commands for target `nmosudo'
/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk:52: warning: ignoring old commands for target `nmosudo'
Composite patch 18522512 successfully applied.
OPatch Session completed with warnings.
Log file location: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2014-07-17_22-28-53PM_1.log
OPatch completed with warnings.
补丁到这里我们很清楚的看到有两个warning
一、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/dbhome_1/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg'
/u01/app/oracle/product/11.2.0/dbhome_1/precomp/lib/ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg'
/u01/app/oracle/product/11.2.0/dbhome_1/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg'
Excerpt from Oracle Metalink note 1448337.1:
CAUSE
ins_srvm.mk:71: warning: overriding commands for target `libsrvmocr11.so'
ins_srvm.mk:34: warning: ignoring old commands for target `libsrvmocr11.so'
ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg'
env_precomp.mk:2115: warning: ignoring old commands for target `pcscfg.cfg'
SOLUTION
二、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/dbhome_1/sysman/lib/ins_emagent.mk:113: warning: overriding commands for target `nmosudo'
/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk:52: warning: ignoring old commands for target `nmosudo'
见mos
APPLIES TO:
Enterprise Manager for Oracle Database - Version 11.2.0.3 to 11.2.0.4 [Release 11.2]Generic UNIX
SYMPTOMS
When relinking the Database Control (DB Control) 11.2.0.3 Agent, you get the following warnings:
ins_emagent.mk:113: warning: overriding commands for target `nmosudo' ins_emagent.mk:52: warning: ignoring old commands for target `nmosudo'
[...]
The command relink however completes successfully.
This warning message can be raised once or several times depending on the relink command executed.
Example of the OPatch output when patching the Oracle database 11.2.0.3 with the 11.2.0.3.7 PSU (Patch 16619892)
$ cd 16619892
$ opatch apply
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /u04/app/oracle/product/11.2.0.3
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'
/u04/app/oracle/product/11.2.0.3/sysman/lib/ins_emagent.mk:113: warning: overriding commands for target `nmosudo'
/u04/app/oracle/product/11.2.0.3/sysman/lib/ins_emagent.mk:52: warning: ignoring old commands for target `nmosudo'
Composite patch 16619892 successfully applied.
OPatch Session completed with warnings.
This warning occurs when OPatch executes the command:
The same warning occurrs several time for different make options with the command:
$ cd $ORACLE_HOME/sysman/lib
$ make -f ins_emagent.mk agent
ns_emagent.mk:113: warning: overriding commands for target `nmosudo'
ins_emagent.mk:52: warning: ignoring old commands for target `nmosudo'
[...]
+ make -f /u01/app/oracle/product/db112032/sysman/lib/ins_emagent.mk new_ld_shlib _FULL_LIBNAME=/u01/app/oracle/product/db112032/sysman/lib/libnmefpfa.so _LIBNAME=libnmefpfa _LIBDIR=/u01/app/oracle/product/db112032/sysman/lib/ '_LIBNAME_LIBS=$(libnmefpfaLIBS)' '_LIBNAME_EXTRALIBS=$(libnmefpfaEXTRALIBS)'
make[2]: Entering directory `/u01/app/oracle/product/db112032/sysman/lib'
/u01/app/oracle/product/db112032/sysman/lib/ins_emagent.mk:113: warning: overriding commands for target `nmosudo'
/u01/app/oracle/product/db112032/sysman/lib/ins_emagent.mk:52: warning: ignoring old commands for target `nmosudo'
[...]
make -f /u01/app/oracle/product/db112032/sysman/lib/ins_emagent.mk relink_sharedobj SHAREDOBJ=libnmevq
make[1]: Entering directory `/u01/app/oracle/product/db112032/sysman/lib'
/u01/app/oracle/product/db112032/sysman/lib/ins_emagent.mk:113: warning: overriding commands for target `nmosudo'
/u01/app/oracle/product/db112032/sysman/lib/ins_emagent.mk:52: warning: ignoring old commands for target `nmosudo'
[...]
make -f /u01/app/oracle/product/db112032/sysman/lib/ins_emagent.mk emtgtctl2
make[1]: Entering directory `/u01/app/oracle/product/db112032/sysman/lib'
/u01/app/oracle/product/db112032/sysman/lib/ins_emagent.mk:113: warning: overriding commands for target `nmosudo'
/u01/app/oracle/product/db112032/sysman/lib/ins_emagent.mk:52: warning: ignoring old commands for target `nmosudo'
gcc -o emtgtctl2 -L/u01/app/oracle/product/db112032/lib/ -L/u01/app/oracle/product/db112032/sysman/lib/ `cat /u01/app/oracle/product/db112032/lib/sysliblist` -Wl,-rpath,/u01/app/oracle/product/db112032/lib -lm `cat /u01/app/oracle/product/db112032/lib/sysliblist` -ldl -lm -L/u01/app/oracle/product/db112032/lib -Wl,-rpath,/u01/app/oracle/product/db112032/lib/:/u01/app/oracle/product/db112032/sysman/lib/:/u01/app/oracle/product/db112032/jdk/jre/lib/amd64/server:/u01/app/oracle/product/db112032/jdk/jre/lib/amd64 /u01/app/oracle/product/db112032/sysman/lib//s0nmetgctl.o -lnmectl -lclntsh -L/u01/app/oracle/product/db112032/lib -L/u01/app/oracle/product/db112032/sysman/lib/ -lnmemso -lcore11 -Wl,-rpath,/u01/app/oracle/product/db112032/lib/:/u01/app/oracle/product/db112032/sysman/lib/:/u01/app/oracle/product/db112032/jdk/jre/lib/amd64/server:/u01/app/oracle/product/db112032/jdk/jre/lib/amd64 -L/u01/app/oracle/product/db112032/jdk/jre/lib/amd64/server -L/u01/app/oracle/product/db112032/jdk/jre/lib/amd64 -z lazyload -ljava -ljvm -lverify -z nolazyload -Wl,-rpath,/u01/app/oracle/product/db112032/lib/:/u01/app/oracle/product/db112032/sysman/lib/:/u01/app/oracle/product/db112032/jdk/jre/lib/amd64/server:/u01/app/oracle/product/db112032/jdk/jre/lib/amd64 -Wl,--allow-shlib-undefined `cat /u01/app/oracle/product/db112032/lib/sysliblist` -ldl -lm
make[1]: Leaving directory `/u01/app/oracle/product/db112032/sysman/lib'
rm -f /u01/app/oracle/product/db112032/bin/emtgtctl2
mv emtgtctl2 /u01/app/oracle/product/db112032/bin/emtgtctl2
/bin/chmod 6751 /u01/app/oracle/product/db112032/bin/emtgtctl2
Enterprise Manager native components relinked
IMPORTANT NOTE: To complete this Install/upgrade, please login as root and execute the root.sh script.
CAUSE
The DB Control Agent file $ORACLE_HOME/sysman/lib/ins_emagent.mk contains obsolete instructions.
SOLUTION
These are simple warnings which do not prevent the relink to complete successfully and which do not alter any DB Control Agent functionality.
These warnings are harmless and can be safely ignored.
An internal bug has been logged to prevent these warnings in the future.
验证
[oracle@oradb 18522512]$ /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.6
OUI version : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2014-07-17_23-09-53PM_1.log
Lsinventory Output file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2014-07-17_23-09-53PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.3.0
There are 1 product(s) installed in this Oracle Home.
Interim patches (1) :
Patch 18522512 : applied on Thu Jul 17 22:33:51 CST 2014
Unique Patch ID: 17629436
Patch description: "Database Patch Set Update : 11.2.0.3.11 (18522512)"
Created on 11 Jun 2014, 05:48:32 hrs PST8PDT
Sub-patch 18031683; "Database Patch Set Update : 11.2.0.3.10 (18031683)"
Sub-patch 17540582; "Database Patch Set Update : 11.2.0.3.9 (17540582)"
Sub-patch 16902043; "Database Patch Set Update : 11.2.0.3.8 (16902043)"
Sub-patch 16619892; "Database Patch Set Update : 11.2.0.3.7 (16619892)"
Sub-patch 16056266; "Database Patch Set Update : 11.2.0.3.6 (16056266)"
Sub-patch 14727310; "Database Patch Set Update : 11.2.0.3.5 (14727310)"
Sub-patch 14275605; "Database Patch Set Update : 11.2.0.3.4 (14275605)"
Sub-patch 13923374; "Database Patch Set Update : 11.2.0.3.3 (13923374)"
Sub-patch 13696216; "Database Patch Set Update : 11.2.0.3.2 (13696216)"
Sub-patch 13343438; "Database Patch Set Update : 11.2.0.3.1 (13343438)"
Bugs fixed:
13593999, 10350832, 14138130, 12919564, 14198511, 13561951, 13588248
13080778, 13804294, 16710324, 18031683, 12873183, 14193240, 16992075
14472647, 12880299, 13369579, 13840704, 14409183, 13492735, 13496884
12857027, 14263036, 13834436, 16038929, 13015379, 14263073, 17748833
16563678, 13732226, 13866822, 13742434, 13944971, 12950644, 12899768
17748831, 16929165, 13063120, 16272008, 13958038, 14613900, 13503204
13972394, 11877623, 12395918, 13072654, 17088068, 13429702, 13814739
17343514, 13649031, 13981051, 15981698, 13901201, 12797765, 17333200
12923168, 16761566, 16279401, 13384182, 13466801, 15996344, 14207163
13596581, 13724193, 11063191, 13642044, 12940637, 15931756, 14052871
13945708, 14123213, 12797420, 13041324, 15869211, 12865902, 14003090
16314468, 16019955, 11708510, 17865671, 14637368, 13026410, 13737746
13742438, 15841373, 16347904, 16088176, 15910002, 16362358, 14398795
13579992, 16344871, 10400244, 13742436, 14275605, 9858539, 14841812
16338983, 9703627, 13483354, 14393728, 14207317, 17165204, 12764337
16902043, 14459552, 14191508, 14588746, 12964067, 12780983, 12583611
14383007, 14546575, 15862016, 13476583, 13489024, 12985237, 17748830
14088346, 13448206, 16314466, 13419660, 18139695, 14110275, 13430938
13467683, 17767676, 14548763, 13424216, 12834027, 13632809, 13853126
13377816, 13036331, 14727310, 16747736, 13584130, 16175381, 17468141
14138823, 12829021, 15862019, 12794305, 14546673, 12791981, 13503598
13787482, 10133521, 12744759, 13399435, 14762511, 13553883, 14023636
9095696, 14343501, 12977562, 13860201, 13257247, 14176879, 13783957
16014985, 12312133, 14480675, 13146182, 16306019, 13559697, 12974860
9706792, 12940620, 13098318, 15883525, 13773133, 16794244, 13340388
13528551, 13366202, 12894807, 13259364, 12747437, 13454210, 12748240
13385346, 15987992, 13923995, 16101465, 14571027, 13582702, 13907462
12784406, 13493847, 13035804, 13857111, 16710363, 13544396, 10110625
14128555, 12813641, 8547978, 14226599, 17478415, 17333197, 9397635
14007968, 13912931, 12925089, 12693626, 14189694, 12815057, 17761775
16721594, 13332439, 14038787, 11071989, 14207902, 14062796, 12913474
14390252, 13370330, 16314470, 14062794, 13358781, 12960925, 17333202
9659614, 14546638, 13699124, 13936424, 9797851, 16794240, 14301592
13338048, 12938841, 12620823, 12656535, 12678920, 13719292, 14488943
14062792, 14791477, 16850197, 13807411, 16794238, 15862022, 12594032
13250244, 14098509, 12612118, 9761357, 18096714, 14053457, 13918644
13527323, 12797620, 18173595, 10625145, 15862020, 13910420, 12780098
13696216, 14774091, 14841558, 10263668, 13849733, 16794242, 16944698
15862023, 16056266, 13834065, 14351566, 13853654, 13723052, 18173593
14063280, 13011409, 13566938, 13737888, 13624984, 16024441, 17333199
13914613, 17540582, 14258925, 14222403, 14755945, 13645875, 12571991
13839641, 14664355, 12998795, 13719081, 14469008, 13361350, 14188650
17019974, 13742433, 14508968, 16314469, 16368108, 12905058, 6690853
16212405, 12849688, 13742435, 18681866, 13464002, 12879027, 13534412
18522512, 12585543, 12747740, 12535346, 13790109, 13878246, 16382448
12588744, 13916549, 13786142, 12847466, 13855490, 13551402, 12582664
14657740, 14262913, 17332800, 14558880, 14695377, 12912137, 13612575
13484963, 14163397, 17437634, 13772618, 16694777, 13070939, 15994107
13605839, 12391034, 14369664, 16279211, 16314467, 12945879, 15901852
7276499, 12976376, 12755231, 13680405, 13742437, 14589750, 14318397
11868640, 14644185, 13326736, 13596521, 13001379, 12898558, 17752121
13099577, 13911711, 9873405, 16372203, 16344758, 11715084, 9547706
16231699, 14040433, 12662040, 14406648, 12617123, 17748832, 16530565
12845115, 16844086, 13354082, 17748834, 13794550, 13397104, 13913630
16462834, 12983611, 13550185, 13810393, 14121009, 13065099, 11840910
13903046, 15862017, 13572659, 16294378, 13718279, 13657605, 17716305
14480676, 13632717, 14668670, 14063281, 14158012, 13736413, 13420224
13812031, 12646784, 16299830, 14512189, 10359307, 12755116, 17230530
13616375, 14035825, 13366199, 13427062, 12861463, 13092220, 15862021
17721717, 16619892, 13043012, 13685544, 18325460, 13499128, 15862018
13839336, 13866372, 13561750, 12718090, 13848402, 13725395, 12401111
12796518, 13362079, 12614359, 12917230, 14408859, 13042639, 13923374
14220725, 12621588, 13524899, 14751895, 14480674, 13916709, 14781609
14076523, 15905421, 12731940, 13343438, 17748835, 14205448, 17082364
14127231, 15853081, 14273397, 16844448, 14467061, 12971775, 16864562
14489591, 14497307, 12748538, 13872868, 10242202, 14230270, 13931044
13686047, 16382353, 17333203, 14095982, 13591624, 14523004, 13440516
16794241, 13499412, 13035360, 14062795, 13040943, 13843646, 12905053
18173592, 16794243, 13477790, 14841409, 14609690, 13059165, 14062797
12959852, 12345082, 16703112, 13890080, 17333198, 16048375, 16450169
12658411, 13780035, 14062793, 13038684, 18740215, 16742095, 13742464
13066936, 14052474, 13060271, 13911821, 13457582, 7509451, 13791364
12821418, 13502183, 13705338, 14237793, 16794239, 13554409, 15862024
13645917, 13103913, 12772404
--------------------------------------------------------------------------------
OPatch succeeded.
如果你是已经存在的DB,让DB处于OPEN的状态,并跑脚本
Loading Modified SQL Files into the Database
The following steps load modified SQL files into the database. For a RAC environment, perform these steps on only one node.
-
For each database instance running on the Oracle home being patched, connect to the database using SQL*Plus. Connect as SYSDBA and run the
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
The
catbundle.sql
execution is reflected in the dba_registry_history view by a row associated with bundle seriesPSU
.For information about the
catbundle.sql
script, see My Oracle Support Document 605795.1 Introduction to Oracle Database catbundle.sql. -
Check the following log files in
$ORACLE_HOME/cfgtoollogs/catbundle
or$ORACLE_BASE/cfgtoollogs/catbundle
for any errors:catbundle_PSU_<database SID>_APPLY_<TIMESTAMP>.log catbundle_PSU_<database SID>_GENERATE_<TIMESTAMP>.log
where TIMESTAMP is of the form YYYYMMMDD_HH_MM_SS. If there are errors, refer to Section 5, "Known Issues".
[oracle@oradb ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 17-JUL-2014 23:12:08
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oradb)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 2: No such file or directory
[oracle@oradb ~]$ lsnrctl start
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 17-JUL-2014 23:12:15
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.3.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/oradb/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oradb)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oradb)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 17-JUL-2014 23:12:16
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/oradb/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oradb)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully
紧接着就DBCA(这部分省略,本采用定制数据库。故下面为验证库的补丁集情况)
SQL> select * from dba_registry_history;
ACTION_TIME
---------------------------------------------------------------------------
ACTION NAMESPACE
------------------------------ ------------------------------
VERSION ID BUNDLE_SERIES
------------------------------ ---------- ------------------------------
COMMENTS
--------------------------------------------------------------------------------
18-JUL-14 12.03.36.460908 AM
APPLY SERVER
11.2.0.3 11 PSU
PSU 11.2.0.3.11
</pre><pre code_snippet_id="429359" snippet_file_name="blog_20140718_12_6092869" name="code" class="sql">
<table id="kmPgTpl:sd_r1:0:dv_rDoc:0:tl5" cellpadding="0" cellspacing="0" border="0" width="100%" summary="" style="color: rgb(0, 61, 91); font-family: Simsun; font-size: 13.333333969116211px;"><tbody><tr id="kmPgTpl:sd_r1:0:dv_rDoc:0:rl12"><td id="kmPgTpl:sd_r1:0:dv_rDoc:0:cf49" align="left"><span id="kmPgTpl:sd_r1:0:dv_rDoc:0:ol22" class="xq" style="text-align: right; padding: 0px 6px 0px 0px;"><label><span style="color:#000000;">Relinking the DB Control 11.2.0.3 Agent Displays a Warning Message "overriding commands for target 'nmosudo'" (文档 ID 1562458.1)</span></label></span></td></tr></tbody></table>
[oracle@oradb ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 18-JUL-2014 00:26:12
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oradb)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 17-JUL-2014 23:12:16
Uptime 0 days 1 hr. 13 min. 56 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/oradb/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oradb)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@oradb ~]$