NC系统运行环境维护手册V1.1
应用版本：NC211（win2000 server 、AIX4.3.3系统） 数据库版本：oracle8i（不分操作系统平台）；DB2 UDB7.2
咨询服务器 2003-3-10
第一章 应用服务维护 ...................................................................................... 5
1. 安装NC211应用 ................................................................................................... 5
1.1 1.2
WIN2000 server系统上安装 .................................................................. 5 IBM AIX系统上安装 .................................................................................... 5
2. 配置中间件启动参数 ....................................................................................... 6
2.1 可见的中间件参数 ............................................................................................. 6
2.2 可设置的参数列表 ............................................................................................................ 7
2.3 设置方法 ................................................................................................................... 8 2.4 影响性能的参数 ................................................................................................... 9
3. 应用可能出现的问题及解决办法： ................................................... 10
3.1 端口被占用 ........................................................................................................... 10 3.2 登录界面出现，但选择登录公司后无内容显示 ............................ 11 3.3业务操作过程中的错误定位： .................................................................. 11
4.常用的AIX系统管理工具及操作命令 .................................................... 12
4.1 smit(smitty)工具 ........................................................................................... 12 4.2 常用命令 ................................................................................................................. 12
4.2.1 pwd ........................................................................................................................ 12 4.2.2 ls .......................................................................................................................... 12 4.3.3 mkdir ................................................................................................................... 13 4.3.4 rm .......................................................................................................................... 13 4.3.5 cp .......................................................................................................................... 13 4.3.6 mv .......................................................................................................................... 13 4.3.7 find ...................................................................................................................... 13 4.3.8 type ...................................................................................................................... 14 4.3.9 more ...................................................................................................................... 14 4.3.10 ps ........................................................................................................................ 14 4.3.11 kill ................................................................................................................... 14 4.3.12 vi ........................................................................................................................ 15
4.3.13 ftp ...................................................................................................................... 15 4.3.14 chmod ................................................................................................................. 16
第二章 oracle8i数据库维护 ........................................................................ 16 1. 创建数据库 ............................................................................................................... 16
1.1 建库工具 ................................................................................................................. 16 1.2 初始化参数设置 ................................................................................................. 16
1.2.1 shared_pool_size .......................................................................................... 16 1.2.2 db_block_size ................................................................................................. 17 1.2.3 db_block_buffers .......................................................................................... 17 1.2.4 log_buffer ........................................................................................................ 17 1.2.5 large_pool_size ............................................................................................. 18 1.2.6 processes .......................................................................................................... 18 1.2.7 open_cursors .................................................................................................... 18 1.2.8 sort_area_size sort_area_retained_size ........................................ 18 1.2.9 共享服务模式（多线程服务） .................................................................... 18
2.管理表空间及数据文件 ...................................................................................... 19 3. 管理回滚段 ............................................................................................................... 19 4. 管理用户表 ............................................................................................................... 19 5. 使用索引 ..................................................................................................................... 20 6. Exp/Imp(导出/导入) ......................................................................................... 22
第三章 DB2 通用数据库系统管理 ........................................................... 22
1、创建数据库 ........................................................................................................................... 22 1.1创建数据库 ....................................................................................................................... 22 1.2表空间管理 ....................................................................................................................... 23 1.2.1系统管理表空间（SMS） ........................................................................................ 23 1.2.2数据库管理表空间（DMS） ................................................................................... 23 1.3 Buffer Pool管理 ............................................................................................................... 24 2、实例和数据库的参数配置 ................................................................................................... 25 2.1参数概述 ........................................................................................................................... 25 2.2主要参数说明： ............................................................................................................... 26
3．数据移动 ............................................................................................................................... 27 3.2 EXPORT ..................................................................................................................... 27 3.3 IMPORT ...................................................................................................................... 27 4、备份和恢复 ........................................................................................................................... 28 4.1备份 ................................................................................................................................... 28 4.1.1、................................................................................................................................. 28 4.1.2、命令行操作 ............................................................................................................. 28 4.1.3、注意事项 ................................................................................................................. 28 4.2恢复 ................................................................................................................................... 29 4.2.1、................................................................................................................................. 29 4.2.2、命令行操作 ............................................................................................................. 29
第四章 客户端维护 .................................................................................................. 29 1. 客户端经常出现的问题 ................................................................................... 29 2. 对客户端的配置要求 ......................................................................................... 29 3. 对客户端Java plug_in的调整 ............................................................... 29
第五章 网络维护 ........................................................................................................ 30 1. 网络设置调整 .......................................................................................................... 30 2. 网络设备配置要求 .............................................................................................. 30
第一章 应用服务维护
1. 安装NC211应用
WIN2000 server系统上安装
NC211在WIN2000 server系统下的安装因较为简单，请参见安装盘中附带的install.html文件中说明。
IBM AIX系统上安装
a. 安装jdk1.3.1 for AIX4.3.3
安装NC211之前我们要确认AIX4.3.3系统下安装的jdk版本为1.3.1。如何知道当前jdk的版本在AIX“控制台”或telnet窗口中输入： java –fullversion命令，系统会将jdk完整的版本信息打印出来。如果当前jdk版本不对，可以从新的AIX4.3.3安装盘或IBM网站上下载获得jdk131安装（jdk131.rte）文件集。
利用AIX系统自带的smitty 工具来进行jdk131的安装，在AIX“控制台”或telnet窗口中输入：smitty按以下步骤选择：
Software Installation and Maintenance->Install and Update Software-> Install and Update from LATEST Availabel Software 在 INPUT device/directory for software 项目中输入jdk131.rte所在的路径后回车确认，系统会自动将jdk131安装到系统。 b. 为AIX4.3.3系统安装IBM-eucCN语言环境
在AIX“控制台”或telnet窗口中输入：smitty按以下步骤选择： System Environments->Manage Language Environment->Add Additional Language Environments 选择 IBM-eucCN 安装。这个安装过程需要AIX4.3.3安装盘的支持。 c. 安装NC211