--------------------------------------------------------------------------------
-- Note on setting up the Oracle Environment
--------------------------------------------------------------------------------

Add the following to your .cshrc file

# Oracle8 Stuff
setenv ORACLE_BASE /pack/oracle-8.0.4;
setenv ORACLE_HOME $ORACLE_BASE/product/8.0.4;
setenv ORACLE_DOC $ORACLE_BASE/doc;
setenv ORACLE_SID blob2;
setenv TWO_TASK $ORACLE_SID;
setenv ORACLE_TERM xsun5;
setenv ORACLE_NLS33 $ORACLE_HOME/ocommon/nls/admin/data;
setenv LD_LIBRARY_PATH $ORACLE_HOME/lib:/usr/openwin/lib;
setenv PATH $ORACLE_HOME/bin:$ORACLE_HOME/lbin:$PATH;

Then source your .cshrc file.

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

To make things easier create the a .login.sql file in your unix home
directory with the following contents. The NLS_DATE_FORMAT is for
making dates appear in ISO standard format.

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD';
SET PAGESIZE 60;
SET LINESIZE 175;

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

Create an alias that start an Oracle connections in your .aliases file

alias sql "sqlplus <your oracle user name> @/user/<your unix user name>/.login.sql"

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

You should now be able of creating an Oracle connection by typing

my machine>sql

You are then asked to enter your Oracle password:

SQL*Plus: Release 8.0.4.0.0 - Production on Mon Jan 25 11:1:16 1999

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

Enter password: 

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

After entering the password you then get an SQL prompt looking like the following

Connected to:
Oracle8 Enterprise Edition Release 8.0.4.0.0 - Production
PL/SQL Release 8.0.4.0.0 - Production


Session altered.

SQL>


