Oracle Resources

In order to connect to your Oracle account you have to:

1. set the following environment variables:

setenv ORACLE_HOME /usr/dcs/oracle/oracle9i
setenv ORACLE_SID oracsil

Add /usr/dcs/oracle/oracle9i/bin to your PATH variable

2. type at the prompt:

/usr/dcs/oracle/oracle9i/bin/sqlplus /nolog

3. type at sql prompt:

connect [netid]@oracsil.cs.uiuc.edu

4. when prompted, type your password (we will announce your passwords in class)

For a more complete understanding of the Oracle DBMS, please refer to our Oracle resource page.

Here is our sample java program that should help you understand JDBC connection to Oracle.