We need to use the version(s) of oracle 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
The commands are:
mkstore -wrl <wallet_location> -create
mkstore -wrl <wallet_location> -createCredential <db_connect_string> <username> <password>
We will make our wallets in ~glast/oracle (actually a symlink to NFS space)
Procedure:
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 GLASTglast@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