10.2.0.3 升級到 10.2.0.4 database upgrade 報ORA-03113錯誤解決方法

 今天在給一個資料庫從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>