Indiana University
University Information Technology Services
  
What are archived documents?
Login>>
Login

Login is for authorized groups (e.g., UITS, OVPIT, and TCC) that need access to specialized Knowledge Base documents. Otherwise, simply use the Knowledge Base without logging in.

Close

How do I access my Oracle database on the IU Research Database complex using Aqua Data Studio?

The Research Database Complex (RDC) is dedicated to research-related databases and data-intensive applications that require a database. Oracle and MySQL databases are supported, and the default database size is 15MB. The RDC also provides an environment for database-driven web applications with a research focus. This system, rdcweb.uits.iu.edu, runs Red Hat Enterprise Linux 5. User home directories reside on the IBM N5500 NAS storage device, with disk quotas of 10GB per user. This quota is shared by your Big Red and Quarry accounts, if you have accounts on those systems.

Following are instructions for accessing your RDC database using Aqua Data Studio.

On this page:

Downloading Aqua Data Studio from IUware

Aqua Data Studio for Windows and Mac OS X is available free of charge to Indiana University students, faculty, and staff via IUware:

  1. Go to: http://iuware.iu.edu/
  2. On the left, click Database.

  3. Under "Database":

    • For Windows, click Aqua Data Studio (4.7) for Windows.
    • For Mac OS X, click Aqua Data Studio (4.7) for OS X.

  4. Next to "Available for Download", click Login, enter your IU Network ID, and then click login.

    Once you're logged in, next to "Available for Download", click Download, and then save the file (ads-windows-x86-4.7.2.exe for Windows; ads-osx-4.7.2.tar.gz for Mac OS X) to your computer.

Installing Aqua Data Studio

After you've downloaded the software, install it on your computer:

Windows installation

  1. On your computer, double-click the ads-windows-x86-4.7.2.exe file you downloaded from IUware.

  2. In the Aqua Data Student 4.7 - InstallShield Wizard window, click Next.

  3. Click I accept the terms in the license agreement, and then click Next.

  4. The installer will provide a default file location for you. To choose a different location, click Change... , and then navigate to the location.

  5. Click Next, and then click Install to start the installation.

  6. After the installation, click Finish.

  7. When you open Aqua Data Studio for the first time, the Usage & License window will appear:

    1. In the Usage section, select Educational Use - Students, faculty and staff of academic institutions.
    2. To verify the educational license, check the box next to I verify that my use is for a non-commercial education purpose at an academic institution classified as K-12, college, or university.
    3. Next to "Institution website/domain", enter www.indiana.edu , and then click OK.

  8. In the Welcome to Aqua Data Studio window, review the choices available, and then click Continue.

Mac OS X installation

  1. Double-click ads-osx-4.7.2.tar.gz to uncompress the file.

  2. Copy the Aqua Data Studio application to your Applications folder.

  3. Double-click the Aqua Data Studio icon.

Registering the server

To connect to your Oracle database on the RDC, you must first register the database server. You'll need the System Identifier (SID) of the database, which is included in the RDC Oracle Database Welcome message you received via email after creating your account.

To register the server:

  1. In Aqua Data Studio, from the menu bar, select Server, and then Register Server.

  2. Click the General tab.

  3. Under "RDBMS", select Oracle 9i/10g.

  4. Next to "Name", enter a name for this server registration (e.g., RDC-One).

  5. From the drop-down list next to "Type:", select Development.

  6. Next to "Login Name:" and "Password", enter your Oracle database username and password.

  7. Next to "Connect As:", make sure Normal is selected.

  8. Uncheck Save password.

  9. Next to "Host:", enter libra45.uits.iu.edu .

  10. Next to "Port:", enter 1521 .

  11. Enter the SID (e.g., IUGP), and then click OK.

Connecting to your Oracle database

To connect to your Oracle database using Aqua Data Studio:

  1. Start Aqua Data Studio. On the left, choose the appropriate server name.

  2. Select Schema, and then select your database.

Getting help

Note: UITS does not support Aqua Data Studio beyond installation of the client. For technical support, visit Support Information for Aqua Data Studio.

For help installing Aqua Data Studio, email the UITS High Performance Systems group. For further installation documentation, see the Installation Instructions for Windows, OS X and Linux on the AquaFold web site.

This is document awqd in domain all.
Last modified on November 11, 2009.

Comments/Questions/Corrections

Use this form to offer suggestions, corrections, and additions to the Knowledge Base. We welcome your input!

If you are affiliated with Indiana University and would like assistance with a specific computing problem, please use the Ask a Consultant form, or contact your campus Support Center.

Contact Information

Note: We will reply to your comment at this address. If your message concerns a problem receiving email, please enter an alternate email address.