当前位置:   article > 正文

ORA-03113:end-of-file on communication channel_error: ora-03113: end-of-file on communication cha

error: ora-03113: end-of-file on communication channel process id: 0 session

环境:oracle 11g 11.2.0.4 r2 RAC

ORALCE启动时报如下错误:

[oracle@racnode2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Fri Apr 30 22:58:07 2021

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup;
ORACLE instance started.

Total System Global Area  835104768 bytes
Fixed Size            2217952 bytes
Variable Size          675285024 bytes
Database Buffers      150994944 bytes
Redo Buffers            6606848 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 10991
Session ID: 7 Serial number: 5

 

解决思路(ORACLE 11g):

查看orcle启动日志,确定具体是什么原因引起的错误。

1、查看orcle启动日志,确定具体是什么原因引起的错误。

cd $ORACLE_HOME/diag/rdbms/实例名/实例名/trace/

查看日志位置

  1. [root@racnode2 /]# locate trace|grep 'racdb'|more
  2. /u01/app/oracle/diag/rdbms/racdb/racdb2/trace
  3. /u01/app/oracle/diag/rdbms/racdb/racdb2/trace/alert_racdb2.log

 ls -alcr | grep alert (c时间排序、r倒序) 定位启动日志。

  1. [root@racnode2 ~]# cd /u01/app/oracle/diag/rdbms/racdb/racdb2/trace
  2. [root@racnode2 trace]# ls -alcr | grep alert
  3. -rw-r----- 1 oracle asmadmin 78259096 04-30 22:59 alert_racdb2.log

2.tail -f -n 500 alert_ncdbemu.log

然后重启运行startup命令:得到oracle提示如下:

************************************************************************
************************************************************************
Errors in file /u01/app/oracle/diag/rdbms/racdb/racdb2/trace/racdb2_arc0_11801.trc:
ORA-19809: 超出了恢复文件数的限制
ORA-19804: 无法回收 42991616 字节磁盘空间 (从 139586437120 限制中)

Errors in file /u01/app/oracle/diag/rdbms/racdb/racdb2/trace/racdb2_arc1_11803.trc:
ORA-19809: 超出了恢复文件数的限制
ORA-19804: 无法回收 42991616 字节磁盘空间 (从 139586437120 限制中)

ARC0: Error 19809 Creating archive log file to '+FRA'
ARC1: Error 19809 Creating archive log file to '+FRA'
Errors in file /u01/app/oracle/diag/rdbms/racdb/racdb2/trace/racdb2_arc0_11801.trc:
ORA-16038: 日志 2 sequence# 2309 无法归档
ORA-19809: 超出了恢复文件数的限制
O

本文内容由网友自发贡献,转载请注明出处:https://www.wpsshop.cn/w/小小林熬夜学编程/article/detail/721787
推荐阅读
相关标签
  

闽ICP备14008679号