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