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

  • No labels