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
Answer by Divine A. ·
Eugene,
I did as you suggested, but I'm getting the following errors:
Problem accessing /statics/images/oracle/tablespaces.html. Reason:
ProxyServlet: /statics/images/oracle/tablespaces.html
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
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.
Answer by Eugene T. ·
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.
JANUARY 15, 3:00 PM GMT / 10:00 AM ET