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 NA
Preprod int2r NA NA
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 NA Not in production (retired?)
Overview Dev/Debug/Prod CMSR (?) NA Not in production
Testbed/Testbed2 int2r_lb (?) NA Not in production
Non-CMSWEB services
WMAgent Preprod int2r Alan M. / Seangchan (?) NA NA
DBS2 Prod/General/etc CMSR (CMS_DBS) Dan Riley / Luis Linares NA NA
Prod/etc int2r (CMS_DBS) NA NA
Test_Global int2r_lb NA NA
Frontier FrontierArc cmsarc_lb (CMS_COND_FRONTIER_R) Luis Linares NA NA
Frontier / FrontierProd / FrontierTest cms_orcon_adg (CMS_COND_FRONTIER_R) NA NA
PromptProd / PromptTest NA NA
LumiCalc / LumiProd cms_orcon_adg (CMS_COND_FRONTIER_LUMI_R) NA NA
FrontierPrep / LumiPrep int2r_lb (CMS_COND_FRONTIER_R) NA NA
FrontierInt int9r_lb (CMS_COND_FRONTIER_R) NA NA

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 | Raw edit | More topic actions...
Topic revision: r4 - 2014-02-19 - LuisLinares
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    Sandbox All webs login

  • Edit
  • Attach
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