Page History

...

The Uptime Infrastructure Monitor DataStore can run on an Oracle database to leverage existing Oracle installations and take advantage of Oracle's advanced replication, recovery and archiving features. This article assumes that you have already installed Uptime Infrastructure Monitor and have an Oracle database available. For more information, see Supported databases in UIMUptime Infrastructure Monitor.

Step 1: Preparing the Oracle database

To run UIM with an Oracle database, first create a database on your Oracle instance that UIM will be able to use. If you are unsure which databases are available to you or how to create a new database, please contact your Oracle administrator and have a database configured for UIM.

...

create tablespace uptime_data logging
datafile '/u01/app/oracle/oradata/uptime/uptime_data' size 10000m 
blocksize 8192
extent management local uniform size 256k 
segment space management auto
online;

create user uptime identified by password default 
tablespace uptime_data;

grant connect to uptime;
grant create session to uptime; 
grant create table to uptime; 
grant create sequence to uptime; 
grant create procedure to uptime; 
grant create synonym to uptime; 
grant create view to uptime;

alter user uptime quota 10000m on uptime_data; 

grant unlimited tablespace to uptime;

Step 2: Configuring UIM

After you have created the Oracle database and set up the UIM database, you need to configure UIM to access the new database.

...

#dbDriver=oracle.jdbc.OracleDriver 
#dbType=oracle 
#dbHostname=10.1.1.124 
#dbPort=1521
#dbName=uptime 
#dbUsername=uptime 
#dbPassword=password

Understanding your Oracle connection settings

If you plan to run UIM with an Oracle DataStore, you can use the information in the Oracle TNS connection string to populate database-specific fields that need to be set in the uptime.conf file.

...

dbHostname=oracle1-2-3.yourdomain.com 
dbPort=1521 
dbName=oradb.yourdomain.com

Step 3: Resetting the UIM DataStore

Reset the Uptime DataStore settings to create the tables and default values required by UIM on your Oracle database. To do this, run the following command on your UIM Monitoring Station:

...

Step 4: Restarting UIM

After the resetdb utility has finished updating your database settings, restart Uptime Infrastructure Monitor. When Uptime Infrastructure Monitor restarts, it will be running from your Oracle database with an empty Uptime Infrastructure Monitor installation.