On Quarry, how do I access the UITS Oracle database Oed1 with SQL*Plus?

On this page:

• Setting up your accounts
• Using Quarry to access the database
• Using SQL*Plus

Setting up your accounts

If you don't have a Quarry account, you'll need to create one; see Getting started on Quarry.

You'll also need an account on the UITS database Oed1. Use the Request Form to request an Oracle account from UITS.

Using Quarry to access the database

Log into Quarry and set your default shell. Follow the appropriate instructions below, depending on your shell:

bash

If you are using bash, you will need to add three lines to your ~/.bash_profile file. Using vi:

1. Use your arrow keys to navigate to the bottom of the file, and then add the following lines: ORACLE_HOME=/N/soft/linux-rhel4-x86_64/Oracle/home; export ORACLE_HOME PATH=$ORACLE_HOME/bin:$PATH; export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/instantclient; export LD_LIBRARY_PATH
2. To make your new environment variables take effect, log out and log back into your Quarry account, and then you will be ready to use SQL*Plus. (See instructions below for Using SQL*Plus.)

csh or tsch

If you are using csh or tcsh, you will need to add two lines to your ~/.cshrc file after the existing "set path=" line. Using vi:

1. Use your arrow keys to navigate to the bottom of the file, and then add the following lines: setenv ORACLE_HOME /N/soft/linux-rhel4-x86_64/Oracle/home set path=($ORACLE_HOME/bin $path)
2. To make your new environment variables take effect, log out and log back into your Quarry account, and then you will be ready to use SQL*Plus. (See instructions below for Using SQL*Plus.)

ksh or sh

If you are using ksh or sh, you will need to add three lines to your ~/.profile file. Using vi:

1. Use your arrow keys to navigate to the bottom of the file, and then add the following lines: ORACLE_HOME=/N/soft/linux-rhel4-x86_64/Oracle/home; export ORACLE_HOME PATH=$ORACLE_HOME/bin:$PATH; export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/instantclient; export LD_LIBRARY_PATH
2. To make your new environment variables take effect, log out and log back into your Quarry account, and then you will be ready to use SQL*Plus. (See instructions below for Using SQL*Plus.)

Using SQL*Plus

To use SQL*Plus after properly configuring your account:

1. At the Unix prompt, enter: sqlplus
2. When prompted for your username, enter: username@database

   Replace username with your username and database with the name of the database on Oed1 that you want to access (e.g., tfps@oed1).

3. Enter your password.

To change your password, at the SQL*Plus prompt, enter:

You will be prompted to enter your old password and your new password, and then to re-enter your new password.

Comments/Questions/Corrections