This documentation supports the 19.08 version of BMC Digital Workplace Basic.

To view the latest version, select the version from the Product Version menu.

Precreating an Oracle database

This topic describes how to precreate an Oracle database.

Note

BMC Digital Workplace uses the Users tablespace and the TEMP tablespace. Each schema requires 20 MB.

Before you begin

Complete the Installation worksheets for Digital Workplace.

To precreate the Oracle database

  1. Use the following script to create the users and grant the necessary roles:

    create user DWP_Business identified by DWP default tablespace USERS temporary tablespace TEMP quota unlimited on USERS;
    
    create user DWP_System identified by DWP default tablespace USERS temporary tablespace TEMP quota unlimited on USERS;
    
    grant create sequence, create table, create view, create session to DWP_Business;
    
    grant create sequence, create table, create view, create session to DWP_System;
    
  2. On your installation worksheet, specify the database name, users, and passwords. The password must be from 5 to 30 symbols in length, not contain %, @, ! or & and start from a letter. 

When you run the installer, select the Use Precreated DB option in the RDBMS Selection window. Therefore, you do not need to enter system credentials.

Important

Do not remove the users after installing BMC Digital Workplace because these user accounts store all the BMC Digital Workplace data.

Where to go from here

Make sure that you have completed the remaining steps in Preparing for installation of Digital Workplace.

Was this page helpful? Yes No Submitting... Thank you

Comments