Setup Instructions

• Add the following to either .cshrc(C-Shell) or .profile (Bash-Shell) depending on the shell you are using.
• Logout and Log Back in.
• Make sure that there are no errors displayed before the prompt.
• Type ". oraenv" without the quotes at the command prompt and hit enter.
For reference see: Oracle Access
• Type "ccdb" without the quotes and hit enter.
• Type "sqlplus /" again without quotes and hit enter.
• It should ask you for your username. Use your gt#.
• For password, type in your gt#DDMM, where DD is your birth day and MM is your birth month e.g., if your gt# is gt1234b and your were born on December 7, then enter gt1234b0712
• If everything is done correctly, you should get a command prompt "SQL>"
• If you don't see a command prompt, check to see you followed each instruction.
• If you still experience problems, email your friendly TA.

OIT allows access to the CCDB [class projects database] on their Oracle Server(cactus.prism.gatech.edu) at port 1525 from both the acme machines as well as outside. In order to connect using java, the oracle jdbc driver(classes12.zip & nls_charset12) should be available and setup in the classpath. If you want to compile and run your java program from CoC Machines (Tokyo, Lennon, etc.), the drivers are already available. All you have to do is add the following to either .cshrc(C-Shell) or .profile (Bash-Shell) depending on the shell you are using.