upgrade oracle 10.2.0.4 for aix

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

[@more@]

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

....升級完成....

...改回記憶體引數配置...