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

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

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?

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

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

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.

Ran into this error with Oracle SQL Developer and the fix for us was to in Oracle SQL Developer:

• Tools -> Preferences
• In the tree view on the left Expand Database and select Advanced
• In Use Oracle Client click Configure...
• Set the path to your Oracle home (should looks something like C:\Path\To\Oracle\19.n)
• Check the Use Oracle Client box
• In the Tnsnames Directory set it to the folder containing the tnsnames.ora file (should looks something like C:\Path\To\Oracle\19.n\network\admin)
• Click OK
• Relaunch Oracle SQL Developer