oracle 10.2.0.3 数据库升级到10.2.0.4 报ORA-03113错误解决方法
oracle 10.2.0.3 数据库升级到10.2.0.4 报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>