Error Message

The following messages are logged in $ORACLE_HOME/startup.log.

/app/oracle/product/11.2.0/dbhome_1/bin/dbstart: Starting up database "ora11204"
Thu Jun 15 22:50:17 JST 2017


SQL*Plus: Release 11.2.0.4.0 Production on Thu Jun 15 22:50:19 2017

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

SQL> Connected to an idle instance.
SQL> ORA-03113: end-of-file on communication channel
SQL> Disconnected

/app/oracle/product/11.2.0/dbhome_1/bin/dbstart: Database instance "ora11204" warm started.

The issue occurs due to some unknown issue with the Oracle setup and the workaround mentioned below is available. Please contact Oracle Support to further diagnose the issue if the workaround cannot be applied.

 

WORKAROUND:
Create a shell script and copy the following lines into the file assuming that '/etc/init.d/dbora start' is being used for a post command. Then, run the script instead of the dbora command as a post command. Please make sure that an appropriate permission is set to the script.

#! /bin/shat now << EOF/etc/init.d/dbora startEOF

The startup of Oracle Database instance using post command which runs automatic startup script (dbstart) on Linux server fails with the error "ORA-03113: end-of-file on communication channel". When the issue occurs the database instance needs to be shut down with abort option before starting up the instance.

Please see your Oracle Database Administrator's Reference for more information on automating database startup and shutdown.
http://docs.oracle.com/database/121/UNXAR/strt_stp.htm#UNXAR150

This issue is seen only with the Oracle Version 11.2.0.3 or 11.2.0.4. Please be noted that the dbstart and dbshut scripts are deprecated in Oracle Database 11g Release 2 (11.2).
http://docs.oracle.com/cd/E11882_01/server.112/e10839/strt_stp.htm#UNXAR136