For OCI 10g/11g and DB2 CLI (Unicode) data sources, provide the name of the data source in the Data Source Name field, then provide a valid user name and password for the data source.
For Oracle Database data sources, the data source name is either a full connect string or a net service name from the tnsnames.ora file. If you enter a net service name, you must ensure that you have set up a tnsnames.ora file within the Oracle Business Intelligence environment, in:
2 个回复
HuHM - 80后IT狗 2016-11-09 回答
赞同来自:
在客户端 D:\Oracle\Middleware\Oracle_Home\domains\bi\config\fmwconfig\bienv\core 目录下() 增加文件tnsnames.ora
内容是
xxxx =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xx.xx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = xxxx)
)
)
即可
官方帮助文档:
For OCI 10g/11g and DB2 CLI (Unicode) data sources, provide the name of the data source in the Data Source Name field, then provide a valid user name and password for the data source.
For Oracle Database data sources, the data source name is either a full connect string or a net service name from the tnsnames.ora file. If you enter a net service name, you must ensure that you have set up a tnsnames.ora file within the Oracle Business Intelligence environment, in:
BI_DOMAIN\config\fmwconfig\bienv\core
闫cc - 被迫学习 2016-11-02 回答
赞同来自: