CODEWITHSUNDEEP
oracle-databaseoracle-sqldeveloper
The_Redhawk
The_Redhawk

Reputation: 273

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.

Upvotes: 13

Views: 54972

Answers (4)

Rashid Qazizada
Rashid Qazizada

Reputation: 27

The easiest solution could be to ask a colleague for assistance and update the tnsnames.ora file with the required connection details. Sometimes, this file might get overwritten or emptied after certain modifications. In such cases, you can simply copy and paste the correct connection details back into the file, and it should work. After this, you should be able to see all the connections you added in the tnsnames.ora file listed under the 'TNS Network Alias'.

Upvotes: -1

dexl
dexl

Reputation: 51

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.

Upvotes: 5

Anketam
Anketam

Reputation: 228

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

Upvotes: 3

thatjeffsmith
thatjeffsmith

Reputation: 22412

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.

Upvotes: 5

Related Questions