SQL Developer, Installation

<- SpecialTopics

Overview

The following covers the most essential steps to start using Oracle's SQL Developer on a Windows system.

Prerequisites

• From your DBA get the following:
  • Username and Password (ex: scott\tiger)
  • Hostname (ex: orahost01).
  • Database Service Name (ex: oradb).
  • Port Number (ex: 1521).
• You must have the Microsoft Visual C++ Redistributable Package installed.
  Choose the file named vcredist_x64.exe.

Procedure

1. Create a C:\app directory (all Oracle software uses this as the base).
2. Download the latest version to the C:\app directory.
   Select: Windows 64-bit with JDK n included
3. Unzip the file. It will create a corresponding subdirecotry.
   Example: C:\app\sqldeveloper-4.1.5.21.78.x64\sqldeveloper
4. From the ...\sqldeveloper sub-directory create a shortcut to the sqldeveloper.exe file on to your desktop.
5. Double-click the desktop short-cut to start the application.

Initial Run

• If prompted to Confirm Import Preferences select No.
• On the top left, click the green plus (+) sign to create a connection.

Complete Essential Fields

Enter the values from your DBA for the items in blue.

• Connection Name: <Enter a Descriptive>
• Username: scott
• Password: tiger
• Select [x] Save Password.
• Connection Type: Basic
• Hostname: orahost01
• Port: 1521
• (x) Service Name: oradb
• Press Test then Save after working.