This documentation supports the 18.08 version of Remedy with Smart IT.

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

Creating the Oracle database

Creating a database is a part of preparing for installation process. Use the following procedure to create the Oracle database.

Before you begin

  • Remedy with Smart IT uses the Users tablespace and the TEMP tablespace
  • Make sure that the database server has 20 MB free for each schema.


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.

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.

Note

Do not remove these users after installing Smart IT, because all Smart IT data is stored under these user accounts.

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

Comments