This documentation supports the 3.5 version of BMC Digital Workplace. To view the latest version, select the version from the Product version menu.

Pre-creating an Oracle database

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


Note

BMC Digital Workplace and Remedy with Smart IT use the Users tablespace and the TEMP tablespace and require 20 MB for each schema.

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.

Important

Do not remove these users after installing BMC Digital Workplace and Smart IT, because all BMC Digital Workplace and Smart ITdata is stored under these user accounts.

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.


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

Comments