Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need java help to connect SQL Developer to an Oracle local single instance.

rjsosiSep 23 2019 — edited Sep 23 2019

Hi,

Not a java expert

Tried to connect to a local Oracle database in SQL Developer.

Got the following message:

"Status : Failure -Test failed: no ocijdbc18 in java.library.path"

I need to add the ocijdbc18.jar to my java path

The path is:

C:\Users\myself\Documents\instantclient_19_3

I  need to run this command

C:\JDBC\jre\bin\java -Djava.library.path=C:\Users\myself\Documents\instantclient_19_3 <main_class> 

So when I run what I think is the right command:

C:\JDBC\jre\bin\javap

I get a java usage error.

Usage: java [-options] class [args...]

           (to execute a class)

   or  java [-options] -jar jarfile [args...]

           (to execute a jar file)

where options include:

    -d32          use a 32-bit data model if available

    -d64          use a 64-bit data model if available

    -client       to select the "client" VM

    -server       to select the "server" VM

                  The default VM is client.

-

-

-

What's wrong with what I'm typing?

Comments
Post Details
Added on Sep 23 2019
14 comments
731 views