AnsweredAssumed Answered

instantclient, when and how is it used?

Question asked by Markus Calmius on Mar 27, 2019
Latest reply on Apr 3, 2019 by Markus Calmius

Hello,

 

we just upgraded to 7.1.1 since we need an update to the ojdbc-driver[1]

After installing 7.1.1 I searched the /home/oracle-directory and found this:

-bash-4.1$ find . -name ojdbc?.jar

./database/lib/ojdbc8.jar

./instantclient_12_1/ojdbc7.jar

./instantclient_12_1/ojdbc6.jar

./deploy/oracle/ojdbc7.jar

./deploy/oracle/ojdbc8.jar

./wildfly-10.1.0.Final/modules/com/oracle/main/ojdbc8.jar

./wildfly-10.1.0.Final/standalone/tmp/vfs/deployment/deployment39d737eef94697ed/ojdbc8.jar-23e1826d171d4c64/ojdbc8.jar

 

Why doesn't the instantclient contain an updated driver? When is it used? 

Can we just remove ALL the old ojdbc-drivers and drop the ojdbc8-driver into the instantclient directory?

 

TIA

Markus

 

[1] Our DBA team want to have a more secure DB and changed a setting:

SQLNET.ENCRYPTION_SERVER from optional to required.

This is not supported (or a bug) in the ojdbc7-driver. It caused all kinds of weird errors. So the DBA-team had to down-grade the security setting again.

Outcomes