SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 419430400 bytes

Fixed Size 1274068 bytes

Variable Size 331353900 bytes

Database Buffers 83886080 bytes

Redo Buffers 2916352 bytes

Database mounted.

Database opened.

4.4 编译无效对象

SQL> @ /rdbms/admin/utlrp.sql

4.5 改参数

SQL> show parameter cluster

NAME TYPE VALUE

------------------------------------ -----------------------------------------

cluster_database boolean FALSE

cluster_database_instances integer 1

cluster_interconnects string

SQL> alter system set cluster_database=truescope=spfile;

System altered.

4.6 重启数据库，升级完成

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 419430400 bytes

Fixed Size 1274068 bytes

Variable Size 331353900 bytes

Database Buffers 83886080 bytes

Redo Buffers 2916352 bytes

Database mounted.

Database opened.

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release10.2.0.5.0 - Prod

PL/SQL Release 10.2.0.5.0 - Production

CORE 10.2.0.5.0 Production

TNS for Linux: Version 10.2.0.5.0 - Production

NLSRTL Version 10.2.0.5.0 - Production