+

Search Tips   |   Advanced Search

Database transfer: Download the script and setup the Oracle database

Note that manual steps from the Configuration Wizard can be found in the IBM Knowledge Center.

  1. Copy the downloaded script to the database server and extract it.

  2. Run the SQL statements listed in this script in the SQL processor.

    Example of the script 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;


Parent Manual Steps: Database Transfer