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

user_13066481 0
Viewed 14675

So 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.

oracle-sqldeveloper oracle
2 Answers

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.

user_11564520

In my case, the DB connection changed from Network Alias to Connect Identifier post a company pushed update, simple fix after hours /days of trouble shooting.

enter image description here

user_181302610
Related