There are a few things I am unable to do with DBeaver while connected to an Oracle instance.
Let us see if SQL Developer will get around the nook.
- Identify Artifact Source
- Available Artifacts
- Identify Artifact
- Download Artifact
- Install Artifact
- Launch Application
- Use Application
Identify Artifact Source
Oracle SQL Developer is available at https://www.oracle.com/tools/downloads/sqldev-downloads.html
|MS Windows||64-bit||494 MB||None|
|MS Windows||32-bit||413 MB||JDK 8 or 11 required|
|Mac OSX||341 MB||JDK 8 or 11 required|
|Linux RPM||404 MB||JDK 8 or 11 required|
Currently, I am on an MS Windows desktop running the 64-bit variant.
And, so chose the MS Windows 64-bit binary.
Thankfully it has JDK bundled-in.
Downloaded the artifact.
No install needed.
The artifact is compressed.
And, so extracted it.
Searched out sqldeveloper.exe from the target of our extraction.
To connect to an Oracle Instance, one needs to configure Database Connections.
Just don’t have much time today to review the actual configuration of database connections.
Will instead re-purpose an existing TSNNAMES. ORA file.
Downloaded the existing TNSNAMES.ORA file and availed it at c:\users\dadeniji.
In your case, it will be c:\users[username].
Image – Database Connection
Was able to quickly avail Oracle’s SQL Developer.
The stumbling blocks that confounded us with DBeaver were thankfully vanquished.