参数配置相信初学者都可以按照提示配置完成 但往往在Test Connection 时得到的却是失败
本人初学Cognos 也碰到这种情况,花了整整一上午的时间来查阅资料都无果
最后想起 之前安装rcu及等多次无法连接上数据库时 大部分都是通过修改监听器配置解决的
于是,按照之前的方式将listener.ora,tnsnames.ora 中HOST 修改成本机IP,并在Cognos Configuration-->Content Manager 将Database Server and port number 也修改成本机IP:1521
果然 再Test Connection时已是Succeed了!!!
附 listener.ora
# listener.ora Network Configuration File: C:/oracle11g/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:/oracle11g/product/11.2.0/dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:/oracle11g/product/11.2.0/dbhome_1/bin/oraclr11.dll")
)
(SID_DESC =
(GLOBAL_DBNAME = orcldb)
(ORACLE_HOME = C:/oracle11g/product/11.2.0/dbhome_1)
(SID_NAME = orcldb)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521))
)
)
ADR_BASE_LISTENER = C:/oracle11g
另外附带一下碰到的一个问题 顺便记录一下 呵呵,
在FM中创建object时出现
Unable to access service at URL:
http://localhost/cognos8/cgi-bin/cognos.cgi?b_action=xts.run&m=portal/close.xts
Please check that your gateway URI information is configured correctly and that the service is available.
For further information please contact your service administrator
幸运的是已有人解决了 【from http://space.itpub.net/16582684/viewspace-629612】
在cognos configuration操作界面中,选择local configuration --> Enviroment,将Gateway settings下的Gateway URI中的内容http://localhost/cognos8/cgi-bin/cognos.cgi替换为http://localhost:9300/p2pd/servlet/dispatch即可
附带一下原因,应该是我安装的时候将cognos8修改成cognos导致 至于为什么替换成后面的地址就不知道了
但之前我的访问地址 依然没变。