或者去v$diag_info查询name=Diag Alert对应的路径去获取log.xml文件
Windows环境下的Oracle 11g在一次关机后，无法正常启动，且无法启动到mount状态，一直提示： ORA-03113: end-of-file on communication channel...=========================================================================== 实际问题解决记录：（无法启动到mount状态） ORA...ORA-03113: 通信通道的文件结尾 注释： 网络连接方式要经过Oracle数据库软件的SQL*NET层来间接访问数据库服务端，而本地连接方式不用经过该层直接访问数据库服务端。...444597672 bytes Database Buffers 327155712 bytes Redo Buffers 5259264 bytes ORA...SQL> alter database mount; alter database mount * 第 1 行出现错误: ORA-03113: 通信通道的文件结尾 进程 ID: 4112 会话 ID:
环境：RHEL6.4 + Oracle 11.2.0.4 步骤摘要： 1.启动报错ORA-03113 2.查看alert日志查找原因 3.根据实际情况采取合理的措施，这里我们先增加闪回区大小，把库启动起来...4.制定对应的归档日志删除策略 1.启动报错ORA-03113 $ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on 星期六...SQL> alter database open; alter database open * ERROR at line 1: ORA-03113: 通信通道的文件结尾 进程 ID: 13501 会话
提示ORA-03113:通信通道的文件结尾解决 ?
Oracle启动时报如下错误： ORA-03113: end-of-file on communication channel 解决方案如下： 1、查看orcle启动日志，确定具体是什么原因引起的错误。
insert into scott.dept values (36,'Oracle','Beijing') ORA-02068: following severe error from TESTORA9 ORA...-03113: end-of-file on communication channel ORA-02068: following severe error from TESTORA9 ORA-03113
diag/rdbms/xxxx/xxxx1/trace/xxxx1_asmb_7463.trc: ORA-15064: communication failure with ASM instance ORA...diag/rdbms/xxxx/xxxx1/trace/xxxx1_asmb_7463.trc: ORA-15064: communication failure with ASM instance ORA
因为之前归档文件满了，还报错：ORA-03113: end-of-file on communication channel，所以增加了闪回区大小，具体操作如下： [oracle@localhost ~
ORA-03113: end-of-file on communication channel Process ID: 2039 Session ID: 102 Serial number: 5 进一步查看...2126114 2126114 SQL> alter database open; alter database open * ERROR at line 1: ORA
diag/rdbms/****/****/trace/****_asmb_8258020.trc: ORA-15064: communication failure with ASM instance ORA...diag/rdbms/****/****/trace/****_asmb_8258020.trc: ORA-15064: communication failure with ASM instance ORA
select taskname from tasks where department in ("+myDepartments+") 这个时候就报错了，始终提示ora-03113的错误，然后确认后提示ora
Oracle启动失败startup - 闪回空间满 登录失败 sqlplus / as sysdb登录后： startup 失败，ORA-03113: end-of-file on communication
153 SQL> / COUNT(*) ---------- 153 SQL> / select count(*) from cat * ERROR at line 1: ORA
n1@TEST11G> commit; ERROR: ORA-03114: not connected to ORACLE commit * ERROR at line 1: ORA-03113: end-of-file...ERROR: ORA-03114: not connected to ORACLE alter system switch logfile * ERROR at line 1: ORA-03113: end-of-file
/rdbms/test/test2/trace/test2_asmb_31457440.trc: ORA-15064: communication failure with ASM instance ORA.../rdbms/test/test2/trace/test2_asmb_31457440.trc: ORA-15064: communication failure with ASM instance ORA
ORA-03113: end-of-file on communication channel Process ID: 8220 Session ID: 237 Serial number: 5 查看
u02/ora11g/oradata/TEST11G/redo03.log' 如果忽略这个错误，数据库还是无法正常open. alter database open * ERROR at line 1: ORA
领取专属 10元无门槛券
手把手带您无忧上云
云服务器
ICP备案
对象存储
实时音视频
即时通信 IM
