Precreating an Oracle database
This topic describes how to precreate an Oracle database.
BMC Digital Workplace uses the Users tablespace and the TEMP tablespace. Each schema requires 20 MB.
Before you begin
Complete the Installation worksheets for BMC Digital Workplace.
To precreate the Oracle database
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;
- 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.
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 BMC Digital Workplace.