search

ikzelf / zbxdb

Zabbix database monitoring, the easy and extendable way
GNU General Public License v3.0
94 stars 44 forks source link

Need to change Thin mode to Thick mode oracledb (10g) #103

Closed MKH-Beldi closed 7 months ago

MKH-Beldi commented 7 months ago

I have a problem with oracledb that cannot connect to my Oracle 10g instance because oracledb thin mode does not support NNE (Native Network Encryption). Can you suggest a solution without changing anything in my Oracle instance? I need to change oracledb mode from Thin mode to Thick mode.

image

ikzelf commented 7 months ago

Easiest is to switch back to the CXoracle 8.3 Python driver with the oracle instant client libraries. That should support most of sqlnet. From what I see in documentation the new oracle Python driver needs an extra client initialization call that CXoracle did not need.

MKH-Beldi commented 7 months ago

I tried to switch to cx_Oracle, but unfortunately, it doesn't support Oracle 10g; it supports versions 11.2 and above.

image

image

ikzelf commented 7 months ago

In that case, download a newer version of the oracle client libraries. You seem to have a v10 library but need from v11.2. There is a good chance it also connects to a v10 database.

MKH-Beldi commented 7 months ago

It works! by replacing oracle client v10 with v11. However, not all queries are working as expected, as shown in the image below.

image

After verification in Zabbix, I found that some metrics or items have nodata, as shown in the image below.

image

There are also metrics that are working:

image

The question that arises is whether the metrics that did not work because I used oracle client v11 and my Oracle instance is v10, or is it something else.

I appreciate your help and your time, a big thank you.

ikzelf commented 7 months ago

Check your config for the site specific templates. You kept the example for ebs in the config which obviously only works if you have that apps objects in your database. Remove that from your config. There is quite a bit of selfmonitoring in zbxdb. Check in zabbix, in latest data the zbxdb application. That lists the queries, their status and some metrics about the queries. For me, it looks like it works as expected.

MKH-Beldi commented 7 months ago

I really appreciate your help and your great work for this third-party Zabbix Oracle monitoring. All in works know, which for how have the same problem can be resolved with this conversation.