Oracle 10g(10.2.0.4)升级到10.2.0.5.19

一、将Oracle数据库版本从10.2.0.4 升级到 10.2.0.5，再升级到10.2.0.5.19

(1) 备份等过程略过，一个老库的升级过程，记录之。  
(2) 一致性关闭数据库及监听

sqlplus / as sysdba;  
shutdown immediate    
lsnrctl stop

二、升级数据库软件

1，解压p8202632_10205_Linux-x86-64.zip  
2，直接采用安装方式安装，覆盖原安装目录

xhost+  
su - oracle    
cd Disk1/    
./runInstaller

三、升级数据字典 1, 升级前检查

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

Oracle Database 10.2 Upgrade Information Utility    03-21-2016 10:27:05    
.    
**********************************************************************    
Database:    
**********************************************************************    
--> name:      ORCL    
--> version:    10.2.0.4.0    
--> compatible: 10.2.0.3.0    
--> blocksize:  8192    
.    
**********************************************************************    
Tablespaces: [make adjustments in the current environment]    
**********************************************************************    
--> SYSTEM tablespace is adequate for the upgrade.    
.... minimum required size: 488 MB    
.... AUTOEXTEND additional space required: 8 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: 259 MB    
.... AUTOEXTEND additional space required: 9 MB    
--> TEMP tablespace is adequate for the upgrade.    
.... minimum required size: 58 MB    
.... AUTOEXTEND additional space required: 38 MB    
.    
**********************************************************************    
Update Parameters: [Update Oracle Database 10.2 init.ora or spfile]    
**********************************************************************    
-- No update parameter changes are required.    
.    
**********************************************************************    
Renamed Parameters: [Update Oracle Database 10.2 init.ora or spfile]    
**********************************************************************    
-- No renamed parameters found. No changes are required.    
.    
**********************************************************************    
Obsolete/Deprecated Parameters: [Update Oracle Database 10.2 init.ora or spfile]    
**********************************************************************    
-- No obsolete parameters found. No changes are required    
.    
**********************************************************************    
Components: [The following database components will be upgraded or installed]    
**********************************************************************    
--> 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    
--> OLAP Analytic Workspace      [upgrade]  VALID    
--> OLAP Catalog                [upgrade]  VALID    
--> Oracle OLAP API              [upgrade]  VALID    
--> Oracle interMedia            [upgrade]  VALID    
--> Spatial                      [upgrade]  VALID    
--> Expression Filter            [upgrade]  VALID    
--> EM Repository                [upgrade]  VALID    
--> Rule Manager                [upgrade]  VALID

PL/SQL procedure successfully completed.

SQL> SPOOL OFF

2. 开始升级数据库字典（大概需要30分钟）

SQL> STARTUP UPGRADE  
SQL> SPOOL patch.log    
SQL> @?/rdbms/admin/catupgrd.sql    
SQL> SPOOL OFF

编译无译对象

SQL> SHUTDOWN IMMEDIATE  
SQL> STARTUP    
SQL> @?/rdbms/admin/utlrp.sql

SQL> SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;

升级后检查，升级成功。