Java – sqlexception: Protocol conflict in Oracle

I received a "breach of agreement"

Oracle version used: jdbc driver used by Oracle 11g R2 (11.2.0.3.0): 12.1 Java used by 0.1: jdk1 7.0. 65 32 bits

I have encountered many forums, in which this error was pointed out as a driver problem, but the Oracle version used in all those forums is higher and the driver version is older, and changing the driver solves the problem But in my case, the Oracle version is lower, but the driver version is higher Therefore, in this case, a higher version of the driver may be a problem?

In addition, this protocol violation will also occur when the maximum number of connections on the DB is reached?

Error message:

Solution

Such an error indicates an error in the JDBC thin driver, which cannot understand what the server returns on the line (socket)

You can always try to use the latest JDBC thin driver, hoping to resolve this error As of today, the latest is 12.1 0.2.

If this does not help, you need to contact Oracle support The first thing you will be asked to provide is an sqlnet trace of the connection where this error occurred This will help Oracle engineers understand what happens on the network when a failure occurs

To open the sqlnet trace, edit sqlnet.net on the server Ora file and add

TRACE_ LEVEL_ SERVER = 16

This adds a trace file for each connection in the trace controller (on the server) Do not perform this operation on the production system, as it will greatly slow down the system and produce a lot of traces

Good luck