CLASS INFO FOR FALL SEMESTER 1998

 New version of Oracle!

Version 7.3.2 has been replaced with version 8.0.4.

FAQ: Oracle Database Access With Java/JDBC  

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

 1. Oracle documentation available online!!!

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

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

Note: the entry for ORACLE_SID is case sensitive.

4. The system will display:

ORACLE_HOME = [/homes11/app/oracle/product/8.0.4] ?

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] ? JS424

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

tracy.umd.edu [2] sqlplus

SQL*Plus: Release 8.0.4.0.0 - Production on Thu Sep 10 9:38:14 1998

(c) Copyright 1997 Oracle Corporation. All rights reserved.

Enter user-name: js42413

Enter password:

Connected to:

Oracle8 Enterprise Edition Release 8.0.4.2.1 - Production

PL/SQL Release 8.0.4.2.1 - Production

SQL> ALTER USER js42413 IDENTIFIED BY newpassword;

User altered.

SQL> exit

Disconnected from Oracle8 Enterprise Edition Release 8.0.4.2.1 - Production