ARCHIVED: Use SQL Developer to access an Oracle database on the RDC
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).
The Indiana University Research Database Complex (RDC) supports research-related MySQL and PostgreSQL databases and data-intensive applications that require databases. The RDC is strictly devoted to supporting research, and is not an instructional, classroom environment.
Download, install, and launch SQL Developer
- 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 , expand the menu, and then select .
To download, install, and launch SQL Developer:
- On the Oracle SQL Developer Downloads page, under "License Agreement", select , and read the license terms. If you accept the terms, return to the Downloads page and check .
- Choose the correct package for your system and read the installation notes for any special instructions or warnings. For complete information, refer to the Oracle SQL Documentation for that release. section in the menu in the
- Select ; if prompted, log in with your Oracle account username and password.
- 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 asqldeveloper
subdirectory that contains thesqldeveloper.exe
executable. To start SQL Developer, double-click the executable. - In OS X, unpack the
tar.gz
archive, and then copy thesqldeveloper
program to yourApplications
folder. To start SQL Developer, click the application's icon. - In Linux, unpack the
.rpm
package, and then change (cd
to thesqldeveloper
directory. To launch SQL Developer, run thesqldeveloper.sh
shell script.
- In Windows, extract the files from the
Connect to your Oracle database
In SQL Developer, to establish a connection to your Oracle database instance on the RDC:
- Right-click the node, and then select .
- 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).
- If you have more than one tab under the
- Connection Type: Select .
- Role: Select .
- Host: Enter the hostname for your database.
- Port: Enter
1521
. - SID: Enter the RDC Oracle instance name (SID) for your database.
checkbox, make sure the tab is selected, and then continue configuring your connection as follows:
- Click . In the bottom right side of the dialog box you should see "Status: Success".
- Click , and then click .
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 or .
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.
This is document bftt in the Knowledge Base.
Last modified on 2018-06-28 09:15:23.