Configuration Database Project

The confDB libraries and its PVSS and python interfaces provide all the functions needed to insert, view and maintain connectivity and inventory information.

If there are some information you want to have and you can't see how to get it, send me a mail.

Some documentation about the confDB: you will need to install Oracle Client 10g and get the confDB zip file.

Oracle Instant Client Installation ( for NICE computers or Linux machines which have access to afs)

For Windows:

Set your environment variables as follows :

SET PATH=G:\Applications\Oracle\OraInst\v9i\bin;%PATH%

SET TNS_ADMIN=G:\Applications\Oracle\ADMIN

(optional) SET LOCAL=name of the database you want to connect as written in the tnsnames.ora. If you do so, when you connect to the database, you can put dbname=""

For Unix

Just connect to Lxplus. The Oracle environment comes automatically.

Oracle Instant Client Installation (Mandatory, to install once on your machine if it is not a NICE computer or if it does not have access to afs)

First install the instant Oracle client 10g (Oracle light client ) : go to http://www.oracle.com/technology/software/tech/oci/instantclient/index.html

Download the package corresponding to your operating system.

For Windows:

1. Unzip your package in the location of your choice provided that you don't put it in your Oracle Home( if you have one) directory. For example, C:\instantclient;

2. Set your environment variables as follows :

SET PATH=C:\instantclient\instantclient10_1;%PATH%

SET TNS_ADMIN=place where your tnsnames.ora is stored. If you want to connect to a CERN database and have a dfs access, you can create a directory of your choice as "C:\tnsora" and copy&paste the tnsnames.ora located in (G):\Applications\Oracle\ADMIN

(optional) SET LOCAL=name of the database you want to connect as written in the tnsnames.ora. If you do so, when you connect to the database, you can put dbname=""

For Unix

1. Unzip your package.

2. Add the location of where you have unzipped your package in the LD_LIBRARY_PATH. Put it in the first place.

    Set the TNS_ADMIN to the place where your tnsnames.ora is stored. (to do if no access to afs)

To make this change permanent, it is advised to put these settings in your profile so that whenever you log in the oracle client path is already in your LD_LIBRARY_PATH

confDB Usage (C, Python and PVSS interfaces)

Download the zip file you need and unzip it in the location of your choice.

Click here to download the library.

ConfDB Tutorials

Connectivity part

How to start?

Inventory part

How to start?

FAQ