Oracle XE not autodiscovered

[simas_ch]

Hi,

I added the jdbc Driver to the oracle plugins lib directory.

But there is no autodiscover of my oracle xe database on the server where the rhq-agent is installed.

What do I have to do to make it work?

Thanks, Simon

[tsegismont]

Hi Simon,

The Oracle plugin descriptor declares this query for process scan:

process|basename|match=^ORACLE.*

I don't know if Oracle Express Edition executable name begins with "ORACLE". We would welcome a contribution to expand the types of supported Oracle databases

You can still manually add an Oracle server resource at the platform level using the Import button in the 'Inventory > Child resources' tab

Regards,

Thomas

[simas_ch]

Hi Thomas,

Ah I see.

1) the process name is oracleXE where can I add this descriptor?

2) when i add oracle manually i get an exception:

java.lang.RuntimeException:[1362561491164] org.rhq.core.clientapi.agent.PluginContainerException:Failed to add resource with type [Oracle Server] and parent resource id [10271] -> org.rhq.core.util.exception.WrappedRemotingException:null -> org.rhq.core.util.exception.WrappedRemotingException:Discovery component invocation failed. -> org.rhq.core.util.exception.WrappedRemotingException:Unable to connect to Oracle -> org.rhq.core.util.exception.WrappedRemotingException:Specified JDBC driver class (oracle.jdbc.driver.OracleDriver) not found.

Where do I have to put the jdbc driver on the server? It's 4.6

Thanks,

Simon    

[mazz]

> Where do I have to put the jdbc driver on the server? It's 4.6

If you are just monitoring Oracle DB with the agent (and NOT using Oracle as RHQ's own database backend) you don't put the Oracle JDBC driver anywhere in the server. Its not needed.

Rather, you need to put it in the proper place inside the Oracle plugin. It should go in the oracle plugin jar's /lib directory. Do a Google search on "rhq oracle plugin" and you'll get a few hits. For example, this talks about a similiar issue: https://community.jboss.org/thread/164396

[simas_ch]

I had to add lib\ojdbc5.jar in the rhq-oracle-plugin-4.6.0.jar

With lib\ojdbc6.jar it didnt work. So ojdbc5.jar seams to be referenced anywhere.

Thanks for you help!