oracle 10.2.0.4 for aix

upgrade for aix升级步骤总的来说跟HPUX/Solaris等大相径庭，不过感觉在Upgrading a Release 10.2 Database时间上稍长于其他unix平台。

1、确认版本：
# su -root
# oslevel -r
5300-07

2、确认系统补丁安装情况：
# lslpp -l | grep -i xlc
xlC.aix50.rte 11.1.0.1 COMMITTED XL C/C++ Runtime for AIX 5.3
xlC.cpp 9.0.0.0 COMMITTED C for AIX Preprocessor
xlC.msg.en_US.cpp 9.0.0.0 COMMITTED C for AIX Preprocessor
xlC.msg.en_US.rte 11.1.0.1 COMMITTED XL C/C++ Runtime
xlC.rte 11.1.0.1 COMMITTED XL C/C++ Runtime

3、将oracle补丁文件(p6810189_10204_AIX64-5L.zip)以oracle登陆ftp，并传至服务器，解压缩：
$ su - oracle
$ unzip p6810189_10204_AIX64-5L.zip

4、停止所有oracle相关服务：
$ stop_db.sh
######################################################
# Stoping the Listener #
######################################################

LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 02-JUL-2010 10:59:03

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
The command completed successfully

######################################################
# Stoping the Instance #
######################################################

SQL*Plus: Release 10.2.0.4.0 - Production on Fri Jul 2 13:52:44 2010

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

SQL> Connected.
SQL> Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

5、清除不再使用的内存资源
# /usr/sbin/slibclean

6、安装oracle10g补丁：
$ su - oracle
$ cd Disk1
$ ./runInstaller

....安装过程结束后执行root.sh....

7、开始Pre-Upgrade数据库：
$sqlplus / as sysdba
SQL> STARTUP UPGRADE
SQL> @?/rdbms/admin/utlu102i.sql

Oracle Database 10.2 Upgrade Information Utility 02-04-2008 11:48:11
.
**********************************************************************
Database:
**********************************************************************
--> name: X102040
--> version: 10.2.0.1.0
--> compatible: 10.2.0.1
--> blocksize: 8192
.
**********************************************************************
Tablespaces: [make adjustments in the current environment]
**********************************************************************
--> SYSTEM tablespace is adequate for the upgrade.
.... minimum required size: 505 MB
.... AUTOEXTEND additional space required: 15 MB
--> UNDOTBS1 tablespace is adequate for the upgrade.
.... minimum required size: 401 MB
.... AUTOEXTEND additional space required: 376 MB
--> SYSAUX tablespace is adequate for the upgrade.
.... minimum required size: 265 MB
.... AUTOEXTEND additional space required: 15 MB
--> TEMP tablespace is adequate for the upgrade.
.... minimum required size: 58 MB
.... AUTOEXTEND additional space required: 38 MB
--> EXAMPLE tablespace is adequate for the upgrade.
.... minimum required size: 69 MB
.
**********************************************************************
Update Parameters: [Update Oracle Database 10.2 init.ora or spfile]
**********************************************************************
WARNING: --> "shared_pool_size" needs to be increased to at least 167772160
WARNING: --> "java_pool_size" needs to be increased to at least 67108864
.
**********************************************************************
Components: [The following database components will be upgraded orinstalled]
**********************************************************************
--> Oracle Catalog Views [upgrade] VALID
--> Oracle Packages and Types [upgrade] VALID
--> JServer JAVA Virtual Machine [upgrade] VALID
--> Oracle XDK for Java [upgrade] VALID
--> Oracle Java Packages [upgrade] VALID
--> Oracle Text [upgrade] VALID
--> Oracle XML Database [upgrade] VALID
--> Oracle Workspace Manager [upgrade] VALID
--> Oracle Data Mining [upgrade] VALID
--> Messaging Gateway [upgrade] VALID
--> OLAP Analytic Workspace [upgrade] VALID
--> OLAP Catalog [upgrade] VALID
--> Oracle OLAP API [upgrade] VALID
--> Oracle interMedia [upgrade] VALID
--> Spatial [upgrade] VALID
--> Oracle Ultra Search [upgrade] VALID
--> Oracle Label Security [upgrade] VALID
--> Expression Filter [upgrade] VALID
--> EM Repository [upgrade] VALID
--> Rule Manager [upgrade] VALID
PL/SQL procedure successfully completed.

....根据提示调整表空间或内存参数....

eg.alter system set shared_pool_size =150M scope=spfile;

8、开始Upgrade数据库：
SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP UPGRADE
SQL> @?/rdbms/admin/catupgrd.sql

....时间稍长...

TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UPGRD_END 2010-07-02 13:43:01
.
Oracle Database 10.2 Upgrade Status Utility 07-02-2010 13:43:01
.
Component Status Version HH:MM:SS
Oracle Database Server VALID 10.2.0.4.0 00:48:20
JServer JAVA Virtual Machine VALID 10.2.0.4.0 00:18:43
Oracle XDK VALID 10.2.0.4.0 00:03:07
Oracle Database Java Packages VALID 10.2.0.4.0 00:02:36
Oracle Text VALID 10.2.0.4.0 00:01:44
Oracle XML Database VALID 10.2.0.4.0 00:11:03
Oracle Workspace Manager VALID 10.2.0.4.3 00:03:12
Oracle Data Mining VALID 10.2.0.4.0 00:01:39
OLAP Analytic Workspace VALID 10.2.0.4.0 00:01:41
OLAP Catalog VALID 10.2.0.4.0 00:04:23
Oracle OLAP API VALID 10.2.0.4.0 00:03:51
Oracle interMedia VALID 10.2.0.4.0 00:23:47
Spatial VALID 10.2.0.4.0 00:08:33
Oracle Expression Filter VALID 10.2.0.4.0 00:00:57
Oracle Enterprise Manager VALID 10.2.0.4.0 00:06:59
Oracle Rule Manager VALID 10.2.0.4.0 00:00:47
.
Total Upgrade Time: 02:21:32

....升级完成....

...改回内存参数配置...