XXX项目部署文档.docVIP

XXX项目部署文档 安装数据库软件并建立实例 1、安装数据库软（win32_11gR1_database.rar） 2、单独搭建实例（XXDB） 建对应的表空间、用户 搭建必要的表空间 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; 建立用户 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; 通过系统管理员角色授权 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.J