Oracle TimesTen Configuration Guide
Guide to deploying the Datadog Oracle TimesTen integration from the Datadog marketplace

Overview

The Oracle TimesTen integration enables you to monitor your TimesTen in-memory databases. This integration covers over 200 metrics and provides details about your top queries, database status, execution times, and much more.

Setup

Prerequisites

The Oracle TimesTen instant client and development package must be installed on the same system as the Datadog Agent and configured to connect to the TimeTen DB to be monitored. 1. Download the packages from Oracle:
1
wget https://download.oracle.com/otn_software/linux/instantclient/19600/oracle‐instantclient19.6‐basic‐19.6.0.0.0‐1.x86_64.rpm
2
wget https://download.oracle.com/otn_software/linux/instantclient/19600/oracle‐instantclient19.6‐devel‐19.6.0.0.0‐1.x86_64.rpm
Copied!
  1. 1.
    Install the client and development packages.
    1
    sudo rpm ‐iUv /home/oratta/oracle‐instantclient19.6‐basic‐19.6.0.0.0‐ 1.x86_64.rpm
    2
    sudo rpm ‐iUv /home/oratta/oracle‐instantclient19.6‐devel‐19.6.0.0.0‐ 1.x86_64.rpm
    Copied!
  2. 2.
    Configure the client libraries on the system (NB: these paths need to be configured to match your system).
    1
    cd /etc/ld.so.conf.d/
    2
    sudo echo "/path/to/tt18.1.3.3.0/lib/" > oracle-timesten.conf
    3
    sudo echo "/usr/lib/oracle/19.6/client64/lib" > oracle‐instantclient.conf
    4
    sudo ldconfig
    Copied!
  3. 3.
    Create Oracle TimesTen users for the Datadog Agent Check using ttisql.
    1
    create user datadog identified by datadog;
    2
    GRANT CREATE SESSION to DATADOG;
    3
    GRANT EXECUTE ON SYS.TT_STATS TO DATADOG;
    Copied!

Install Integration

Install the Synthetic Mail Integration. Obtain the command to download the agent by activating the free trial in the Marketplace.

Configuration

  1. 1.
    Edit the oracle_timesten.d/conf.yaml file, in the conf.d/ folder at the root of your Agent's configuration directory.
    See the sample oracle_timesten.d/conf.yaml.example provided during the integration installation for all available configuration options.
    1
    ‐ database: master1:timestendirect
    2
    username: datadog
    3
    password: datadog
    4
    hostname: 127.0.0.1
    5
    verbose_flag: 1
    6
    logs_flag: 1
    7
    timesten_home: '/path/to/oratta/timesten/tt181'
    8
    endpoint: https://http‐intake.logs.datadoghq.com/v1/input/
    Copied!

Validation

Run the Agent's status subcommand and look for oracle_timesten under the Checks section.
Alternatively, you can get detailed information about the integration using the following command.
1
sudo ‐u dd‐agent datadog‐agent check oracle_timesten
Copied!

Support

For support or feature requests please contact RapDev.io through the following channels:
Made with ❤️ in Boston
This isn't the integration you're looking for? Missing a critical feature for your organization? Drop us a note and we'll build it!!
Last modified 10mo ago