It’s easy to forget that many people still have not discovered SQL Developer, or are just getting started. Many of my recent posts have been on advanced topics, hidden tricks, and productivity tips.
I want to spend some time in the next few weeks helping the beginners out there.
I can’t think of a better place to start than with how to ‘install’ SQL Developer.
I’ve been telling anyone who will listen than you can get up and running with SQL Developer in under 5 minutes. That’s a pretty big claim, and I reckon I should back that up now.
Disclaimer: I have a hi-speed residential network connection that was averaging 15.93Mbps this morning. I realize many of you have connections that are both slower and faster, so keep that in mind when I make my ‘5 minute’ claim.
The Basics – Download SQL Developer
Otherwise, if you’re on Windows 64 bit OS, you can simply download this version of SQL Developer: Windows 64-bit with JDK 8 included.
JDK? JRE? Java? What?!?
SQL Developer is a Java application. To run it requires the Java Virtual Machine – this is the ‘go box’ for java applications. If you’ve ever seen that funny icon popup in your system tray while running apps over a website, that’s probably java.
JDK – Java Development Kit. I call it the ‘Toolkit’, but it’s just a ‘Kit,’ but not THAT K.I.T.T.
The Java Runtime Environment (JRE) is a smaller and less powerful ‘go box’ for Java applications, but SQL Developer relies on some of the libraries included only in the JDK – so get the JDK!
Many versions of Java out there – 7, 8, and 9 are the most common. The name is ‘8’, but the version is ‘1.8.’ We develop, test, and support SQL Developer for 1.8. You can run Java 9, but you’re on your own for the moment. If you HAVE to use Java 6 or 7, you’ll have to grab an older version of SQL Developer, sorry.
It’s an archive, not an installer.
After you’ve downloaded SQL Developer, there’s no installer to run. Just extract the folder, then find the ‘sqldeveloper.exe’ in the top directory, and run it.
If you’ve downloaded the 64 bit windows version with the JDK bundled, you’re all set.
If not, you’ll need to tell SQL Developer where it can find it’s Java master, AKA the Java Virtual Machine. Be sure to point to the base JDK home directory. It should look something like ‘C:\Program Files\Java\jdk-9.0.1’
Once you hit OK, you’ll never have to answer this question again.
You can change this location later in the product.conf file. You can find that file in Windows here
C:\Users\jdsmith\AppData\Roaming\sqldeveloper\17.4.0 — where ‘jdsmith’ is your Windows OS username and ‘17.4.0’ is the version of SQL Developer you’re running.
If you’re on Linux or a Mac, it’ll be in a .sqldeveloper directory in $HOME.
SetJavaHome C:\Program Files\Java\jdk-9.0.1
SQL Developer will then start, and you can proceed by setting up your connection.
Before you can connect, you will need the following:
- database user account (complete with username and password)
- location of database (either via TNSNames, LDAP, or servername/IP, port, and SID/Service)
If you don’t have an account, don’t go online asking people for a ‘default.’ Find the owner of your application or database and ask them for an account. If you don’t want to involve them, then you’re looking for a backdoor and could be labeled a ‘hacker.’
Now you get to learn by doing. Many of you won’t have access to formal training, and I think that’s a real shame. If your organization provides training or compensation for taking classes – do it! Lots of free resources out there, including my blog of course.
Here’s a rundown of the official stuff from Oracle:
- OTN SQL Developer Forum – ask questions here
- 60+ video tutorials in the Oracle Learning Library (OLL)
- 10 Step Getting Started Guide