cognos8.3 创建oracle数据源失败

来源：互联网发布：web库存管理系统源码编辑：程序博客网时间：2024/05/16 13:58

参数配置相信初学者都可以按照提示配置完成但往往在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导致至于为什么替换成后面的地址就不知道了

但之前我的访问地址依然没变。