Oracle – SQL Developer – Installation ( v20.2 )

Background

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.

Outline

  1. Artifact
    • Identify Artifact Source
    • Available Artifacts
    • Identify Artifact
    • Download Artifact
  2. Install Artifact
  3. Launch Application
  4. Use Application
    • Configure

 

Artifact

Identify Artifact Source

Oracle SQL Developer is available at https://www.oracle.com/tools/downloads/sqldev-downloads.html

 

Available Artifacts

Image

 

Text

OS Bitness File Size Requirement
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

 

Identify Artifact

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.

 

Download Artifact

Downloaded the artifact.

 

Install Artifact

Installation

No install needed.

The artifact is compressed.

And, so extracted it.

 

Launch Application

Searched out sqldeveloper.exe from the target of our extraction.

 

Use Application

Configure

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

Images

Image – Database Connection

 

Summary

Was able to quickly avail Oracle’s SQL Developer.

The stumbling blocks that confounded us with DBeaver were thankfully vanquished.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s