Database transfer: Download the script and setup your Oracle database | HCL Digital Experience

Manual steps from the Configuration Wizard are included in HCL Digital Experience Product Documentation for reference and for advanced users. The procedure includes variables and steps for different databases. When you use the wizard to configure your deployment, it replaces the variable with information that you provided in the wizard. It also shows only the steps that are specific to your environment. The instructions that the wizard generates are specific to your environment.

About this task

Attention: All steps for all database environments are included without consideration for your environment. Use the Configuration Wizard to generate custom instructions for your environment.

Procedure

  1. Copy the downloaded script to the database server and extract it.
  2. Run the SQL statements that are listed in this script in your SQL processor.

    Example of the script that the Configuration Wizard generates:

    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;