Oracle Database 11.2.0.1.1 升级笔记

即在11.2.0.1.0版本的基础上安装PSU 11.2.0.1.1, 本 PSU(Patch Set Update)是基于11.2.0.1.0版本的第1个累计补丁集11.2.0.1.1(Bug 9352237), 共修正了94个bug, 且已经包含了截至到201004月份的CPU(Critical Patches Update).


1.1 安装新版OPatch

Oracle Database 11.2.0.1.0默认自带的OPatch版本是11.1.0.6.6, 而安装PSU 11.2.0.1.1必须使用OPatch 11.2.0.1.0或以上版本才行. 否则会有错误. 最新版本OPatch下载地址(选择版本为11.2.0.0.0):
http://updates.oracle.com/ARULink/PatchDetails/process_form?patch_num=6880880
安装过程大概 1-2分钟.

$ $ORACLE_HOME/OPatch/opatch version                    (检查当前OPatch版本)
Invoking OPatch 11.1.0.6.6
OPatch Version: 11.1.0.6.6
OPatch succeeded.

$ cd $ORACLE_HOME

$ tar zcvf OPatch_`date +%Y%m%d`.tar.gz OPatch                    (备份原有OPatch)

$ cd /u01/software/11g/

如果是x86 平台:

$ unzip p6880880_112000_LINUX.zip -d $ORACLE_HOME

如果是 x86_64平台:

$ unzip p6880880_112000_Linux-x86-64.zip -d $ORACLE_HOME

Archive:  p6880880_112000_Linux-x86-64.zip
replace /u01/app/oracle/product/11.2.0/db_1/OPatch/docs/FAQ? [y]es, [n]o, [A]ll, [N]one, [r]ename: A
...

$ $ORACLE_HOME/OPatch/opatch version                    (检查现有OPatch版本)
Invoking OPatch 11.2.0.1.2
OPatch Version: 11.2.0.1.2
OPatch succeeded.


1.2 停止Oracle相关进程

$ lsnrctl stop

$ emctl stop dbconsole

$ sqlplus /  as sysdba

SQL> shutdown immediate;


1.3 安装PSU

安装过程大概 3-5分钟.

$ cd /u01/software/11g/

如果是x86 平台:

$ unzip p9352237_112010_LINUX.zip

如果是 x86_64平台:

$ unzip p9352237_112010_Linux-x86-64.zip

$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./9352237

$ cd 9352237

$ $ORACLE_HOME/OPatch/opatch apply

...

Running prerequisite checks...

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: {Enter}

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

...

Is the local system ready for patching? [y|n]

y

...


1.4 安装后数据库操作(可选)

如果原先已建数据库则一定要做本步骤, 大概4-5分钟.

加载 modified.sql到数据库:

$ sqlplus /nolog

SQL> CONNECT / AS SYSDBA

SQL> STARTUP

SQL> @?/rdbms/admin/catbundle.sql psu apply

SQL> exit


1.5 验证安装结果

$ $ORACLE_HOME/OPatch/opatch lsinventory

Invoking OPatch 11.2.0.1.2
...
-------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 11g                                                  11.2.0.1.0
There are 1 products installed in this Oracle Home.
Interim patches (1) :
Patch  9352237      : applied on Fri May 28 14:24:59 CST 2010
Unique Patch ID:  12250325
Created on 25 Mar 2010, 00:05:17 hrs PST8PDT
Bugs fixed:
8661168, 8769239, 8898852, 8801119, 9054253, 8706590, 8725286, 8974548
8778277, 8780372, 8769569, 9027691, 9454036, 9454037, 9454038, 8761974
7705591, 8496830, 8702892, 8639114, 8723477, 8729793, 8919682, 8818983
9001453, 8475069, 9328668, 8891929, 8798317, 8820324, 8733749, 8702535
8565708, 9036013, 8735201, 8684517, 8870559, 8773383, 8933870, 8812705
8405205, 8822365, 8813366, 8761260, 8790767, 8795418, 8913269, 8897784
8760714, 8717461, 8671349, 8775569, 8898589, 8861700, 8607693, 8642202
8780281, 9369797, 8780711, 8784929, 8834636, 9015983, 8891037, 8828328
8570322, 8832205, 8665189, 8717031, 8685253, 8718952, 8799099, 8633358
9032717, 9321701, 8588519, 8783738, 8796511, 8782971, 8756598, 9454385
8856497, 8703064, 9066116, 9007102, 8721315, 8818175, 8674263, 9352237
8753903, 8720447, 9057443, 8790561, 8733225, 9197917, 8928276, 8991997, 8837736
--------------------------------------------------------------------------------
OPatch succeeded.


1.6 启动Oracle其它进程

$ lsnrctl start

$ emctl start dbconsole