Oracle 安装 略过!!!
create tablespace rep_data nologging
datafile ‘D:\APP\ORADATA\ORCL\rep_data.dbf’ size 512m
autoextend on next 20M MAXSIZE 30g
extent management local segment space management auto;
create user domain_user identified by oracle default tablespace rep_data temporary tablespace temp;
create user rep_user identified by oracle default tablespace rep_data temporary tablespace temp;
grant dba to domain_user,rep_user;
create tablespace BI_ETL datafile ‘D:\APP\ORADATA\ORCL\BI_ETL.dbf’
size 512M reuse autoextend on next 20M;
2:创建 域用户 并分配权限,用来管理域
create user bi_domain identified by bi_domain
default tablespace bi_etl temporary tablespace temp
profile default account unlock;
grant connect to bi_domain;
grant dba to bi_domain;
grant resource to bi_domain;
grant unlimited tablespace to bi_domain;
grant select any table to bi_domain;
alter user bi_domain default role all;
3:创建 资源用户 并分配权限
create user bi_resource identified by bi_resource
default tablespace bi_etl temporary tablespace temp
profile default account unlock;
grant connect to bi_resource;
grant dba to bi_resource;
grant resource to bi_resource;
grant unlimited tablespace to bi_resource;
grant select any table to bi_resource;
alter user bi_resource default role all;
-===== orale 数据库 相关的准备工作===
create tablespace rep_data nologging
datafile ‘E:\APP\ORADATA\ORCL\DATAFILE\rep_data.dbf’ size 1024m
autoextend on next 100M MAXSIZE 30g
extent management local segment space management auto;
create user domain_user identified by oracle default tablespace rep_data temporary tablespace temp;
create user rep_user identified by oracle default tablespace rep_data temporary tablespace temp;
grant dba to domain_user,rep_user;
或是
grant connect,resource,create view to rep_user,domain_user;
tnsname 文件 添加 如下的内容
orcl =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = joy-PC)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
===== 创建练习 用户====
create tablespace PC_TRAINING nologging
datafile ‘E:\APP\ORADATA\ORCL\PC_TRAINING.dbf’ size 512m
autoextend on next 20M MAXSIZE 30g
extent management local segment space management auto;
Create User bi_ods Identified By bi_ods
Default Tablespace PC_TRAINING Temporary Tablespace temp
Profile Default Account Unlock ;
Grant Connect To bi_ods ;
Grant Dba To bi_ods ;
Grant Resource To bi_ods ;
Grant Unlimited Tablespace To bi_ods ;
Grant Select Any Table To bi_ods ;
Alter User bi_ods Default Role All;
Create User bi_edw Identified By bi_edw
Default Tablespace PC_TRAINING Temporary Tablespace temp
Profile Default Account Unlock ;
Grant Connect To bi_edw ;
Grant Dba To bi_edw ;
Grant Resource To bi_edw ;
Grant Unlimited Tablespace To bi_edw ;
Grant Select Any Table To bi_edw ;
Alter User bi_edw Default Role All;
Create User bi_dm Identified By bi_dm
Default Tablespace PC_TRAINING Temporary Tablespace temp
Profile Default Account Unlock ;
Grant Connect To bi_dm ;
Grant Dba To bi_dm ;
Grant Resource To bi_dm ;
Grant Unlimited Tablespace To bi_dm ;
Grant Select Any Table To bi_dm ;
Alter User bi_dm Default Role All;
================= informatica client 安装 ===========
================== informatica server 安装============