oracle 10.2.0.2升級到10.2.0.4

安裝步驟來源於官方的p6810189_10204_Linux-x86.zip的README.HTML,
由於裡面的步驟集合了RAC,ASM,single intance,
所以把single intance的安裝步驟抽取出來

1:升級時區包（這一步通常不需要，只是徵對有利用到
TIMESTAMP WITH LOCAL TIME ZONE (TSLTZ) , TIMESTAMP WITH TIME ZONE (TSTZ) 的資料型別和函式 TZ_OFFSET ）
安裝之前先檢視這個版本號，正常升級後這個版本值是4
SQL> select version from v$timezone_file;

VERSION
----------
2
下載包utltzpv4.zip，可以在google上找一下，在itpub.net裡有下載地址
直接@utltzpv4.sql;
2:關閉oracle相關的所有服務

$ emctl stop dbconsole
$ isqlplusctl stop
$ lsnrctl stop

$ sqlplus /NOLOG
SQL> CONNECT SYS AS SYSDBA
Enter password:SYS_password
SQL> SHUTDOWN IMMEDIATE
3:啟用vncserver
vncserver
4:用vncviewer登入資料庫所在的作業系統，開啟一個terminal
xhost +
cd patchset_directory/Disk1
./runInstaller
5:以root使用者執行root.sh檔案
6：手工升級 10.2 Database ,先檢視是升級前是否丟失相關元件

SQL> STARTUP UPGRADE
SQL> SPOOL upgrade_info.log
SQL> @?/rdbms/admin/utlu102i.sql
SQL> SPOOL OFF

7：新開一個terminal
su - oracle
$ lsnrctl start

8:在第6步的視窗裡繼續執行 (在startup upgrade狀態下執行)
SQL> SPOOL /oracle/patch.log
SQL> @?/rdbms/admin/catupgrd.sql
SQL> SPOOL OFF

9:檢視/oracle/patch.log日誌檔案，如果有出錯，檢查原因，並重新執行第9步
.
Oracle Database 10.2 Upgrade Status Utility 06-05-2009 15:03:25
.
Component Status Version HH:MM:SS
Oracle Database Server VALID 10.2.0.4.0 00:10:44
JServer JAVA Virtual Machine VALID 10.2.0.4.0 00:01:56
Oracle XDK VALID 10.2.0.4.0 00:00:40
Oracle Database Java Packages VALID 10.2.0.4.0 00:00:37
Oracle Text VALID 10.2.0.4.0 00:00:24
Oracle XML Database VALID 10.2.0.4.0 00:02:07
Oracle Workspace Manager VALID 10.2.0.4.3 00:00:58
Oracle Data Mining VALID 10.2.0.4.0 00:00:28
OLAP Analytic Workspace VALID 10.2.0.4.0 00:01:02
OLAP Catalog VALID 10.2.0.4.0 00:00:58
Oracle OLAP API VALID 10.2.0.4.0 00:01:02
Oracle interMedia VALID 10.2.0.4.0 00:03:56
Spatial VALID 10.2.0.4.0 00:02:28
Oracle Expression Filter VALID 10.2.0.4.0 00:00:14
Oracle Enterprise Manager VALID 10.2.0.4.0 00:01:47
Oracle Rule Manager INVALID 10.2.0.4.0 00:00:12

不知哪裡出了問題導致　Oracle Rule Manager INVALID ，由於這個功能沒有用到，先跳過了
10:重啟資料庫並對包和過程重新編譯

SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP
SQL> @?/rdbms/admin/utlrp.sql
11:檢視相關版本
SQL> column comp_name format a50;
SQL> column version format a10;
SQL> column status format a5;
SQL> select comp_name,version,status from sys.dba_registry;

COMP_NAME VERSION STATU
-------------------------------------------------- ---------- -----
Oracle Enterprise Manager 10.2.0.4.0 VALID
Spatial 10.2.0.4.0 VALID
Oracle interMedia 10.2.0.4.0 VALID
OLAP Catalog 10.2.0.4.0 VALID
Oracle XML Database 10.2.0.4.0 VALID
Oracle Text 10.2.0.4.0 VALID
Oracle Expression Filter 10.2.0.4.0 VALID
Oracle Rule Manager 10.2.0.4.0 VALID
Oracle Workspace Manager 10.2.0.4.3 VALID
Oracle Data Mining 10.2.0.4.0 VALID
Oracle Database Catalog Views 10.2.0.4.0 VALID
Oracle Database Packages and Types 10.2.0.4.0 VALID
JServer JAVA Virtual Machine 10.2.0.4.0 VALID
Oracle XDK 10.2.0.4.0 VALID
Oracle Database Java Packages 10.2.0.4.0 VALID
OLAP Analytic Workspace 10.2.0.4.0 VALID
Oracle OLAP API 10.2.0.4.0 VALID
12:升級 Enterprise Manager
emca -upgrade db

注意：Enterprise Manager的地址已經從http協議變成https協議了，和11g是一樣的。

13:執行許可權指令碼
$ cd $ORACLE_HOME/install
./changePerm.sh

[@more@]