This twiki page aims to map and provide a test plan for all CMS services which rely on central Oracle databases at CERN. This upgrade involves the offline production database (CMSR) from version to of Oracle RDBMS. The proposed date is Thursday February 27th, from 8:00 to 12:00 CET. See HN announcement HERE.

Please note that Oracle version is already available in the integration (INT2R) and development databases (DEVDB11). The integration upgrade happened on Dec 11th.

Validation procedure

The main goal is to validate the services against the INT2R or DEVDB11, since they have already Oracle version It's hard to define a validation procedure for all the services, but in general it would be:
  • for those services deployed in or AND that are pointing already to INT2R or DEVDB11, they could be used for this validation
  • or the service responsibles should deploy their service in a VM (or somewhere else) and point it to one of the Oracle instances above.

For the success of these validations, we need to:

  1. simulate as close as possible the production environment, so we can be more confident of the validation results.
  2. the entire responsability of these services rely on the service responsibles listed in the table below.

Table of CMS services relying on Oracle

CMSWEB services
Service name Instance Oracle Instance Responsible Validation status Comments
CRABServer Dev devdb11 Brian B. / Marco M. (?) NA NA
Preprod devdb11 NA NA
DBS3 Dev int2r Yuyi / Manuel (?) NA DB Upgraded in Dec 2013
Preprod int2r NA DB Upgraded in Dec 2013
PhEDEx Dev CMSR (cms_transfermgmt_test) Tony Wildish NA NA
Preprod CMSR (cms_transfermgmt_sc) NA NA
Prod CMSR (cms_transfermgmt) NA NA
ReqMgr Dev devdb11 Seangchan NA NA
Preprod devdb11 NA NA
SiteDB Dev devdb11 Diego G./ Justas/ Alan NA NA
Preprod / Prod CMSR (CMS_SITEDB) NA NA
T0DataSvc (?) CMSR (CMS_T0AST) Dirk NA Not in production (retired?)
T0WMADataSvc (?) int2r Not in production (retired?) DB Upgraded in Dec 2013
Overview Dev/Debug/Prod CMSR (?) Not in production NA
Testbed/Testbed2 int2r_lb (?) DB Upgraded in Dec 2013
Non-CMSWEB services
WMAgent Preprod int2r Alan M. / Seangchan (?) NA DB Upgraded in Dec 2013
DBS2 Prod/General/etc CMSR (CMS_DBS) Dan Riley / Luis Linares NA NA
Prod/etc int2r (CMS_DBS) Passed DB Upgraded in Dec 2013
Test_Global int2r_lb Passed DB Upgraded in Dec 2013
Frontier FrontierArc cmsarc_lb (CMS_COND_FRONTIER_R) Luis Linares Passed NA
Frontier / FrontierProd / FrontierTest cms_orcon_adg (CMS_COND_FRONTIER_R) NA DB To be upgraded in May
PromptProd / PromptTest NA
LumiCalc / LumiProd cms_orcon_adg (CMS_COND_FRONTIER_LUMI_R) NA
FrontierPrep / LumiPrep int2r_lb (CMS_COND_FRONTIER_R) Passed DB Upgraded in Dec 2013
FrontierInt int9r_lb (CMS_COND_FRONTIER_R) NA DB To be upgraded in May

Additional notes:

  • If your service relies on Oracle CMSR instance and it's not present in the table above, please add it yourself and/or contact
  • There are several DBS2 instances and it seems some accounts talk to both production (CMSR) and integration (INT2R) instances (list provided by Luis L.).
  • Frontier is using cms_orcon_adg instead of CMSR.

Validation results

Results should be provided as soon as possible, so we can give or not the green light to Kate D. / DBAs. In case we need to define a date, I'd say which should have all validation results by next Monday Feb 24th. Please add the validation results to the table above (and add comments if you consider important). If we face show-stoppers for this upgrade, then it's better to send an email to

blah -- AlanMalta - 17 Feb 2014

Edit | Attach | Watch | Print version | History: r5 < r4 < r3 < r2 < r1 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r5 - 2014-02-20 - LuisLinares
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    Sandbox All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2023 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