We need to use the version of oracle in
/afs/slac.stanford.edu/package/oracle/e/LINUX64/10.2.0
(This only works on RHEL4 64bit machine, like glastlnx21).
We need to create our own oracle admin directory, we can do that using the command:
setenv TNS_ADMIN ~glast/oracle/admin/
The commands 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)
We will make our wallets in ~glast/oracle (actually a symlink to NFS space set up to be readable only by the glast account)
Procedure:
glast@glastlnx21 $ source /afs/slac.stanford.edu/package/oracle/e/LINUX64/10.2.0/bin/coraenv
ORACLE_SID = [glast] ? GLASTP
dbhome: Command not found.
ORACLE_HOME = [] ? /afs/slac.stanford.edu/package/oracle/e/LINUX64/10.2.0
See also: Secure Oracle Paswords for GLAST