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

The Research Database Complex (RDC), part of the Libra cluster, 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:

• Download Aqua Data Studio from IUware Online
• Install the client
• Register the server
• Connect to your Oracle database
• Getting help

---

Download Aqua Data Studio from IUware Online

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

1. Go to: http://iuware.iu.edu/
2. On the left, click Database.
   
   
3. Under "Database":
   
   
   • If your computer is running Windows, click Aqua Data Studio (4.7) for Windows.
   • If your computer is running 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 username and passphrase, and then click login.

   When you're logged in, next to "Available for Download", click Download, and choose to 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.

Install the client

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

Windows version

1. On your computer, find the ads-windows-x86-4.7.2.exe file you downloaded from IUware Online, and double-click it to begin the installation. The InstallShield Wizard and the Preparing to install window will open.
   
   
2. In the Aqua Data Student 4.7 - InstallShield Wizard window, click Next.
   
   
3. Click the radio button next to 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. To continue, click Next.
   
   
5. The installer will ask if you want to change any of your installation settings. Click Back to make changes or Install to start the installation.
   
   
6. The InstallShield Wizard will begin the installation. This may take several minutes. When it's complete, 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 version

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 icon for the Aqua Data Studio application.

Register the server

To connect to your Oracle database on the RDC you must first register the database server. To do so, you'll need the System Identifier (SID) of the database, which is included in the RDC Oracle Database Welcome letter you received in 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:", enter your Oracle database username, and next to "Password", enter your Oracle database password.
   
   
7. Next to "Connect As:", make sure Normal is selected.
   
   
8. Uncheck the box next to 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.

Connect to your Oracle database

To connect to your Oracle database using Aqua Data Studio, open the application, and then:

1. 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 the AquaFold Documentation and Knowledge Base.

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.