• Forums
    • Public Forums
      • Community Connect
      • Dynatrace
        • Dynatrace Open Q&A
      • Application Monitoring & UEM
        • AppMon & UEM Open Q&A
      • Network Application Monitoring
        • NAM Open Q&A
        • Enterprise Synthetic Monitoring
      • Synthetic Classic
        • Synthetic Classic Open Q&A
      • BSM Open Q&A
  • Home /
  • Public Forums /
  • Application Monitoring & UEM /
  • AppMon & UEM Open Q&A /
avatar image
Question by Ritesh S. · Jul 12, 2012 at 01:46 PM ·

Oracle Monitor Plugin not running

Hi I have installed the Oracle Monitor Plugin, at a customer place in production but I am not able to connect to get any data.

I had tested the same in the UAT environment and it worked fine , however now when I am trying in the production setup I am unable to connect.

I get the following errors.

ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
The Connection descriptor used by the client was:
192.168.25.89:1521/bvsbipr

I am able to manually connect to the database using the same user id and Password. But when I try through the plugin I am unable to do so.

The collector used is running on the dynaTrace Warehous server, which has an Oracle Database already installed , do I still need to install a client?

Also as far as I understand , we use jdbc connection even for the plugin to get information and not an Oracle client , so do we still need a client for getting connection.

Attaching herewith are the screen shots of the error.

Request help.

Thanks and Regards,
Ritesh.

Comment

People who like this

0 Show 0
10 |2000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

4 Replies

· Add your reply
  • Sort: 
  • Most voted
  • Newest
  • Oldest
avatar image

Answer by Ritesh S. · Jul 12, 2012 at 01:52 PM

Please find the screen shots of the configuration and error.

Comment

People who like this

0 Show 1 · Share
10 |2000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users
avatar image Roman S. · Jul 12, 2012 at 03:23 PM 0
Share

The error message you get points at the database not being known by the listener, you are not even at the point where user/password would be checked.

I would take a look at the source of the Oracle plugin to see how it assembles the JDBC connection string. Once you have the string you can try if your DB tool can connect using this, if not adjust the plugin accordingly.

Best, Roman

avatar image

Answer by Mohammed I. · Jul 12, 2012 at 06:55 PM

I have un jared the oracle plugin jar file and found the below code is commented

private String getConnectionUrl() { if (url.equals("jdbc:oracle:thin")) {

         /*jdbc:oracle:thin:/@localhost:1521:diagrepo20
         url=jdbc:oracle:thin
         serverName=localhost
         portNumber=1521
         databaseName=diagrepo20
         userName=cmillerjava
         password=
          */
         
         //Oracle thin driver new syntax - http://www.orafaq.com/wiki/JDBC
         return url + ":" + "//@" + host + ":" + port + "/" + dbService;
     }
     else if (url.equals("jdbc:jtds:sqlserver")) {

         /*
         jdbc:jtds:sqlserver://localhost:41884/diagrepo20;
         url=jdbc:jtds:sqlserver
         serverName=localhost
         portNumber=41884cd ..
          *
         databaseName=diagrepo20
         userName=cmillerjava
         password=
          */
         return url + ":" + "//@" + host + ":" + port + ":" + dbService;
     }
     return new String("");
 }

If I have understood your above comment correctly, this code has to be uncommented and edited with the ip address of the installed Oracle host machine instead of the localhost

Please find the Jar fill attached

Regards Ibrahim ]]>

Comment

People who like this

0 Show 1 · Share
10 |2000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users
avatar image Roman S. · Jul 12, 2012 at 06:59 PM 0
Share

Hi Ibrahim,

I have not written this plugin but looking at the source code it is now generating the URL by using the parameters you pass into the plugin:

 
return url + ":" + "//@" + host + ":" + port + "/" + dbService;

The question really is - how does the JDBC URL need to look like in order to work. Once you have figured that out you can adjust the plugin to generate the right format. In order to test the JDBC URLs you could use a tool like SQuirreL - http://squirrel-sql.sourceforge.net.

Best, Roman

avatar image

Answer by Rob V. · Jul 12, 2012 at 08:06 PM

Ibrahim,

Look into your TNSNAMES.ORA file and find the service name for the TNS name that you are trying to use. Put that in as the DBNAME in the Oracle plugin. For example, on my system this works fine going from a Windows-based collector to a Linux oracle server:



 
 
Does this work for you?
 
Rob
 

Comment

People who like this

0 Show 0 · Share
10 |2000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users
avatar image

Answer by Ritesh S. · Jul 13, 2012 at 02:20 PM

Hi Rob,

Actually this was one of the first things that I had checked with the local DB Administrator.

However , we have now managed to get the correct Service_Name, out of the 3 that are in place so we are able to get the data .

Thanks and lot for your inputs.

Regards,
Ritesh

Comment

People who like this

0 Show 1 · Share
10 |2000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users
avatar image Rob V. · Jul 13, 2012 at 07:16 PM 0
Share

Excellent! Glad to help.

Rob

Your answer

Hint: You can notify a user about this post by typing @username

Up to 10 attachments (including images) can be used with a maximum of 52.4 MB each and 262.1 MB total.

Welcome to the
Dynatrace Community Forums

Check out the Forum User Guide and Forum Guidelines to learn how to get started.

Community Member of the Month
February 2019

Announcing Dynatrace's Community Member of the Month for February 2019, Larry R.! Click here to read more!

Employee Member of the Month
February 2019

Announcing Dynatrace's Employee Member of the Month for February 2019, Dave M.! Click here to read more!

Live webinar: AIOps done right through enhanced Dynatrace AI root cause detection

Learn the enhanced capabilities of the next generation Dynatrace AI root cause analysis and how to feed it with your own data sources.
Wednesday, February 20, 2019
Register today!

Live webinar: AIOps done right through enhanced Dynatrace AI root cause detection

Learn the enhanced capabilities of the next generation Dynatrace AI root cause analysis and how to feed it with your own data sources.
Wednesday, February 20, 2019
Register today!

NAM 2019 Beta is available

Would you like to have an early taste of what we have cooked up for 2019? We would love to hear your feedback and improve some of the new features. Check NAM 2019 Beta release notes.
Sign up today!

Follow this Question

Answers Answers and Comments

4 People are following this question.

avatar image avatar image avatar image avatar image

Forum Tags

nginx java dotnet docker 6.5 ios customization knowledge sharing browser agent mobileapp sensor chart 7.1 hybris 6.3+ production incidents Dynatrace Managed php javascript processes monitoring nodejs uem splunk license framework good to know installation web services plugin splitting rest webserver reports 7.0 kubernetes errors rum mainframe 6.1 account configuration forum user guide security web dashboard agent load window oneagent upgrade diagnostics search scheduler appmonsaas log analytics database performance warehouse services web performance monitoring user sessions test automation transactionflow measures business transaction migration plugins android dashlet server purelytics 6.2 rest api system profile appmon appmon 7 mobile monitoring collector adk messagebroker purepath apache guardian appmon iis 7.2 dashboard mq kibana client continuous delivery unique users postgresql sensors documentation alerting auto-detection 6.3 administration
  • Forums
  • Public Forums
    • Community Connect
    • Dynatrace
      • Dynatrace Open Q&A
    • Application Monitoring & UEM
      • AppMon & UEM Open Q&A
    • Network Application Monitoring
      • NAM Open Q&A
      • Enterprise Synthetic Monitoring
    • Synthetic Classic
      • Synthetic Classic Open Q&A
    • BSM Open Q&A