A bug in Oracle 11.2.0.1, client reported ORA-03113: End of file for communication channel

Half an hour ago, a project feedback application system partial function error, ORA-03113: The end of the file of the communication channel. It seems to be a common mistake.

Exception information: ORA-031132392298 serial Number: 46826

Check the archive log did not find an exception, check the Oracle log found corresponding ORA-03137 error, after reviewing the online data, belonging to Oracle Bug,god, unexpectedly concealed behind the ORA-03113.

Errors in file D:\app\administrator\diag\rdbms\fssc\fssc\trace\fssc_ora_3972.trc (incident=137360): ora-03137:TTC protocol Internal Error:[12333] [ $] [ -] [ About] [] [] [] []Wed Dec07 19:09:00 2016Sweep[Inc][137360]: completedwed Dec07 19:12:06 2016Errors in File D:\app\administrator\diag\rdbms\fssc\fssc\trace\fssc_ora_3468.trc (incident=137596):ora- 03137:TTC protocol Internal Error:[12333] [ $] [ -] [98] [] [] [] []Wed Dec07 19:12:07 2016Sweep[Inc][137596]: Completed

Workaround:

1. Upgrade Oracle to 11.2.0.3/4

2. Close hidden parameters: peering of bound variables

Sql> alter system set "_optim_peek_user_binds" = False;

After you set the hidden parameters, the problem disappears. We recommend that you update the Oracle patches later.

A bug in Oracle 11.2.0.1, client reported ORA-03113: End of file for communication channel