Setting up your Oracle account

You have been given an account on Oracle as a member of this class. To access this account, you will need to do a couple of things:

First, make sure you can get logged on to ds9. See my ds9 notes for more information on this process and to check your userID.
Once you are on ds9, you will need to make a few changes to your configuration file. In the default shell, this file is called .cshrc, and it lives on your main directory.

Type

cd

to get to the main directory, then open up the .cshrc with your favorite editor

emacs.cshrc

Go to the end of the file and type the following lines Exactly (It might be better to just copy and paste them)

#oracle stuff

setenv ORACLE_HOME /opt1/oracle/product/8.0.5
setenv ORACLE_BASE /opt1/oracle
setenv ORACLE_SID OS80
#setenv CLASSPATH $ORACLE_HOME/jdbc/lib/classes111.zip

set path = ($path /opt1/oracle/product/8.0.5/bin)

Do not make other changes to .cshrc unless you really know what you are doing!! There is no easier way to destroy your account than to mess around carelessly in this file.
Save .cshrc
Exit and re-connect
To get into sqlplus, type:
```
sqlplus
```
from the command line.
Enter your userid and password. Your oracle userid and password are exactly the same as those from the ds9 account. Start with the same userid and password, and if you find the password does not work, try the default password used to create your account (eg f6789myd). Note that sqlplus does NOT hide your password, so be careful who is watching you log in.
© Andy Harris
Indiana University / Purdue University, Indianapolis
email: aharris@cs.iupui.edu
homepage: http://www.cs.iupui.edu/~aharris