/
githubmirror
/
cmssw
Обзор
Документация
Войти
/
githubmirror
/
cmssw
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
CondTools/SiStrip/test/Documentation/OracleDBAProcedure_Strip
106 строк
4 KB
Giulio Eulisse
Snapshot of CMSSW_6_2_0_pre8.
26 июн 2013, 18:12
26 июн 2013, 18:12
214ab73
Код
Авторство
О чём код?
## ## To create mapping descriptions, if not already defined here ## rm -f SiStripPedestals-mapping-default.xml pool_build_object_relational_mapping -f mapping-template-SiStripPedestals.xml -o SiStripPedestals-mapping-default.xml -d CondFormatsSiStripObjects -c sqlite_file:pippo.db -b -u whoever -p whatever rm -f pippo.db cp SiStripPedestals-mapping-default.xml SiStripPedestals-mapping-custom.xml ###################### rm -f SiStripNoises-mapping-default.xml pool_build_object_relational_mapping -f mapping-template-SiStripNoises.xml -o SiStripNoises-mapping-default.xml -d CondFormatsSiStripObjects -c sqlite_file:pippo.db -b -u whoever -p whatever rm -f pippo.db cp SiStripNoises-mapping-default.xml SiStripNoises-mapping-custom.xml ########################### rm -f SiStripFedCabling-mapping-default.xml pool_build_object_relational_mapping -f mapping-template-SiStripFedCabling.xml -o SiStripFedCabling-mapping-default.xml -d CondFormatsSiStripObjects -c sqlite_file:pippo.db -b -u whoever -p whatever rm -f pippo.db cp SiStripFedCabling-mapping-default.xml SiStripFedCabling-mapping-custom.xml ###################### rm -f SiStripBadStrip-mapping-default.xml pool_build_object_relational_mapping -f mapping-template-SiStripBadStrip.xml -o SiStripBadStrip-mapping-default.xml -d CondFormatsSiStripObjects -c sqlite_file:pippo.db -b -u whoever -p whatever rm -f pippo.db cp SiStripBadStrip-mapping-default.xml SiStripBadStrip-mapping-custom.xml ###################### rm -f SiStripModuleHV-mapping-default.xml pool_build_object_relational_mapping -f mapping-template-SiStripModuleHV.xml -o SiStripModuleHV-mapping-default.xml -d CondFormatsSiStripObjects -c sqlite_file:pippo.db -b -u whoever -p whatever rm -f pippo.db cp SiStripModuleHV-mapping-default.xml SiStripModuleHV-mapping-custom.xml ################################## # OBSOLETE PART ###################### ## edit SiStrip*-mapping-custom.xml change to meaningful names ###################################### ## start DBA procedure: ## build real table in oracle db setenv TNS_ADMIN /afs/cern.ch/project/oracle/admin pool_build_object_relational_mapping -f SiStripPedestals-mapping-custom.xml -d CondFormatsSiStripObjects -c oracle://devdb10/CMS_COND_STRIP -u CMS_COND_STRIP -p strip_cern200603 -debug >! SiStripPedestals.debug pool_build_object_relational_mapping -f SiStripNoises-mapping-custom.xml -d CondFormatsSiStripObjects -c oracle://devdb10/CMS_COND_STRIP -u CMS_COND_STRIP -p strip_cern200603 -debug >! SiStripNoises.debug pool_build_object_relational_mapping -f SiStripFedCabling-mapping-custom.xml -d CondFormatsSiStripObjects -c oracle://devdb10/CMS_COND_STRIP -u CMS_COND_STRIP -p strip_cern200603 -debug >! SiStripFedCabling.debug pool_build_object_relational_mapping -f mapping-template-CondIOV-default.xml -d CondCoreIOVService -c oracle://devdb10/CMS_COND_STRIP -u CMS_COND_STRIP -p strip_cern200603 -o CondIOV-mapping-default.xml -debug >! SiStripCondIOV.debug ##################################################### ## NOT NEEDED ANYMORE ##to get create statements for DBA record: ##grep CREATE *.debug > SiStripschema.debug ##clean up SiStripschema.debug and replace CMS_XIEZHEN_DEV by SiStrip schema name ## NOT NEEDED ANYMORE ################################################################### ## also change the GRANT SELECT according to setup (still not implemented, do it ) ##sqlplus CMS_COND_STRIP/strip_cern200603@devdb10 < grants.sql ## add extra TIME column to the payload tables sqlplus CMS_COND_STRIP/strip_cern200603@devdb10 < addSiStripPayloadTime.sql ## create METADATA table sqlplus CMS_COND_STRIP/strip_cern200603@devdb10 < createMetaDataTable.sql ## create catalog tables setenv POOL_OUTMSG_LEVEL D FCregisterPFN -p pippo -u relationalcatalog_oracle://devdb10/CMS_COND_STRIP -t POOL_RDBMS > &catalog.debug grep CREATE catalog.debug ########################################## ## To remove all tables in CMS_COND_STRIP sqlplus CMS_COND_STRIP/strip_cern200603@devdb10 < clear.sql ## #########################################