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 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.
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
	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@cernSPAMNOTNOSPAMPLEASE.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@cernSPAMNOTNOSPAMPLEASE.ch

blah -- AlanMalta - 17 Feb 2014