blob: 722c77b7532feaecb95c44f529f592f812afea36 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
|
<!--
title: "OracleDB monitoring with Netdata"
custom_edit_url: "https://github.com/netdata/netdata/edit/master/collectors/python.d.plugin/oracledb/README.md"
sidebar_label: "OracleDB"
learn_status: "Published"
learn_topic_type: "References"
learn_rel_path: "Integrations/Monitor/Databases"
-->
# OracleDB collector
Monitors the performance and health metrics of the Oracle database.
## Requirements
- `cx_Oracle` package.
- Oracle Client (using `cx_Oracle` requires Oracle Client libraries to be installed).
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 `cx_Oracle` package ([link](https://cx-oracle.readthedocs.io/en/latest/user_guide/installation.html)).
2. Install Oracle Client libraries
([link](https://cx-oracle.readthedocs.io/en/latest/user_guide/installation.html#install-oracle-client)).
3. 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:
```
ALTER SESSION SET "_ORACLE_SCRIPT"=true;
CREATE USER netdata IDENTIFIED BY <PASSWORD>;
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
```
|
