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

Like • Show 0 Likes0
Comment • 6

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.

Russell Waliszewski

Apr 2, 2019 11:25 AM

Correct Answer

That should work as well. You should unzip that to the same directory name as we may be looking specifically for that name.

See the reply in context

No one else had this question

Outcomes

Russell Waliszewski

Mar 27, 2019 9:12 AM

There are some portions of our install of the application that use sqlplus to access the database. With a remote database installation we install a local sqlplus and the instant client for access. There are also some other shell scripts, after the product is installed, that currently use the instant client as well.

Actions

Markus Calmius @ Russell Waliszewski on Mar 27, 2019 9:36 AM

So what does that mean regarding the ojdbc-drivers?

Because if there are parts of the installation and other script that use ojdbc7.jar, we will have to tell the DBA we STILL cannot use the SQLNET.ENCRYPTION_SERVER=required setting....

Unless it is as simple as removing the old drivers and dropping in the ojdbc8.jar

Actions

Russell Waliszewski

@ Markus Calmius on Mar 27, 2019 7:00 PM

The problem is that instant client install is packaged from Oracle directly without the newer version of the drivers. While Oracle is typically forward compatible in this type of case I am not sure if they have it certified and would need to check on it. If you have a lower environment to test it on I think it would be apparent if there is a problem on the application server startup. I see you are using wildfly and we should use the client in that instance to get the database server time.

Actions

Markus Calmius @ Russell Waliszewski on Apr 1, 2019 5:10 AM

Sure. However, there is a later version of instant client/sqlplus (12.2) that includes ojdbc8 .

Later as in released 2 years ago

Can we use that instead?

Actions

Russell Waliszewski

@ Markus Calmius on Apr 2, 2019 11:25 AM

That should work as well. You should unzip that to the same directory name as we may be looking specifically for that name.

1 person found this helpful

Actions

Markus Calmius @ Russell Waliszewski on Apr 3, 2019 5:31 AM

Thanks for the info.

I will try that.

Actions

6 Replies

Russell Waliszewski Mar 27, 2019 9:12 AM
Mark Correct
Correct Answer
There are some portions of our install of the application that use sqlplus to access the database. With a remote database installation we install a local sqlplus and the instant client for access. There are also some other shell scripts, after the product is installed, that currently use the instant client as well.
Like • Show 0 Likes0
Actions
- Markus Calmius @ Russell Waliszewski on Mar 27, 2019 9:36 AM
  Mark Correct
  Correct Answer
  So what does that mean regarding the ojdbc-drivers?
  Because if there are parts of the installation and other script that use ojdbc7.jar, we will have to tell the DBA we STILL cannot use the SQLNET.ENCRYPTION_SERVER=required setting....
  Unless it is as simple as removing the old drivers and dropping in the ojdbc8.jar
  Like • Show 0 Likes0
  Actions
  - Russell Waliszewski @ Markus Calmius on Mar 27, 2019 7:00 PM
    Mark Correct
    Correct Answer
    The problem is that instant client install is packaged from Oracle directly without the newer version of the drivers. While Oracle is typically forward compatible in this type of case I am not sure if they have it certified and would need to check on it. If you have a lower environment to test it on I think it would be apparent if there is a problem on the application server startup. I see you are using wildfly and we should use the client in that instance to get the database server time.
    Like • Show 1 Like1
    Actions
    - Markus Calmius @ Russell Waliszewski on Apr 1, 2019 5:10 AM
      Mark Correct
      Correct Answer
      Sure. However, there is a later version of instant client/sqlplus (12.2) that includes ojdbc8 .
      Later as in released 2 years ago
      
      Can we use that instead?
      Like • Show 0 Likes0
      Actions
      - Russell Waliszewski @ Markus Calmius on Apr 2, 2019 11:25 AM
        Unmark Correct
        Correct Answer
        That should work as well. You should unzip that to the same directory name as we may be looking specifically for that name.
        1 person found this helpful
        Like • Show 0 Likes0
        Actions
        Markus Calmius @ Russell Waliszewski on Apr 3, 2019 5:31 AM
        Mark Correct
        Correct Answer
        Thanks for the info.
        I will try that.
        Like • Show 0 Likes0
        Actions