Page History

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:

(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:

/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^{Image Removed})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:

Wiki Markupglast@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