oracle 10.2.0.3 数据库升级到10.2.0.4 报ORA-03113错误解决方法

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:422

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>

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】