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

Process ID: 12400
Session ID: 96 Serial number: 3

Solution:

1.Check your alert log file

One of the suggested action is to look in the alert.log file.  To find the location of alert.log, you do:

1. Find the location of diagnostic destination from the initialization parameter file (i.e., dbs/init<sid>.ora ).  For example, we have this entry:
• diagnostic_dest=/slot/fiz7865/log
• 
  
2. From there, you can find alert.log file in the following sub directory:
• <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace

In the alert_<sid>.log, we have found the following messages:

-rw-r----- 1 oracle oinstall 178164407 Jul 22 15:51 alert_app.log

[oracle@exilant trace]$ tail -200 alert_app.log

Output of alert log file:

Errors in file /opt/app/oracle/diag/rdbms/apple/apple/trace/apple_arc3_3238.trc:

ORA-19809: limit exceeded for recovery files

ORA-19804: cannot reclaim 18179072 bytes disk space from 4070572032 limit

ARC3: Error 19809 Creating archive log file to '/opt/app/oracle/flash_recovery_area/APPLE/archivelog/2013_03_10/o1_mf_1_615_%u_.arc'

Sun Mar 10 16:05:32 2013

Errors in file /opt/app/oracle/diag/rdbms/apple/apple/trace/apple_arc0_3201.trc:

ORA-19815: WARNING: db_recovery_file_dest_size of 4070572032 bytes is 100.00% used, and has 0 remaining bytes available.

************************************************************************

You have following choices to free up space from recovery area:

1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,

   then consider changing RMAN ARCHIVELOG DELETION POLICY.

2. Back up files to tertiary device such as tape using RMAN

   BACKUP RECOVERY AREA command.

3. Add disk space and increase db_recovery_file_dest_size parameter to

   reflect the new space.

4. Delete unnecessary files using RMAN DELETE command. If an operating

   system command was used to delete files, then use RMAN CROSSCHECK and

   DELETE EXPIRED commands.

************************************************************************

Errors in file /opt/app/oracle/diag/rdbms/apple/apple/trace/apple_arc0_3201.trc:

ORA-19809: limit exceeded for recovery files

ORA-19804: cannot reclaim 18179072 bytes disk space from 4070572032 limit

ARC0: Error 19809 Creating archive log file to '/opt/app/oracle/flash_recovery_area/APPLE/archivelog

2. Go to SQLPLUS

         SQL> startup                                         — Failed to startup, the same ORA-03113 Error

 SQL> startup nomount                          — ORACLE Instance Started

 SQL> alter database mount                   — Database altered

 SQL> exit

 $ rman target /

 RMAN> crosscheck archivelog all      — Here you will see all the names of archivelogs still exist

 RMAN> delete expired archivelog all

 RMAN> exit

 $ sqlplus / as sysdba

 SQL> alter database open                    — Database altered

$ ps -ef | grep pmon

oracle   12734     1  0 16:10 ?        00:00:00 ora_pmon_app

oracle   12880 12257  0 16:12 pts/5    00:00:00 grep pmon