COGNOS服务器安装配置手册

一系统环境说明用户说明:安装与使用过程中的用户Root:系统补丁安装用户Cognos:软件安装，运行用户目录说明:请先使用Root创建以下目录，并将相应文件拷贝到相应目录中，修改目录所有者为cognos，后面的安装进行均以cognos身份进行,安装目录/tmp/share/app/apache_32:apache安装目录/tmp/share/app/cognos:Cognos安装目录(根据安装规范实际安装到/tmp/share/app/cognos/c10)/tmp/share/app/jdk1.6.0_45:java安装目录(安装版本为java 32位)/tmp/share/app/OpenDJ-2.4.5:LDAP服务OpenDJ安装目录/tmp/share/app/oracle_32:oracle客户端安装目录源文件目录:/tmp/share/app/setup/Cognos:Cognos安装源文件目录/tmp/share/app/setup/httpd-2.2.24:apche源代码目录默认配置文件说明.bash_profile cognos10_linux.conf tnsnames.ora mecool-20131204.ldifhttpd.confkettle-start.bat MECOOLDB-BACK.sqlcreate schema.SQLCognos SVR安装时的RPM.txt.bash_profile:用户cognos的登录用户角本，路径为/home/cognos/Cognos10_linux.conf:apache的Cognos虚拟目录配置信息，路径为/tmp/share/app/apache_32/confTnsnames.ora:连接oracle服务的配置信息，路径为/tmp/share/app/oracle_32/network/admin Mecool-20131204.ldif:OpenDJ目录内容备份，安装系统导入路径为/tmp/share/app/setup/OpenDJ-2.4.5Kettle-start.bat:etl启动文件，供windows任务计划调用MECOOLDB-BACK.sql:为mecool数据仓库mecool用户表，存储过程等定义Create schema.sql:为oracle表空间，用户创建语句Httpd.conf:为apche配置文件，本文件不用拷贝，供阅读本文件apache配置部分参考Cognos SVR安装时的RPM:RHEL6.4(64位版本)验证安装所需数据包,RHEL6.4为默认安装，如无意外，请顺序执行包安装提供上述文件是可以直接在上述文件中修改相关配置路径信息，方便安装配置操作。

内容修改的说明:.bash_profile文件########### javaconfig #################export JAVA_HOME=/tmp/share/app/jdk1.6.0_45export CLASSPATH=${JAVA_HOME}/lib:${JAVA_HOME}/jre/lib:.##CLASSPATH=.:$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jarexport PATH=${JAVA_HOME}/bin:${PATH}##export JAVA_HOME CLASSPATH PATHexport ORACLE_HOME=/tmp/share/app/oracle_32export TNS_ADMIN=${ORACLE_HOME}/network/adminexport NLS_LANG=${NLS_LANG:-SIMPLIFIED CHINESE_CHINA.ZHS32GB18030}export PATH=${ORACLE_HOME}/bin:${ORACLE_HOME}:${PATH}export LD_LIBRARY_PATH=${ORACLE_HOME}/lib:${ORACLE_HOME}:${LD_LIBRARY_PATH}#exportLD_LIBRARY_PATH=${ORACLE_HOME}/lib:${ORACLE_HOME}/lib32:${ORACLE_HOME}/network/li b:${ORACLE_HOME}/ctx/lib:${LD_LIBRARY_PATH}##export ORACLE_BASE ORACLE_HOME NLS_LANG PATH LD_LIBRARY_PATH########### cognosconfig #################export COGNOS_BASE=/tmp/share/app/cognos/c10export COGNOS_HOME=${COGNOS_BASE}export COGNOS_TM_HOME=${COGNOS_HOME}/binexport COGNOS_TM_SHELL=cogtrexport PATH=${COGNOS_HOME}/bin:${PATH}exportLD_LIBRARY_PATH=${COGNOS_HOME}/bin:${COGNOS_HOME}/cgi-bin:${LD_LIBRARY_PATH}##export COGNOS_BASE COGNOS_HOME COGNOS_TM_HOME COGNOS_TM_SHELL PATHLD_LIBRARY_PATH#if you are using a servlet gatewayexport AIXTHREAD_SCOPE=SexportThousandSeparator=,export LD_PRELOAD=/lib/libfreebl3.so默认只需修改黄色标注部分的路径信息cognos10_linux.conf文件LoadModulecognos_module "/tmp/share/app/cognos/c10/cgi-bin/mod2_2_cognos.so" ScriptAlias /cognos10/cgi-bin "/tmp/share/app/cognos/c10/cgi-bin"Alias /cognos10 "/tmp/share/app/cognos/c10/webcontent"<Directory "/tmp/share/app/cognos/c10/webcontent">DAV OnOptions Indexes MultiViewsAllowOverride NoneOptions NoneOrder allow,denyAllow from all</Directory><Directory "/tmp/share/app/cognos/c10/cgi-bin">AllowOverride NoneOptions NoneOrder allow,denyAllow from all</Directory><Location /cognos10/cgi-bin/cognos_module>SetHandlercognos-handlerOrder allow,denyAllow from all</Location><IfModule mod2_2_cognos.c>CGIBinDir "/tmp/share/app/cognos/c10/cgi-bin"</IfModule><IFModuleheaders_module>Header add P3P "CP=CAO PSA OUR"</IFModule>LoadModuledav_module modules/mod_dav.soLoadModuledav_fs_module modules/mod_dav_fs.so##LoadModuledav_lock_module modules/mod_dav_lock.so<IfModule !mod_setenvif>LoadModulesetenvif_module modules/mod_setenvif.so</IfModule><IfModule !mod_alias>LoadModulealias_module modules/mod_alias.so</IfModule><IfModule !auth_digest_module>LoadModuleauth_digest_module modules/mod_auth_digest.so</IfModule><IfModule !authn_file_module>LoadModuleauthn_file_module modules/mod_authn_file.so</IfModule># Distributed authoring and versioning (WebDAV)## Distributed authoring and versioning (WebDAV)## Required modules: mod_dav, mod_dav_fs, mod_setenvif, mod_alias# mod_auth_digest, mod_authn_file## The following example gives DAV write access to a directory called# "uploads" under the ServerRoot directory.## The User/Group specified in httpd.conf needs to have write permissions# on the directory where the DavLockDB is placed and on any directory where# "Dav On" is specified.DavLockDB "/tmp/share/app/apache_32/var/DavLock"Alias /uploads "/tmp/share/app/apache_32/uploads"<Directory "/tmp/share/app/apache_32/uploads">Dav OnOrder Allow,DenyAllow from allAuthType DigestAuthName DAV-upload# You can use the htdigest program to create the password database:# htdigest -c "D:/soft/Apache2.2/conf/cognos/user.pwd" DAV-upload admin AuthUserFile "/tmp/share/app/apache_32/conf/user.pwd"#AuthDigestProvider file# Allow universal read-access, but writes are restricted# to the admin user.<LimitExcept GET OPTIONS>require user admin</LimitExcept></Directory>## The following directives disable redirects on non-GET requests for# a directory that does not include the trailing slash. This fixes a# problem with several clients that do not appropriately handle# redirects for folders with DAV methods.#BrowserMatch "Microsoft Data Access Internet Publishing Provider" redirect-carefully BrowserMatch "MS FrontPage" redirect-carefullyBrowserMatch "^WebDrive" redirect-carefullyBrowserMatch "^WebDAVFS/1.[0123]" redirect-carefullyBrowserMatch "^gnome-vfs/1.0" redirect-carefullyBrowserMatch "^XML Spy" redirect-carefullyBrowserMatch "^Dreamweaver-WebDAV-SCM1" redirect-carefully默认只需修改黄色标注部分的路径信息tnsnames.ora文件SVR=(description =(address_list =(address = (protocol = tcp)(host = 192.168.1.52)(port=1521)))(connect_data =(sid = orcl)(server = dedicated)))默认只需修改黄色标注部分的路径信息因为被Cognos等引入红色部分不建议修改用户环境修改请将.bash_profile拷贝到/home/cognos/下,登出系统以使用cognos重新登录系统Linux安装缺失文件的说明根据不同的linux环境安装过程中可能提示文件缺失，这些文件可通过linux对应的安装源盘取得，因为包的依赖关系问题，我默认使用包安装器安装相应包文件二JDK的安装配置图1.11.1.安装JDK用户cognos,使用./jdk-6u45-linux-i586.bin解压文件,将解压后的文件(含子目录结构，拷贝至/tmp/share/app/jdk1.6.0_451.2.测试配置使用java –version命令查询java版本，如果看到图1.4效果，则表示JDK安装配置成功完成。