XXX项目部署文档一、安装数据库软件并建立实例1、安装数据库软(win32_11gR1_database.rar)2、单独搭建实例(XXDB)二、建对应的表空间、用户1、搭建必要的表空间CREA TE TABLESPACE TBS_XXX1DA TAFILE 'F:\app\oradata\ TBS_XXX1.DBF' SIZE 1024M AUTOEXTEND ON;CREA TE TABLESPACE TBS_XXX2DA TAFILE 'E:\app\oradata\ TBS_XXX2.DBF' SIZE 1024M AUTOEXTEND ON;CREA TE TABLESPACE TBS_XXX3DA TAFILE 'F:\app\oradata\PLM_TEST1.DBF' SIZE 2048M AUTOEXTEND ON;CREA TE TEMPORARY TABLESPACE TBS_XXX4TEMPFILE 'E:\app\oradata\ TBS_XXX3.dbf' SIZE 500M AUTOEXTEND ON;2、建立用户CREA TE USER USER_XXX1 IDENTIFIED BY USER_XXX1DEFAULT TABLESPACE TBS_XXX1temporary tablespace TEMP;Grant Dba To USER_XXX1;-- Create the usercreate user USER_XXX2 identified by USER_XXX2default tablespace TBS_XXX2temporary tablespace TEMP;grant dba to USER_XXX1;grant unlimited tablespace to USER_XXX1;create user USER_XXX3 identified by USER_XXX3default tablespace TBS_XXX2temporary tablespace TEMP;grant create session to USER_XXX3 with USER_XXX1 option;create user USER_XXX4 identified By USER_XXX4default tablespace TBS_XXX2temporary 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.MA TERIAL to USER_XXX1;grant select on USER_XXX1.MA TERIAL_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_ERS 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_ER_XXX2_KC to USER_XXX1; grant select on USER_ER_XXX2_KC_ID_SEQ to USER_XXX1;grant insert, delete on USER_ER_XXX2_MA TERIAL to USER_XXX1; grant select on USER_ER_XXX2_MA TERIAL_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_MA TER_BOM to USER_XXX3;grant select on USER_XXX1.SQ_IF_SCM_MA TER_USE_NUM to USER_XXX3;三、将XXX数据文件(*.dbf)导入1、导入数据Imp user/passwd@net_name full=y buffer=1024000000 ignore=y file='USER_XXX1-scmdemo-exp-alluser.dmp' log='sqdb.log'四、检查导入情况并编译无效对象1、先建立find_invalid_object.sql,将下面内容存入SET feedback OFFSET heading OFFSET linesize 1000SET pagesize 0SET pause OFFSET trimspool ONSET verify OFFspool exec_pare.sql;SELECT'alter '||object_type||' '||owner||'.'||object_name||' compile;'FROM all_objectsWHERE status = 'INVALID'AND object_type in('FUNCTION','JAVA SOURCE','JAVA CLASS','PROCEDURE','PACKAGE','TRIGGER');SELECT'alter package '||owner||'.'||object_name||' compile body;'FROM all_objectsWHERE status = 'INVALID'AND object_type = 'PACKAGE BODY';spool OFF;当执行完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)。