ORACLE
                              CLASS INFO
                                  FOR
                         SPRING 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
                ----------                      ----------

        Dr. Sudarshan Chawathe .................. SC724

        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
	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] ? SC724
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: sc72413
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 sc72413 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