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

If your SAP system “HANGS or DOWN” due to error message of “ORA-03113 : end-of-file on communication channel” then you should check the following steps to find figure out what is going on…

Our SAP system hangs yesterday and i have found the following error ;

As you can see SM21 log info ;

SQL error 3113 occurred (possible network problems?). Work process is stopped
Database error 3113 at CON
> ORA-03113: end-of-file on communication channel
Initialization DB-Connect Failed, Return Code 000256
Stop Workp. 5, PID 11644

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

Related WorkProcess log output ;

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

Executed ;

C:\>R3trans -x

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

TRANS.LOG output ;

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

Oracle DB ALERT.LOG

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

then i have found the following solution ;

—————————————————————————–

SOLUTION ;

Add following line to your SQLNET.ORA file

SQLNET.INBOUND_CONNECT_TIMEOUT = 0

—————————————————————————–

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

After this solution , i have tried “R3trans -x” and operation finished with SUCCESS , return code was “0000″

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

Restarting SAP system might be good idea after this fix and finally system has started without any error…

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

Leave a Reply


eight − 3 =

Blogroll