ORA-03113 end-of-file on communication channel 问题解决

目前遇到过两种情况 ，如下：

CASE 1:

SQL> startup force

ORACLE instance started.


Total System Global Area 2672361472 bytes
Fixed Size                  2256232 bytes
Variable Size            1392509592 bytes
Database Buffers         1258291200 bytes
Redo Buffers               19304448 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 6300
Session ID: 193 Serial number: 3

文档：

ORA-03113: end-of-file on communication channel

Cause: The connection between Client and Server process was broken.

Action: There was a communication error that requires further investigation.  

实际中多为TRACE 文件占空间太多。

解决如下：（非生产环境，所以把所有的TRACE文件都删除了）

SQL> startup nomount;
ORACLE instance started.


Total System Global Area 2672361472 bytes
Fixed Size                  2256232 bytes
Variable Size            1392509592 bytes
Database Buffers         1258291200 bytes
Redo Buffers               19304448 bytes
SQL> alter database mount;


Database altered.


SQL> exit

Recovery Manager: Release 11.2.0.4.0 - Production on Tue Mar 11 11:32:04 2014


Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.


connected to target database: AD_TEST (DBID=846030938, not open)


RMAN> delete archivelog all;


using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1

Do you really want to delete the above objects (enter YES or NO)? YES

RMAN> exit




Recovery Manager complete.
-bash-3.2$ sqlplus / as sysdba


SQL*Plus: Release 11.2.0.4.0 Production on Tue Mar 11 11:33:22 2014


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




Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


SQL> alter database open
  2  ;


Database altered.

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------

CASE2

SQL> startup
ORACLE instance started.


Total System Global Area 2672361472 bytes
Fixed Size                  2256232 bytes
Variable Size            1392509592 bytes
Database Buffers         1258291200 bytes
Redo Buffers               19304448 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 17653
Session ID: 193 Serial number: 3




SQL> create spfile from pfile;
ERROR:
ORA-03114: not connected to ORACLE




SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
-bash-3.2$ sqlplus / as sysdba


SQL*Plus: Release 11.2.0.4.0 Production on Mon Mar 24 15:50:42 2014


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


Connected to an idle instance.


SQL> create spfile from pfile;


File created.


SQL> startup
ORACLE instance started.


Total System Global Area 2672361472 bytes
Fixed Size                  2256232 bytes
Variable Size            1392509592 bytes
Database Buffers         1258291200 bytes
Redo Buffers               19304448 bytes
Database mounted.
ORA-38760: This database instance failed to turn on flashback database




SQL> alter database open
  2  ;
alter database open
*
ERROR at line 1:
ORA-38760: This database instance failed to turn on flashback database




SQL> alter database flashback off;


Database altered.


SQL> alter database open;


Database altered.