...
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 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; |
Understanding your Oracle Connection Settings
If you plan to run Uptime Infrastructure Monitor 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.
The uptime.conf file settings for an Oracle DataStore are:
Code Block | ||
---|---|---|
| ||
dbDriver=oracle.jdbc.OracleDriver
dbType=oracle
dbHostname=oraserv
dbPort=1521
dbName=uptime
dbUsername=name
dbPassword=password |
Below is a sample of a TNS connection string:
Code Block | ||
---|---|---|
| ||
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle1-2-3.yourdomain.com) (PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=oradb.yourdomain.com))) |
Add the values highlighted in bold in the TNS connection string above into the uptime.conf file as follows:
Code Block | ||
---|---|---|
| ||
dbHostname=oracle1-2-3.yourdomain.com
dbPort=1521
dbName=oradb.yourdomain.com |
Step 2 - Configuring Uptime Infrastructure Monitor
After you have created the Oracle database and set up the Uptime Infrastructure Monitor database, you need to configure Uptime Infrastructure Monitor to access the new database.
...