You are here: TWiki> Online Web>DataBases (2011-10-18, zvyagin)
Tags:
create new tag
, view all tags

LHCb Online Databases

All LHCb Online data-bases are served by two Oracle instances running on lbrac01 to lbrac04. The databases are operated by IT/DB. Requests concerning the databases should be send to the helpdesk intern External link mark extern External link mark.

How to use the databases

Once your accounts are configured your application will need two things

  • The Oracle environment: this is normally setup automatically when you login. It can be forced manually by doing

 source /sw/oracle/set_oraenv.sh

The set_oraenv.sh script has three optional arguments:

--arch 32|64
--version 

Example:

. set_oraenv.sh --arch 64 --version 10.2.0.4

Default values:

arch = 32 bits
version = 10.2.0.4 (latest when this script was written)

The tnsnames.ora file

You should never use a local copy of this file. Please make a symbolic link to the master-copy

/sw/oracle/linux/network/admin/tnsnames.ora
P:\oracle\win32\network\admin\tnsnames.ora

On Windows make sure that the Environment variable %TNS_ADMIN% points to

P:\oracle\win32\network\admin

For web services TNS_ADMIN=/web/conf/oracle/linux/network/admin is set in cfg/pro/web_apache.tpl template.

For what it's worth the current version can be found here

-- Main.niko - 10 Aug 2010

Topic revision: r4 - 2011-10-18 - zvyagin
 

TWIKI.NET
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2022 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback