Question

Cognos framework配置数据源出错

cognos framework 配置数据源，测试成功，选择这个数据源的时候提示TNS:listener was not give the SERVICE_NAME in CONNECT_DATA

Answer 1

cognos不太了解，一直用的FineReport，楼主实在不行可以试试我的。下面是我在百度上搜的答案，希望对你有帮助。
说明：其实上面出现这样的情况是在tnsname.ora中配置错了，将tnsname.ora中的ADDRESS_LIST参数去掉就行了。
最终的tnsname.ora中的配置变为：

[sql] view plaincopy
[oracle@sm2 admin]$ cat tnsnames.ora

sm2 = (
DESCRIPTION = (
ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.137.82)(PORT = 1521)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = sm2)
)
)
这样就行了

验证：

[sql] view plaincopy
[oracle@sm2 admin]$ sqlplus sys/oracle@sm2 as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Tue Jul 29 12:39:45 2014

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>