oracle 10.2.0.5补丁,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

--> Orac