1. 安装11.2.0.2.0 software;
安装软件之前，需要先安装如下的包：
-- 对HP IA64平台，安装11.2之前，需要安装如下的操作os patch：
PHCO_40381
PHKL_38691
PHKL_38762
PHKL_38938
PHKL_39351
PHSS_36354
PHSS_37042
PHSS_37959
PHSS_38141
PHSS_39100
PHSS_39102
其中PHKL_39351单独是无法安装的，安装过程中提示需要安装如下
依赖相关的包：
-- PHKL_39351
Patch Dependencies：
11.31：PHKL_36142 PHKL_36699 PHKL_37465
PHKL_38691 PHKL_37650
但是安装上面的包时，又需要其他的包，hp真是BT，无奈之下我只能下载如下的zip包，
同时把所有依赖patch全部下载，然后安装该zip包，即可。
hpux_11.31_11180102.zip
-- 安装11.2.0.2以后，安装如下两个重要的one-off patch
Bug 10368698
Bug 10419629
2. 运行dbupgdiag.sql进行检查(或运行@ utlu112i.sql)
$ cd
$ sqlplus / as sysdba
sql> alter session set nls_language='American';
sql> @dbupgdiag.sql
sql> exit
该脚本需要从Mos上下载。（个人感觉运行两个脚本结合一起用比较好）
该脚本运行情况如下：
SQL> @ dbupgdiag.sql
Enter location for Spooled output：
19_Nov_2011_0837 .log
DMSBHMC_
SP2-0606：Cannot create SPOOL file "0/db_upg_diag_DMSBHMC_19_Nov_2011_0837.log"
*** Start of LogFile ***
Oracle Database Upgrade Diagnostic Utility 11-19-2011 20：37：11
===============
Hostname
===============
dmsdbp02
===============
Database Name
===============
DMSBHMC
===============
Database Uptime
===============
20：03 19-NOV-11
=================
Database Wordsize
=================
This is a 64-bit database
================
Software Version
================
Oracle Database 10g Release 10.2.0.4.0 - 64bit Production
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for HPUX：Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production
=============
Compatibility
=============
Compatibility is set as 10.2.0.3.0
================
Archive Log Mode
================
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /ora_arch/DMSBHMC/
Oldest online log sequence 38503
Next log sequence to archive 38505
Current log sequence 38505
================
Auditing Check
================
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string /ora_dump/DMSBHMC/adump/
audit_sys_operations boolean FALSE
audit_syslog_level string
audit_trail string NONE
===========================================
Tablespace and the owner of the aud$ table
===========================================
OWNER TABLESPACE_NAME
------------ ------------------------------
SYS SYSTEM
============================================================================
count of records in the sys.aud$ table where dbid is null- Standard Auditing
============================================================================
0
============================================================================================
count of records in the system.aud$ when dbid is null，Std Auditing with OLS or DV installed
============================================================================================
sele