• 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
  • Home /
  • Public Forums /
  • Application Monitoring & UEM /
  • AppMon & UEM Open Q&A /
avatar image
Question by Divine A. · Mar 21, 2015 at 04:27 AM · plugins

Oracle Database Plugin

Hi,

 I was able to install the Oracle Plugin V 1.0.11

However,  I was not able to retrieve any data/charts from the database dashboard or any of the dashlets after successfully creating the DB schema, deploying the war file

& installing the plugin. (the dashboard keeps pointing to a default web URL(http://localhost:8080/SqlMVC/search)

Please help resolve this issue

 

 

Comment

People who like this

0 Show 0
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

3 Replies

  • Sort: 
  • Most voted
  • Newest
  • Oldest
avatar image

Answer by Divine A. · Mar 26, 2015 at 12:36 AM

Hi Eugene,

We're using a wso2carbon carbon web server & will adjust the html files accordingly.

I will send you the Configure Oracle Monitor scrren shot via your email

Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image

Answer by Divine A. · Mar 25, 2015 at 09:13 AM

Eugene,

I did as you suggested, but I'm getting the following errors:

  1. When I click on the Tablespace dashlet I get: HTTP ERROR 404

    Problem accessing /statics/images/oracle/tablespaces.html. Reason:

        ProxyServlet: /statics/images/oracle/tablespaces.html

     

  2. When I click on another dashlet like the Analysis of top SQL dashlet I get Exception: SqlMVC: SearchService searchTopSqls method: There are no names in the T_SRC_DB_NAME table

    com.dynatrace.diagnostics.plugins.web.mvc.service.SearchService.searchTopSqls(SearchService.java:42)

    Please advise

Comment

People who like this

0 Show 1 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image Eugene T. · Mar 25, 2015 at 12:32 PM 0
Share

Hi Devine,

Regarding #1: the HTTP ERROR 404 means that the tablespaces.html file is not located in the

DT_HOME/server/plugins/com.dynatrace.diagnostics.webservices/WebContent/statics/images/oracle directory, assuming that you are using an embedded in the Dynatrace distribution internal Web server which enablement is described in the KB-381. So, please check value of the htmlFileTablespaces configuration parameter of the plugin to make sure that it is setup correctly. If you are using different Web server, please adjust the htmlFileTablespaces and URL field of the Tablespaces dashlet appropriately following this server documentation.
 
Regarding #2: Please attach here a screenshot of the Configure Oracle Monitor screen. I'd like to check settings of the plugin before moving further. If you cannot attach screenshot, feel free to e-mail it to me directly at eugene.turetsky@dynatrace.com.
 
Eugene. 
 
avatar image

Answer by Eugene T. · Mar 23, 2015 at 02:15 AM

Hi Devine,

In order to change URL in the Web Page dashlets please go to Dashlet Properties --> Content. In the URL field enter URL for each of the following dashlets: Analysis of Slow SQL, Analysis of Locks, Explain Plan, Analysis of Tablespaces. These dashlets require creation of the DB schema for plugin's historical tables and Web UI war file to be deployed on application server of your choice. Slow SQL, Oracle Locks, and Tablespaces dashlets do not require historical tables and Web UI war file to be deployed on the application server. The htmlFileSqls, htmlFileLocks, and htmlFileTablespaces configuration parameters are pointing to the location of the appropriate html files on the Web server of your choice. These Web Page dashlets should be configured similar to the above Analysis dashlets, i.e. by going to Dashlet Properties --> Content and setting up appropriate URL fields. Please see this page for details or Oracle Monitor plugin documentation, Section 2 Configuration of the plugin.

Let me know if you still have issues.

 Eugene.

Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

How to get started

First steps in the forum
Read Community User Guide
Best practices of using forum

NAM 2019 SP5 is available


Check the RHEL support added in the latest NAM service pack.

Learn more

LIVE WEBINAR

"Performance Clinic - Monitoring as a Self Service with Dynatrace"


JANUARY 15, 3:00 PM GMT / 10:00 AM ET

Register here

Follow this Question

Answers Answers and Comments

3 People are following this question.

avatar image avatar image avatar image

Related Questions

Email Alerting only when error count exceeds particular value in a time interval

Data of performance warehouse - Any documentation about the data?

Plugin to monitor process and restart

Could you please provide details on how to integate Dynatrace with the Jenkins pipeline. In particular running Jmeter tests

PHP database sensor packs?

Forum Tags

dotnet mobile monitoring load iis 6.5 kubernetes mainframe rest api dashboard framework 7.0 appmon 7 health monitoring adk log monitoring services auto-detection uem webserver test automation license web performance monitoring ios nam probe collector migration mq web services knowledge sharing reports window java hybris javascript appmon sensors good to know extensions search 6.3+ server documentation easytravel web dashboard kibana system profile purelytics docker splunk 6.1 process groups account 7.2 rest dynatrace saas spa guardian appmon administration production user actions postgresql upgrade oneagent measures security Dynatrace Managed transactionflow technologies diagnostics user session monitoring unique users continuous delivery sharing configuration alerting NGINX splitting business transaction client 6.3 installation database scheduler apache mobileapp RUM php dashlet azure purepath agent 7.1 appmonsaas messagebroker nodejs 6.2 android sensor performance warehouse
  • 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