Oracle 11g startup times The End Of The ORA-03113 communication channel File

Oracle 11g startup times The End Of The ORA-03113 communication channel file:

SQL> startup;

The oracle routine has been started.

....

....

The database has been loaded.

Ora-03113: End of the file for the communication channel

ID: 5851

Session ID 96 Serial Number: 3

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

Solution:

SQL> startup mount;

The oracle routine has been started.

SQL> shown parameter db_recovery;

Db_recovery_file_dest_size 3882 M

SQL> alter system set db_recovery_file_dest_size = 30G;

The system has been changed.

SQL> shutdown immediate;

SQL> startup;

The database has been loaded.

The database has been opened.

The database can be used normally.