I am pretty new to netdata
a) how do I get the charts from the oracledb collector to show
b) how can I get the collector to use python3 not python2? Both flavours are installed, at the command prompt âpythonâ brings up the system default python2.7.5 while âpython3â brings up python 3.6.8
Environment/Browser
OracleLinux7.6(==Redhat/Centos), Chrome browser, cx_Oracle installed in both python2.7.5 and python3.6.8
What I expected to happen
I expected some charts to appear once this plugin was working. I believe the plugin itself is probably functional it is because the netdata collector now starts without errors after installing cx_Oracle and some libraries running the debug command I found â/usr/libexec/netdata/plugins.d/python.d.plugin oracledb debug traceâ I get output like this continuously scrolling:
BEGIN oracledb_local.tablespace_size 4000735
SET âAPEX_tablespace_sizeâ = 1073741824000
SET âAPEX_3639508696174651_tablespace_sizeâ = 104923136000
SET âAPEX_FILES_tablespace_sizeâ = 209715200000
SET âAUDIT_DATA_tablespace_sizeâ = 34359721984000
SET âFORMS_APEX_POC_DATA_tablespace_sizeâ = 34359721984000
SET âNHBC_COMMON_DATA_tablespace_sizeâ = 34359721984000
SET âSYSAUX_tablespace_sizeâ = 34359721984000
SET âSYSTEM_tablespace_sizeâ = 34359721984000
SET âTEMP_tablespace_sizeâ = 34359721984000
SET âUMNT_DATA_tablespace_sizeâ = 34359721984000
SET âUNDOTBS1_tablespace_sizeâ = 34359721984000
SET âUSERS_tablespace_sizeâ = 34359721984000
END
BEGIN oracledb_local.physical_disk_read_write 4000735
SET âphysical_reads_per_secâ = 25373533
SET âphysical_writes_per_secâ = 0
END
BEGIN oracledb_local.activity 4000735
SET âactivity_parse_count_totalâ = 19606770000
SET âactivity_execute_countâ = 59616973000
SET âactivity_user_commitsâ = 362772000
SET âactivity_user_rollbacksâ = 21743000
END
BEGIN netdata.runtime_oracledb_local 4000735
SET run_time = 3454
END
Thanks for the really helpful replies Ilyam. I implemented those two suggestions and it started working with graphs appearing as well - Iâm pleased to have the python3 in use as it allows me to use the later/current cx_oracle versions.
The netdata.conf file did not have a [plugin:python.d] section at all so I just added one as per your text above. Would that have been the problem? Do plugins normally register themselves or do they always have to be manually entered in the main conf file?
Thanks. The netdata.conf from my epel based install is very different from your example. It is out of the box very empty with only global,web and health sections in it so it is a very short file but I have added a plugin section just holding the pythod.d entry as you advised and that does work. Thanks again.