We need to use the version(s) of oracle in
We have set up an area for storing oracle admin files and wallets in:
(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:
/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/admin/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)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 Wiki Markup
See also: Secure Oracle Paswords for GLAST