From dba@cs.umb.edu (Also known as sj@cs.umb.edu)

Hi everyone,

I will be the database administrator for your database class.  I have
already created oracle accounts for you.

The following are some instructions for accessing the database server:

1. Login on the dbtest machine (full name is: dbtest.cs.umb.edu).

   If you are already logged in to a different machine, you can get
   onto dbtest by using the "rlogin dbtest" command.
   If you do not have access to the dbtest machine then you should
   contact an operator about getting access to it.

2. Load the oracle module by typing:

   module load oracle

   You can add the line above in your .cshrc file in order to load the
   module automatically, any time you login.

   For example add the following 4 lines:

   if ( $HOST == dbtest.cs.umb.edu ) then
      module add oracle
   endif
   stty -tabs       # This resolves some display problems when you rlogin   

   JUST BEFORE the following section in your .cshrc file: 

   # If this file is being executed by shell run from a program, exit now--
   if (! $?prompt) exit

3. Run sqlplus to access the server.  

   ********************************************************************
   *** NOTE: THE ORACLE PASSWORD IS THE SAME WORD WITH THE USERNAME *** 
   ********************************************************************

   Your oracle account and password are the same as your unix username.
   You can just type:

   sqlplus  

   and you will be prompted for your username and password.

   If your unix login is jsmith then you should logon to Oracle with
   username jsmith and password jsmith! You can later change this
   default password if you so desire, instructions are provided below.

4. If you would like to change your password, run the following command at 
   the SQL prompt:

   alter user your_username identified by "newpassword";

5. You can access oracle documentation for Oracle 9.2 at:

      http://www.cs.umb.edu/~rickm/oracledocs/nav/docindex.htm?remark=homepage

   the SQL reference is at:

      http://www.cs.umb.edu/~rickm/oracledocs/server.920/a96540/toc.htm

   Due to copyrights, please do not make this links publicly avbailable

Please let me know if you have any problems. 

Thank you,

dba@cs.umb.edu