...
| Note | ||||
|---|---|---|---|---|
| ||||
| This script is provided as an example. Your exact steps and settings will vary depending on your Oracle database configuration. |
| Code Block | ||
|---|---|---|
| ||
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 create session to uptime; |
...
grant create table to uptime; |
...
grant create sequence to uptime; |
...
alter user uptime quota 10000m on uptime_data; |
Also set up the following permissions, which are sufficient for up.time to create the up.time data structure and continue with standard operations:
...
To do this, edit the uptime.conf file (located in the up.time installation folder) and add a # character to the beginning of each of the following lines:
| Code Block | ||
|---|---|---|
| ||
dbDriver=com.mysql.jdbc.Driver |
...
dbType=mysql |
...
dbHostname=localhost |
...
dbPort=3308 |
...
dbName=uptime |
...
dbUsername=uptime |
...
dbPassword=uptime |
Just below the lines listed above, there is a second group of lines in the uptime.conf file that define how up.time will connect to an Oracle database (see below). Remove the # character from the start of these lines and update the dbHost, dbPort, dbName, dbUsername and dbPassword to match the settings of your Oracle database and the user that you created in Step 1.
| Code Block | ||
|---|---|---|
| ||
#dbDriver=oracle.jdbc.OracleDriver |
...
#dbType=oracle |
...
#dbHostname=10.1.1.124 |
...
#dbPort=1521 |
...
#dbName=uptime |
...
#dbUsername=uptime |
...
#dbPassword=password |
Step 3 - Resetting the up.time DataStore
Reset the up.time DataStore settings to create the tables and default values required by up.time on your Oracle database. To do this, run the following command on your up.time monitoring station:
| Code Block | ||
|---|---|---|
| ||
up.time_install_path/resetdb really |
| Note | ||
|---|---|---|
| ||
| This command will reset any existing up.time-specific database settings. Before running this command, ensure that the settings in the uptime.conf file are correct. |
...