We need to use the version(s) of oracle in
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:
To get oracle to use our own admin directory we need to:
No Format |
---|
setenv TNS_ADMIN ~glast/oracle/admin/ |
This is done but the setup scripts mentioned above, so in practice you need:
No Format |
---|
source /u/gl/glast/oracle/bin/setup.(c)sh |
The commands for manipulating wallets are:
No Format |
---|
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