How to Install Oracle 11g, SQL Developer & create a connection.

In this tutorial I’m going to show you how to install Oracle, SQL developer and create a local connection on Windows.

  1. Download Oracle Database Express Edition 11g
    1. First login to Oracle (if you don’t have an account, you’ll need to create one)
    2. Accept License Agreement and download either the 64bit or 32bit version depending on your system (if your’re unsure, sight click on This PC, click properties and it will say under System Type.
    3. Once downloaded, navigate to the download folder and click install.
    4. Oracle will ask you to set a password for your system, it is important to remember this password as you will need it to create a connection later.
  2. Next, download SQL Developer
    1. Again you will need to log in to Oracle, accept the licence.
    2. Check you have JDK 8 installed. Open the command line (search windows for cmd) enter the command javac -version.
    3. If you haven’t got 1.8 installed then download the SQL developer with JDK 8 included, otherwise download the Windows 32-bit/64-bit version.
    4. Navigate to the folder it was downloaded too and run SQLDeveloper
  3. Open SQL Developer, click the plus sign and create a new connection.
    1. Enter a Connection Name of your choice
    2. Enter system as the username
    3. Enter the password you created when installed Oracle in step 1
    4. Leave the hostname as localhost
    5. Leave the port as 1521
    6. Leave the SID as xe
    7. Click Test which should return ‘success’
    8. Click Connect and begin using SQL

testconnection

Now you can begin creating tables and developing your SQL skills. See Oracle’s documentation for more information on getting started.

Enjoy 🤓

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s