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

Leave a Reply

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