0. You do
ln -s /usr/local/bin/coraenv coraenv
this would create a soft link linking a file "coraenv" in your home directory to an oracle initialization file located at /usr/local/bin/. You only need to do this ONCE to create the file "coraenv". For the other steps, namely step1~4, you need to do them everytime when you want to connect to Oracle.
1. Login to Oracle.wpi.edu:
ssh Oracle.wpi.edu
2. Source the Oracle environment initialization file:
source coraenv
This runs the initialization file that sets up some environment variables for Oracle. If it prompts "ORACLE_SID = [xxx]" where "xxx" is not "CS", answer "CS". If it prompts "ORACLE_SID = [CS]", just hit the ENTER key.
3. You now can start using Oracle by giving:
sqlplus
You should get the response like:
SQL*Plus: Release 9.2.0.1.0 - Production on Thu Sep 11 11:01:04 2003 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Enter user-name:
4. Provide your username and password:
input your user name and password, both of which are the same as your unix login name. Now you should be at the SQL-Prompt and should be able to create tables etc.. We strongly suggest you change your password immediately after you login to Oracle for the first time, by issuing the command password at the SQL prompt.
5. NOTE: If you are using some Oracle client software, the tnsnames.ora entry for this Oracle server instance is:
CS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = oracle.WPI.EDU)(Port = 1521))
)
(CONNECT_DATA =
(SID = CS)
(SERVICE_NAME = CS.WPI.EDU)
)
)