Setting up Database Connection in SQL Developer Fails with Error "Status : Failure - Test Failed: No Ocijdbc12 In Java.library.path"

(Doc ID 2419691.1)

Last updated on JULY 06, 2018

Applies to:

Oracle SQL Developer - Version 18.2 and later
Information in this document applies to any platform.

Symptoms

Environment
SQL Developer 18.2
Database 11.2.0.3.0
Windows 7

Problem
After upgrading SQL Developer from 4.2 to 18.2, receive the following error when trying to set up a database connection:

Status : Failure - Test Failed: no ocijdbc12 in java.library.path

Changes

Upgrade SQL Developer from 4.2 to 18.2.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms