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

On the Research Database Complex at IU, how do I access my Oracle or MySQL database?

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.

On this page:

Connecting to the RDC

To connect to your account on the RDC:

  1. In your SSH client, enter: ssh username@rdc.uits.iu.edu

    Replace username with your Network ID username.

  2. Read the message of the day (MOTD). It contains news and information about the status of the RDC.

Note: If you're logging into the RDC for the first time, the changeshell program will prompt you to select your preferred login shell: jdoe@rdc:~> changeshell This program will assist you in changing your login shell on all nodes of the RDC . . . . 1) bash 2) tcsh . . . 5) quit Select 1-5: 2 Changing login shell for jdoe Password: Shell changed. Your shell has been changed to the Cornell tcsh shell This will take effect on all nodes within 15 minutes

If you use the Bash, Bourne, or Korn shells, the system will automatically read and execute commands from the /etc/profile file and your own ~/.profile (and ~/.bash_profile  for Bash). With the csh and tcsh shells, the .login and .cshrc (or .tcshrc) files are read. For details, see In Unix, what is the shell? or the Unix man pages.

For more, see Getting started on the IU Research Database Complex.

Connecting to your Oracle database using SQL*Plus

Note: 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)
  • Information about your initial database password

If you don't have the Welcome letter, email the High Performance Systems group for assistance.

To connect to your RDC database using SQL*Plus:

  1. At the system prompt, enter the following, replacing username with your database login and oracle_instance_name with the SID: sqlplus username@oracle_instance_name

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

  2. When prompted, enter your Oracle database password, as shown below: SQL*Plus: Release 10.2.0.1.0 - Production on Fri Mar 14 13:49:03 2008 Copyright (c) 1982, 2005, Oracle. All rights reserved. Enter password:
  3. When you've logged in successfully, you'll see: Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production With the Partitioning, OLAP and Data Mining options SQL>

Connecting to your MySQL database

Note: Your RDC MySQL Database Welcome letter contains information you need to connect to your database:

  • Your MySQL database login (username)
  • Information about your initial database password
  • Your database port number

If you don't have the Welcome letter, email the High Performance Systems group for assistance.

To connect to your RDC database using MySQL:

  1. At the system prompt, enter the following, replacing your_username with your Network ID username. Do not change root. Because you are the database administrator (DBA) for your MySQL database, you need to log into your database as root. mysql --defaults-file=/N/u/your_username/Libra/.my.cnf -u root -p

    Note: For security reasons, do not enter your password on the MySQL command line.

    Note: The name Libra in the command above reflects the fact that the RDC used to be part of the Libra cluster, which UITS retired in summer 2009.

  2. When prompted, enter your MySQL database password.

  3. When you've logged in successfully, you'll see: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 11 Server version: 5.0.60sp1-enterprise-gpl-log MySQL Enterprise Server (GPL) Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

Getting help

For help connecting to your Oracle or MySQL database, email the High Performance Systems group.

This is document awqb in domain all.
Last modified on July 01, 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.