cognos10安装及配置oracle指引1.如果操作系统曾经过Oracle且删除的时候做不干净

IBMCognos一．并安装Oracle10gOracleOracle安装失败或者安装后无法使用。建议有类似情况的同事，重装操作系统，是否GHOST版没有在默认情况下，OracleUTF-8字符集。因此，必UTF-8，以免在启动IBMCognos二．使用Oracle10g创建用户并浏览器URL：以SYSTEM用户登录，为orcl对应的createuserzhanjqidentifiedbyzhanjq;grantconnect,resource,dbatozhanjq;Cognos10默认选择安装在C JVMJDKJDK 五．Jar文件将cognos的bcprov-jdk14-134.jar拷贝到JVM对应 将oracle的ojdbc14.jar拷贝到COGNOS对应 目标位置：%cognos%\c10\webapps\p2pd\WEB-INF\libCognosIBMCognos数据数据库连接测IBMcognos12:58:45,'LogService','StartService','Success'.12:58:46,CAFinputvalidationenabled.12:58:46,CAFThirdPartyXSScheckingdisabled.12:58:53,'ContentManagerService','StartService','Success'.12:58:52,CM-SYS-2216AContentManagerinternalPRECACHEINITACTIONStaskis12:58:52,CM-SYS-2216AContentManagerinternalPOSTINITACTIONStaskiscomplete.12:58:52,CM-SYS-2215AContentManagerinternalPRECACHEINITACTIONStaskstarted.12:58:52,CM-SYS-2215AContentManagerinternalPOSTINITACTIONStaskstarted.12:58:53,CM-SYS-5159ContentManagerisrunninginactive12:58:54,DPR-DPR- 已成功 Content 中注册调度程。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',12:59:38,'IBMCognosEnhancedSearchService','StartService','Success'.12:59:39,'PresentationService','StartService','Success'.12:59:44,PresentationServiceStartServiceSuccess'.12:59:44,启动，因为起始计数1大于0。12:59:58,'QueryService','StartService','Success'.13:00:01,'QueryService','StartService','Success'.13:00:02,'BUXService','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',13:00:09,'FragmentServerService','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,'CPSProducerRegistrationService','StartService',SSLNEXT。显示器右下角显示APACHE通 #For<Directory"C:/ProgramFiles/IBM/cognos/c10/cgi-bin">AllowOverrideNoneOptionsNoneAllowfromAll<Directory"C:/ProgramFiles/IBM/cognos/c10/webcontent/ation">OptionsNoneAllowOverrideNoneOrderAllow,DenyAllowfromAllAlias/ibmcognos"C:/Program<Directory"C:/ProgramFiles/IBM/cognos/c10/webcontent">OptionsNoneAllowOverrideNoneOrderAllow,DenyAllowfromAll重新启动九．通过浏览器Cognos服务URL配置数据源数据源,然后配置数据源到你的需要数据库中，在WMS中需要做如下处理，找到 下的webUIConfig.xml，配置COGNOS的服务器例如：<parm Oracle8.1.7UTF-8Oracle9i，则字符集为将ORACLE_HOME/jdbc/lib 下的classes12.zip文件[ORACLE_HOME指ORACLE ]到Cognos8/webapps/p2pd/WEB-INF/lib 下，并将classes12.zip文件重命名为classes12.jar如果oracle10gojdbc14_g.jar设置Cognos下一步同配置SQLServer一样，在右边填写用户名、及数据库名启动服务，通过IE（APACHE端口改动的需要加上端口1：如果COGNOS这时执行下面操作，在安装cognos完成后，需要将D:\cognos\c8\bin\jre\1.5.0\lib\ext的一个bcprov-jdk14-134.jar放到C:\j2sdk1.4.2_09\jre\lib\ext 下，解决Cognos无法正2：如果在COGNOSCONFIGRATION配置数据源，如果是用ORACLE数据库，则需要将ORACLE_HOME/jdbc/lib 下的classes12.zip文件[ORACLE_HOME指ORACLE ]到Cognos8/webapps/p2pd/WEB-INF/lib 下，并将classes12.zip文件重命名为classes12.jar，否则会报找不到驱动的错误，错误显示如下：[ContentManagerdatabaseconnection]1.[ERROR]Thedatabaseconnectionfailed.2.[ERROR]ContentManagerfailedtoconnecttothecontentstore.Theconnectionstringis"jdbcracle:thinlocalhost:1521:cognos".connectCREATEUSER"COGNOS"IDENTIFIEDBY"cognos" defaulttablespaceUSERStemporarytablespaceTEMPprofileDEFAULT;grantconnecttoCOGNOS;grantdbatoCOGNOS;grantdelete_catalog_roletoCOGNOS;grantejbtoCOGNOS;grantexecute_catalog_roletoCOGNOS;grantexp_full_databasetoCOGNOS;grantgather_system_statisticstoCOGNOS;grantimp_full_databasetoCOGNOS;grantresourcetograntselect_catalog_roleto--Grant/RevokesystemgrantcreateanymaterializedviewtoCOGNOS;grantcreateanytabletoCOGNOS;grantcreateanyviewtoCOGNOS;grantcreatetabletoCOGNOS;grantdropanymaterializedviewtoCOG