Cognos 常见错误解决办法.docVIP

???????? 常见问题： ??????????????? CM-CFG-5137：Content Manager was unable to complete the initialization of the ????????????????????????????????????????content store。 ?????? ?????? 解决办法： 1.??? Ensure that all Cognos 8 Services are stopped. 2.??? Have the DBA make a backup the Content Store. 3.??? Have the DBA run the install_path\configuration\schemas\content\dbVendor\dbClean_dbVendor.sql script on the Content Store database. 4.??? Start the Cognos 8 with Cognos Configuration. ? ?????????? CM-CFG-5063: 数据库的用户配置的权限不够? ?????????????? 解决办法： ??????????? ??? Must ensure that Oracle database has the following permissions set: ??????????????? a) connect to the database?????????????? ?b) create, alter, and drop tables ??????????????? c) create, alter and drop triggers ??????????????? d) create, alter and drop views ??????????????? e) create, alter and drop procedures ??????????????? f) create, alter and drop sequences ??????????????? Also, add Unlimited Quotas permission to oracle content store?? ??????????????? schema if the above steps do not work ? ?????? ??????? CM-SYS-5124: 数据库编码方式一定要是 UTF-8 ???解决办法：需要在数据库中修改数据库的字符集，需要DBA权限执行下面的语句： ?????????? ????? sqlplus /nolog?????????? ????? conn /as sysdba?????????? ????? shutdown immediate;?????????? ????? startup mount;?????????? ????? ALTER SESSION SET SQL_TRACE=TRUE;????????????? ?????? ALTER SYSTEM ENABLE RESTRICTED SESSION;????????????? ?????? ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;????????????? ?????? ALTER SYSTEM SET AQ_TM_PROCESSES=0;????????????? ?????? ALTER DATABASE OPEN;????????????? ?????? set linesize 120;?????????? ????? ALTER DATABASE character set INTERNAL_USE UTF8; ????????????? ?????? ALTER SESSION SET SQL_TRACE=FALSE; ????????????? ?????? shutdown immediate; ????????????? ?????? STARTUP; ? ?????? ??????? CFG-ERR-0106: IBM Cognos Configuration did not receive a response from the IBM Cognos 8 ?????????????? service in the time allotted.Check that IBM Cognos 8 service is available and properly configu