IBM Portal 数据库迁移.docVIP

数据库准备工作 修改参数值 确保数据库实例的参数配置满足以下条件： db_block_size = 8192 db_cache_size = 300M shared_pool_size = 200M pre_page_sga = true pga_aggregate_target = 200M db_files = 1024 open_cursors = 1500 processes = 300 log_buffer = 65536 创建用户及表空间 创建用户 create user releaseusr identified by password default tablespace users temporary tablespace temp; create user communityusr identified by password default tablespace users temporary tablespace temp; create user customizationusr identified by password default tablespace users temporary tablespace temp; create user wmmdbusr identified by password default tablespace users temporary tablespace temp; create user icmadmin identified by password default tablespace users temporary tablespace temp; create user feedback identified by password default tablespace users temporary tablespace temp; create user lmdbusr identified by password default tablespace users temporary tablespace temp; 用户赋权限 grant select on dba_pending_transactions to releaseusr; grant connect, resource to releaseusr; grant select on dba_pending_transactions to communityusr; grant connect, resource to communityusr; grant select on dba_pending_transactions to customizationusr; grant connect, resource to customizationusr; grant select on dba_pending_transactions to wmmdbusr; grant connect, resource to wmmdbusr ; grant create session, alter session, create table, create view, create procedure, create trigger, create library, create tablespace, alter tablespace, drop tablespace, execute any procedure, unlimited tablespace, create public synonym, drop public synonym, create sequence to icmadmin; grant select on dba_pending_transactions to icmadmin; grant connect, resource to icmadmin; grant insert any table to icmadmin; grant select on dba_pending_transactions to feedback; grant connect, resource, create session to feedback; grant select on dba_pending_transactions to lmdbusr; grant connect, resource, create session to lmdbusr; grant insert any table to lmdbusr; 创建表空间文件 在