To run Oracle, add the following to your .cshrc file.

setenv ORACLE_HOME /hd/oracle 
setenv ORACLE_BASE /hd/oracle 
setenv ORACLE_PATH ".:$ORACLE_HOME/bin"

add $ORACLE_HOME/bin to your path, use your preferred method to do this.

We have created an Alias for the CS610/CS710 database.
The Oracle client is sqlplus and should be in your path once you made the above mentioned changes.
The alias is CS610. To connect to the database use the following command:
sqlplus <dbuser>/cs610@cs610
The syntax is 
sqlplus <dbuser>/<dbpasswd>@<DB_ALIAS>
The DB_ALIAS is CS610 (case insensitive), all of you have the same password: cs610. 
Another way to connect, which works from both UNIX and Windows systems is
sqlplus <dbuser>@cs610.cis.uab.edu, you will then be prompted for your password.
You can obtain the dbuser from the dbusers webpage. 
 

Please change your initial password with the following command in sqlplus:

alter user <dbuser> identified by <newpassword>;

Note: The first character of the new password has to be a letter.