方法一：直接在连接池中输入连接信息
将tnsname.ora里配置的连接信息等号后面的字符串去掉空格和换行符即可)
(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.48.112)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = PDBORCL)))
方法二: 使用tnsname.ora的情况
tnsname.ora(手工编辑或者从Oracle服务器拷贝)
PDBORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.48.112)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PDBORCL)
)
)
Admin tool需要知道此tnsname.ora的路径，分两种情况
2.1 为OBIEE server自带的BI Admin Tool配置数据源
(For the Admin Tool installed with the complete OBIEE server installation)
使用windows上安装BIEE自带的Admin tool连接数据源，直接复制上面的tnsname.ora到BIEE自带的Oracle客户端目录即可(C:\Oracle\OracleBIEE11g\Oracle_BI1\network\admin)
2.2 为单独安装的BIEE客户端中的Admin Tool配置数据源
(For the Admin Tool installed with the new standalone installer)
1、 从Oracle服务器复制tnsnames.ora到任意目录，比如E:\network\admin
2、 在%OBIEE_Client_Home% \oraclebi\orahome\bifoundation\server\bin\bi_init.bat添加下面一行，指定tnsnames.ora 的路径
例如：C:\Software\Oracle Business Intelligence Enterprise Edition Plus Client Tools\oraclebi\orahome\bifoundation\server\bin\bi_init.bat
set TNS_ADMIN=C:\network\admin
参考文档
http://allappsdba.blogspot.com/2013/05/obiee-11g-client-admin-tool-connection.html
原文：http://www.cnblogs.com/xqzt/p/4827103.html
| 
转播
