Pre-creating an Oracle database

This topic describes how to pre-create the Oracle database.

Before you begin

Complete the BMC Digital Workplace and Smart IT installation worksheets.

To pre-create the oracle database

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

   create user SmartIT_Business identified by SmartIT default tablespace USERS temporary tablespace TEMP quota unlimited on USERS;
   
   create user SmartIT_System identified by SmartIT default tablespace USERS temporary tablespace TEMP quota unlimited on USERS;
   
   create user openfire identified by openfire default tablespace USERS temporary tablespace TEMP quota unlimited on USERS;
   
   grant create sequence, create table, create view, create session to SmartIT_Business;
   
   grant create sequence, create table, create view, create session to SmartIT_System;
   
   grant create sequence, create table, create view, create session to openfire;

2. On your installation worksheet, write the database name, users, and passwords.

When you run the installer, select the Use Pre-created DB option in the RDBMS Selection window. When you select this option, you are not prompted to enter system credentials.

Where to go from here

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