Oracle SetUp

To set up using Oracle at CSUC:

After

• getting an Oracle8 account with me, at the account request page
  and inform me of the submission at akeuneke@csuchico.edu
  You should get the following email from me when I have given you the account. After you get the account from me, you need to explicitly log in to Oracle the first time since it will ask you to change your password. This can be done by connecting through putty and using ssh:
  1. ssh ect-sun.ecst.csuchico.edu
     Login with your ecst account name and password
  2. once there, do command sqlplus
  3. log-in
     with your oracle UserName and password
  4. change password if requested
  5. exit or quit out of Oracle
• downloading the .zip file with the proper driver from our machines at /opt/Oracle8i/products/8.1.7/jdbc/lib/classes12.zip and also at /usr/java/lib/classes12.zip
• and putting the path for this driver (i.e, to the classes12.zip file) in your classpath OR if you are running off of our SUNs here then put /opt/Oracle8i/products/8.1.7/jdbc/lib/classes12.zip in your CLASSPATH in your .profile. (This is the JDBC thin driver for Oracle8i 8.1.7 and Java SDK 1.2.x and is backward compatible with previous versions - seems to work for 1.3.x too)
• try the test page first on http://www.ecst.csuchico.edu/~amk/foo/cscijava/database/oracle/Employee.java with your database username and password to see if you are lucky :-) :-(
• summary

If not you have two paths to take: see

1. get an account on oracle and set the new password
2. get a copy of the .java program on your machine and edit it with your Oracle UserName and Password
3. get a local copy of the oracle driver (classes12.zip) for your machine
   Oracle does not need the jdbc:odbc bridge
4. make sure the CLASSPATH on your machine knows where this driver is
   in UNIX, I have CLASSPATH=./:/opt/Oracle8i/products/8.1.7/jdbc/lib/classes12.zip;export CLASSPATH
   In fact, here, save this .profile file in your top level directory on our UNIX machines (if I am clueless in Windows, I can allow you to be clueless in Unix). Make sure that there is not a .profile already there so you do not overwrite it (there will not be one unless you had put it there. Type more .profile in the top level directory and see if it tells you there is no file) After this file is present, future logins will set your CLASSPATH automatically.
   
   on Windows 98 and less this is a line in the autoexec.bat
   on Windows 2000 and NT,
   • go to the HardDrive properties (right click on hardDrive icon)
   • choose Advanced
   • choose Environment Variables
   • make a new one with VariableName: CLASSPATH and VariableValue: where your .zip file is
     in Windows 2000, mine is set to D:\courses\csci215\oracle\classes12.zip;.;
     in Windows 98, my autoexec has a line SET CLASSPATH=.;C:\courses\csci215\oracle\classes12.zip
   • click OK