ARCHIVED: Use SQL Developer to access an Oracle database on the RDC

This content has been archived, and is no longer maintained by Indiana University. Resources linked from this page may no longer be available or reliable.

On this page:


Overview

Oracle SQL Developer (for Windows, macOS, or Linux) is a free graphical application for performing database development tasks. Following are instructions for downloading SQL Developer, installing it on your workstation, and configuring it to connect to your Oracle database on the Indiana University Research Database Complex (RDC).

Note:

The Indiana University Research Database Complex (RDC) supports research-related MySQL databases and data-intensive applications that require databases.

Download, install, and launch SQL Developer

Requirements:
  • To download SQL Developer, you need a valid Oracle account; if you don't have an Oracle account, submit this form to create one.
  • To install SQL Developer on your workstation, you must be logged in as an administrator.
  • To launch SQL Developer, your workstation must have a current version of the Java Development Kit (JDK) installed; if you don't have the current JDK installed, download it from the Oracle website.
  • For additional system requirements, see the SQL Developer Documentation for the release you plan to install; go to Oracle SQL Documentation, select a release, open the Installation Guide, expand the Installing Oracle SQL Developer menu, and then select SQL Developer System Recommendations.

To download, install, and launch SQL Developer:

  1. On the Oracle SQL Developer Downloads page, under "License Agreement", select OTN License Agreement for SQL Developer, and read the license terms. If you accept the terms, return to the Downloads page and check I accept.
  2. Choose the correct package for your system and read the installation notes for any special instructions or warnings. For complete information, refer to the Installing and Starting SQL Developer section in the Installing Oracle SQL Developer menu in the Oracle SQL Documentation for that release.
  3. Select Download; if prompted, log in with your Oracle account username and password.
  4. Save the .zip (for Windows), tar.gz (for OS X), or .rpm file (for Linux) file to your workstation, and then:
    • In Windows, extract the files from the .zip archive to a directory of your choice. This sets up a sqldeveloper subdirectory that contains the sqldeveloper.exe executable. To start SQL Developer, double-click the executable.
    • In OS X, unpack the tar.gz archive, and then copy the sqldeveloper program to your Applications folder. To start SQL Developer, click the application's icon.
    • In Linux, unpack the .rpm package, and then change ( cd to the sqldeveloper directory. To launch SQL Developer, run the sqldeveloper.sh shell script.

Connect to your Oracle database

Note:
To complete these instructions, you will need some of the information included in the "welcome" email message you received after creating your database account on the RDC.

In SQL Developer, to establish a connection to your Oracle database instance on the RDC:

  1. Right-click the Connections node, and then select New Database Connection.
  2. In the "New/Select Database Connection" dialog box, enter information and configure settings as follows:
    • Connection Name: Enter a name you will recognize.
    • Username: Enter the Oracle account name specified in your RDC Oracle database "welcome" email message.
    • Password: Enter the passphrase you set for the Oracle account username.
    • Save Password: Make sure this option is not selected (i.e., unchecked).
  3. If you have more than one tab under the Save Password checkbox, make sure the Oracle tab is selected, and then continue configuring your connection as follows:
    • Connection Type: Select Basic.
    • Role: Select Default.
    • Host: Enter the hostname for your database.
    • Port: Enter 1521.
    • SID: Enter the RDC Oracle instance name (SID) for your database.
  4. Click Test. In the bottom right side of the dialog box you should see "Status: Success".
  5. Click Save, and then click Connect.

Get help

For more about installing and using SQL Developer, see the SQL Developer Documentation for the release you are installing; go to Oracle SQL Documentation, select a release, and then choose Installation Guide or User's Guide.

For a tutorial that introduces SQL Developer and demonstrates how to manage your database objects, see Oracle's Getting Started With SQL Developer.

If you need help connecting to your Oracle database on the RDC, contact the UITS High Performance Systems (HPS) team.

Note:
UITS does not support SQL Developer beyond the installation of the client. For additional documentation and online demonstrations, see the Learn More tab on Oracle's SQL Developer product page.

This is document bftt in the Knowledge Base.
Last modified on 2018-06-28 09:15:23.

Contact us

For help or to comment, email the UITS Support Center.