Using Oracle from the Student Clusters

1. Please go here and follow the directions to enable access to your account. This is only necessary the first time you access oracle.

2. Login to one of the undergraduate/graduate servers.

3. Set environment variables:

4.  csh \ tcsh : prompt> source .cshrc
     bash \ ksh : prompt> . .profile

     or logout and login again

5.  To access oracle:
 
        > sqlplus /nolog

      This starts the program to connect to the database.
 
        SQL> connect username@student    ( use your remus username )

    You will be prompted for a password:

<>         Enter password:

    Upon successful login you will see:

        Connected.
        SQL>

If your login is unsuccessful, please make sure you followed all the previous steps.

6.  To test that you are connected, try this at the SQL prompt:

    SQL> describe dual;

    You should see something like the following:
    Name                                                                                     Null?     Type
    -------------------------------------------------------------- -------- ---------------------------------------------
    DUMMY                                                                                            VARCHAR2(1)