11.2.0.3.0单机PSU到11.2.0.3.11

         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]$ ls13343438  13923374  14727310  16619892  17540582  18522512     README.html13696216  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.6Copyright (c) 2013, Oracle Corporation.  All rights reserved.PREREQ sessionOracle Home       : /u01/app/oracle/product/11.2.0/dbhome_1Central Inventory : /u01/app/oraInventory   from           : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.locOPatch version    : 11.2.0.3.6OUI version       : 11.2.0.3.0Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2014-07-17_21-51-23PM_1.logInvoking 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 applyOracle Interim Patch Installer version 11.2.0.3.6Copyright (c) 2013, Oracle Corporation.  All rights reserved.Oracle Home       : /u01/app/oracle/product/11.2.0/dbhome_1Central Inventory : /u01/app/oraInventory   from           : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.locOPatch version    : 11.2.0.3.6OUI version       : 11.2.0.3.0Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2014-07-17_21-51-57PM_1.logVerifying 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/tnslsnrPrerequisite check "CheckActiveFilesAndExecutables" failed.The details are:Following executables are active :/u01/app/oracle/product/11.2.0/dbhome_1/lib/libclntsh.so.11.1UtilSession 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.logOPatch failed with error code 73

这个时候看到

Following executables are active :/u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnrPrerequisite check "CheckActiveFilesAndExecutables" failed.The details are:

解决方法：

[oracle@oradb 18522512]$ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 17-JUL-2014 22:28:44Copyright (c) 1991, 2011, Oracle.  All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oradb)(PORT=1521)))STATUS of the LISTENER------------------------Alias                     LISTENERVersion                   TNSLSNR for Linux: Version 11.2.0.3.0 - ProductionStart Date                17-JUL-2014 19:48:37Uptime                    0 days 2 hr. 40 min. 8 secTrace Level               offSecurity                  ON: Local OS AuthenticationSNMP                      OFFListener Parameter File   /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.oraListener Log File         /u01/app/oracle/diag/tnslsnr/oradb/listener/alert/log.xmlListening Endpoints Summary...  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oradb)(PORT=1521)))  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))The listener supports no servicesThe command completed successfully[oracle@oradb 18522512]$ lsnrctl stopLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 17-JUL-2014 22:28:48Copyright (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 applyOracle Interim Patch Installer version 11.2.0.3.6Copyright (c) 2013, Oracle Corporation.  All rights reserved.Oracle Home       : /u01/app/oracle/product/11.2.0/dbhome_1Central Inventory : /u01/app/oraInventory   from           : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.locOPatch version    : 11.2.0.3.6OUI version       : 11.2.0.3.0Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2014-07-17_22-28-53PM_1.logVerifying 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]yUser Responded with: YAll checks passed.Provide your email address to be informed of security issues, install andinitiate Oracle Configuration Manager. Easier for you if you use your MyOracle 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]:  yPlease 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]yUser Responded with: YBacking 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.logOPatch 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

This warning is independent of the version of opatch used. 

Targets are defined more than once within the makefiles and this is just a warning that the second (later) definition is being used:

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'

If you check the $OH/install/make.log you will see that these warnings existed before patching i.e. after the original installation.  This is not an issue which the patch you are applying has introduced, simply a warning which opatch has correctly captured and is reporting back to the user.

SOLUTION

This is a warning only which opatch is reporting.  The Patch has applied successfully and the warning output can be safely ignored.

二、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

Relinking the DB Control 11.2.0.3 Agent Displays a Warning Message "overriding commands for target 'nmosudo'" (文档 ID 1562458.1)

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:

$ make -f ins_emagent.mk e2eme

 

Note: OPatch recognizes the messages as warning and successfully applies the PSU

 

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 lsinventoryOracle Interim Patch Installer version 11.2.0.3.6Copyright (c) 2013, Oracle Corporation.  All rights reserved.Oracle Home       : /u01/app/oracle/product/11.2.0/dbhome_1Central Inventory : /u01/app/oraInventory   from           : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.locOPatch version    : 11.2.0.3.6OUI version       : 11.2.0.3.0Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2014-07-17_23-09-53PM_1.logLsinventory 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.0There are 1 product(s) installed in this Oracle Home.Interim patches (1) :Patch  18522512     : applied on Thu Jul 17 22:33:51 CST 2014Unique Patch ID:  17629436Patch description:  "Database Patch Set Update : 11.2.0.3.11 (18522512)"   Created on 11 Jun 2014, 05:48:32 hrs PST8PDTSub-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的状态，并跑脚本
Relinking the DB Control 11.2.0.3 Agent Displays a Warning Message "overriding commands for target 'nmosudo'" (文档 ID 1562458.1)

 Loading Modified SQL Files into the Database

Relinking the DB Control 11.2.0.3 Agent Displays a Warning Message "overriding commands for target 'nmosudo'" (文档 ID 1562458.1)

The following steps load modified SQL files into the database. For a RAC environment, perform these steps on only one node.

1. 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/adminsqlplus /nologSQL> CONNECT / AS SYSDBASQL> STARTUPSQL> @catbundle.sql psu applySQL> QUIT

   The catbundle.sql execution is reflected in the dba_registry_history view by a row associated with bundle series PSU.

   For information about the catbundle.sql script, see My Oracle Support Document 605795.1 Introduction to Oracle Database catbundle.sql.

2. Check the following log files in $ORACLE_HOME/cfgtoollogs/catbundle or $ORACLE_BASE/cfgtoollogs/catbundle for any errors:

   catbundle_PSU_<database SID>_APPLY_<TIMESTAMP>.logcatbundle_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".

而我的工作是单机并没有安装DB，那么接下来的工作就是开启监听并创建数据库了。

[oracle@oradb ~]$ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 17-JUL-2014 23:12:08Copyright (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 refusedConnecting 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 startLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 17-JUL-2014 23:12:15Copyright (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 - ProductionSystem parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.oraLog messages written to /u01/app/oracle/diag/tnslsnr/oradb/listener/alert/log.xmlListening 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                     LISTENERVersion                   TNSLSNR for Linux: Version 11.2.0.3.0 - ProductionStart Date                17-JUL-2014 23:12:16Uptime                    0 days 0 hr. 0 min. 0 secTrace Level               offSecurity                  ON: Local OS AuthenticationSNMP                      OFFListener Parameter File   /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.oraListener Log File         /u01/app/oracle/diag/tnslsnr/oradb/listener/alert/log.xmlListening Endpoints Summary...  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oradb)(PORT=1521)))  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))The listener supports no servicesThe 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 AMAPPLY       SERVER11.2.0.3       11 PSUPSU 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 statusLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 18-JUL-2014 00:26:12Copyright (c) 1991, 2011, Oracle.  All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oradb)(PORT=1521)))STATUS of the LISTENER------------------------Alias                     LISTENERVersion                   TNSLSNR for Linux: Version 11.2.0.3.0 - ProductionStart Date                17-JUL-2014 23:12:16Uptime                    0 days 1 hr. 13 min. 56 secTrace Level               offSecurity                  ON: Local OS AuthenticationSNMP                      OFFListener Parameter File   /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.oraListener Log File         /u01/app/oracle/diag/tnslsnr/oradb/listener/alert/log.xmlListening 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 ~]$