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
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.
Eugene,
I did as you suggested, but I'm getting the following errors:
- 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
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. 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.
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
