数据库转移：下载脚本并设置 Oracle 数据库

IBM Knowledge Center 中提供了配置向导中的手动步骤，以供您参考并供高级用户使用。此过程针对不同的数据库提供了变量和步骤。使用此向导配置部署时，它会将变量替换为您在此向导中提供的信息。另外，它还仅显示特定于环境的步骤。此向导生成的指示信息特定于环境。

关于此任务

注意：提供了针对所有数据库环境的所有步骤，而未考虑您的环境。使用配置向导可以针对您的环境生成定制指示信息。

过程

将下载的脚本复制到数据库服务器并将其解压缩。

在 SQL 处理器中运行此脚本中列出的 SQL 语句。

下面是配置向导生成的脚本示例。

CREATE USER runtime_ID 
	IDENTIFIED BY runtime_pwd 
	DEFAULT TABLESPACE USERS 
	TEMPORARY TABLESPACE TEMP; 
        
    
  
CREATE USER config_ID 
	IDENTIFIED BY config_pwd 
	DEFAULT TABLESPACE USERS 
	TEMPORARY TABLESPACE TEMP; 
CREATE USER release 
	IDENTIFIED BY config_pwd 
	DEFAULT TABLESPACE USERS 
	TEMPORARY TABLESPACE TEMP; 
        
GRANT UNLIMITED TABLESPACE TO release; 
  
CREATE ROLE WP_BASE_CONFIG_USERS NOT IDENTIFIED;
GRANT ALTER ANY TABLE, CREATE ANY TABLE, DROP ANY TABLE,
	CREATE ANY INDEX, DROP ANY INDEX,
	INSERT ANY TABLE, UPDATE ANY TABLE, SELECT ANY TABLE, DELETE ANY TABLE,
	CREATE SESSION
	TO WP_BASE_CONFIG_USERS;
      
      
GRANT SELECT ON DBA_PENDING_TRANSACTIONS TO WP_BASE_CONFIG_USERS;
GRANT WP_BASE_CONFIG_USERS TO config_ID;
    
CREATE ROLE WP_BASE_RUNTIME_USERS NOT IDENTIFIED;
GRANT CREATE SESSION TO WP_BASE_RUNTIME_USERS;
GRANT SELECT ON DBA_PENDING_TRANSACTIONS TO WP_BASE_RUNTIME_USERS;
GRANT WP_BASE_RUNTIME_USERS TO runtime_ID;
 
  
  
    
  
CREATE USER community 
	IDENTIFIED BY config_pwd 
	DEFAULT TABLESPACE USERS 
	TEMPORARY TABLESPACE TEMP; 
        
GRANT UNLIMITED TABLESPACE TO community; 
  
GRANT ALTER ANY TABLE, CREATE ANY TABLE, DROP ANY TABLE,
	CREATE ANY INDEX, DROP ANY INDEX,
	INSERT ANY TABLE, UPDATE ANY TABLE, SELECT ANY TABLE, DELETE ANY TABLE,
	CREATE SESSION
	TO WP_BASE_CONFIG_USERS;
      
      
GRANT SELECT ON DBA_PENDING_TRANSACTIONS TO WP_BASE_CONFIG_USERS;
GRANT WP_BASE_CONFIG_USERS TO config_ID;
    
GRANT CREATE SESSION TO WP_BASE_RUNTIME_USERS;
GRANT SELECT ON DBA_PENDING_TRANSACTIONS TO WP_BASE_RUNTIME_USERS;
GRANT WP_BASE_RUNTIME_USERS TO runtime_ID;
 
  
  
    
  
CREATE USER customization 
	IDENTIFIED BY config_pwd 
	DEFAULT TABLESPACE USERS 
	TEMPORARY TABLESPACE TEMP; 
        
GRANT UNLIMITED TABLESPACE TO customization; 
  
GRANT ALTER ANY TABLE, CREATE ANY TABLE, DROP ANY TABLE,
	CREATE ANY INDEX, DROP ANY INDEX,
	INSERT ANY TABLE, UPDATE ANY TABLE, SELECT ANY TABLE, DELETE ANY TABLE,
	CREATE SESSION
	TO WP_BASE_CONFIG_USERS;
      
      
GRANT SELECT ON DBA_PENDING_TRANSACTIONS TO WP_BASE_CONFIG_USERS;
GRANT WP_BASE_CONFIG_USERS TO config_ID;
    
GRANT CREATE SESSION TO WP_BASE_RUNTIME_USERS;
GRANT SELECT ON DBA_PENDING_TRANSACTIONS TO WP_BASE_RUNTIME_USERS;
GRANT WP_BASE_RUNTIME_USERS TO runtime_ID;
 
  
  
    
  
CREATE USER jcr 
	IDENTIFIED BY config_pwd 
	DEFAULT TABLESPACE USERS 
	TEMPORARY TABLESPACE TEMP; 
        
GRANT UNLIMITED TABLESPACE TO jcr; 
  
CREATE ROLE WP_JCR_CONFIG_USERS NOT IDENTIFIED;
GRANT ALTER ANY TABLE, CREATE ANY TABLE, DROP ANY TABLE,
	CREATE ANY INDEX, DROP ANY INDEX,
	INSERT ANY TABLE, UPDATE ANY TABLE, SELECT ANY TABLE, DELETE ANY TABLE,
	CREATE SESSION
	TO WP_JCR_CONFIG_USERS;
      
GRANT CREATE TABLESPACE, DROP TABLESPACE,
	CREATE ANY SEQUENCE, DROP ANY SEQUENCE,
	CREATE ANY TRIGGER, DROP ANY TRIGGER,
	CREATE ANY TYPE, DROP ANY TYPE, EXECUTE ANY TYPE,
	CREATE ANY VIEW, DROP ANY VIEW
	TO WP_JCR_CONFIG_USERS;
GRANT SELECT ON DBA_IND_COLUMNS to WP_JCR_CONFIG_USERS;
GRANT SELECT ON DBA_INDEXES to WP_JCR_CONFIG_USERS;
      
      
GRANT SELECT ON DBA_PENDING_TRANSACTIONS TO WP_JCR_CONFIG_USERS;
GRANT WP_JCR_CONFIG_USERS TO config_ID;
    
CREATE ROLE WP_JCR_RUNTIME_USERS NOT IDENTIFIED;
GRANT CREATE SESSION TO WP_JCR_RUNTIME_USERS;
GRANT SELECT ON DBA_PENDING_TRANSACTIONS TO WP_JCR_RUNTIME_USERS;
GRANT WP_JCR_RUNTIME_USERS TO runtime_ID;
 
  
  
    
  
CREATE USER feedback 
	IDENTIFIED BY config_pwd 
	DEFAULT TABLESPACE USERS 
	TEMPORARY TABLESPACE TEMP; 
        
GRANT UNLIMITED TABLESPACE TO feedback; 
  
CREATE ROLE WP_PZN_CONFIG_USERS NOT IDENTIFIED;
GRANT ALTER ANY TABLE, CREATE ANY TABLE, DROP ANY TABLE,
	CREATE ANY INDEX, DROP ANY INDEX,
	INSERT ANY TABLE, UPDATE ANY TABLE, SELECT ANY TABLE, DELETE ANY TABLE,
	CREATE SESSION
	TO WP_PZN_CONFIG_USERS;
      
      
GRANT CREATE ANY SEQUENCE, DROP ANY SEQUENCE TO WP_PZN_CONFIG_USERS;
      
GRANT SELECT ON DBA_PENDING_TRANSACTIONS TO WP_PZN_CONFIG_USERS;
GRANT WP_PZN_CONFIG_USERS TO config_ID;
    
CREATE ROLE WP_PZN_RUNTIME_USERS NOT IDENTIFIED;
GRANT CREATE SESSION TO WP_PZN_RUNTIME_USERS;
GRANT SELECT ON DBA_PENDING_TRANSACTIONS TO WP_PZN_RUNTIME_USERS;
GRANT WP_PZN_RUNTIME_USERS TO runtime_ID;
 
  
  
    
  
CREATE USER likeminds 
	IDENTIFIED BY config_pwd 
	DEFAULT TABLESPACE USERS 
	TEMPORARY TABLESPACE TEMP; 
        
GRANT UNLIMITED TABLESPACE TO likeminds; 
  
GRANT ALTER ANY TABLE, CREATE ANY TABLE, DROP ANY TABLE,
	CREATE ANY INDEX, DROP ANY INDEX,
	INSERT ANY TABLE, UPDATE ANY TABLE, SELECT ANY TABLE, DELETE ANY TABLE,
	CREATE SESSION
	TO WP_PZN_CONFIG_USERS;
      
      
GRANT SELECT ON DBA_PENDING_TRANSACTIONS TO WP_PZN_CONFIG_USERS;
GRANT WP_PZN_CONFIG_USERS TO config_ID;
    
GRANT CREATE SESSION TO WP_PZN_RUNTIME_USERS;
GRANT SELECT ON DBA_PENDING_TRANSACTIONS TO WP_PZN_RUNTIME_USERS;
GRANT WP_PZN_RUNTIME_USERS TO runtime_ID;
CREATE TABLESPACE ICMLFQ32 DATAFILE 'oracle/product/11.2.0/dbhome_1/wpsdb/data/wpsdb_ICMLFQ32_01.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT 10M maxSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE;   
CREATE TABLESPACE ICMLNF32 DATAFILE 'oracle/product/11.2.0/dbhome_1/wpsdb/data/wpsdb_ICMLNF32_01.dbf' SIZE 25M REUSE AUTOEXTEND ON NEXT 10M maxSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE;   
CREATE TABLESPACE ICMVFQ04 DATAFILE 'oracle/product/11.2.0/dbhome_1/wpsdb/data/wpsdb_ICMVFQ04_01.dbf' SIZE 25M REUSE AUTOEXTEND ON NEXT 10M maxSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE;   
CREATE TABLESPACE ICMSFQ04 DATAFILE 'oracle/product/11.2.0/dbhome_1/wpsdb/data/wpsdb_ICMSFQ04_01.dbf' SIZE 150M REUSE AUTOEXTEND ON NEXT 10M maxSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE;   
CREATE TABLESPACE ICMLSNDX DATAFILE 'oracle/product/11.2.0/dbhome_1/wpsdb/index/wpsdb_ICMLSNDX_01.dbf' SIZE 10M REUSE AUTOEXTEND ON NEXT 10M maxSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE;