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

Getting error while starting a database.

SQL> startup;
ORACLE instance started.

Total System Global Area 1.0055E+10 bytes
Fixed Size                  2237008 bytes
Variable Size            3992980912 bytes
Database Buffers         6039797760 bytes
Redo Buffers               19767296 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 24621
Session ID: 1345 Serial number: 3

Check the alert log.

Alert log path is ( Ex alert log -: alert_cgemimo.log)

SQL>  show parameter background

NAME                                                      TYPE        VALUE
------------------------------------                   -----------   ------------------------------
background_core_dump                 string      partial
background_dump_dest                 string      /oracle/app/oracle/diag/rdbms/PROD/PROD/trace




If it shows something like below

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


Then it means  db_recovery_file_dest_size id full.




 
There is three ways to solve this issue...........:)

1. One solution is log as rman and delete archive logs.

$rman target /
RMAN> delete archivelog all;



2. If the oracle is not available then

start the database as nomount.

SQL> startup nomount;




Get the db_recovery_file_dest_size
 
SQL> show parameter recovery_file_dest;

NAME                                                      TYPE                     VALUE
------------------------------------                  -----------                  ------------------------------
db_recovery_file_dest                       string                   /var/app/oracle/fast_recovery_area
db_recovery_file_dest_size              big integer        20G


 Increase the  DB_RECOVERY_FILE_DEST_SIZE

SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 25G SCOPE=BOTH;


Shutdown the database

SQL> shutdown immediate;

Then startup and it all will be fine.




3. If nothing success then delete manually from the db_recovery_file_dest

Log to the database as nomount (mentioned above) and find the db_recovery_file_dest



SQL> show parameter db_recovery_file_dest ;

NAME                                                  TYPE                 VALUE
------------------------------------               -----------             ------------------------------
db_recovery_file_dest                   string                  /var/app/oracle/fast_recovery_ area
db_recovery_file_dest_size         big integer         25G



Go to the above mentioned location and delete unwanted files.