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

While startup the database getting error.

SQL> startup
ORACLE instance started.

Total System Global Area  209235968 bytes
Fixed Size                  1332188 bytes
Variable Size             125832228 bytes
Database Buffers           75497472 bytes
Redo Buffers                6574080 bytes
Database mounted.
Database opened.
SQL> select instance_name from v$instace;
select instance_name from v$instace
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 43880
Session ID: 170 Serial number: 5



Solution:


SQL> alter database recover database until cancel;

database altered


SQL> alter system set db_recovery_file_dest_size=8000m scope=both;

database altered


SQL> alter database open resetlogs;

database altered

ORA-19809: limit exceeded for recovery files tips

SQL> alter database open resetlogs;



ERROR at line 1
ORA-19809: Limit exceeded for recovery files
ORA-19804: cannot reclaim 52428800 bytes disk space from 10 limit




SQL> show parameter db_recovery



NAME                                            TYPE            VALUE
---------------------------------------------------------------------------------------------------------------------

db_recovery_file_dest                     string               /ora/oracle/oracle12/fast_recovery_file_dest_size
db_recovery_file_dest_Size             big integer         10


SQL> alter system set db_recovery_file_dest_size=8000m scope=both



SQL> alter database open resetlogs;

database altered.

12c Grid Infrastructure diskmon Will be Offline by Default in Non-Exadata Environment

As Grid Infrastructure daemon diskmon.bin is used for Exadata fencing, started from 11.2.0.3, resource ora.diskmon will be offline in non-Exadata environment. This is expected behaviour change.

$ crsctl stat res -t -init
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.asm
      1        ONLINE  ONLINE       pricedev1-lnx            Started             
ora.cluster_interconnect.haip
      1        ONLINE  ONLINE       pricedev1-lnx                                
ora.crf
      1        ONLINE  ONLINE       pricedev1-lnx                                
ora.crsd
      1        ONLINE  ONLINE       pricedev1-lnx                                
ora.cssd
      1        ONLINE  ONLINE       pricedev1-lnx                                
ora.cssdmonitor
      1        ONLINE  ONLINE       pricedev1-lnx                                
ora.ctssd
      1        ONLINE  ONLINE       pricedev1-lnx            OBSERVER            
ora.diskmon
      1        OFFLINE OFFLINE                                                   
ora.drivers.acfs
      1        ONLINE  ONLINE       pricedev1-lnx                                
ora.evmd
      1        ONLINE  ONLINE       pricedev1-lnx                                
ora.gipcd
      1        ONLINE  ONLINE       pricedev1-lnx                                
ora.gpnpd
      1        ONLINE  ONLINE       pricedev1-lnx                                
ora.mdnsd
      1        ONLINE  ONLINE       pricedev1-lnx  

Refer:
11.2.0.3 Grid Infrastructure diskmon Will be Offline by Default in Non-Exadata Environment (Doc ID 1346881.1)