4 Replies Latest reply on Mar 7, 2013 4:29 AM by Simon Martinelli

    Oracle XE not autodiscovered

    Simon Martinelli Novice

      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

        • 1. Re: Oracle XE not autodiscovered
          Thomas Segismont Expert

          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

          1 of 1 people found this helpful
          • 2. Re: Oracle XE not autodiscovered
            Simon Martinelli Novice

            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    

            • 3. Re: Oracle XE not autodiscovered
              mazz Master

              > 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

              • 4. Re: Oracle XE not autodiscovered
                Simon Martinelli Novice

                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!

                1 of 1 people found this helpful