cognos,数据源链接测试失败,如何解决?
0
本人使用的环境是win7+cognos8.4+oracle11,按照视频教程一步步操作,在framework,create一个项目然后配置数据源的时候,测试链接失败,失败原因见截图。我也看了很多网上关于测试链接失败的帖子,问题还是无法解决。对于sql*net连接字符串,我也找到了:
# tnsnames.ora Network Configuration File: E:\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
COGNOS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = cognos)
)
)
LISTENER_COGNOS =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
照理来说也没问题。可是就是连接不上。但是在cognos configuration中的IBM COGNOS CONTENT STORE中测试链接是成功的。但是user id and password和database naem (cm)这些个是默认的。
希望天山上的童姥们帮我解决下这个问题,万分感谢!!!
# tnsnames.ora Network Configuration File: E:\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
COGNOS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = cognos)
)
)
LISTENER_COGNOS =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
照理来说也没问题。可是就是连接不上。但是在cognos configuration中的IBM COGNOS CONTENT STORE中测试链接是成功的。但是user id and password和database naem (cm)这些个是默认的。
希望天山上的童姥们帮我解决下这个问题,万分感谢!!!
没有找到相关结果
重要提示:提问者不能发表回复,可以通过评论与回答者沟通,沟通后可以通过编辑功能完善问题描述,以便后续其他人能够更容易理解问题.
2 个回复
梁勇 - 天道酬勤、上善若水。爱好商业智能 2014-08-27 回答
赞同来自:
matoidwang - 人不行,别怪脚下路不平 2014-08-27 回答
赞同来自: