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

Username:
Password:

On this page:

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 Oed1prd. Use the Request Form to request an Oracle account from UITS.

Log into Quarry and set your default shell. Follow the appropriate instructions below, depending on your shell:
- bash: Using vi, navigate to the bottom of your ~/.bash_profile file and add the following lines: ORACLE_HOME=/N/soft/linux-rhel4-x86_64/oracleds/home; export ORACLE_HOME PATH=$ORACLE_HOME/bin:$PATH; export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/instantclient; export LD_LIBRARY_PATH
- csh or tsch: Using vi, use your arrow keys to navigate to the bottom of your ~/.cshrc file. After the existing "set path=" line, add the following lines: setenv ORACLE_HOME /N/soft/linux-rhel4-x86_64/oracleds/home set path=($ORACLE_HOME/bin $path)
- ksh or sh: Using vi, use your arrow keys to navigate to the bottom of your ~/.profile file and add the following lines: ORACLE_HOME=/N/soft/linux-rhel4-x86_64/oracleds/home; export ORACLE_HOME PATH=$ORACLE_HOME/bin:$PATH; export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/instantclient; export LD_LIBRARY_PATH
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.

To use SQL*Plus after properly configuring your account:

At the Unix prompt, enter: sqlplus
When prompted for your username, enter: username@database
Replace username with your username and database with the name of the database that you want to access (e.g., tfps@oed1prd).
Enter your password.

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

PASSWORD

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

This is document ajpk in domain all.
Last modified on August 04, 2011.