Monday, May 2, 2016

ORA-03113: end-of-file on communication channel error AT STARTUP UPGRADE

This error was encounter during upgrade of 11.2.0.1 to 11.2.0.4. this also apply to other startup options.

after change of oracle_home and path variables. 
"sqlplus > startup upgrade" thrown error ORA-03113

Solution====

set LD_LIBRARY_PATH and SHLIB_PATH to the new oracle home location for example:
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
export SHLIB_PATH=$SHLIB_PATH:$ORACLE_HOME/lib32

HTH