XXX项目部署文档

XXX项目部署文档一、安装数据库软件并建立实例1、安装数据库软（win32_11gR1_database.rar）2、单独搭建实例（XXDB）二、建对应的表空间、用户1、搭建必要的表空间CREATETABLESPACETBS_XXX1DATAFILE'F:\app\oradata\TBS_XXX1.DBF'SIZE1024MAUTOEXTENDON;CREATETABLESPACETBS_XXX2DATAFILE'E:\app\oradata\TBS_XXX2.DBF'SIZE1024MAUTOEXTENDON;CREATETABLESPACETBS_XXX3DATAFILE'F:\app\oradata\PLM_TEST1.DBF'SIZE2048MAUTOEXTENDON;CREATETEMPORARYTABLESPACETBS_XXX4TEMPFILE'E:\app\oradata\TBS_XXX3.dbf'SIZE500MAUTOEXTENDON;2、建立用户CREATEUSERUSER_XXX1IDENTIFIEDBYUSER_XXX1DEFAULTTABLESPACETBS_XXX1temporarytablespaceTEMP;GrantDbaToUSER_XXX1;--CreatetheusercreateuserUSER_XXX2identifiedbyUSER_XXX2defaulttablespaceTBS_XXX2temporarytablespaceTEMP;grantdbatoUSER_XXX1;grantunlimitedtablespacetoUSER_XXX1;createuserUSER_XXX3identifiedbyUSER_XXX3defaulttablespaceTBS_XXX2temporarytablespaceTEMP;grantcreatesessiontoUSER_XXX3withUSER_XXX1option;createuserUSER_XXX4identifiedByUSER_XXX4defaulttablespaceTBS_XXX2temporarytablespaceTEMP;grantcreatesessiontoUSER_XXX4withUSER_XXX1option;3、通过系统管理员角色授权grantselectonUSER_XXX1.ASN_DETAILtoUSER_XXX1;grantselectonUSER_XXX1.ASN_HEADtoUSER_XXX1;grantselectonUSER_XXX1.CGDD_DETAILtoUSER_XXX1;grantselectonUSER_XXX1.CGDD_HEADtoUSER_XXX1;grantselectonUSER_XXX1.SHDDtoUSER_XXX1;grantselect,insert,updateonUSER_XXX1.DEPARTMENTtoUSER_XXX1;grantselectonUSER_XXX1.DEPARTMENT_ID_SEQtoUSER_XXX1;grantselect,insert,updateonUSER_XXX1.ERP_PO_VENDORtoUSER_XXX1;grantselect,insert,updateonUSER_XXX1.GET_LOGtoUSER_XXX1;grantselect,insert,deleteonUSER_XXX1.ITEMtoUSER_XXX1;grantselectonUSER_XXX1.ITEM_ID_SEQtoUSER_XXX1;grantselect,insertonUSER_XXX1.ITEM_STRUCTtoUSER_XXX1;grantselectonUSER_XXX1.ITEM_STRUCT_ID_SEQtoUSER_XXX1;grantselect,insert,updateonUSER_XXX1.JHYtoUSER_XXX1;grantselectonUSER_XXX1.JHY_ID_SEQtoUSER_XXX1;grantinsertonUSER_XXX1.JPEI_PLANtoUSER_XXX1;grantselectonUSER_XXX1.JPEI_PLAN_ID_SEQtoUSER_XXX1;grantinsertonUSER_XXX1.JSHENG_JUN_PLANtoUSER_XXX1;grantselectonUSER_XXX1.JSHENG_JUN_PLAN_ID_SEQtoUSER_XXX1;grantinsertonUSER_XXX1.JSHENG_PLANtoUSER_XXX1;grantselectonUSER_XXX1.JSHENG_PLAN_ID_SEQtoUSER_XXX1;grantinsertonUSER_XXX1.JSHI_PLANtoUSER_XXX1;grantselectonUSER_XXX1.JSHI_PLAN_ID_SEQtoUSER_XXX1;grantinsertonUSER_XXX1.JZHUAN_PLANtoUSER_XXX1;grantselectonUSER_XXX1.JZHUAN_PLAN_ID_SEQtoUSER_XXX1;grantinsertonUSER_XXX1.MANUPLANtoUSER_XXX1;grantselectonUSER_XXX1.MANUPLAN_ID_SEQtoUSER_XXX1;grantselect,insert,updateonUSER_XXX1.MATERIALtoUSER_XXX1;grantselectonUSER_XXX1.MATERIAL_ID_SEQtoUSER_XXX1;grantinsertonUSER_XXX1.SUPPLIER_LIST2toUSER_XXX1;grantselectonUSER_XXX1.SUPPLIER_SEQtoUSER_XXX1;grantselectonUSER_XXX1.SUPP_INVENTORYtoUSER_XXX1;grantselect,insert,updateonUSER_XXX1.USERStoUSER_XXX1;grantinsertonUSER_XXX1.VEHICLE_STRUCTtoUSER_XXX1;grantselectonUSER_XXX1.VEHICLE_STRUCT_ID_SEQtoUSER_XXX1;grantselect,insert,deleteonUSER_XXX1.USER_XXX2_KCtoUSER_XXX1;grantselectonUSER_XXX1.USER_XXX2_KC_ID_SEQtoUSER_XXX1;grantinsert,deleteonUSER_XXX1.USER_XXX2_MATERIALtoUSER_XXX1;grantselectonUSER_XXX1.USER_XXX2_MATERIAL_ID_SEQtoUSER_XXX1;grantinsertonUSER_XXX1.ZPEI_PLANtoUSER_XXX1;grantselectonUSER_XXX1.ZPEI_PLAN_ID_SEQtoUSER_XXX1;grantselect,insert,updateonUSER_XXX1.ZZJGUSERtoUSER_XXX1;grantselectonUSER_XXX1.ZZJG_USERtoUSER_XXX1;grantselectonUSER_XXX1.ASN_H_INTER_OUTtoUSER_XXX2;grantselectonUSER_XXX1.ASN_L_INTER_OUTtoUSER_XXX2;grantselectonUSER_XXX1.PO_H_INTER_OUTtoUSER_XXX2;grantselectonUSER_XXX1.PO_L_INTER_OUTtoUSER_XXX2;grantselectonUSER_XXX1.ASN_H_INTER_OUTtoUSER_XXX3;grantselectonUSER_XXX1.ASN_L_INTER_OUTtoUSER_XXX3;grantselectonUSER_XXX1.SQ_IF_SCM_MATER_BOMtoUSER_XXX3;grantselectonUSER_XXX1.SQ_IF_SCM_MATER_USE_NUMtoUSER_XXX3;三、将XXX数据文件（*.dbf）导入1、导入数据Impuser/passwd@net_namefull=ybuffer=1024000000ignore=yfile='USER_XXX1-scmdemo-exp-alluser.dmp'log='sqdb.log'四、检查导入情况并编译无效对象1、先建立find_invalid_object.sql,将下面内容存入SET

feedback

OFF

SET

heading

OFF

SET

linesize

1000SET

pagesize

0SET

pause

OFF

SET

trimspool

ON

SET

verify

OFF

spoolexec_pare.sql;SELECT

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

FROM

all_objects

WHERE

status=

'INVALID'

AND

object_type

in

('FUNCTION','JAVASOURCE','JAVACLASS','PROCEDURE','PACKAGE','TRIGGER');SELECT

'alterpackage'||owner||'.'||object_name||'compilebody;'

FROM

all_objects

WHERE

status=

'INVALID'

AND

object_type=

'PACKAGEBODY';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）。3、配置环境变量将”C:\ProgramFiles\Java\jdk1.6.0_10\bin”JDK路径放入环境变量path里面并用分号隔开。六、部署应用并配置数据库连接1、部署源码将源码解压后放入Tomcate目录：C:\ProgramFiles\ApacheSoftwareFoundation\Tomcat6.0\webapps下，按项目起个名字，这我用的是XMMC。2、配置数据库连接编辑C:\ProgramFiles\ApacheSoftwareFoundation\Tomcat6.0\webapps\XMMC\WEB-INF目录下applicationContext.xml文件，填写下面的IP、端口、SID、用户名、密码/schema/context/spring-context-2.0.xsd"><beanid="dataSource"class="xool.ProxoolDataSource"><propertyname="alias"value="proxool1"></property><propertyname="driver"value="oracle.jdbc.driver.OracleDriver"></property><propertyname="driverUrl"value="jdbc:oracle:thin:@11:1521:XXDB"></property><propertyname="user"value="USER_XXX1"></property><propertyname="pa