[opennms-discuss] Monitoring Oracle DB with openNMS

[Tim Maier]

Hi @ all,
does anyone know how to monitor an oracle db?
I tried it and downloaded the ojdbc5.jar into OpenNMS\lib

If I use this in capsd:

<protocol-plugin protocol="Oracle-JDBC" class-name="org.opennms.netmgt.capsd.plugins.JDBCPlugin" scan="on" user-defined="false">
<property key="user" value="XXX"/>
<property key="password" value="XXX"/>
<property key="retry" value="3"/>
<property key="timeout" value="5000"/>
<property key="driver" value="oracle.jdbc.driver.OracleDriver"/>
<property key="url" value="jdbc:oracle:thin:@OPENNMS_JDBC_HOSTNAME:1521/xxx"/>
</protocol-plugin>

Nothing gets detected an nothing is written in the capsd.log

If I use this:

<protocol-plugin protocol="Oracle-JDBC3" class-name="org.opennms.netmgt.capsd.plugins.JDBCPlugin" scan="on" user-defined="false">
<property key="user" value="xxx"/>
<property key="password" value="xxx"/>
<property key="retry" value="3"/>
<property key="timeout" value="5000"/>
<property key="driver" value="oracle.jdbc.driver.OracleDriver"/>
<property key="url" value="jdbc:oracle:oci:@OPENNMS_JDBC_HOSTNAME:1521/xxx"/>
</protocol-plugin>

I get this error in capsd.log

2008-11-14 12:06:14,562 WARN [Capsd Rescan Pool-fiber0] IfCollector: IfCollector: Caught an exception when testing for protocol Oracle-JDBC3 on host XXX.XXX.XXX.XXX
java.lang.UnsatisfiedLinkError: no ocijdbc11 in java.library.path
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1682)
at java.lang.Runtime.loadLibrary0(Runtime.java:823)
at java.lang.System.loadLibrary(System.java:1030)


But the ocijdbc11.dll is in the opennms\lib directory

I also tried to check the databases with other programs to verify that all parameters are right


Thanks for your help

Tim



Jetzt neu! Schützen Sie Ihren PC mit McAfee und WEB.DE. 30 Tage
kostenlos testen. *http://www.pc-sicherheit.web.de/startseite/?mc=022220* [http://www.pc-sicherheit.web.de/startseite/?mc=022220]

[Umberto Nicoletti]

Post by Tim Maier
does anyone know how to monitor an oracle db?
I tried it and downloaded the ojdbc5.jar into OpenNMS\lib
<protocol-plugin protocol="Oracle-JDBC"
class-name="org.opennms.netmgt.capsd.plugins.JDBCPlugin" scan="on"
user-defined="false">
<property key="user" value="XXX"/>
<property key="password" value="XXX"/>
<property key="retry" value="3"/>
<property key="timeout" value="5000"/>
<property key="driver" value="oracle.jdbc.driver.OracleDriver"/>
<property key="url"
</protocol-plugin>
Nothing gets detected an nothing is wr itten in the capsd.log
<protocol-plugin protocol="Oracle-JDBC3"
class-name="org.opennms.netmgt.capsd.plugins.JDBCPlugin" scan="on"
user-defined="false">
<property key="user" value="xxx"/>
<property key="password" value="xxx"/>
<property key="retry" value="3"/>
<property key="timeout" value="5000"/>
<property key="driver" value="oracle.jdbc.driver.OracleDriver"/>
<property key="url"
</protocol-plugin>
I get this error in capsd.log
IfCollector: Caught an exception when testing for protocol Oracle-JDBC3 on
host XXX.XXX.XXX.XXX
java.lang.UnsatisfiedLinkError: no ocijdbc11 in java.library.path
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:16 82)
at java.lang.Runtime.loadLibrary0(Runtime.java:823)
at java.lang.System.loadLibrary(System.java:1030)
But the ocijdbc11.dll is in the opennms\lib directory

You need the whole oracle 11 client installed AND in path to use the
oci connection type. Try changing the connection string
in the second capsd configuration as follows:

value="jdbc:oracle:thin:@OPENNMS_JDBC_HOSTNAME:1521/xxx"/>

(FYI, I changed the third param from oci to thin).
You can remove the ocijdbc11.dll from the opennms\lib directory as
it's useless there.

Regards,
Umberto

Post by Tim Maier
I also tried to check the databases with other programs to verify that all
parameters are right
Thanks for your help
Tim
Jetzt neu! Schützen Sie Ihren PC mit McAfee und WEB.DE. 30 Tage
kostenlos testen. http://www.pc-sicherheit.web.de/startseite/?mc=022220
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great
prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
http://www.opennms.org/index.php/Mailing_List_FAQ
opennms-discuss mailing list
To *unsubscribe* or change your subscription options, see the bottom of this
https://lists.sourceforge.net/lists/listinfo/opennms-discuss