oracledba.help
SpecialTopics

SQL Developer, Installation

Improving Launch Time

Disable Unused Features

  1. Tools Menu
  2. Features (deselect any that you don't need).

Disable the Welcome Page.

  1. Scroll to the bottom of the page.
  2. Disable checkbox "Show on Startup".

Disable IndexedPreferences

  1. Edit ...\sqldeveloper\bin\sqldeveloper.conf
  2. Add entry:
    AddVMOption -DIndexedPreferencesCommand=false

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: lnx01).
    • 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.
  • If already using, you can export your connections as so:
    1. Oracle Connections section (on left).
    2. On the top of the tree right-click over the words "Oracle Connections".
    3. Select: Export Connections (follow prompts).
      Import them in the same manner choosing Import Connections.

Create Desktop Shortcut

From Windows Explorer:

  1. Create shortcut of exe in same folder as exe.
    C:\app\sqldeveloper-<version>-x64\sqldeveloper.exe
  2. Copy shortcut to the Public Desktop folder:
    1. Go to C:\Users.
    2. Menu -> View [x] Hidden Items
    3. Copy the new shortcut here:
      C:\Users\Public\Desktop\Public Desktop

Procedure

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

Initial Run

  • If prompted to Confirm Import Preferences select Yes if upgrading from older version.
  • 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: lnx01
  • Port: 1521
  • (x) Service Name: oradb
  • Press Test then Save after working.

Create ERD

Configure Data Modeler

  1. Ensure the Data Modeler feture is enabled.
  2. File 🠊 Data Modeler 🠊 Import 🠊 Data Dictionary
    Follow prompts...
  3. Select: Database 🠊 Next
  4. Select: Schema 🠊 Next
  5. Select: Objects (tables) 🠊 Next
    • If they are not all selected; to select all tables:
      • Press Ctrl-A to hi-light all entries.
      • Press the Select All image button at bottom left.
  6. Press [Finish]

Once imported you can create\print an ERD.

Create ERD File

  1. File 🠊 Data Modeler 🠊 Print Diagram
  2. Choose desired output (examples):
    • To PDF File
    • To HTML/SVG File

DBA View

Add Database

 Menu 🠊 View 🠊 DBA 🠊 + MyDB

Dashboard GUI

 Database Status 🠊 Instance View

Roles

 Security 🠊 [Right-Click] Roles: Create New