biee11g无法连接数据源的问题

最新推荐文章于 2021-08-04 13:33:19 发布

原创最新推荐文章于 2021-08-04 13:33:19 发布 · 309 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#Oracle

BIEE 专栏收录该内容

2 篇文章

订阅专栏

从BIEE 10g升级到11g时，由于软件内捆绑了Oracle客户端，导致连接数据库的方式发生变化。文章介绍了两种解决方法：一是复制tnsnames.ora文件到指定目录；二是直接使用完整的tnsname配置。

This is a behaviour change when we move from 10g to 11g. In BI EE 10g, there was no Oracle Client bundled along with BI EE. So, BI EE will use your Oracle DB Home client to connect to the database. Generally no issues in that case. But in BI EE 11g, the software itself contains the 11.2 DB client. So, when you try to connect to the database through the Repository or BI Server, it will try to find the tnsnames entry in the Oracle Client of BI EE 11g instead of your database. There are 2 options to work around this

1. Copy your tnsnames.ora to {Oracle_BI1}\network\admin directory & {oracle_common}\network\admin directory (only the former is needed as that is the ORACLE_HOME)

2. Or instead of tnsnames.ora source entry, use the full expanded tnsnames as shown below

(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.66.173)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = orcl)))