Database instance access map

Complete:

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

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

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