OracleUpgradeTestPlan < Sandbox

%TOC{title="Contents:"}%
---++ Introduction
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 11.2.0.3 to 11.2.0.4 of Oracle RDBMS.
The proposed date is *Thursday February 27th, from 8:00 to 12:00 CET*. See HN announcement [[https://hypernews.cern.ch/HyperNews/CMS/get/database/1274.html][HERE]].

Please note that Oracle version 11.2.0.4 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 11.2.0.4. It's hard to define a validation procedure for all the services, but in general it would be:
   * for those services deployed in cmsweb-dev.cern.ch or cmsweb-testbed.cern.ch 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.
   1. 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 |
| ^ | Prod | CMSR | ^ | NA | NA |
|DBS3| Dev | int2r | Yuyi / Manuel (?) | NA | DB Upgraded in Dec 2013 |
| ^ | Preprod | int2r | ^ | NA | DB Upgraded in Dec 2013 |
| ^ | Prod | CMSR (CMS_DBS) | ^ | NA | NA |
|DMWM| (?) | CMSR (CMS_DMWM_MON) | (?) | NA | NA |
|^| (?) | CMSR (CMS_DMWM_MON) | (?) | 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 |
| ^ | Prod | CMSR (CMS_REQMGR) | ^ | 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 |
| ^ | Prod | CMSR | ^ | NA | NA |
|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 cms-comp-ops@cernSPAMNOT.ch
   * 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 cms-comp-ops@cernSPAMNOT.ch

blah
-- Main.AlanMalta - 17 Feb 2014
Topic revision: r5 - 2014-02-20 - LuisLinares
Account
- Log In
- Cern Search
- TWiki Search
- Google Search
Sandbox All webs
Edit
Attach
Copyright &© 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