Client Certification for Oracle Database 12.1.0.2/12.2.0.1

I’ve received a question about client certification for Oracle Database 12.2.0.1 the other day.
And this reminded me on this very helpful MOS Note:

It spans the client interoperability back to the Oracle 9.2 days and is a very helpful resource.

Client Certification Oracle Database

And don’t forget that sometimes client software may need a patch as well. A customer I exchange emails with on a regular basis just upgraded the Database server to Oracle Database 12.1.0.2 and saw several strange errors with the JDBC client despite the fact that they were already using the most recent JDBC client.

ORA-904, ORA-923 and ORA-920 were signaled together with:
oracle.jdbc.driver.OracleParameterMetaDataParser.computeBasicInfo(OracleParameterMetaDataParser.java:277)

It turned out that the JDBC client need some patch treatment with merge patch 21623553
on top of the 12.1.0.2. client. It got combined together with some other useful fixes into merge patch 24012252 for the JDBC client:

JDBC Patch for Bug# 24012252 for Generic Platform

Afterwards the errors were gone. For further JDBC client patch recommendations please see:

Furthermore don’t forget that there’s the Instant Client as well which is easy to deploy and downloadable from OTN:

Oracle Instant Client Download OTN

–Mike

2 thoughts on “Client Certification for Oracle Database 12.1.0.2/12.2.0.1

  1. And this bug with 12.1.0.2 client on Windows:

    The parameter StrLen_or_IndPtr of the API SQLBindParameter() returns length in characters instead of in bytes. As per specification, it should return length in bytes. This is described in the Bug 21616079

    See: Oracle ODBC Driver Truncates The Data Length of Output Parameter When Data Type is
    SQL_VARCHAR/SQL_WVARCHAR (Doc ID 2101352.1)

Leave a Reply

Your email address will not be published. Required fields are marked *