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)))
分享到:
相关推荐
BIEE11g连接Oracle数据库&BIEE11g连接Essbase
biee11g架构,有助于新手系统的了解Biee11g
BIEE11g使用手册
BIEE 11G在linux下的安装、配置、启动及基本使用
BIEE 11G安装教程手册,内附详细安装步骤以及安装环境要求
BIEE11g语言选择项,减少语言选择项,多语言支持。
BIEE11g培训资料(中文) 全中文的!!!!
该文档详细介绍了ORACLE BIEE11G的安装过程,截图详细,步骤详细。
BIEE11G Oracle Linux 安装 配置
BIEE 11g 常见问题 整合版 biee如何实现下钻逻辑维,biee的许多功能实现 还有权限问题等
ORACLE BIEE11G安装步骤-王思力.pdf
BIEE配置ODBC连接impala BIEE配置ODBC连接impala BIEE配置ODBC连接impala
BIEE11g核心开发人员指南 想学习BIEE人员必读
Oracle BIEE 11G 企业版完全安装文档
非常全面有用的BIEE11G教程,集完整性,权威性,实用性与一体
BIEE 11G 安装详解
BIEE11g_连oracle配置.pdf
BIEE11g安装详细手册,在真实环境中截图
BIEE11G升级文档,从BIEE10升级到BIEE11的过程
Oralce BIEE 10g 升级到BIEE 11g的文档,相当详细。