IBM Cognos 10 环境搭建指引(Window XP 32位).doc

IBM Cognos 环境搭建指引（Window XP 32位）编者：詹坚强编写日期：2011.07.28一 制作Cognos 10组件光盘ISO镜像文件1.下载并安装UltraISO共享软件 2. 制作Cognos 10组件光盘的镜像文件操作菜单：工具 - 制作光盘镜像文件3将ISO镜像文件通过SVN共享给项目组成员。【注意保密，不可外泄！】二 下载并安装Oracle 10g。注意事项：1.如果操作系统曾经安装过Oracle且删除的时候做的不干净，则会导致Oracle安装失败或者安装后无法使用。建议有类似情况的同事，重装操作系统，是否GHOST版没有关系。2.在默认情况下，Oracle执行基本安装，所创建的数据库不支持UTF-8字符集。因此，必须选择高级安装方式，并在安装选项中设置字符集为UTF-8，以免在启动IBM Cognos 服务出错。三 使用Oracle 10g创建用户并授权。浏览器访问URL： http:/localhost:5560/isqlplus/以SYSTEM用户登录，密码为orcl对应的密码执行相关SQL：create user zhanjq identified by zhanjq ;grant connect,resource,dba to zhanjq ;四 安装Cognos 10组件。注意事项：1.六个组件可以按照任意次序安装。2.建议将六个组件安装在同一位置，对于重复警告，选择覆盖。3.默认选择安装在C盘目录。4.ISO安装方式4.1加载ISO文件到虚拟光驱4.2双击虚拟光驱直接启动安装程序或者打开之后运行win32目录的安装脚本，例如：五 搭建JVM环境。1.JDK安装文件：2.JDK主目录：3.配置环境变量3.1 JAVA_HOMED:JDK63.2 Path%JAVA_HOME%bin;D:oracleproduct10.2.0db_1bin;%SystemRoot%system32;%SystemRoot%;%SystemRoot%System32Wbem;D:SVNbin3.3 Classpath%JAVA_HOME%libtools.jar;%JAVA_HOME%libdt.jar;六 Jar文件复制。1.将cognos的bcprov-jdk14-134.jar拷贝到JVM对应目录。源位置：%cognos%c10binjre6.0libext目标位置：%JAVA_HOME%jrelibext2.将oracle的ojdbc14.jar拷贝到COGNOS对应目录。源位置：%ORACLE_HOME%product10.2.0db_1jdbclib目标位置：%cognos% c10webappsp2pdWEB-INFlib七 配置并启动Cognos服务1. 运行IBM Cognos Configuration 2. 为内容存储数据库设置数据库连接2.1 右击删除默认节点，右击新建orcl节点。2.2 建议数据库用户具有DBA权限，权限不足会影响会报错！3. 数据存储数据库连接测试4. 启动IBM cognos 服务启动成功日志明细：12:58:45, LogService, StartService, Success.12:58:46, CAF input validation enabled.12:58:46, CAF Third Party XSS checking disabled.12:58:53, ContentManagerService, StartService, Success.12:58:52, CM-SYS-2216 A Content Manager internal PRECACHEINITACTIONS task is complete.12:58:52, CM-SYS-2216 A Content Manager internal POSTINITACTIONS task is complete.12:58:52, CM-SYS-2215 A Content Manager internal PRECACHEINITACTIONS task started.12:58:52, CM-SYS-2215 A Content Manager internal POSTINITACTIONS task started.12:58:53, CM-SYS-5159 Content Manager is running in active mode.12:58:54, DPR-DPR-1002 已成功在 Content Manager 中注册调度程序 http:/pczhanjq:9300/p2pd。12:58:53, StatisticService, StartService, Success.12:59:28, camAsyncService, StartService, Success.12:59:38, ContentManagerCacheService, StartService, Success.12:59:38, ReportDataService, StartService, Success.12:59:38, BatchReportService, StartService, Success.12:59:38, IBM Cognos Enhanced Search Service, StartService, Success.12:59:39, PresentationService, StartService, Success.12:59:44, PresentationService, StartService, Success.12:59:44, 启动 ，因为起始计数 1 大于 0。12:59:58, QueryService, StartService, Success.13:00:01, QueryService, StartService, Success.13:00:02, BUX Service, StartService, Success.13:00:07, GraphicsService, StartService, Success.13:00:07, SystemService, StartService, Success.13:00:07, camAsyncAA, StartService, Success.13:00:09, ReportService, StartService, Success.13:00:09, Fragment Server Service, StartService, Success.13:00:10, EventService, StartService, Success.13:00:10, AgentService, StartService, Success.13:00:10, IndexDataService, StartService, Success.13:00:10, MonitorService, StartService, Success.13:00:10, HumanTaskService, StartService, Success.13:00:10, JobService, StartService, Success.13:00:11, AnnotationService, StartService, Success.13:00:11, DeliveryService, StartService, Success.13:00:11, IndexSearchService, StartService, Success.13:00:10, IndexUpdateService, StartService, Success.13:00:11, MetadataService, StartService, Success.13:00:10, DimensionManagementService, StartService, Success.13:00:16, CPS Producer Registration Service, StartService, Success.查看服务状态，可见已经成功启动。八 安装Apache1. 下载支持SSL的版本/download.cgi2. 安装过程一路NEXT。以下内容可以随意填写。显示器右下角显示APACHE服务器正在运行。通过http:/localhost:80访问验证，安装成功。九 配置虚拟目录1.编辑文件%apache2219_HOME%confhttpd.conf在文件末尾处追加以下内容：# For COGNOSScriptAlias /ibmcognos/cgi-bin C:/Program Files/IBM/cognos/c10/cgi-binAllowOverride NoneOptions NoneOrder Allow,DenyAllow from AllAlias /ibmcognos/help C:/Program Files/IBM/cognos/c10/webcontent/documentationOptions NoneAllowOverride NoneOrd