IIS配置
1. 安装JDK,配置相应的环境变量;
2. 安装oracle数据库,创建一个新的数据库,字符集为UTF8类型(包括国家集);
3. 安装IIS服务;
4. 安装cognos8服务端软件;
5. 将D:\Program Files\cognos\c8\bin\jre\1.5.0\lib\ext目录下的bcprov-jdk14-134.jar复制到D:\ProgramFiles\Java\jdk1.5.0\jre\lib\ext目录下;
6. 配置IIS服务虚拟目录;
7. 配置JAVA_HOME环境变量(若有第5步,则该步骤省略);
8. 将D:\oracle\product\10.1.0\Db_1\jdbc\lib\ojdbc14.jar复制到
D:\Program Files\cognos\c8\webapps\p2pd\WEB-INF\lib目录下9. 运行cognos8,修改Security-Authentication-Cognos为匿名访问,值为true,关闭防火墙CognosApplication Firewall;删除缺省资料库,选择“Data Access”-“ Content Manager”选择“Content Store”击右键选择“delete”删除缺省的资料库。Content Manager 必须配置唯一资料库。新建合适资料库,以oracle为例选择“Data Access”-“ Content Manager”选择“Content Store”击右键选择“New resource”-“Database”;
10. 测试连接;
11. 安装客户端。
Tomcat配置
1. 安装JDK,配置相应的环境变量;
2. 安装oracle数据库,创建一个新的数据库,字符集为UTF8类型(包括国家集);
3. 安装cognos8服务端软件;
4. 将D:\Program Files\cognos\c8\bin\jre\1.5.0\lib\ext目录下的bcprov-jdk14-134.jar复制到D:\ProgramFiles\Java\jdk1.5.0\jre\lib\ext目录下;
5. 将D:\oracle\product\10.1.0\db_1\jdbc\lib\ojdbc14.jar复制到
D:\Program Files\cognos\c8\webapps\p2pd\WEB-INF\lib目录下6. 将D:\Program Files\cognos\c8\webcontent目录下所有文件拷到D:\Program Files\cognos\c8\webapps\p2pd目录下;
7. 修改表权限,若不成功则将数据库表删除后再重新修改表权限,修改如下:
(sqlplus
输入用户名和密码
System/cognos8
conn sys/sys sysdba
grant connect to scott;grant dba toscott;
grant resourceto scott;
grant unlimitedtablespace to scott;
grantdelete_catalog_role to scott;
grant ejbclientto scott;
grantexecute_catalog_role to scott;
grantexp_full_database to scott;
grantgather_system_statistics to scott;
grantimp_full_database to scott;
grant resourceto scott;
grantselect_catalog_role to scott;
-- Grant/Revokesystem privileges
grant create anymaterialized view to scott;
grant create anytable to scott;
grant create anyview to scott;
grant createtable to scott;
grant drop anymaterialized view to scott;
grant drop anytable to scott;
grant unlimitedtablespace to scott;
若重新创建用户,则:
create userscott
identified by scott
default tablespace USERS
temporary tablespace TEMP
profile DEFAULT;
grant connect toscott;
grant dba toscott;
grant resourceto scott;
grant unlimitedtablespace to scott;
grantdelete_catalog_role to scott;
grant ejbclientto scott;
grantexecute_catalog_role to scott;
grantexp_full_database to scott;
grantgather_system_statistics to scott;
grantimp_full_database to scott;
grant resourceto scott;
grant select_catalog_roleto scott;
-- Grant/Revokesystem privileges
grant create anymaterialized view to scott;
grant create anytable to scott;
grant create anyview to scott;
grant createtable to scott;
grant drop anymaterialized view to scott;
grant drop anytable to scott;
grant unlimitedtablespace to scott;
8. 运行cognos8,修改Security-Authentication-Cognos为匿名访问,值为true,关闭防火墙CognosApplication Firewall;删除缺省资料库,选择“Data Access”-“ Content Manager”选择“Content Store”击右键选择“delete”删除缺省的资料库。Content Manager 必须配置唯一资料库。新建合适资料库,以oracle为例选择“Data Access”-“ Content Manager”选择“Content Store”击右键选择“New resource”-“Database”;
9. 安装客户端
10.在CognosConfiguration 客户端中对Environment项进行配置:Gateway URI:替换为:
在tomcat环境下发布时将D:\Program Files\cognos\c8\webcontent目录下所有文件拷到D:\Program Files\cognos\c8\webapps\p2pd目录下
tomcat安装注意:
客户端修改Gateway URI地址为服务端地址,如:http://cognos.management.ccb:9300/p2pd/servlet/dispatch
修改客户端URI时需删除客户端C:\ProgramFiles\cognos\c8\configuration目录下三个文件:encryptkeypair、signkeypair、csk
CFG-ERR-0106 CognosConfiguration did not receive a response from the Cognos 8 service in the timeallotted.
Check that Cognos 8service is available and properly configured.
服务端:
1、 oracle下数据库实例配成utf-8
oracle字符集要是:SIMPLIFIED CHINESE_CHINA.AL32UTF8
(可以通过:selectuserenv('language') from dual;查询)
2、安装cognos服务
3、设置jdk
客户端安装:
第一步cognos configuration里的Gateway ,保存时要删除encryptkeypair、signkeypair、csk三个文件
第二步打开framwork manager 创建工程、设置数据源、创建物理及视图模型(按规则)