Access your Oracle database on the IU Research Database Complex

Following are instructions for accessing your Oracle database on the Indiana University Research Database Complex (RDC).

Note:

The Indiana University Research Database Complex supports research-related databases and data-intensive applications that require databases. The RDC provides an environment for database-driven web applications focusing on research, and offers the following database accounts:

  • MySQL: The RDC supports MySQL Enterprise Server.
  • Oracle: MySQL can meet most database needs. However, if your research has an immediate requirement for specific functionality in Oracle, you may request to be considered for an Oracle database account. To do so, follow the instructions in the RDC Database and Web Services Account Application.

On this page:


Connect to the RDC

To connect to your account on the Research Database Complex (RDC) front-end server:

  1. In your SSH client, enter the following (replace username with your IU username):
      ssh username@rdc.uits.iu.edu
  2. Read the message of the day (MOTD). It contains news and information about the status of the RDC.
Note:
Your login shell is automatically set to bash.

Connect to your Oracle database for the first time

When your Oracle schema was created, the password was set to expire the first time you connect. Because of this, you will be prompted to change your password immediately after you connect to Oracle using the password information sent to you via email.

In order to change your password, your first connection to your Oracle account (schema) must use SQL*Plus. SQL*Plus is installed on rdc.uits.iu.edu and karst.uits.iu.edu.

After you have successfully changed your Oracle password using SQL*Plus, you will be able to connect to your Oracle schema using SQL*Plus, Aqua Data Studio, or Oracle Client software.

Your RDC Oracle Database welcome letter contains information you need to connect to your database:

  • Your Oracle database login (username)
  • The Oracle instance name or Security Identifier (SID)
  • The Oracle global database name or Service Name (needed if you will be logging in from Karst)
  • Information about your initial database password

If you don't have your welcome letter, email the High Performance Systems group for help.

Note for those connecting from Karst:

The general-purpose RDC Oracle database instances IUGP, IURSRCH, and RSRCH are accessible from Karst.

Access to other, customer-specific Oracle database instances is added upon request. Email the High Performance Systems group if you're not sure if your database instance is accessible or if you want your database instance to be accessible from Karst.

From the RDC: Connect to your Oracle database using SQL*Plus

  1. Connect to your account on the RDC, as shown above.
  2. At the system prompt, enter the following (replace username with your database login and oracle_instance_name with the SID noted in your RDC Oracle Database welcome letter):
     sqlplus username@oracle_instance_name

    For security reasons, you should not enter your password on the SQL*Plus command line.

  3. When prompted, enter your Oracle database password, as shown below:
      SQL*Plus: Release 11.2.0.1.0 Production on Mon Aug 13 15:23:16 2012
    
      Copyright (c) 1982, 2009, Oracle.  All rights reserved.
    
      Enter password: 

    If this is your first time connecting to your Oracle schema, you will be prompted to change your expired password.

When you've logged in successfully, you'll see:

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
  
With the Partitioning, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options

SQL>

From Karst: Connect to your Oracle database using SQL*Plus

  1. Connect to your account on Karst by entering the following (replace username with your IU username):
    ssh username@karst.uits.iu.edu
    
  2. At the system prompt, run the command to load the Oracle module (module load oracleds) so that you can run SQL*Plus:
    [username@h4 ~]$ module load oracleds
    
    Oracle 11.2 database client for DSDI version 11.2.0.3 loaded.
    
    Note:
    You can modify your environment so that the Oracle module is loaded automatically when you log into Karst. For more, see In Modules, how do I save my environment with a .modules file?
  3. After the module has been loaded, enter the following (replace username with your database login and oracle_service_name with the Service Name noted in your RDC Oracle Database welcome letter):
    sqlplus username@oracle_service_name
    

    For security reasons, you should not enter your password on the SQL*Plus command line.

  4. When prompted, enter your Oracle database password, as shown below:
    SQL*Plus: Release 11.2.0.1.0 Production on Mon Aug 13 15:23:16 2012
    
    Copyright (c) 1982, 2009, Oracle.  All rights reserved.
    
    Enter password:
    

    If this is your first time connecting to your Oracle schema, you will be prompted to change your expired password.

When you've logged in successfully, you'll see:

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

With the Partitioning, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options

SQL>

Connect to your Oracle database using Aqua Data Studio

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.

For more, see Use Aqua Data Studio for Windows to access your Oracle database on the IU RDC.

Get help

For more about SQL*Plus, see the SQL*Plus® User's Guide and Reference.

For more on the use of Modules on High Performance Systems servers, see On the research computing systems at IU, how do I use Modules to manage my software environment?

For help connecting to your Oracle database at IU, email the High Performance Systems group.

This is document bfxd in the Knowledge Base.
Last modified on 2018-01-29 16:30:14.

  • Fill out this form to submit your issue to the UITS Support Center.
  • Please note that you must be affiliated with Indiana University to receive support.
  • All fields are required.

Please provide your IU email address. If you currently have a problem receiving email at your IU account, enter an alternate email address.

  • Fill out this form to submit your comment to the IU Knowledge Base.
  • If you are affiliated with Indiana University and need help with a computing problem, please use the I need help with a computing problem section above, or contact your campus Support Center.

Please provide your IU email address. If you currently have a problem receiving email at your IU account, enter an alternate email address.