Spring 2001: CMSC 424 Database Design Oracle Account Info

**************************** 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: 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. 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 IDENTIFIED BY ;

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