How To Download Oracle SQL DeveloperIn this post, I’ll explain how to download, install, and set up an Oracle Database on your own computer.

Requirements to Install and Set Up Oracle Database

To be able to run the Oracle database on your computer, you’ll need:

  • Internet access to download the required files (or the files downloaded to be used offline)
  • Windows or Linux operating system. At the moment, there is no way to install Oracle on a Mac, unless you use a virtual machine such as Parallels.

 

Step 1 – Download Oracle Client

The steps to download Oracle Database 11g Express Edition are:

  1. Visit the Oracle website at oracle.com.
  2. Go to the Downloads menu at the top.
  3. Select Oracle Database 11g Express Edition.
  4. Read and accept the license agreement
  5. Click on the link to the relevant version (Windows or Linux).
  6. Enter your Oracle account details (or sign up for one if you don’t have one already)
  7. Select the save location and press Save.

You can view the video here:

 

Step 2 – Install Oracle Client

To install the Oracle database client, follow these steps:

  • Extract the file that was downloaded
  • Run the “setup.exe” file
  • Click Next on the Welcome screen
  • Accept the terms and conditions
  • Select your installation directory
  • Enter a password to use for both the SYS and SYSTEM database accounts. You will need this for logging in to the database later.
  • Click Install after reading the summary.

You can view the video here:

 

Step 3 – Download Java JDK

The steps to download the Java JDK are:

  1. Visit the Oracle website at oracle.com.
  2. Hover over the top menu and click on Downloads
  3. Click on Java for Developers
  4. Click on the Java Platform JDK. The JDK download page is shown.
  5. Read and accept the license agreement.
  6. Scroll down to find the installation files for the JDK for various operating systemsand file types.
  7. Choose your preferred file type and download.
  8. Save the file in your preferred destination.

You should now be able to install the JDK on your computer.

PS: I’m aware that the J in JDK stands for Java, and it’s a bit strange calling it the Java JDK as that actually means “Java Java Development Kit”, but it’s a bit easier for some to recognise if it’s mentioned as Java JDK.

You can view the video here:

 

Step 4 – Install Java JDK

The steps for how to install Java JDK are:

  1. Run the file downloaded in the previous step (e.g. “jdk-7u25-windows-x64.exe”).
  2. Click Run if a security warning appears.
  3. Click Next on the Welcome screen
  4. Click Next on the Features screen (the default features are OK). The installation directory can remain at the default value.
  5. Wait for the JDK to be installed (approx 30-40 seconds).
  6. Accept the default installation for the Java Runtime Environment (JRE) and click Next.
  7. Wait for the JRE to be installed.
  8. Click Close.

Java JDK should now be installed on your computer.

You can view the video here:

 

Step 5 – Download Oracle SQL Developer

To download Oracle SQL Developer, which lets you run queries on the database, follow these steps:

  1. Go to oracle.com
  2. Select the Downloads tab, then under Developer Tools, click on SQL Developer.
  3. Accept the license agreement.
  4. Select a download link for your operating system.
  5. Save the file to a location on your computer
  6. Browse to the saved location
  7. Extract the ZIP file using a compression program (WinZIP, WinRAR, 7ZIP, etc)
  8. Close the ZIP file.
  9. Open the extracted folder.

The Oracle SQL Developer application can be run by opening sqldeveloper.exe.

You can view the video here:

 

Step 6 – Set Up Oracle SQL Developer

To set up Oracle SQL Developer for use, follow these steps:

  • Open the “sqldeveloper.exe” file
  • Click on Browse for the java.exe pathname
  • Browse to the location that the Java JDK was installed to (which may be C:\Program Files\Java\jdk1.7.0_25\bin)
  • Open Java.exe
  • Click OK
  • Click Yes if a warning for a certified version appears. I haven’t noticed any issues with this.
  • Click Yes if another message for version incompatibility appears.
  • Select the file types to associate with SQL Developer. I’ve selected all of them.

You can view the video here:

 

Step 7 – Create Connection in Oracle SQL Developer

To create a connection to your database from Oracle SQL Developer so you can run queries, follow these steps:

  • Click on the green + icon in the top left
  • Enter whatever your like as the connection name. I’ve used “Local”. This is the value that is displayed for this connection iwthin the application.
  • For username, use SYSTEM
  • For password, enter the same password as you did during the installation
  • Leave all of the other fields the same
  • Click on Test. The status should show “Status: Success”, which means the details are correct
  • Click Connect.

The connection will be created and an connected to.

You can view the video here:

 

Well I hope this has given you some guidance on how to download, install, and set up an Oracle database on your computer. If you have any questions, let me know!

Lastly, if you enjoy the information and career advice I’ve been providing, sign up to my newsletter below to stay up-to-date on my articles. You’ll also receive a fantastic bonus. Thanks!