Rockwell Automation Emonitor with an Oracle Multi-User Database - Manual (Page 13)

2 • I NSTALLING THE DATABASE COMPONENTS
9
•
•
•
• •
These scripts are located in the Emonitor program directory
C:\Program Files\Rockwell Software\Emonitor.
The guideline for index file sizing is about 25% of the data file. This is quite generous and
can be changed if needed.
1. Using SQL*Plus, connect to Oracle as an administrator.
2. Create the tablespaces to hold the tables using these commands.
create tablespace entekd datafile 'entekd.ora' size 600M;
create tablespace enteki datafile 'enteki.ora' size 150M;
create tablespace econfigd datafile 'econfigd.ora' size
50M;
create tablespace econfigi datafile 'econfigi.ora' size
10M;
3. Create Entek and Econfig users using the commands below.
create user entek
identified by euser
default tablespace entekd
quota unlimited on entekd
quota unlimited on enteki;
create user econfig
identified by econfig
default tablespace econfigd
quota unlimited on econfigd
quota unlimited on econfigi;
4. Grant the users proper rights by using these commands.
grant connect, resource, create view to entek;
grant connect, resource to econfig;
You are creating two schema, the entek schema and the econfig schema. Both are needed
for the software to run properly. The entek schema holds the collected vibration data and
other items to run the software. The econfig schema holds the database configuration
information and does not grow much. All data is housed in entekd.
We recommend using a different password for the ECONFIG database user than the
password used for the vibration database or databases. You may be required to reinstall
Emonitor if you accidently connect to the ECONFIG database using File > Change Database
in Emonitor if the ECONFIG database uses the same password as an Emonitor vibration
database.