oracle用制御系ー

DATALOGGINGSYSTEMFORLINACOPERATIONUSINGORACLEDATABASER.Kato1,A),S.KashiwagiA),T.YamamotoA),S.SuemineA),G.IsoyamaA)A)InstituteofScientificandIndustrialResearch,OsakaUniversity8-1Mihogaoka,Ibaraki,Osaka,567-0047AbstractThecomputercontrolsystem,whichwascomposedofProgrammableLogicControllersandPersonalComputers,wasintroducedintotheL-bandlinacattheInstituteofScientificandIndustrialResearch,OsakaUniversity.Lastyear,thedataloggingsystembasedontheOraclewasaddedtothecontrolsystem,andisusedforthewatchingoftheextraordinaryconditionoftheequipmentsandtheautomaticproductionoftheoperationdailyreport.OracleCNT1-DCSPCGW-SVROP-PCKLY-MODSHPB1-PSSHPB3-PSHUBFL-netEthernetIL-DCSLNC2-DCS-14DB-SVRIL-PCHUBLNC1-DCSHUBOpticalLinacRoomKlystronRoomControlRoomControlRoomPCPCPCPLCPLCPLCPLCPLCPLCPLCDB-SVR1E-mail:[e-mail]1978L1981MELCOM70/40[1]PersonalComputerPCFEL20LRF[2][3](PLC)(PC)[4]PCEthernetPLCFL-netPCEthernetPCPCPC2.1DB-SVRProceedingsofthe1stAnnualMeetingofParticleAcceleratorSocietyofJapanandthe29thLinearAcceleratorMeetinginJapan(August4-6,2004,FunabashiJapan)498//BASICRS232CRS485I/OGP-IBFL-netEthernetGW-SVRDB-SVRDCS(PLC)EthernetOP-PCEthernetPC(DB-SVR)PCL1OperatorPC(OP-PC)FL-netEthernetGatewayServer(GW-SVR)DeviceControlStation(DCS)DCSFL-netFL-netDB-SVROP-PCGW-SVROP-PCOracle2.2DB-SVR2DCSDIADCI/OBASICDCSFL-netFL-netGW-SVRFL-netGP-IBDB-SVROP-PCUDPDB-SVRDB-SVROP-PC3.1LFL-netDCSON/OFFRFON/OFFOP-PCGW-SVRLProceedingsofthe1stAnnualMeetingofParticleAcceleratorSocietyofJapanandthe29thLinearAcceleratorMeetinginJapan(August4-6,2004,FunabashiJapan)499LVONMODHVONGUNHVONLVONMODHVONGUNHVONLVONMODHVONGUNHVON3.2OP-PCLLVONSQLINSERTINTOLVOFFLVOFFSQLUPDATEONLVONGUNMODON/OFFONONONLVONONLVONHVOFFLVOFFL()[1]T.Hori,S.Takeda,K.Tsumori,T.YamamotoandN.Kimura,“Real-TimeDataLoggingSystemfortheOsakaUniversitySingleBunchElectronLinearAccelerator”,Proceedingsofthe6thMeetingonLinearAcceleratorinJapan,Sapporo,July27-29,1981,pp.162-166.[2]G.Isoyama,etal.,“RemodellingoftheL-bandLinacatISIR,OsakaUniversity”,Proceedingsofthe27thLinearAcceleratorMeetinginJapan,Kyoto,Aug.7-9,2002,pp.115-117.[3]etal.,L,Proceedingsofthe28thLinearAcceleratorMeetinginJapan,Tokai,Jul.30-Aug.1,2003,pp.51-53.[4]etal.,FL-netPLC,Proceedingsofthe28thLinearAcceleratorMeetinginJapan,Tokai,Jul.30-Aug.1,2003,pp.461-463.Proceedingsofthe1stAnnualMeetingofParticleAcceleratorSocietyofJapanandthe29thLinearAcceleratorMeetinginJapan(August4-6,2004,FunabashiJapan)500