Creating Oracle database for a Smart IT upgrade

Before you begin

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

To create an Oracle database

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

   create user SmartIT_Business_New identified by SmartIT default tablespace USERS temporary tablespace TEMP quota unlimited on USERS;
   
   create user SmartIT_System_New  identified by SmartIT default tablespace USERS temporary tablespace TEMP quota unlimited on USERS;
    
   grant create sequence, create table, create view, create session, alter session to SmartIT_Business_New;
   
   grant create sequence, create table, create view, create session, alter session to SmartIT_System_New;
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 Blank Schemas option in the Smart IT Database Information dialog box. When you select this option, you are not prompted to enter DBA credentials.