Skip to content

Database transfer: Download the script and setup your Oracle database

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.

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.

  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;