说明：这是新上线主机，还没有建库的。如果库已经存在，那么最后还要进行刷库操作！


环境：Red Hat Enterprise Linux 6.4 (x86_64)

将Oracle数据库从11.2.0.3.0升级到11.2.0.3.7 PSU（目前最新），补丁为：16619892(p16619892_112030_Linux-x86-64--DB--11.2.0.3.7.zip)


推荐阅读：Oracle数据库服务器升级内存需要考虑的问题 http://www.linuxidc.com/Linux/2013-05/83809.htm


一般要先把ORACLE相关服务先停止：

[oracle@redhat1 soft]$ lsnrctl stop


LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 28-APR-2016 14:54:14


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


Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

The command completed successfully

[oracle@redhat1 soft]$ sqlplus "/as sysdba"


SQL*Plus: Release 11.2.0.3.0 Production on Thu Apr 28 14:55:03 2016


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



Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options


SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options


用oracle用户登录下载并解压补丁包：

su - oracle
mkdir /u01/app/softs
cd /u01/app/softs

p16619892_112030_Linux-x86-64--DB--11.2.0.3.7.zip

http://pan.baidu.com/s/1hrlPuDm

p6880880_112000_Linux-x86-64.zip

http://pan.baidu.com/s/1skvapE9

把下载的文件放在FTP共享目录，再使用FTP下载补丁文件：

ftp ftpserver
ftp> bin
//转换为二进制模式
ftp> get p16619892_112030_Linux-x86-64--DB--11.2.0.3.7.zip
//下载补丁文件
ftp> get p6880880_112000_Linux-x86-64.zip
//下载OPatch的补丁
unzip p16619892_112030_Linux-x86-64--DB--11.2.0.3.7.zip 
ls

16619892  p16619892_112030_Linux-x86-64--DB--11.2.0.3.7.zip

cd 16619892/
ls

13343438  13696216  13923374  14275605  14727310  16056266  16619892  patchmd.xml  README.html  README.txt


这个PSU对OPatch有要求，要用11.2.0.3.0之后版本的OPatch，这个OPatch的补丁号为6880880(p6880880_112000_Linux-x86-64.zip)。上面已经下载，现在直接解压并替换OPatch目录

cp p6880880_112000_Linux-x86-64.zip $ORACLE_HOME
cd $ORACLE_HOME
mv OPatch OPatch_bak
//备份OPatch目录
unzip p6880880_112000_Linux-x86-64.zip
cd /u01/app/softs/16619892/
/u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch version

OPatch Version: 11.2.0.3.3

OPatch succeeded.

补丁冲突检查：

/u01/app/oracle/product/11.2.0/dbhome_1/OPatch/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.3

OUI version      : 11.2.0.3.0

Log file location : /opt/oracle/product/11gR2/db/cfgtoollogs/opatch/opatch2013-08-20_04-52-55AM_1.log



Invoking prereq "checkconflictagainstohwithdetail"



Prereq "checkConflictAgainstOHWithDetail" passed.



OPatch succeeded.



没有补丁冲突。


安装补丁：

/u01/app/oracle/product/11.2.0/dbhome_1/OPatch/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/cfgtoollogs/opatch/opatch2013-08-20_04-53-08AM_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


 



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 '13343438' 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 '13696216' 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 '13923374' 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 '14275605' 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 '14727310' 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 '16056266' 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 '16619892' 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/cfgtoollogs/opatch/opatch2013-08-20_04-53-08AM_1.log



OPatch completed with warnings.

进行补丁升级检查

/u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch lsinventory


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/cfgtoollogs/opatch/opatch2013-08-20_04-58-27AM_1.log


Lsinventory Output file location : /opt/oracle/product/11gR2/db/cfgtoollogs/opatch/lsinv/lsinventory2013-08-20_04-58-27AM.txt


--------------------------------------------------------------------------------

Installed Top-level Products (1):



Oracle Database 11g                                                  11.2.0.3.0

There are 1 products installed in this Oracle Home.


Interim patches (1) :



Patch  16619892    : applied on Tue Aug 20 04:56:34 CST 2013

Unique Patch ID:  16346737

Patch description:  "Database Patch Set Update : 11.2.0.3.7 (16619892)"

  Created on 23 Jun 2013, 09:03:20 hrs PST8PDT

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, 13566938, 10350832, 14138130, 12919564, 13561951, 13624984

    13588248, 13080778, 13914613, 13804294, 14258925, 12873183, 13645875

    14472647, 12880299, 14664355, 12998795, 14409183, 13719081, 14469008

    13492735, 14263036, 12857027, 13496884, 13015379, 14263073, 13742433

    13732226, 16314469, 16368108, 12905058, 6690853, 13742434, 12849688

    12950644, 13742435, 13464002, 13063120, 13534412, 12879027, 13958038

    14613900, 12585543, 13790109, 12535346, 16382448, 12588744, 11877623

    12395918, 13814739, 13786142, 12847466, 13649031, 13855490, 13981051

    12582664, 12797765, 14262913, 12923168, 16279401, 12912137, 13612575

    13384182, 13466801, 13484963, 14207163, 13724193, 13772618, 11063191

    16694777, 13070939, 12797420, 15869211, 13041324, 16279211, 16314467

    16314468, 12976376, 11708510, 13680405, 13742437, 13026410, 14589750

    13737746, 13742438, 14644185, 15841373, 13326736, 13596521, 14398795

    1357×××, 13001379, 16344871, 13099577, 9873405, 13742436, 14275605

    9858539, 14841812, 11715084, 16231699, 14040433, 9703627, 12662040

    12617123, 16530565, 14207317, 12845115, 12764337, 13354082, 14459552

    13397104, 13913630, 12964067, 12983611, 13550185, 12780983, 13810393

    12583611, 14546575, 15862016, 13476583, 13489024, 11840910, 13903046

    15862017, 13572659, 16294378, 13718279, 14088346, 13657605, 13448206

    16314466, 14480676, 13419660, 13632717, 14668670, 14063281, 14110275

    13430938, 13467683, 13420224, 13812031, 14548763, 16299830, 12646784

    14512189, 12755116, 14035825, 13616375, 13427062, 12861463, 12834027

    15862021, 13632809, 13377816, 13036331, 14727310, 16619892, 13685544

    13499128, 15862018, 13584130, 16175381, 12829021, 15862019, 12794305

    14546673, 12791981, 13561750, 13503598, 13787482, 10133521, 12718090

    13848402, 13399435, 14023636, 9095696, 13860201, 12401111, 13257247

    13362079, 14176879, 12917230, 16014985, 13923374, 14220725, 13524899

    14480675, 16306019, 13559697, 12974860, 9706792, 12940620, 14480674

    13916709, 13098318, 14076523, 13773133, 15905421, 16794244, 13340388

    12731940, 13528551, 13366202, 12894807, 13343438, 13454210, 12748240

    14205448, 13385346, 14127231, 15853081, 14273397, 14467061, 12971775

    13923995, 14571027, 13582702, 13907462, 10242202, 13493847, 13857111

    13035804, 13544396, 16382353, 8547978, 14226599, 16794241, 14062795

    13035360, 12925089, 12693626, 13332439, 14038787, 11071989, 14062796

    16794243, 12913474, 14841409, 14390252, 16314470, 13370330, 13059165

    14062797, 14062794, 12959852, 12345082, 13358781, 12960925, 16703112

    9659614, 14546638, 13699124, 13936424, 14301592, 16794240, 13338048

    12938841, 12658411, 12620823, 12656535, 14062793, 12678920, 13038684

    14062792, 13807411, 16742095, 16794238, 15862022, 12594032, 13250244

    12612118, 9761357, 14053457, 13742464, 14052474, 13911821, 13457582

    7509451, 13527323, 13791364, 15862020, 13910420, 12780098, 13502183

    13696216, 13705338, 10263668, 14841558, 16794242, 15862023, 16056266

    16794239, 15862024, 13554409, 13645917, 13103913, 12772404, 13011409, 14063280


--------------------------------------------------------------------------------


OPatch succeeded.


转载下文，并根据实际操作略做更改

http://www.linuxidc.com/Linux/2013-08/89114.htm