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:

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:

(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:

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