No Ocijdbc18 In Java Library Path Mac

Posted By admin  On 17.08.21

Last updated on AUGUST 04, 2020

Applies to:

Path

Contents Preface Audience lviii Documentation Accessibility lviii Related Documents lix Conventions lx Changes in This Release for Oracle Call Interface Programmer's Guide Changes in Oracle Database Release 18c Version 18.1 1 lxi OCI: Introduction 1.1 Overview of OCI 1-1 1.2 Building an OCI Application 1-3 1.3 Alternatives to OCI 1-3 1.4 SQL. Just for clarity for anyone else having this issue - I am using Oracle SQL Developer 19.2.1, and for me the Database:Advanced dialog asks for the path to the TNSnames file, which is my case was: C: Oracle Product 11.2.0 Client32 Network Admin After that I was able to select the right TNS entry in the connection dialog, and everything worked ok.

JDBC - Version 11.1.0.7 and later
Information in this document applies to any platform.

Symptoms

On a Solaris or Linux platform, a 11.2.0.3 JDBC OCI Driver client program is executed :

$ $ORACLE_HOME/jdk/bin/java -cp $ORACLE_HOME/jdbc/lib/ojdbc5.jar:. <JAVA_PROGRAM>
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
11.2.0.3.0
jdbc:oracle:oci:@//<HOSTNAME>:<PORT>/<SERVICE_NAME>

This Java program is accessing a 11.2.0.3 Oracle database server ( running on the same machine as the Java client program).

Depending on the LD_LIBRARY_PATH environment variable settings, the UnsatisfiedLinkError exception is thrown :

1. LD_LIBRARY_PATH=$ORACLE_HOME/lib

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
11.2.0.3.0
jdbc:oracle:oci:@//<HOSTNAME>:<PORT>/<SERVICE_NAME>
Mac

2. LD_LIBRARY_PATH=/instantclient_11_2/lib

Library

Changes

Cause

No ocijdbc18 in java library path machine

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.

SQL Developer


no ocijdbc12 in java.library.path

No Ocijdbc18 In Java Library Path Machine Learning



Related Links

No Ocijdbc18 In Java Library Path Machine

early adopter testing issues and other new release issues
30EA1: 'Connection' panel behavior on clicks of twisties and object names
Unable to download
sql server error 17836 at sql developer startup
30EA1 - Report Toolbar Disappears
EA1: 'About' dialog still shows 2.1.1.64
SQL Developer 3.0 and Scheduler
30EA1: SQL History performance
Excute Plan in Oracle SQL Develper
license issue
30EA1: Preferences: Use Tabulator
30EA1: 2nd instance of the sql developer delivers no query results
30EA1 SQL Worksheet background color (syntax colors)
30EA1 package bodies missing in schema browser still not fixed
SQL Developer 3.0 EA 1 advanced data type support in unit testing
Optimizing an SQL Query using Oracle SQL Developer