The following is a slightly edited version of the information on
Oracle accounts sent to instructors.  Please read it carefully.
(Please do NOT contact OIT staff directly; check with the TA or
instructor first.)

                                ORACLE
                              CLASS INFO
                                  FOR
                         FALL SEMESTER 2004


**************************** REMINDERS *************************************


1.  Oracle documentation available online!!!

    http://www.dc.umd.edu/~oracle/index.htm

2.  Creating executables that use the Oracle Shared Library!!!

    Prior to using the standard Oracle Make procedures the following
    environment variables must be set as follows:

         LD_LIBRARY_PATH=$ORACLE_HOME/lib
         ORA_CLIENT_LIB=shared

    To do otherwise will create executables that will, in most cases,
    exhaust the user's available disk space!


*********************** END OF REMINDERS ************************************

What follows is the information students will need to access their
particular class database.  Also included is the command to change their
Oracle password.

1.      Please note that setting the Orcle SID and directory path is
different
        depending upon which shell is being used.


                If the shell environment variable is set to one of
                the "sh" family enter:

                        source /usr/local/bin/coraenv

                If the shell environment variable is set to "ksh" or
                "bash" enter:

                        . oraenv


2.      The system will display:

                ORACLE_SID = [<current database SID>] ?

                Note: <current database SID> could be any of the class
SIDs
                but will most likely showup as the current userid.

3.      At the ? prompt the student will enter the SID for their
particular
        instance/database.

                Instructor                      ORACLE_SID
                ----------                      ----------

                Sudarshan Chawathe .................. SC424

        Note: the entry for ORACLE_SID is case sensitive.

4.      The system will display:

                ORACLE_HOME = [/home/app/oracle/product/8.0.6] ?

5.      Since this is Oracle's home directory the student simply needs hit
the
ENTER/RETURN key.


6.      At the system's prompt enter:  sqlplus


7.      SQL*Plus will prompt the student for his or her ORACLE userid and
passw
ord.


8.      To change the Oracle password:

                ALTER USER <userid> IDENTIFIED BY <new password>;

        Note:   There is not a redundant password validity check as with
                changing the system password.


9.      Finally, to get out of Oracle SQL*Plus:

                exit

-------------------------------------------------------------------------


The following is a sample run:

tracy.umd.edu [1] source /usr/local/bin/coraenv


7.      SQL*Plus will prompt the student for his or her ORACLE userid and
password.


8.      To change the Oracle password:

                ALTER USER <userid> IDENTIFIED BY <new password>;

        Note:   There is not a redundant password validity check as with
                changing the system password.


9.      Finally, to get out of Oracle SQL*Plus:

                exit

-------------------------------------------------------------------------


The following is a sample run:

tracy.umd.edu [1] source /usr/local/bin/coraenv
ORACLE_SID = [oracle] ? SC424
ORACLE_HOME = [/home/app/oracle/product/8.0.6] ?
tracy.umd.edu [2] sqlplus

SQL*Plus: Release 8.0.6.0.0 - Production on Tue Feb 1 14:08:54 2000

(c) Copyright 1999 Oracle Corporation.  All rights reserved.
Enter user-name: sc42413
Enter password:

connected to:
Oracle8 Enterprise Edition Release 8.0.6.0.0 - Production
With the Objects option
PL/SQL Release 8.0.6.0.0 - Production

SQL> alter user sc42413 identified by new-password;

User altered.

SQL> exit

Disconnected from Oracle8 Enterprise Edition Release 8.0.6.0.0 -
Production
With the Objects option
PL/SQL Release 8.0.6.0.0 - Production