XXX项目部署文档.doc

XXX项目部署文档一、 安装数据库软件并建立实例1、安装数据库软（win32_11gR1_database.rar）2、单独搭建实例（XXDB）二、 建对应的表空间、用户1、 搭建必要的表空间CREATE TABLESPACE TBS_XXX1DATAFILE F:apporadata TBS_XXX1.DBF SIZE 1024M AUTOEXTEND ON;CREATE TABLESPACE TBS_XXX2DATAFILE E:apporadata TBS_XXX2.DBF SIZE 1024M AUTOEXTEND ON;CREATE TABLESPACE TBS_XXX3DATAFILE F:apporadataPLM_TEST1.DBF SIZE 2048M AUTOEXTEND ON;CREATE TEMPORARY TABLESPACE TBS_XXX4TEMPFILE E:apporadata TBS_XXX3.dbf SIZE 500M AUTOEXTEND ON;2、 建立用户CREATE USER USER_XXX1 IDENTIFIED BY USER_XXX1 DEFAULT TABLESPACE TBS_XXX1 temporary tablespace TEMP;Grant Dba To USER_XXX1;- Create the user create user USER_XXX2 identified by USER_XXX2 default tablespace TBS_XXX2 temporary tablespace TEMP;grant dba to USER_XXX1;grant unlimited tablespace to USER_XXX1;create user USER_XXX3 identified by USER_XXX3 default tablespace TBS_XXX2 temporary tablespace TEMP;grant create session to USER_XXX3 with USER_XXX1 option;create user USER_XXX4 identified By USER_XXX4 default tablespace TBS_XXX2 temporary tablespace TEMP;grant create session to USER_XXX4 with USER_XXX1 option;3、 通过系统管理员角色授权grant select on USER_XXX1.ASN_DETAIL to USER_XXX1;grant select on USER_XXX1.ASN_HEAD to USER_XXX1;grant select on USER_XXX1.CGDD_DETAIL to USER_XXX1;grant select on USER_XXX1.CGDD_HEAD to USER_XXX1;grant select on USER_XXX1.SHDD to USER_XXX1;grant select, insert, update on USER_XXX1.DEPARTMENT to USER_XXX1;grant select on USER_XXX1.DEPARTMENT_ID_SEQ to USER_XXX1;grant select, insert, update on USER_XXX1.ERP_PO_VENDOR to USER_XXX1;grant select, insert, update on USER_XXX1.GET_LOG to USER_XXX1;grant select, insert, delete on USER_XXX1.ITEM to USER_XXX1;grant select on USER_XXX1.ITEM_ID_SEQ to USER_XXX1;grant select, insert on USER_XXX1.ITEM_STRUCT to USER_XXX1;grant select on USER_XXX1.ITEM_STRUCT_ID_SEQ to USER_XXX1;grant select, insert, update on USER_XXX1.JHY to USER_XXX1;grant select on USER_XXX1.JHY_ID_SEQ to USER_XXX1;grant insert on USER_XXX1.JPEI_PLAN to USER_XXX1;grant select on USER_XXX1.JPEI_PLAN_ID_SEQ to USER_XXX1;grant insert on USER_XXX1.JSHENG_JUN_PLAN to USER_XXX1;grant select on USER_XXX1.JSHENG_JUN_PLAN_ID_SEQ to USER_XXX1;grant insert on USER_XXX1.JSHENG_PLAN to USER_XXX1;grant select on USER_XXX1.JSHENG_PLAN_ID_SEQ to USER_XXX1;grant insert on USER_XXX1.JSHI_PLAN to USER_XXX1;grant select on USER_XXX1.JSHI_PLAN_ID_SEQ to USER_XXX1;grant insert on USER_XXX1.JZHUAN_PLAN to USER_XXX1;grant select on USER_XXX1.JZHUAN_PLAN_ID_SEQ to USER_XXX1;grant insert on USER_XXX1.MANUPLAN to USER_XXX1;grant select on USER_XXX1.MANUPLAN_ID_SEQ to USER_XXX1;grant select, insert, update on USER_XXX1.MATERIAL to USER_XXX1;grant select on USER_XXX1.MATERIAL_ID_SEQ to USER_XXX1;grant insert on USER_XXX1.SUPPLIER_LIST2 to USER_XXX1;grant select on USER_XXX1.SUPPLIER_SEQ to USER_XXX1;grant select on USER_XXX1.SUPP_INVENTORY to USER_XXX1;grant select, insert, update on USER_XXX1.USERS to USER_XXX1;grant insert on USER_XXX1.VEHICLE_STRUCT to USER_XXX1;grant select on USER_XXX1.VEHICLE_STRUCT_ID_SEQ to USER_XXX1;grant select, insert, delete on USER_XXX1.USER_XXX2_KC to USER_XXX1;grant select on USER_XXX1.USER_XXX2_KC_ID_SEQ to USER_XXX1;grant insert, delete on USER_XXX1.USER_XXX2_MATERIAL to USER_XXX1;grant select on USER_XXX1.USER_XXX2_MATERIAL_ID_SEQ to USER_XXX1;grant insert on USER_XXX1.ZPEI_PLAN to USER_XXX1;grant select on USER_XXX1.ZPEI_PLAN_ID_SEQ to USER_XXX1;grant select, insert, update on USER_XXX1.ZZJGUSER to USER_XXX1;grant select on USER_XXX1.ZZJG_USER to USER_XXX1;grant select on USER_XXX1.ASN_H_INTER_OUT to USER_XXX2;grant select on USER_XXX1.ASN_L_INTER_OUT to USER_XXX2;grant select on USER_XXX1.PO_H_INTER_OUT to USER_XXX2;grant select on USER_XXX1.PO_L_INTER_OUT to USER_XXX2;grant select on USER_XXX1.ASN_H_INTER_OUT to USER_XXX3;grant select on USER_XXX1.ASN_L_INTER_OUT to USER_XXX3;grant select on USER_XXX1.SQ_IF_SCM_MATER_BOM to USER_XXX3;grant select on USER_XXX1.SQ_IF_SCM_MATER_USE_NUM to USER_XXX3;三、 将XXX数据文件（*.dbf）导入1、导入数据Imp user/passwdnet_name full=y buffer=1024000000 ignore=y file=USER_XXX1-scmdemo-exp-alluser.dmp log=sqdb.log四、 检查导入情况并编译无效对象1、先建立find_invalid_object.sql,将下面内容存入SETfeedbackOFFSETheadingOFFSETlinesize1000SETpagesize0SETpauseOFFSETtrimspoolONSETverifyOFFspool exec_pare.sql;SELECTalter |object_type| |owner|.|object_name| compile;FROMall_objectsWHEREstatus =INVALIDANDobject_typein (FUNCTION,JAVA SOURCE,JAVA CLASS,PROCEDURE,PACKAGE,TRIGGER);SELECTalter package |owner|.|object_name| compile body;FROMall_objectsWHEREstatus =INVALIDANDobject_type =PACKAGE BODY;spoolOFF;当执行完find_invalid_object.sql脚本后，会生成exec_pare.sql脚本2、再运行tmp.sql脚本SQL exec_pare.sql五、 搭建Tomcate服务1、 现在装JDKjdk-6u10-rc2-bin-b32-windows-i586-p-12_sep_2008.exe2、 安装Tomcat安装apache-tomcat-6.0.16.exe文件，注意：端口号不要与本机的其他软件端口发生冲突，我这里用的8001,（默认8080）。3、配置环境变量将” C:Program FilesJavajdk1.6.0_10bin”JDK路径放入环境变量path里面并用分号隔开。六、 部署应用并配置数据库连接1、 部署源码将源码解压后放入Tomcate目录：C:Program FilesApache Software FoundationTomcat 6.0webapps下，按项目起个名字，这我用的是XMMC。2、 配置数据库连接编辑C:Program FilesApac