XXX项目部署文档

XXX项目部署文档

一、 安装数据库软件并建立实例

1、安装数据库软（win32_11gR1_database.rar）

2、单独搭建实例（XXDB）

二、 建对应的表空间、用户

1、 搭建必要的表空间

CREATE TABLESPACE TBS_XXX1

DATAFILE 'F:\\app\\oradata\\ TBS_XXX1.DBF' SIZE 1024M AUTOEXTEND ON;

CREATE TABLESPACE TBS_XXX2

DATAFILE 'E:\\app\\oradata\\ TBS_XXX2.DBF' SIZE 1024M AUTOEXTEND ON;

CREATE TABLESPACE TBS_XXX3

DATAFILE 'F:\\app\\oradata\\PLM_TEST1.DBF' SIZE 2048M AUTOEXTEND ON;

CREATE TEMPORARY TABLESPACE TBS_XXX4

TEMPFILE 'E:\\app\\oradata\\ 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/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 OFF

SET heading OFF

SET linesize 1000

SET pagesize 0

SET pause OFF

SET trimspool ON

SET verify OFF

spool exec_pare.sql;

SELECT 'alter '||object_type||' '||owner||'.'||object_name||' compile;'

FROM all_objects

WHERE status = 'INVALID'

AND object_type in

('FUNCTION','JAVA

CLASS','PROCEDURE','PACKAGE','TRIGGER');

SOURCE','JAVA

SELECT 'alter package '||owner||'.'||object_name||' compile body;'

FROM all_objects

WHERE 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、 现在装JDK

jdk-6u10-rc2-bin-b32-windows-i586-p-12_sep_2008.exe

2、 安装Tomcat

安装apache-tomcat-6.0.16.exe文件，注意：端口号不要与本机的其他软件端口发生冲突，我这里用的8001,（默认8080）。

3、配置环境变量

将” C:\\Program Files\\Java\\jdk1.6.0_10\\bin”JDK路径放入环境变量path里面并用分号隔开。

六、 部署应用并配置数据库连接

1、 部署源码

将源码解压后放入Tomcate目录：C:\\Program Files\\Apache Software Foundation\\Tomcat 6.0\\webapps下，按项目起个名字，这我用的是XMMC。

2、 配置数据库连接

编辑C:\\Program Files\\Apache Software Foundation\\Tomcat 6.0\\webapps\\ XMMC\\WEB-INF目录下applicationContext.xml文件，填写下面的IP、端口、SID、用户名、密码

http://www.springframework.org/schema/context/spring-context-2.0.xsd\">

class=\"org.logicalcobwebs.proxool.ProxoolDataSource\">

id=\"dataSource\"

value=\"oracle.jdbc.driver.OracleDriver\">

name=\"driver\"

value=\"jdbc:oracle:thin:@192.168.0.111:1521:XXDB\">

七、 登录地址访问

1、 在IE中输入http://localhost:8081/XMMC/地址就可以登录了。

地址里包含IP、端口、项目名称（就是部署源码时在webapps目录下的文件夹名称）。