Database instance access map

Complete: 3

Contents:

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

ServiceSorted ascending 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
  1. Set up the CMSSW environment: 
       $ cd /path/to/CMSSW
   $ cmsenv
  2. 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
  1. Set up the CMSSW environment: 
       $ cd /path/to/CMSSW
   $ cmsenv
  2. Set one environment variable:
    1. If you are using (t)csh: 
       
      $ setenv TNS_ADMIN /afs/cern.ch/cms/DB/conddb
    2. If you are using bash: 
            $ export TNS_ADMIN=/afs/cern.ch/cms/DB/conddb
  3. 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

Editor/Reviewer and date Comments
ZhenXie - 26 Jul 2006 page author
JennyWilliams - 03 Apr 2007 moved page to SWGuide
ZhenXie -10 Apr 2008 rewrite completely
SalvatoreDiGuida - 02-May-2012 changed to ADG
Responsible: ZhenXie
Last reviewed by: Reviewer

This topic: CMSPublic > CMSCommunicationsGroup > CMSCommunicationsProjects > WebHome > SWGuide > SWGuideCondDB > SWGuideORACLEProductionAndDevelopmentDatabaseSetup
Topic revision: r27 - 2012-05-02 - AndreasPfeiffer
 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright &© 2008-2021 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
or Ideas, requests, problems regarding TWiki? use Discourse or Send feedback