大数据清洗、转换工具——ETL工具概述_etl工具的主要功能_javastart的博客-CSDN博客

账号密码Scott321  Tiger321  

administrator   infa_domain

DATAFILE 文件路径自我选择

--临时表空间，若不创建会使用默认的临时表空间
CREATE TEMPORARY TABLESPACE BI_ETL_TMP  
TEMPFILE 'F:\APP\TKHYWANG\ORADATA\ORCLCDB\info_data_tmp.dbf' 
SIZE 50M  
AUTOEXTEND ON  
NEXT 50M MAXSIZE 20480M  
EXTENT MANAGEMENT LOCAL;  
--数据表空间
CREATE TABLESPACE BI_ETL 
DATAFILE 'F:\APP\TKHYWANG\ORADATA\ORCLCDB\info_data.dbf'          --表空间名
SIZE 500M                                                    --大小
AUTOEXTEND ON                                            --自动扩展
NEXT 50M MAXSIZE 2048M                        --每次扩展50M
EXTENT MANAGEMENT LOCAL;
--注：数据存放位置、空间大小等根据实际情况灵活配置。

安装前配置好hosts文件。(位置：C:\Windows\System32\drivers\etc)

可以cmd输入 hostname 获取主机名

 有报错

问题解决截图

 改成普通模式

有报错

 删除重建后换成这个连接成功

https://www.freesion.com/article/41441145462/

https://blog.csdn.net/qq_42611537/article/details/122076963

创建存储库服务时：代码页选的是GB2312 ，对应的codepage是936；

最终我换成

集成服务和存储服务创建成功

CREATE TEMPORARY TABLESPACE BI_ETL_TMP  
TEMPFILE 'F:\APP\TKHYWANG\ORADATA\ORCLCDB\info_data_tmp.dbf' 
SIZE 50M  
AUTOEXTEND ON  
NEXT 50M MAXSIZE 20480M  
EXTENT MANAGEMENT LOCAL;  


CREATE TABLESPACE BI_ETL 
DATAFILE 'F:\APP\TKHYWANG\ORADATA\ORCLCDB\info_data.dbf'          --表空间名
SIZE 500M                                                    --大小
AUTOEXTEND ON                                            --自动扩展
NEXT 50M MAXSIZE 2048M                        --每次扩展50M
EXTENT MANAGEMENT LOCAL;



CREATE USER BI_DATAANALYZER
IDENTIFIED BY PASSWD 
DEFAULT TABLESPACE BI_ETL 
TEMPORARY TABLESPACE BI_ETL_TMP PROFILE DEFAULT ACCOUNT UNLOCK;
--赋权
GRANT CONNECT TO BI_DATAANALYZER;
GRANT DBA TO BI_DATAANALYZER;
GRANT RESOURCE TO BI_DATAANALYZER;
GRANT UNLIMITED TABLESPACE TO BI_DATAANALYZER;
GRANT SELECT ANY TABLE TO BI_DATAANALYZER;
GRANT CREATE ANY VIEW TO BI_DATAANALYZER;
ALTER USER BI_DATAANALYZER DEFAULT ROLE ALL;


CREATE USER BI_METADATA
IDENTIFIED BY PASSWD 
DEFAULT TABLESPACE BI_ETL 
TEMPORARY TABLESPACE BI_ETL_TMP PROFILE DEFAULT ACCOUNT UNLOCK;
--赋权
GRANT CONNECT TO BI_METADATA;
GRANT DBA TO BI_METADATA;
GRANT RESOURCE TO BI_METADATA;
GRANT UNLIMITED TABLESPACE TO BI_METADATA;
GRANT SELECT ANY TABLE TO BI_METADATA;
GRANT CREATE ANY VIEW TO BI_METADATA;
ALTER USER BI_METADATA DEFAULT ROLE ALL;



--Create User BI_ODS
create user bi_ods				--用户名
	identified by bi_ods		--密码
DEFAULT TABLESPACE BI_ETL 
TEMPORARY TABLESPACE BI_ETL_TMP PROFILE DEFAULT ACCOUNT UNLOCK;

--Grant/Revoke role privileges
grant connect to bi_ods;
grant dba to bi_ods;
grant resource to bi_ods;

--Grant/Revoke system privileges
grant unlimited tablespace to bi_ods;





--Create User BI_EDW
create user bi_edw
	identified by bi_edw
DEFAULT TABLESPACE BI_ETL 
TEMPORARY TABLESPACE BI_ETL_TMP PROFILE DEFAULT ACCOUNT UNLOCK;


--Grant/Revoke role privileges
grant connect to bi_edw;
grant dba to bi_edw;
grant resource to bi_edw;

--Grant/Revoke system privileges
grant unlimited tablespace to bi_edw;