windows系统基于Oracle数据库安装Informatica9.1的安装步骤、连接客户端使用、重启服务
大数据清洗、转换工具——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 --每次扩展50MEXTENT MANAGEMENT LOCAL;--注:数据存放位置、空间大小等根据实际情况灵活配置。
安装前配置好hosts文件。(位置:C:\Windows\System32\drivers\etc)
可以cmd输入 hostname 获取主机名
有报错
问题解决截图
改成普通模式
有报错
删除重建后换成这个连接成功
/article/41441145462/
/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 --每次扩展50MEXTENT MANAGEMENT LOCAL;CREATE USER BI_DATAANALYZERIDENTIFIED 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_METADATAIDENTIFIED 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_ODScreate user bi_ods--用户名identified by bi_ods--密码DEFAULT TABLESPACE BI_ETL TEMPORARY TABLESPACE BI_ETL_TMP PROFILE DEFAULT ACCOUNT UNLOCK;--Grant/Revoke role privilegesgrant connect to bi_ods;grant dba to bi_ods;grant resource to bi_ods;--Grant/Revoke system privilegesgrant unlimited tablespace to bi_ods;--Create User BI_EDWcreate user bi_edwidentified by bi_edwDEFAULT TABLESPACE BI_ETL TEMPORARY TABLESPACE BI_ETL_TMP PROFILE DEFAULT ACCOUNT UNLOCK;--Grant/Revoke role privilegesgrant connect to bi_edw;grant dba to bi_edw;grant resource to bi_edw;--Grant/Revoke system privilegesgrant unlimited tablespace to bi_edw;