Hi,
Someone was able to setup LibreNMS to monitor server with Oracle DB ?
I played with nagios plugin implemented in LibreNMS, but no luck…
The nagios plugin is the way… why no luck?
btw. Adding something like this to LibreNMS wiki will be awesome help for others…
/usr/lib64/nagios/plugins/check_oracle
On server with LibreNMS:
- install client from Instant Client for Linux x86-64 (64-bit) | Oracle Polska (example oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm)
- install sqlplus from Instant Client for Linux x86-64 (64-bit) | Oracle Polska (example oracle-instantclient12.1-sqlplus-12.1.0.2.0-1.x86_64.rpm)
- add to /usr/lib64/nagios/plugins/check_oracle
export ORACLE_HOME=/usr/lib/oracle/12.1/client64
export ORACLE_SID=SI01
export TNS_ADMIN=/etc
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$PATH:$ORACLE_HOME/bin
- create /etc/tnsnames.ora
example =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (COMMUNITY = tcp.world)(PROTOCOL = TCP)(Host = example.local)(Port = 1521))
)
(CONNECT_DATA =
(SID = SI01)
)
)
From server with your oracle db copy to LibreNMS server:
<ORACLE_HOME>/network/mesg/tnsus.msg
<ORACLE_HOME>/network/mesg/tnsus.msb
You can now use ./check_oracle --tablespace example user pass USERS
1 Like