Oracle9i is maintained
on SciClone by Mike Barnes (mbarnes@compsci.wm.edu).
Questions or problems regarding the use of Oracle on SciClone should
be directed to sciclone@compsci.wm.edu.
Oracle accounts are distinct
from Solaris accounts. To obtain an Oracle account on SciClone, send
an email request to sciclone@compsci.wm.edu.
The Oracle9i server and
database files reside on maelstrom.sciclone.wm.edu, but client
applications can connect to the server from any node in the system.
Environment Variables
Required environment
variables:
setenv ORACLE_HOME
/sciclone/db01/oracle/9.2.0
setenv ORACLE_SID db1
Also add $ORACLE_HOME/bin
to your search path, e.g.,
set path=($path $ORACLE_HOME/bin)
C/C++ Programs
To compile C/C++ programs
with Oracle, you must use Sun's compilers and specify the "-xarch=v9a"
or "-xarch=v9b" flags to produce 64-bit binaries. GCC compilers
are not supported.
You may need to use one
or more of the following include paths:
-I$ORACLE_HOME/rdbms/demo
-I$ORACLE_HOME/rdbms/public
-I$ORACLE_HOME/plsql/public
-I$ORACLE_HOME/network/public
Oracle libraries are
in $ORACLE_HOME/lib. To link against a specific library (e.g., libclntsh.so),
use something like the following:
... -L$ORACLE_HOME/lib
-lclntsh ...
Java Programs
To compile/run Java applications
with Oracle, you will need the following classpath:
setenv CLASSPATH "$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib"
Perl Scripts
A 64-bit version of Perl
has been installed along with the DBI
and DBD-Oracle modules. To use this version of Perl you must start your
script with:
#!/usr/local/v9a/generic/bin/perl
A sample DBI Perl script
can be found here.
