Forum Stats

  • 3,770,398 Users
  • 2,253,103 Discussions
  • 7,875,439 Comments

Discussions

no ocijdbc11 in java.library.path

userLynx
userLynx Member Posts: 117
edited Jun 26, 2015 3:32PM in SQL Developer

I have Oracle Client 32 bit and Oracle Client 64 bit installed on my Win7 machine. 

Yesterday I was able to connect to my databases via SQL DEVELOPER  (4.0.3).   I had to reboot my machine this morning and now when I try and connect to my databases, I get the following error:

no ocijdbc11 in java.library.path

I have Win7

I have Oracle Client 32

I have Oracle Client 64  (I need both as I support legacy systems that still use 32 bit)

I have SQL developer 4.0.3

I have set Tools > Preferences > Database > Advances > TNS Names Directory to the 64-bit path and I have confirmed that the TNSNames.ora file is located in that Oracle Client\Network\Admin folder

I noticed that Tools > Preferences > Database > Third Party JDBC Drives list box is empty.  I tried to add an entry here to the Oracle\Client\JDBC\bin\ folder and I have ojdbc7 in there.   (not sure if this is needed as I use TNS to connect)

I don't know what else to do.  Can someone assist?

Tagged:

Answers

  • thatJeffSmith-Oracle
    thatJeffSmith-Oracle Distinguished Product Manager Posts: 8,089 Employee
    edited Jun 26, 2015 3:32PM

    you don't need a client to use tnsnames

    in advanced preferences, disable the use client/thick connections

    and then be sure your setting for tnsnames file directory points to the tnsnames you want to use

    restart sqldev, try your connection

This discussion has been closed.