When you are using one of the following Adapters – Database/Oracle Application/AQ, sometimes (randomly) you might get an error like:
“Exception occured when binding was invoked. Exception occured during invocation of JCA binding: “JCA Binding execute of Reference operation ‘GetData’ failed due to: Stored procedure invocation error. Error while trying to prepare and execute the BPEL_GETDATA.PROCEDURE$GET_ DATA API. An error occurred while preparing and executing the BPEL_GETDATA.PROCEDURE$GET_ DATA API. Cause: java.sql.SQLTimeoutException: ORA-03111: break received on communication channel Check to ensure that the API is defined in the database and that the parameters match the signature of the API. This exception is considered retriable, likely due to a communication failure. Because the global transaction is rolling back the invoke must be retried in a new transaction, restarting from the place of the last transaction commit. To classify it as non-retriable instead add property nonRetriableErrorCodes with value “1013” to your deployment descriptor (i.e. weblogic-ra.xml). “. The invoked JCA adapter raised a resource exception. Please examine the above error message carefully to determine a resolution.”
The root of the problem is in the SDU parameter within the listener.ora file on the DB (that the Adapter tries to connect to).
The SDU (session data unit) parameter instruct Oracle Net to optimize the transfer rate of data packets being sent across the network.
This error happens when the packet of data coming from the db is too large and the communication between the DB and the client server is not possible.
To resolve this problem, you have to increase the value of the SDU parameter.
Oracle recommends to increase it to 8192. After the change the listener must be restarted.