1. Login to wpi.wpi.edu:
telnet wpi.wpi.edu
People familiar with UNIX should now include ~chenst/oracle/coraenv in their .cshrc, source that once and then run sqlplus with a / (slash) as parameter.
Everybody else please read on ..., and do:
2. You do
ln -s ~chenst/oracle/coraenv
This gives you a link to a file that sets up some directories and environment variables for Oracle. You have to do this step 2 only once, that means if you connect to the database later, just source the coraenv-file (do setp 3) and run sqlplus. Please create a link to that file (instead of copying it) to have the most recent version, as the file may be updated throughout course in order to fix any problems, if needed.
3. You execute this file using
source ~/coraenv
If you're into editing your .cshrc-File, you can also include this command there.
4. You start Oracle by giving
sqlplus /
If you forget the slash (/), Oracle will ask for a user name, at which point you should just press Enter.
Now you should be at the SQL-Prompt and should be able to create some tables or something like that.
In particular, you are encouraged to right away change
your password. You can change passwords using the following command:
alter user smurf identified by bluecolor;
where "smurf" is your username and "bluecolor" is your password. Passwords cannot start with numbers, and cannot contain (most) special characters