Monitoring Oracle with Jop

[joaoantunes87]

Hi, My name is Joao Antunes and I'am new using Jopr.

I have Jopr installed with a Oracle database. And now i want monitoring this database, but when i try add OracleServer manually i have the follow errors:

An unexpected error occurred in the Agent. Cause: java.lang.Exception:Discovery component invocation failed. -> org.rhq.core.pluginapi.inventory.InvalidPluginConfigurationException:Unable to connect to Oracle -> org.rhq.core.pluginapi.inventory.InvalidPluginConfigurationException:Specified JDBC driver class (oracle.jdbc.driver.OracleDriver) not found.

I'm passing the same parameters of database that i passed when installed Jopr Server.

How i monitoring a database oracle? Someone can help me?

PS: Sorry for my bad english

Thanks,
Joao

[mazz]

There are licensing issues that are attached to the Oracle JDBC driver that prohibit us from packaging it in the oracle plugin. You have to get the Oracle JDBC driver yourself and deploy it in the agent yourself. We talk about this here:

http://jopr.org/display/RHQ/Advanced+Build+Notes#AdvancedBuildNotes-BuildingWithOracle

and here:

http://jopr.org/display/RHQ/Maven+Profiles+and+Properties#MavenProfilesandProperties-{{ojdbcdriver}}Profile

(By the way, your english isn't too bad :)

[joaoantunes87]

Thanks!

Problem solved :)!

Another little question. To configure notifications by e-mail: What i have to do?

I simply edit the file rhq-server.properties, but when jopr want make a notification i get this error:

ERROR [AlertManagerBean] One or more notifications for Alert[id=10293] failed: Unknown SMTP host: smtp...

This is very strange because i tested the connection with this smtp and it's all ok. Apparently!

Escaped me something?

Thanks,
Joao

[ips]

Another little question. To configure notifications by e-mail: What i have to do?

I simply edit the file rhq-server.properties, but when jopr want make a notification i get this error:

ERROR [AlertManagerBean] One or more notifications for Alert[id=10293] failed: Unknown SMTP host: smtp...

This is very strange because i tested the connection with this smtp and it's all ok. Apparently!

Escaped me something?

One possibility - make sure the smtp host line in rhq-server.properties does not have any trailing whitespace or any other typos.

[joaoantunes87]

Hi!

My mistake! I had the smtp server name wrong.

Now, it's ok...

Thanks,
João

[rplenz]

Hi Joao,

how did you solve the problem with the jdbc-driver?

When I try to add manually the oracle-inventory i get the following error on the server:

An unexpected error occurred in the Agent. Cause: java.lang.Exception:Discovery component invocation failed. -> java.lang.NoClassDefFoundError:oracle/dms/instrument/ExecutionContextForJDBC

Ralf Lenz

[joaoantunes87]

Hi,

is necessary add the ojdbc.jar in the oracle plugin of Jopr. To this you should create a folder lib/ with ojdbc.jar (make download in oracle site) and add this folder to the corresponding .jar of oracle plugin in rhq/jopr.

To update the .jar file this link maybe is useful:

http://www.iam.ubc.ca/guides/javatut99/jar/basics/update.html

I hope I have helped you.

Joao

[rplenz]

Hi Joao,

thank you for the answer.

I have updated the jar-file this way:

jar um rhq-oracle-plugin-1.3.1.jar lib/ojdbc14.jar

and now I get this error on the server:

An unexpected error occurred in the Agent. Cause: java.lang.Exception:Discovery component invocation failed. -> java.lang.NoClassDefFoundError:org/rhq/plugins/oracle/OracleServerComponent

Did I forget anything?

Ralf