今天在给一个数据库从10.2.0.3 rac 升级到10.2.0.4 rac,最后升级数据字典,startup upgrade时报ORA-03113错误

[oracle@p520:/oracle/app/oracle/product/10.2.0/clusterdb/rdbms/admin]$sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Fri May 28 09:50:30 2010

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.rtu

Connected to an idle instance.

SQL> startup upgrade
ORACLE instance started.

Total System Global Area 1258291200 bytes
Fixed Size                  2083728 bytes
Variable Size             318768240 bytes
Database Buffers          922746880 bytes
Redo Buffers               14692352 bytes
Database mounted.
ORA-03113: end-of-file on communication channel

SQL> show parameter cluster

NAME                                 TYPE
------------------------------------ ----------------------
VALUE
------------------------------
cluster_database                     boolean
TRUE
cluster_database_instances           integer
2
cluster_interconnects                string

检查cluster_database参数,为true,修改为false即可

SQL> alter system set cluster_database=false scope=spfile;

System altered.

SQL> shutdown immediate
ORA-01507: database not mounted

ORACLE instance shut down.
SQL> startup nomount
ORACLE instance started.

Total System Global Area 1258291200 bytes
Fixed Size                  2083728 bytes
Variable Size             318768240 bytes
Database Buffers          922746880 bytes
Redo Buffers               14692352 bytes
SQL> show parameter cluster

NAME                                 TYPE
------------------------------------ ----------------------
VALUE
------------------------------
cluster_database                     boolean
FALSE
cluster_database_instances           integer
1
cluster_interconnects                string

SQL> shutdown immediate
ORA-01507: database not mounted

ORACLE instance shut down.
SQL> startup upgrade
ORACLE instance started.

Total System Global Area 1258291200 bytes
Fixed Size                  2083728 bytes
Variable Size             318768240 bytes
Database Buffers          922746880 bytes
Redo Buffers               14692352 bytes
Database mounted.
Database opened.
SQL>