MOSAIC安装完成后的配置

MOSAIC安装完成后的配置文件与系统配置1.把当前sysman.cfg复制到d:\usr\mosaic\bin2.把当前services文件夹复制到d:\usr\mosaic3.复制当前FileDistrib文件夹到D:\usr\mosaic4.如果恢复WebServer(画面服务器)：需要复制最新备份中的SchematicRepository、Schematics文件夹到D:\usr\mosaic5.共享usr文件夹并设置可读写6.修改d:\usr\mosaic\bin下的mosaicenv文件#Schematicsexport SCHEM_REPOSITORY_ROOT=\\\\WebServer\\usr\\mosaic\\SchematicRepository 7.修改C:\WINDOWS\system32\drivers\etc下的hosts文件，添加内容如下192.168.20.2 Server1192.168.20.4 Server2192.168.20.6 WebServer192.168.20.8 scada-pc01192.168.20.10 scada-pc02192.168.20.12 scada-pc03192.168.20.14 scada-pc048.添加用户名添加系统用户与mosaic中对应，当前Mosaic中添加的有Administrator、op1,engineer,web1等等，之后应该是实名登陆。

9.设置mosaic启动我的电脑→属性→管理→服务和应用程序→服务→mosaic startup→属性→登陆→选择此账户账户名：administrator密码:mosaic(当前)然后去d:\usr\mosaic\bin中把dispatcher_core.exedispatcher_event.exedispatcher_histsvr.exedispatcher_scada.exedispatcher_trans.exe这个文件删除，如果删不掉，到dos下面删除，如del d:\usr\mosaic\bin\dispatcher_core.exe10.关闭系统防火墙重起后打开进程看，Dispatcher是否起来，等到server_ready这个进程消失，右下角出现“MOSAIC is NOW available”后点击来运行mosaic。

1.Bulkloadingtool注意事项确保是offline数据表存放路径中不能有中文，例如d:\tmp\xx.xls建议倒点前备份一下数据库倒点步骤1.倒入Equip建议分批导入2.倒入点举例说明需导入以及修改的语句1.INSERTING LOCATIONS#INSERTING LOCATIONSinsert into LocationT (Name, ScadaCluster) values ("氧气厂采集站", (ScadaCluster where Name = "Gas"));2.INSERTING EQUIPMENT#INSERTING EQUIPMENTinsert into EquipT (Desig, Description, PlantId, Plant, Location, Network) values ("天然气总管", "", "", (Plant where Name = "总管"), (Location where Name = "氧气厂采集站" and ScadaCluster:Name = "Gas"), (Network where Name = "Gas"));3.INSERTING ANALOGUE POINTS#INSERTING ANALOGUE POINTSinsert into AnaT (Equip, Quantity, InActive, Hd, InitCondition, ManualClearAlarm, AlarmDisable, PasswordProtected, CoefficientW, CoefficientX, CoefficientY, EngMax, EngMin, ZeroClamp, ZeroClampIsPercent, AltId) values((Equip where Desig = "1.8MPa送炼钢氧气总管" and Plant:Name = "总管" and Location:Name = "氧气厂采集站" and Location:ScadaCluster:Name = "Gas" and Network:Name = "Gas"), (Quantity where Name = "总管流量" and Plant:Name = "总管"), 0, 0, 0, 0, 0, 0, 0, 0, 0, 60000, 0, 0, 0, "HO_4087_FT3006");4.INSERTING DNP RTUS倒出后语句#INSERTING DNP RTUSinsert into DnpRtuT (Name, Addr, Location, Model, ProtocolGroup, PrimaryIPAddr, PrimaryUDPPort, SecondaryIPAddr, SecondaryUDPPort, DnpLevel, Critical, FullScanRate, CosScanRate, SendUnsolEnable, ScanRetries, FailureTimeout, ScanAfterControl, InitDataScanTmo, DisableDLResets, InhibitPolls) values ("G_YCQ", 1, (Location where Name = "氧气厂采集站" and ScadaCluster:Name = "Gas"), (Model where Name = ""), (ProtocolGroup where Name = "Dnp_Gas"), "", , "", , , , , , , , , , , , );修改后语句#INSERTING DNP RTUSinsert into DnpRtuT (Name, Addr, Location, ProtocolGroup) values ("G_YCQ", 1, (Location where Name = "氧气厂采集站" and ScadaCluster:Name = "Gas"), (ProtocolGroup where Name = "Dnp_Gas"));5.INSERTING DNP MODULES#INSERTING DNP MODULESinsert into DnpModuleT (DACUnit, Address, Modtype, Slot, Chassis, Cubicle, DIU, AccumType) values ((DACUnit where Name = "G_YCQ" and Location:Name = "氧气厂采集站" and Location:ScadaCluster:Name = "Gas"), 0, (DnpModuleType where Name = "fpm 102"), 0, 0, 0, 0, 0);6.Inserting Analog倒出后语句insert into DnpAchanT (Rmin, Rmax, Rtol, Deadband,Number, Point, IOGroup) values (0, 0, 0, 0, 0, (Point where Quantity:Name = "总管流量" and Quantity:Plant:Name = "总管" and Equip:Equip.Desig = "1.8MPa送炼钢氧气总管" and Equip:Plant:Name = "总管" and Equip:Location:Name = "氧气厂采集站" and Equip:Location:ScadaCluster:Name = "Gas" and Equip:Network:Name = "Gas"), (DnpModule where Address = 0 and DACUnit:Name = "G_YCQ" and DACUnit:Location:Name = "氧气厂采集站" and DACUnit:Location:ScadaCluster:Name = "Gas" and Modtype:Name = "fpm 102"));修改后语句insert into DnpFchanT ( Number, Point, IOGroup) values ( 0, (Point where Quantity:Name = "总管流量" and Quantity:Plant:Name = "总管" and Equip:Equip.Desig = "1.8MPa送炼钢氧气总管" and Equip:Plant:Name = "总管" and Equip:Location:Name = "氧气厂采集站" and Equip:Location:ScadaCluster:Name = "Gas" and Equip:Network:Name = "Gas"), (DnpModule where Address = 0 and DACUnit:Name = "G_YCQ" and DACUnit:Location:Name = "氧气厂采集站" and DACUnit:Location:ScadaCluster:Name = "Gas" and Modtype:Name = "fpm 102"));7.INSERTING CONTROL CHANNELS倒出后语句#INSERTING CONTROL CHANNELSinsert into DnpOchanT (Rmin, Rmax, Number, Point, IOGroup, DnpControlType) values (0, 0, 0, (Point where Quantity:Name = "累计重置" and Quantity:Plant:Name = "总管" and Equip:Equip.Desig = "1#转炉氧枪氧气总管" and Equip:Plant:Name = "总管" and Equip:Location:Name = "12#转炉采集站" and Equip:Location:ScadaCluster:Name = "Gas" and Equip:Network:Name = "Gas"), (DnpModule where Address = 0 and DACUnit:Name = "G_12ZLCJZ" and DACUnit:Location:Name = "12#转炉采集站" and DACUnit:Location:ScadaCluster:Name = "Gas" and Modtype:Name = "dom 102"),(DnpControlType where Code=));修改后语句#INSERTING CONTROL CHANNELSinsert into DnpOchanT ( Number, Point, IOGroup) values ( 0, (Point where Quantity:Name = "累计重置" and Quantity:Plant:Name = "总管" and Equip:Equip.Desig = "1#转炉氧枪氧气总管" and Equip:Plant:Name = "总管" and Equip:Location:Name = "12#转炉采集站" and Equip:Location:ScadaCluster:Name = "Gas" and Equip:Network:Name = "Gas"), (DnpModule where Address = 0 and DACUnit:Name = "G_12ZLCJZ" and DACUnit:Location:Name = "12#转炉采集站" and DACUnit:Location:ScadaCluster:Name = "Gas" and Modtype:Name = "dom 102"));8.INSERTING IEC104 MODULES#INSERTING IEC104 MODULESinsert into IEC104ModuleT (ModuleName,ModuleAddress,DACUnit,ModuleType,OnLineIntPoll,OnLineCountPoll,OnLi neClockSync,EOInitIntPoll,EOInitCountPoll,EOInitClockSync,ExpectActTermSPCmd,Ex pectActTermCmd) values ("FULLDATA1",1,(DACUnit where Name = "E_YQC_35kV" and Location:Name = "氧气厂35kV变电站" and Location:ScadaCluster:Name = "Electricity"),(ModuleType where Name="aim"),1,0,0,1,0,0,0,0);9.INSERTING IEC104 DIGITAL CHANNELS#INSERTING DIGITAL CHANNELSinsert into IEC104DchanT (Aux, Invert, Number, Point, IOGroup) values (0, 0, 1, (Point where Quantity:Name = "合分闸位置" and Quantity:Plant:Name = "断路器" and Equip:Equip.Desig = "1AH1_3#主变1TM3" and Equip:Plant:Name = "断路器" and Equip:Location:Name = "氧气厂35kV变电站" and Equip:Location:ScadaCluster:Name = "Electricity" and Equip:Network:Name = "Electricity"), (IEC104Module where ModuleAddress = 1 and DACUnit:Name = "E_YQC_35kV" and DACUnit:Location:Name = "氧气厂35kV变电站" and DACUnit:Location:ScadaCluster:Name = "Electricity"));10.INSERTING IEC104 ANALOGUE CHANNELS#INSERTING ANALOGUE CHANNELSinsert into IEC104AchanT (Rmin, Rmax, Rtol, Deadband, Number, Point, IOGroup) values (0, 0, 0, 0, 16385, (Point where Quantity:Name = "电流IA" and Quantity:Plant:Name = "线路" and Equip:Equip.Desig = "1AH1_3#主变1TM3" and Equip:Plant:Name = "线路" and Equip:Location:Name = "氧气厂35kV变电站" and Equip:Location:ScadaCluster:Name = "Electricity" and Equip:Network:Name = "Electricity"),(IEC104Module where ModuleAddress = 1 and DACUnit:Name = "E_YQC_35kV" and DACUnit:Location:Name = "氧气厂35kV变电站" andDACUnit:Location:ScadaCluster:Name = "Electricity"));11.INSERTING IEC104 Control CHANNELSinsert into IEC104OchanT (Number, Point, IOGroup,IEC104ControlType) values (2817,(Point where Quantity:Name ="合闸_分闸操作" and Quantity:Plant:Name = "断路器" and Equip:Desig = "1#进线635_1AH" and Equip:Plant:Name = "断路器" and Equip:Location:Name ="新三泵站高压室" and Equip:Location:ScadaCluster:Name = "Electricity" and Equip:Network:Name = "Electricity Network"), (IEC104Module where ModuleAddress = 86 and DACUnit:Name = "EMCC_3BZ_DL" and DACUnit:Location:Name = "新三泵站高压室" and DACUnit:Location:ScadaCluster:Name = "Electricity" and ModuleType:Name = "aim"), (IEC104ControlTypeT where code = 4));12.更新变量名update AnaT set AltId="W-FI-3224" where AltId="W-FI-3220";13.删除整个区域的数据dql scada master;delete from AnaT where Equip:Location:Name="";delete from EquipT where Location:Name="";上述蓝色字体的是需要修改的，其他如bearer、plant、quantity等可以在电脑上建立。