GBUNC技术支持部NCV5X实施&维护顾问技术环境备查手册GBUNC技术支持部目录前言：............................................................................................................................................10第一章：NCV5安装手册.............................................................................................................11序言：.....................................................................................................................................11一：安装WebSphere6.1ApplicationServer(WAS)..............................................................111：启动WAS安装程序，进入安装界面....................................................................112：指定安装路径...........................................................................................................133:选择创建WAS环境的类型（概要文件类型）.......................................................144：设置was管理用户名与密码...................................................................................145：进入安装总结，进行安装。...................................................................................156：安装完成.................................................................................................................157：进行安装验证...........................................................................................................168：WAS打补丁：.........................................................................................................18二．安装NC5.0.....................................................................................................................22三：NC50+WAS进行设置...................................................................................................241：如果WAS启动了安全管理：................................................................................242：执行安装目录下NC_HOME\bin\wasSysConfig.bat..............................................253：添加数据源...............................................................................................................254：Server设置...............................................................................................................265：设置日志级别以及输出策略...................................................................................266：License检查.............................................................................................................277：服务设置界面...........................................................................................................278：消息设置界面...........................................................................................................289：系统登录相关配置设置...........................................................................................2810：WAS路径、部署设置...........................................................................................2911：验证部署成功.........................................................................................................30第二章：NC＋WAS集群安装说明案例文档..............................................................................32安装步骤概述：.....................................................................................................................32第一部分：Was集群安装部分.............................................................................................321：两台机器was的安装。...........................................................................................332：node加入dm。........................................................................................................333：HTTPserver的安装。..............................................................................................344：Plugin的安装。.......................................................................................................355：补丁配置。...............................................................................................................376：集群的创建与配置。...............................................................................................377：web服务器加入Dm中...........................................................................................38第二部分：NC的安装配置..................................................................................................381：在was中删除原有的NC应用，并重启was：....................................................382：运行wasSysConfig工具，进行数据源配置..........................................................393：在工具左边列表中选择Server，然后在右边点击从WAS读取：.....................41GBUNC技术支持部4：如图在工具左边列表中选择Deployment，然后在右边点击读取，选择WasImformation面版.....................................................................................................425：如果此was安装时启用了安全用户名与密码，需要运行nchome/bin/wasImportCert.bat,做安全证书导入。......................................................436：如果没有生成ejb；还得在Deployment对应的右边面板中，点击生成EJB。.........................................................................................................................................437：生成完ejb后，点击部署EJB。对应信息可以看日志was_sysConfig.log。在部署的过程中必须保证was中应用服务器是启动的.........................................................438:主服务器与从服务器代码在部署后需要同步。（文件复制得模式）....................43第三部分：NC＋WAS集群的部署......................................................................................431：启动管理页面，进入应用程序，验证NC50已经启动成功。............................432：手工做好虚拟主机映射：.......................................................................................443：将NC50关联到WebServer：.................................................................................454：在web服务器中生成插件并传播插件：..............................................................465：重启was...................................................................................................................466：做过相关修改配置的时候记得在系统管理－》节点－》做节点同步...............467：验证：.......................................................................................................................46第三章：NC应用中WAS管理控制台日常管理.......................................................................47一：WAS启动与关闭...........................................................................................................471：DM的启动与关闭...................................................................................................472：Node的启动与关闭.................................................................................................483：Server的启动与关闭...............................................................................................48二：WAS日志管理...............................................................................................................481：DM日志...................................................................................................................482：Node日志.................................................................................................................483：Server日志...............................................................................................................48三：WAS管理控制台中进行配置管理...............................................................................491：应用服务器ServerJVM参数管理.........................................................................492：Server端口修改管理...............................................................................................533：应用程序查看与相关配置管理...............................................................................564：集群查看与相关配置...............................................................................................605：数据源查看与相关配置...........................................................................................626：启用安全性管理.......................................................................................................64第四章：NC客户端相关设置手册..............................................................................................66一：客户端浏览器java插件参数设置：............................................................................66二：需要启用NC登录界面中的压缩传输功能.................................................................68三：根据客户实际情况，可以考虑启用并初始化客户端数据缓存.................................69四：NC客户端程序启用说明............................................................................................71五：客户端浏览器访问NC不能走代理模式.....................................................................73六:浏览器属性->常规中-》Internet临时文件-》设置中选择每次访问时刷新..............74第五章：NC数据库日常恢复备份手册......................................................................................75一、Db2数据库.....................................................................................................................751.1通过db2backup与db2restore进行备份与恢复................................................751.1.1备份数据库...........................................................................................................75GBUNC技术支持部1.1.2恢复数据库...........................................................................................................751.1.3backuprestore使用情况说明.........................................................................751.1.4备份恢复一例:.....................................................................................................761.2db2move的备份恢复...............................................................................................761.2.1执行db2move命令导出数据............................................................................761.2.2执行db2move命令导出数据............................................................................771.2.3执行db2look命令导出数据结构创建语句（即表、试图等的创建语句）..781.2.4NC产品通过db2move备份恢复一例:..............................................................79二、oracle数据库的备份与恢复.........................................................................................822.1导出(exp)和导入(imp)实用程序.............................................................................822.2exp的用法................................................................................................................822.2.1导出工具exp交互式命令方式............................................................................822.2.2非交互式命令行方式............................................................................................822.2.2.1全库备份............................................................................................................832.2.2.2用户备份和单表备份........................................................................................832.2.3BUFFER................................................................................................................852.2.4FILE和LOG参数...............................................................................................852.2.5FILESIZE设置导出的数据文件的大小............................................................862.3imp用法...................................................................................................................862.3.1FROMUSER和TOUSER..........................................................................................862.3.2导入一个完整数据库.........................................................................................872.3.3导入一个或一组指定用户所属的对象.............................................................872.3.4导入一个表.........................................................................................................872.4EXPDP和IMPDP使用说明...................................................................................882.5数据泵导出导入与传统导出导入的区别...............................................................882.6expdp用法................................................................................................................882.6.1expdp参数.........................................................................................................882.6.2expdp实例.........................................................................................................912.6.2.1导出表.............................................................................................................922.6.2.2导出方案.........................................................................................................932.6.2.3导出表空间.....................................................................................................932.6.2.4导出数据库.....................................................................................................932.7IMPDP参数.............................................................................................................942.8IMPDP用法.............................................................................................................952.8.1导入表..................................................................................................................952.8.2导入方案.............................................................................................................962.8.3导入表空间.........................................................................................................962.8.4导入数据库.........................................................................................................96三、Sqlserver的备份与恢复................................................................................................973.1数据库的备份..........................................................................................................973.1.1设置数据库服务器的监听.................................................................................973.1.2数据库的备份.....................................................................................................973.2数据库的恢复..........................................................................................................983.2.1还原数据库.........................................................................................................98GBUNC技术支持部3.3数据库的分离与附加............................................................................................1003.3.1数据库的分离......................................................................................................1003.3.2数据库的附加.....................................................................................................100四、数据库的参数...............................................................................................................1014.1ORACLE的参数配置说明：................................................................................1014.2db2的参数配置说明：.........................................................................................101五、oracle数据库连接池....................................................................................................102六、Oracle数据库临时表空间和临时表...........................................................................1036.1临时表空间补足或占磁盘空间过大问题解决....................................................1036.2临时表....................................................................................................................103七、数据库警告日志位置...................................................................................................104oracle数据库................................................................................................................104db2数据库日志的位置................................................................................................105sqlserver的日志位置..................................................................................................105第六章：NC日常维护之unix常用命令介绍..........................................................................106一：nc安装步骤中涉及的unix命令.................................................................................106二：nc部署步骤中涉及的unix命令.................................................................................106三：nc文件备份..................................................................................................................107四：NC使用中涉及unix命令详细说明...........................................................................107第七章：NC外网问题测试及优化方案....................................................................................109前言：...................................................................................................................................109一：NC在网络中经常遇到的问题....................................................................................109二：NC对网络的质量要求很高........................................................................................109三：网络相关术语与知识：...............................................................................................110四：NC网络信息收集方案................................................................................................1111：NC常用节点使用速度调查表：..........................................................................1112：分子公司网络信息调查表.....................................................................................1123：测试脚本：.............................................................................................................113五：测试网络小工具及其他方法：...................................................................................1151：直接测试客户端从应用服务器下载的速度：.....................................................1152：ping测试MTU.......................................................................................................1153：测试并调整MTU的工具......................................................................................115六：NC网络优化建议方案................................................................................................117（一）；专线组网方式.................................................................................................117（二）：总部电信、网通专线，分部企业级ADSL（或ADSL+VPN）................118（三）：Citrix远程终端方式:.....................................................................................119第八章：实施中与效率相关之业务规范...................................................................................121一：自定义查询：...............................................................................................................121二：总账...............................................................................................................................121三：固定资产计提...............................................................................................................122四：报表设计.......................................................................................................................123五：报表计算.......................................................................................................................123六：外部交换平台：...........................................................................................................124第九章：NC系统日常维护手册................................................................................................125GBUNC技术支持部1:NC系统ORACLE数据库备份和恢复...........................................................................1251.1:Windows环境ORACLE备份：........................................................................1251.2:UNIX环境下的备份..............................................................................................1251.3:Windows环境ORACLE数据恢复.....................................................................1251.4:UNIX环境oracle数据恢复.................................................................................1262:NC系统MSSQL2005数据库备份和恢复....................................................................1262.1:备份........................................................................................................................1262.2:恢复........................................................................................................................1293:NC系统代码和IBMWEBSPHERE的备份和恢复......................................................1333.1:备份........................................................................................................................1333.2:恢复........................................................................................................................1334::ORACLE数据库环境恢复一个测试帐套......................................................................1334.1:创建一个新的oracle用户，名称为nctest........................................................1334.2:启动was中间件,运行\bin\wassysconfig.bat,datasource—添加---确定—保存...................................................................................................................................1344.3:生成EJB步骤:deployment---选择twostep---selectall–generate.......1354.4:部署EJB步骤:deployment–selectall–deploy.........................................1354.5:创建一个新帐套步骤:在ie浏览器输入中间件服务器IP-‗账套‘处选择‗系统管理‘—用户名为root---登录....................................................................................1364.6:账套管理--增加-数据源处选择nctest---保存.................................................1364.7:修改帐套信息........................................................................................................1394.8:帐套系统管理root的密码错误3次，帐号即被销定.....................................1404.9:建立帐套步骤增加-数据源处选择nctest---保存.......................................1415:安装License过程.............................................................................................................1436:NC系统的启动和停止.....................................................................................................1456.1:启动........................................................................................................................1456.2:停止........................................................................................................................1467:怎样打补丁.......................................................................................................................1467.1:代码补丁................................................................................................................1467.2:Oracle更新数据库补丁方法...............................................................................1497.3sqlserver更新数据库补丁.................................................................................1568:系统的卸载.......................................................................................................................1579:安装JDK1.6兼容使用....................................................................................................15710:程序出错时，提交问题给用友公司的注意事项..........................................................15811:怎样补安装一个模块......................................................................................................15812:哪些位置的补丁需要重新部署......................................................................................16213:从was环境copy代码，并且使用用友中间件时,不能启动的问题解决...................16214:设置后台日志的方式......................................................................................................16415.was集群环境重新部署后，访问NC首页界面时，出现IBMhttpserver页面......16516.NC系统LINUX环境常用命令.....................................................................................16617.NC502wassyconfig.bat-deployment-generate-deploy后生成IBMUTC应用(正确应该为nc50)，系统无法访问.....................................................................................................16818.使用IE浏览器访问NC时，客户端的设置注意事项.................................................169第十章：NC常见环境问题........................................................................................................171GBUNC技术支持部WAS+部署常见问题：........................................................................................................1711：安装WAS时需要注意事项..................................................................................1712：NC502部署时出现IBMUTC应用.......................................................................1713：WindowsServer2008上安装WAS后补丁打不上问题.......................................1714：APACHE访问出错问题........................................................................................1725：HTTPServer的80端口访问慢问题....................................................................1746:Was启动时乱码且关闭不了问题............................................................................1747:32位操作系统之广西某项目WAS宕机问题........................................................1758:WAS安装不了问题..................................................................................................1779:如果主机名被更改,was的运行与访问可能会出现问题........................................17710:was集群模式下NC部署不成功问题:..................................................................17711:NC成功部署到集群后通过浏览器访问出现的是ibmhttpserver的页面..........17712:NC部署后访问页面是ibmhttpserver页面..........................................................17813:WAS集群环境NC登陆页面很长时间才出来.....................................................17814:WAS日志中出现内存溢出....................................................................................17915:有关功能异常,日志中出现无法从jndi找到相关模块或资源...........................17916:集群模式部署时部分应用服务器，ear包中的jar没有拷贝全..........................17917:集群模式部署后进行集群映射到其他服务器过程中无法映射成功：..............17918:AIX主机添加内存后，应用服务器再无法正常启动:.........................................18019:主机名中不能包含下划线等特殊字符:.................................................................18020:将was安装盘从widows下上传到u...
