WebLogic ORA-03111 error handling process

ORA-03111 error, causing system failure

Symptom Description: The system reports a "java. SQL. SQLException: ORA-03111" error at runtime.

Problem Analysis:

Locate the fault code in metalink. Document No. [ID 1219453.1] is similar to the customer's fault information, "ORA-03111: break received on communication channel" is due to the configuration of linstener for the listener process on the database server. this is caused by the insufficient SDU settings of ora.

The basic meaning of the error is "the buffer is not large enough to send data ." For Oracle Net, this buffer zone is a Session Data Unit value (SDU ). in short, SDU is a buffer used to copy data to the Socket buffer and transmit data to the server inside the client.

ORA-3111 errors can generally be ignored because it won't cause more problems or Core dumps. To eliminate these errors, you only need to increase the configuration of SDU.

Solution:

Increase SDU.

The configuration listen. ora of the listener process of the Oracle database server is modified.

LISTENER. ORA:

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SDU = 16384) <-Setting SDU to 16384 for this SID

(TDU = 16384) <-8.0 TDU position

(SID_NAME = XXX)

(ORACLE_HOME = XXXX )))

The value range of SDU is 512 to 32768. The default value is 2048. We recommend that you change this value to 16384.

For SDU, see SQL * Net Packet Sizes (SDU & TDU Parameters) [ID 44694.1] In metalink.