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 Brian B. / Marco M. (?) NA NA
Prod CMSR Brian B. / Marco M. (?) NA NA
DBS3 Dev int2r Yuyi / Manuel (?) NA NA
Preprod int2r Yuyi / Manuel (?) NA NA
Prod CMSR (CMS_DBS) Yuyi / Manuel (?) NA NA
PhEDEx Dev CMSR (cms_transfermgmt_test) Tony Wildish NA NA
Preprod CMSR (cms_transfermgmt_sc) Tony Wildish NA NA
Prod CMSR (cms_transfermgmt) Tony Wildish NA NA
ReqMgr Dev devdb11 Seangchan NA NA
Preprod devdb11 Seangchan NA NA
Prod CMSR (CMS_REQMGR) Seangchan NA NA
SiteDB Dev devdb11 Diego G./ Justas/ Alan NA NA
Preprod / Prod CMSR (CMS_SITEDB) Diego G./ Justas/ Alan NA NA
T0DataSvc (?) CMSR (CMS_T0AST) Dirk NA Not in production (retired?)
T0WMADataSvc (?) int2r Dirk 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
DBS2 Prod/General/etc CMSR (CMS_DBS) Luis L. NA NA
DBS2 Prod/etc int2r (CMS_DBS) Luis L. NA NA
DBS2 Test_Global int2r_lb Luis L. NA NA
Frontier (several instances) cms_orcon_adg (usually) Luis L. NA Not connected to CMSR
WMAgent Preprod int2r Alan M. / Seangchan (?) NA NA
WMAgent Prod CMSR Alan M. / Seangchan (?) 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.).
  • For Frontiers, it seems none of them are using CMSR or INT2R (list provided by Luis L.).

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: r3 - 2014-02-18 - AlanMalta
    • 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