Database instance access map
Complete:
Access from CERN and outside
Development
Service |
Access Mode |
Connect String |
Auth Path |
frontier |
sitelocal-read-only (development test) |
frontier://FrontierPrep/[schemaname] |
None |
frontier |
siteless-read-only (commandline,webservice,small test) |
frontier://cmsfrontier.cern.ch:8000/FrontierPrep/[schemaname] |
None |
direct oracle |
read-only |
oracle://cms_orcoff_prep/[schemaname] |
/afs/cern.ch/cms/DB/conddb |
direct oracle |
read-write |
oracle://cms_orcoff_prep/[schemaname] |
/afs/cern.ch/cms/DB/conddb |
Note: please use siteless-read-only frontier only for indicated cases and temporary small tests.
site-local frontier access requires site-local-config.xml file in $CMS_PATH/SITECONF/<site>/JobConfig
Integration
Service |
Access Mode |
Connect String |
Auth Path |
direct oracle |
read-only |
oracle://cms_orcoff_int/[schemaname] |
/afs/cern.ch/cms/DB/conddb |
direct oracle |
read-write |
not allowed |
not allowed |
frontier |
sitelocal-read-only (preproduction test) |
frontier://FrontierInt/[schemaname] |
None |
frontier |
siteless-read-only (commandline,webservice,small test) |
frontier://cmsfrontier.cern.ch:8000/FrontierInt/[schemaname] |
None |
sitelocal frontier access requires site-local-config.xml file in $CMS_PATH/SITECONF/<site>/JobConfig
Note: please use siteless-read-only frontier only for indicated cases and temporary small tests.
Production
Service |
Access Mode |
Connect String |
Auth Path |
frontier |
sitelocal-read-only (production) |
frontier://FrontierProd/[schemaname] |
None |
frontier |
siteless-read-only (commandline,webservice,small test) |
frontier://cmsfrontier.cern.ch:8000/FrontierProd/[schemaname] |
None |
direct oracle |
read-only |
oracle://cms_orcon_adg/[schemaname] |
/afs/cern.ch/cms/DB/conddb |
direct oracle |
read-write |
not allowed |
not allowed |
site-local frontier access requires site-local-config.xml file in $CMS_PATH/SITECONF/<site>/JobConfig
Please use direct ORACLE access for fast and critical monitoring purposes only: ORACLE DB is critical for data processing. If you want to look at calibrations in details, especially using web applications, please use frontier.
Note: please use siteless-read-only frontier only for indicated cases and temporary small tests.
Using ORACLE Active Data Guard in CMSSW
When using CMSSW 5.2.5, 5.3.0, 6.0.0.pre4 or newer releases
- Set up the CMSSW environment:
$ cd /path/to/CMSSW
$ cmsenv
- Now you can connect to ORACLE, e.g. for listing the IOV tags of a schema
$ cmscond_list_iov -c oracle://cms_orcon_adg/[schemaname] -P /afs/cern.ch/cms/DB/conddb -a
When using releases before CMSSW 5.2.5, 5.3.0 or 6.0.0.pre4
- Set up the CMSSW environment:
$ cd /path/to/CMSSW
$ cmsenv
- Set one environment variable:
- If you are using (t)csh:
$ setenv TNS_ADMIN /afs/cern.ch/cms/DB/conddb
- If you are using bash:
$ export TNS_ADMIN=/afs/cern.ch/cms/DB/conddb
- Now you can connect to ORACLE, e.g. for listing the IOV tags of a schema
$ cmscond_list_iov -c oracle://cms_orcon_adg/[schemaname] -P /afs/cern.ch/cms/DB/conddb -a
Access from CMS pit on .cms network
Development
Service |
Access Mode |
Connect String |
Auth Path |
direct oracle |
read-only |
oracle://cms_orcoff_prep/[schemaname] |
/nfshome0/popcondev/conddb |
direct oracle |
read-write |
oracle://cms_orcoff_prep/[schemaname] |
/nfshome0/popcondev/conddb |
Integration
Service |
Access Mode |
Connect String |
Auth Path |
direct oracle |
read-only |
oracle://cms_orcoff_int/[schemaname] |
/nfshome0/popcondev/conddb |
direct oracle |
read-write |
oracle://cms_orcoff_int/[schemaname] |
/nfshome0/popcondev/conddb |
Online Integration
Service |
Access Mode |
Connect String |
Auth Path |
direct oracle |
read-only |
oracle://cmsintr_lb/[schemaname] |
/nfshome0/popcondev/conddb |
direct oracle |
read-write |
oracle://cmsintr_lb/[schemaname] |
/nfshome0/popcondev/conddb |
Production
Service |
Access Mode |
Connect String |
Auth Path |
frontier |
siteless-read-only (allowed within .cms network) |
frontier://(proxyurl=http://localhost:3128)(serverurl=http://localhost:8000/FrontierOnProd)(serverurl=http://localhost:8000/FrontierOnProd)(retrieve-ziplevel=0)(failovertoserver=no)/[schemaname] |
None |
direct oracle |
read-only (allowed to .cms group 'onlinedb' ) |
oracle://cms_orcon_prod/[schemaname] |
/nfshome0/popcondev/conddb |
direct oracle |
read-write (allowed to group 'onlinedb' ) |
oracle://cms_orcon_prod/[schemaname] |
/nfshome0/popcondev/conddb |
Please use direct ORACLE access only for operational issues: ORACLE online DB and online frontier servlets are critical for data taking. If you want to look at condition datasets in details, please use carefully offline ORACLE access, or offline frontier.
Review Status
Responsible:
ZhenXie
Last reviewed by: Reviewer