马上注册,结交更多数据大咖,获取更多知识干货,轻松玩转大数据
您需要 登录 才可以下载或查看,没有帐号?立即注册
x
一、 将原来装的orcl的字符集修改成utf8 在sys用户下,用命令select * from nls_database_parameters查看当前orcl所用的字符集。 在sys用户下,通过以下命令设置orcl字符集: SHUTDOWN IMMEDIATE; STARTUP MOUNTEXCLUSIVE; ALTER SYSTEM ENABLE RESTRICTED SESSION; ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; ALTER SYSTEM SET AQ_TM_PROCESSES=0; ALTER DATABASE OPEN; ALTER DATABASENATIONAL CHARACTER SET INTERNAL_USE UTF8; SHUTDOWNimmediate; startup; 二、 添加cognos用户,并设置权限 create user cognos identified by cognosdefault tablespace users temporary tablespace temp profile default; grant connect to cognos; grant dba to cognos; grant delete_catalog_role to cognos; grant ejbclient to cognos; grant exp_full_database to cognos; grant gather_system_statistics to cognos; grant imp_full_database to cognos; grant resource to cognos; grant select_catalog_role to cognos; --grant/revoke system privileges; grant create any materialized view tocognos; grant create any table to cognos; grant create any view to cognos; grant create table to cognos; grant drop any materialized view to cognos; grant drop any table to cognos; grant unlimited tablespace to cognos; commit; 三、 在cognos configuration中的content manager 设置orcl
|