**************************** REMINDERS *************************************
1. Oracle documentation available online!!!
http://www.csc.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 = [
Note:
3. At the ? prompt the student will enter the SID for their particular
instance/database.
Instructor ORACLE_SID
---------- ----------
Dr. V. S. Subrahmanian .................. VS424
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 E
NTER/RETURN key.
6. At the system's prompt enter: sqlplus
7. SQL*Plus will prompt the student for his or her ORACLE userid and passwo
rd.
8. To change the Oracle password:
ALTER USER
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] ? VS424
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: xxxxxxx
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 xxxxx 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