System Info from the Comp Center

The OIT Unix cluster systems (details below) share a common file

system, common news and mail systems, and common users. This means

users can login to whichever of the systems they want and their same

This also means users can do their own "load balancing" by logging in

to whichever system seems to be best for them at the time.

----- System Details -----

The cluster machines (known as session servers) are as follows:

Session Servers

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

holmes.umd.edu

marlowe.umd.edu

marple.umd.edu

tracy.umd.edu

wolfe.umd.edu

To make all this easier, users of the OIT Unix cluster can just

All mail sent to the cluster should be addressed to

<login-id>@umd5.umd.edu (which is the address that is placed on all

outgoing cluster mail). Mail sent in this manner can be read from any

cluster system. The machine known as umd5.umd.edu is also part of the

cluster but acts as a server for the cluster. DO NOT USE UMD5 for

anything other than your EMAIL address. Never login to umd5.

Games, IRC, and MUDs are not allowed on the OIT Unix cluster.

The home directories contain default .login, .cshrc, and .logout

files. In addition, the access mode on the home directories has been

set to 700. This means that a student will not be able to copy files

from an unsuspecting student, unless the owner changes the mode of his

home directory to something that allows such access. Of course

students can still MAIL things to each other.

User files are NFS mounted on various servers. Symbolic links

are used to create the file names found in the system password file.

This means the names returned by the pwd command may not match the

names found in the system password file. Users should always refer to

home directories by the ~loginid or $HOME methods.

Oracle Info from the Comp Center

**************************** 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 = [<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. Joel Saltz .................. JS424

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

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

Enter user-name: js42413

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 js42413 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