NCV5实施顾问技术环境备查手册NCV5实施顾问技术环境备查手册...............................................................................................1第一章：NCV5安装手册...............................................................................................................8序言：......................................................................................................................................8一：安装WebSphere6.1ApplicationServer(WAS).................................................................91：启动WAS安装程序，进入安装界面.......................................................................92：指定安装路径...........................................................................................................113:选择创建WAS环境的类型（概要文件类型）........................................................114：设置was管理用户名与密码...................................................................................125：进入安装总结，进行安装。...................................................................................126：安装完成..................................................................................................................137：进行安装验证...........................................................................................................148：WAS打补丁：.........................................................................................................16二．安装NC5.0.....................................................................................................................19三：NC50+WAS进行设置....................................................................................................221：如果WAS启动了安全管理：.................................................................................222：执行安装目录下NC_HOME\bin\wasSysConfig.bat...............................................233：添加数据源..............................................................................................................234：Server设置...............................................................................................................235：设置日志级别以及输出策略...................................................................................246：License检查.............................................................................................................257：服务设置界面...........................................................................................................258：消息设置界面...........................................................................................................269：系统登录相关配置设置...........................................................................................2610：WAS路径、部署设置...........................................................................................2711：验证部署成功.........................................................................................................28第二章：NC＋WAS集群安装说明案例文档..............................................................................30安装步骤概述：....................................................................................................................30第一部分：Was集群安装部分.............................................................................................301：两台机器was的安装。...........................................................................................312：node加入dm。........................................................................................................313：HTTPserver的安装。..............................................................................................324：Plugin的安装。.......................................................................................................335：补丁配置。..............................................................................................................356：集群的创建与配置。...............................................................................................357：web服务器加入Dm中............................................................................................36第二部分：NC的安装配置..................................................................................................361：在was中删除原有的NC应用，并重启was：.....................................................362：运行wasSysConfig工具，进行数据源配置..........................................................373：在工具左边列表中选择Server，然后在右边点击从WAS读取：......................394：如图在工具左边列表中选择Deployment，然后在右边点击读取，选择WasImformation面版.....................................................................................................405：如果此was安装时启用了安全用户名与密码，需要运行nchome/bin/wasImportCert.bat,做安全证书导入。..........................................................................416：如果没有生成ejb；还得在Deployment对应的右边面板中，点击生成EJB。.417：生成完ejb后，点击部署EJB。对应信息可以看日志was_sysConfig.log。在部署的过程中必须保证was中应用服务器是启动的.............................................................418:主服务器与从服务器代码在部署后需要同步。（文件复制得模式）..................41第三部分：NC＋WAS集群的部署......................................................................................411：启动管理页面，进入应用程序，验证NC50已经启动成功。............................412：手工做好虚拟主机映射：.......................................................................................423：将NC50关联到WebServer：.................................................................................434：在web服务器中生成插件并传播插件：...............................................................445：重启was...................................................................................................................446：做过相关修改配置的时候记得在系统管理－》节点－》做节点同步...............447：验证：......................................................................................................................44第三章：NC应用中WAS管理控制台日常管理........................................................................45一：WAS启动与关闭...........................................................................................................451：DM的启动与关闭...................................................................................................452：Node的启动与关闭.................................................................................................463：Server的启动与关闭...............................................................................................46二：WAS日志管理...............................................................................................................461：DM日志...................................................................................................................462：Node日志.................................................................................................................463：Server日志...............................................................................................................46三：WAS管理控制台中进行配置管理................................................................................471：应用服务器ServerJVM参数管理..........................................................................472：Server端口修改管理...............................................................................................513：应用程序查看与相关配置管理...............................................................................544：集群查看与相关配置...............................................................................................585：数据源查看与相关配置...........................................................................................606：启用安全性管理.......................................................................................................62第四章：NC客户端相关设置手册..............................................................................................64一：客户端浏览器java插件参数设置：.............................................................................64二：需要启用NC登录界面中的压缩传输功能..................................................................66三：根据客户实际情况，可以考虑启用并初始化客户端数据缓存.................................67四：NC客户端程序启用说明.............................................................................................69五：客户端浏览器访问NC不能走代理模式......................................................................71六:浏览器属性->常规中-》Internet临时文件-》设置中选择每次访问时刷新................72第五章：NC数据库日常恢复备份手册......................................................................................73一、Db2数据库.....................................................................................................................731.1通过db2backup与db2restore进行备份与恢复..................................................731.1.1备份数据库...........................................................................................................731.1.2恢复数据库...........................................................................................................731.1.3backuprestore使用情况说明............................................................................731.1.4备份恢复一例:......................................................................................................741.2db2move的备份恢复...............................................................................................741.2.1执行db2move命令导出数据..............................................................................741.2.2执行db2move命令导出数据..............................................................................751.2.3执行db2look命令导出数据结构创建语句（即表、试图等的创建语句）.....761.2.4NC产品通过db2move备份恢复一例:...............................................................77二、oracle数据库的备份与恢复..........................................................................................802.1导出(exp)和导入(imp)实用程序.............................................................................802.2exp的用法................................................................................................................802.2.1导出工具exp交互式命令方式............................................................................802.2.2非交互式命令行方式............................................................................................802.2.2.1全库备份............................................................................................................812.2.2.2用户备份和单表备份.........................................................................................812.2.3BUFFER................................................................................................................832.2.4FILE和LOG参数................................................................................................832.2.5FILESIZE设置导出的数据文件的大小............................................................842.3imp用法...................................................................................................................842.3.1FROMUSER和TOUSER...........................................................................................842.3.2导入一个完整数据库.........................................................................................852.3.3导入一个或一组指定用户所属的对象.............................................................852.3.4导入一个表.........................................................................................................852.4EXPDP和IMPDP使用说明...................................................................................862.5数据泵导出导入与传统导出导入的区别...............................................................862.6expdp用法................................................................................................................862.6.1expdp参数..........................................................................................................862.6.2expdp实例..........................................................................................................892.6.2.1导出表............................................................................................................902.6.2.2导出方案.........................................................................................................912.6.2.3导出表空间.....................................................................................................912.6.2.4导出数据库.....................................................................................................912.7IMPDP参数.............................................................................................................922.8IMPDP用法.............................................................................................................932.8.1导入表..................................................................................................................932.8.2导入方案............................................................................................................942.8.3导入表空间.........................................................................................................942.8.4导入数据库.........................................................................................................94三、Sqlserver的备份与恢复................................................................................................953.1数据库的备份...........................................................................................................953.1.1设置数据库服务器的监听.................................................................................953.1.2数据库的备份.....................................................................................................953.2数据库的恢复...........................................................................................................963.2.1还原数据库.........................................................................................................963.3数据库的分离与附加...............................................................................................983.3.1数据库的分离........................................................................................................983.3.2数据库的附加........................................................................................................98四、数据库的参数................................................................................................................994.1ORACLE的参数配置说明：..................................................................................994.2db2的参数配置说明：............................................................................................99五、oracle数据库连接池....................................................................................................100六、Oracle数据库临时表空间和临时表...........................................................................1016.1临时表空间补足或占磁盘空间过大问题解决.....................................................1016.2临时表....................................................................................................................101七、数据库警告日志位置...................................................................................................102oracle数据库................................................................................................................102db2数据库日志的位置................................................................................................103sqlserver的日志位置..................................................................................................103第六章：NC日常维护之unix常用命令介绍............................................................................104一：nc安装步骤中涉及的unix命令.................................................................................104二：nc部署步骤中涉及的unix命令.................................................................................104三：nc文件备份..................................................................................................................105四：NC使用中涉及unix命令详细说明............................................................................105第七章：NC外网问题测试及优化方案....................................................................................107前言：..................................................................................................................................107一：NC在网络中经常遇到的问题....................................................................................107二：NC对网络的质量要求很高........................................................................................107三：网络相关术语与知识：...............................................................................................108四：NC网络信息收集方案................................................................................................1091：NC常用节点使用速度调查表：..........................................................................1092：分子公司网络信息调查表.....................................................................................1103：测试脚本：.............................................................................................................111五：测试网络小工具及其他方法：...................................................................................1131：直接测试客户端从应用服务器下载的速度：.....................................................1132：ping测试MTU.......................................................................................................1133：测试并调整MTU的工具......................................................................................113六：NC网络优化建议方案................................................................................................115（一）；专线组网方式...............................................................................................115（二）：总部电信、网通专线，分部企业级ADSL（或ADSL+VPN）...............116（三）：Citrix远程终端方式:....................................................................................117第八章：实施中与效率相关之业务规范...................................................................................119一：自定义查询：...............................................................................................................119二：总账..............................................................................................................................119三：固定资产计提..............................................................................................................120四：报表设计......................................................................................................................121五：报表计算......................................................................................................................121六：外部交换平台：...........................................................................................................122第九章：NC系统日常维护手册................................................................................................1231:NC系统ORACLE数据库备份和恢复............................................................................1231.1:Windows环境ORACLE备份：.........................................................................1231.2:UNIX环境下的备份..............................................................................................1231.3:Windows环境ORACLE数据恢复.....................................................................1231.4:UNIX环境oracle数据恢复.................................................................................1242:NC系统MSSQL2005数据库备份和恢复.....................................................................1242.1:备份........................................................................................................................1242.2:恢复........................................................................................................................1273:NC系统代码和IBMWEBSPHERE的备份和恢复.......................................................1313.1:备份........................................................................................................................1313.2:恢复........................................................................................................................1314::ORACLE数据库环境恢复一个测试帐套......................................................................1314.1:创建一个新的oracle用户，名称为nctest........................................................1314.2:启动was中间件,运行\bin\wassysconfig.bat,datasource—添加---确定—保存......................................................................................................................................1324.3:生成EJB步骤:deployment---选择twostep---selectall–generate..........1334.4:部署EJB步骤:deployment–selectall–deploy...........................................1334.5:创建一个新帐套步骤:在ie浏览器输入中间件服务器IP-‘账套’处选择‘系统管理’—用户名为root---登录..............................................................................1344.6:账套管理--增加-数据源处选择nctest---保存...................................................1344.7:修改帐套信息........................................................................................................1374.8:帐套系统管理root的密码错误3次，帐号即被销定........................................1384.9:建立帐套步骤增加-数据源处选择nctest---保存...........................................1395:安装License过程.............................................................................................................1416:NC系统的启动和停止.....................................................................................................1436.1:启动........................................................................................................................1436.2:停止........................................................................................................................1447:怎样打补丁.......................................................................................................................1447.1:代码补丁................................................................................................................1447.2:Oracle更新数据库补丁方法................................................................................1477.3sqlserver更新数据库补丁..................................................................................1548:系统的卸载.......................................................................................................................1559:安装JDK1.6兼容使用.....................................................................................................15510:程序出错时，提交问题给用友公司的注意事项..........................................................15611:怎样补安装一个模块......................................................................................................15612:哪些位置的补丁需要重新部署......................................................................................16013:从was环境copy代码，并且使用用友中间件时,不能启动的问题解决....................16014:设置后台日志的方式.....................................................................................................16215.was集群环境重新部署后，访问NC首页界面时，出现IBMhttpserver页面........16316.NC系统LINUX环境常用命令.....................................................................................16417.NC502wassyconfig.bat-deployment-generate-deploy后生成IBMUTC应用(正确应该为nc50)，系统无法访问.....................................................................................................16618.使用IE浏览器访问NC时，客户端的设置注意事项..................................................167第十章：NC常见环境问题........................................................................................................169WAS+部署常见问题：........................................................................................................1691：安装WAS时需要注意事项...................................................................................1692：NC502部署时出现IBMUTC应用.......................................................................1693：WindowsServer2008上安装WAS后补丁打不上问题........................................1694：APACHE访问出错问题........................................................................................1705：HTTPServer的80端口访问慢问题......................................................................1726:Was启动时乱码且关闭不了问题............................................................................1727:32位操作系统之广西某项目WAS宕机问题.........................................................1738:WAS安装不了问题..................................................................................................1759:如果主机名被更改,was的运行与访问可能会出现问题........................................17510:was集群模式下NC部署不成功问题:..................................................................17511:NC成功部署到集群后通过浏览器访问出现的是ibmhttpserver的页面...........17512:NC部署后访问页面是ibmhttpserver页面...........................................................17613:WAS集群环境NC登陆页面很长时间才出来.....................................................17614:WAS日志中出现内存溢出....................................................................................17715:有关功能异常,日志中出现无法从jndi找到相关模块或资源............................17716:集群模式部署时部分应用服务器，ear包中的jar没有拷贝全...........................17717:集群模式部署后进行集群映射到其他服务器过程中无法映射成功：..............17718:AIX主机添加内存后，应用服务器再无法正常启动:.........................................17819:主机名中不能包含下划线等特殊字符:.................................................................17820:将was安装盘从widows下上传到unix，无法正常安装:...................................17821:NC501标准版无法部署到was6107上:.................................................................17922:NC＋WAS集群时主机名...
