Creating the Oracle database

To 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 alter session to SmartIT_Business;
   
   grant create sequence, create table, create view, create session alter session to SmartIT_System;
   
   grant create sequence, create table, create view, create session alter session to openfire;
2. On your installation worksheet, write 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 Pre-created DB option in the RDBMS Selection window. When you select this option, you are not prompted to enter system credentials.