Friday , November 22 2024

Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

ORA 03113 End Of File On Communication Channel On Startup

Buğra PARLAYAN February 13, 2022 ORACLE

In today’s article, we will talk about solving the ORA 03113 End Of File On Communication Channel On Startup error.

What should we do if we get ORA-03113 error when we close or open oracle db. After opening the database in mount mode, if we connect to sqlplus and increase the file target size, the problem is solved.

$ sqlplus / as sysdba

SQL> startup mount

$ sqlplus / as sysdba

SQL> startup mount

SQL>alter system set db_recovery_file_dest_size = 75G scope=both

1	SQL>alter system set db_recovery_file_dest_size = 75G scope=both

About Buğra PARLAYAN

Burgra Parlayan is an experienced Database and Weblogic Administrator. After completing his technical / relevant training he has got involved with a serious amount of projects. He successfully managed database upgrade, database migration, database performance tuning projects for various public institutions.Currently he has been employed by one of the leading financial institutions called Turkiye Hayat & Emeklilik as responsible administrator for Oracle Database and Oracle Middleware. He has been sharing his experience and knowledge by face to face training, personal blog and various social networking accounts to support the Oracle ecosystem continuously since 2010.

ORA 03113 End Of File On Communication Channel On Startup

About Buğra PARLAYAN

Leave a Reply Cancel reply