oracle-databaseoracle-sqldeveloper

Sql developer problem. No ocijdbc21 in java.library.path

I downloaded Oracle 19c DBMS. Then I downloaded Sql Developer. When I try to add a new connection, I get the message enter image description here

How do I get past this. I have seen some other threads on this but none of the solutions that I understand seem to fix it. I need to keep the connection type as local. Is there somewhere I can go and just adjust this path?

EDIT I used just a basic connection and the name database name in the service name box and it worked. The initial setup instructions I had were dated and not set up for 19c. One of the comments in the answer below suggested this.

Solution

  • For 20.4.1 and bequeath connection you must have a 21c instant client as we're using a 21c jdbc driver.

    If you're not on Linux, that means you'll need version 20.4.0 so you can use a 19c Instant Client.

    Windows 21c Clients should be available later this Summer.

    Edit/Update: Version 21.2.1 now supports 19c and 21c Clients. 21c Instant Clients are rolling out across supported platforms. Currently avail for Linux, soon to include Windows and OS X.