We need to use the version(s) of oracle in

• 32 bit - /afs/slac.stanford.edu/package/oracle/f/10.2.0/i386_linux/10.2.0
• 64 bit - /afs/slac.stanford.edu/package/oracle/e/LINUX64/10.2.0

We have set up an area for storing oracle admin files and wallets in:

/u/gl/glast/oracle

(Currently a link to NFS space, but perhaps will change to AFS space to take advantage of AFS based access restrictions).

Three subdirectories:

• wallet – For oracle wallets
• admin – admin files like tnsnames.ora sqlnet.ora
• bin – utilities, such as setup.sh and setup.csh

To get oracle to use our own admin directory we need to:

setenv TNS_ADMIN ~glast/oracle/admin/

This is done but the setup scripts mentioned above, so in practice you need:

source /u/gl/glast/oracle/bin/setup.(c)sh

The commands for manipulating wallets are:

mkstore -wrl <wallet_location> -create
mkstore -wrl <wallet_location> -createCredential <db_connect_string> <username> <password>
mkstore -wrl <wallet_location> -modifyCredential <db_connect_string> <username> <password>

(see http://download.oracle.com/docs/cd/B19306_01/network.102/b14266/cnctslsh.htm)

See also: Secure Oracle Paswords for GLAST