【总结】cognos10.2+Oracle11g+apache环境搭建

---------------Drop  cognos--------------------------------------
drop tablespace COGNOS_DATA including contents and datafiles;
drop tablespace COGNOS_TEMP including contents and datafiles;
drop user COGNOS cascade;  

--------------create   COGNOS --------------------
--创建表空间
create TABLESPACE COGNOS_DATA datafile 'E:\app\OracleData\COGNOS_DATA.dbf' size 1024m autoextend on next 100M maxsize unlimited;
--创建临时表空间
create temporary TABLESPACE COGNOS_TEMP TEMPFILE 'E:\app\oracleData\COGNOS_TEMP.dbf' size 500M autoextend on next 50M maxsize unlimited;
--创建用户，并指定表空间和临时表空间
create user COGNOS Identified by kingdee Default TABLESPACE COGNOS_DATA temporary TABLESPACE COGNOS_TEMP Quota unlimited on COGNOS_DATA;
--授予用户相关权限
grant dba to COGNOS;

--------------drop   KBI_DW--------------------
drop tablespace KBI_DW_DATA including contents and datafiles;
drop tablespace KBI_DW_TEMP including contents and datafiles;
drop user KBI_DW cascade;

--------------create   KBI_DW--------------------
--创建表空间
create tablespace KBI_DW_DATA datafile 'E:\app\oracleData\KBI_DW_DATA.dbf' size 2000M reuse autoextend on next 100M maxsize unlimited;
--创建临时表空间
create temporary tablespace KBI_DW_TEMP TEMPFILE 'E:\app\oracleData\KBI_DW_TEMP.dbf' size 500m reuse autoextend on next 10M maxsize unlimited;
--创建用户，并指定表空间和临时表空间
create user KBI_DW Identified by kingdee Default tablespace KBI_DW_DATA temporary tablespace KBI_DW_TEMP Quota unlimited on KBI_DW_DATA;
--授予用户相关权限
--grant DBA,connect,select any table to KBI_DW;
grant DBA to KBI_DW;        

Cognos环境安装步骤及注意点：
1、安装Oracle，新建一个cognos内容库（UTF-8）和一个查询库
2、安装cognos服务器和FM组件，拷贝oracle驱动
3、安装apache，配置端口和cognos虚拟目录
# For COGNOS
ScriptAlias /ibmcognos/cgi-bin "F:/ibm/cognos/c10_64/cgi-bin"
<Directory "F:/ibm/cognos/c10_64/cgi-bin">
        AllowOverride None
        Options None
        Order Allow,Deny
        Allow from All
</Directory>
Alias /ibmcognos/help "F:/ibm/cognos/c10_64/webcontent/documentation"
<Directory "F:/ibm/cognos/c10_64/webcontent/documentation">
        Options None
        AllowOverride None
        Order Allow,Deny
        Allow from All
</Directory>
Alias /ibmcognos "F:/ibm/cognos/c10_64/webcontent"
<Directory "F:/ibm/cognos/c10_64/webcontent">
        Options None
        AllowOverride None
        Order Allow,Deny
        Allow from All
</Directory>

4、配置内容库和网关地址（客户端的网关地址一定要启动cognos服务后更改）
5、配置数据源((DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))(CONNECT_DATA= (SERVER = DEDICATED)(SERVICE_NAME=ORCl))))
6、本地访问的时候请用127.0.0.1（不可用localhost）

沙发！沙发!

帮你顶下哈！！

小手一抖，钱钱到手！