# OracleDB collector Monitors the performance and health metrics of the Oracle database. ## Requirements - `oracledb` package. It produces following charts: - session activity - Session Count - Session Limit Usage - Logons - disk activity - Physical Disk Reads/Writes - Sorts On Disk - Full Table Scans - database and buffer activity - Database Wait Time Ratio - Shared Pool Free Memory - In-Memory Sorts Ratio - SQL Service Response Time - User Rollbacks - Enqueue Timeouts - cache - Cache Hit Ratio - Global Cache Blocks Events - activities - Activities - wait time - Wait Time - tablespace - Size - Usage - Usage In Percent - allocated space - Size - Usage - Usage In Percent ## prerequisite To use the Oracle module do the following: 1. Install `oracledb` package ([link](https://python-oracledb.readthedocs.io/en/latest/user_guide/installation.html)). 2. Create a read-only `netdata` user with proper access to your Oracle Database Server. Connect to your Oracle database with an administrative user and execute: ```SQL CREATE USER netdata IDENTIFIED BY ; GRANT CONNECT TO netdata; GRANT SELECT_CATALOG_ROLE TO netdata; ``` ## Configuration Edit the `python.d/oracledb.conf` configuration file using `edit-config` from the Netdata [config directory](https://github.com/netdata/netdata/blob/master/docs/configure/nodes.md), which is typically at `/etc/netdata`. ```bash cd /etc/netdata # Replace this path with your Netdata config directory, if different sudo ./edit-config python.d/oracledb.conf ``` ```yaml local: user: 'netdata' password: 'secret' server: 'localhost:1521' service: 'XE' remote: user: 'netdata' password: 'secret' server: '10.0.0.1:1521' service: 'XE' ``` All parameters are required. Without them module will fail to start. ### Troubleshooting To troubleshoot issues with the `oracledb` module, run the `python.d.plugin` with the debug option enabled. The output will give you the output of the data collection job or error messages on why the collector isn't working. First, navigate to your plugins directory, usually they are located under `/usr/libexec/netdata/plugins.d/`. If that's not the case on your system, open `netdata.conf` and look for the setting `plugins directory`. Once you're in the plugin's directory, switch to the `netdata` user. ```bash cd /usr/libexec/netdata/plugins.d/ sudo su -s /bin/bash netdata ``` Now you can manually run the `oracledb` module in debug mode: ```bash ./python.d.plugin oracledb debug trace ```