Icon

Comments have been closed on this page. Please use AppMon & UEM Open Q & A forum for questions about this plugin.

  1. Anonymous (login to see details)

    I have installed the plugin/dashboard and verified in the log that my Oracle monitor is connection successfully to the DB. However the metrics displayed above are no where to be found so my dashboad has no data. I am using DT 3.5.2.2402. Any ideas?

    1. Anonymous (login to see details)

      Hi Jason

      Does the monitor execute successfully? Can you check the Tasks/Monitor Dashlet and verify the last execution status?
      If you look at the details you should see the values that were queried by the last monitor execution

  2. Anonymous (login to see details)

    Adding to Jason's comment above, we were able to figure this out. The monitor has to be called RepositoryDB. Seems like that name is hard-coded in the plugin.

    1. Anonymous (login to see details)

      You are correct - the pre-build dashboard that comes with this monitor uses RepositoryDB as monitor name.

      I will add this to the description of this monitor.
      Thanks for letting us know

      Andi

    2. Anonymous (login to see details)

      SInce I'm new in using Dynatrace, could you please tell me how I 'name'  the monitor RespositoryDB ?

       I've imported the plugin(1.0.5) , defined the parameters to connect to the oracle database... what are the next steps to get it to work  ?

      1. Anonymous (login to see details)

        Hi Jan

        Monitors get executed on a pre-defined schedule on a Collector. So - once you have configured the monitor and defined a schedule and collector you should be able to analyze the captured data using e.g: a chart.
        You can add a chart to a dashboard and add the measures returned by the monitor and look at the collected data

        If you are new to dynaTrace I definitely recommend checking out some basic stuff about monitoring: dynaTrace 4 - Core Concepts - Monitoring your Application

        1. Anonymous (login to see details)

           

          I think above link is broken. Could you please fix it.

          1. Anonymous (login to see details)

            Since this posting from Jan 2012 we moved these online classes to APM University. Here is the link to the Product Fundamentals for dynaTrace: http://apmuonline.compuwareapm.com/course/index.php?categoryid=580


             

  3. Anonymous (login to see details)

    Hi,

    I'm using Oracle Plugin and its works fine generate incidents if Oracle Server is running properly,But if Oracel Server is down then in that case it gives me error and not able to generate Incidents.

    Please suggest.

    1. Anonymous (login to see details)

      Hi Amol
      I think you've asked the same question on the forum where I posted an answer: Oracle Plugin Issue

  4. Anonymous (login to see details)

    A DBA setting up a user for this Monitor was concerned that the roles requested allow table creation. Is this so? and if true, is this necessary? 

    1. Anonymous (login to see details)

      Hi Kia

      I am not sure if that is true. The user must have read access to the v$ tables - thats all

  5. Anonymous (login to see details)

    Is there an Oracle monitor plugin specific for dynatrace version 4.1?

    1. Anonymous (login to see details)

      This Oracle Monitor should work well with 4.x. Give it a try

      1. Anonymous (login to see details)

        Andreas,

        I was able to add the monitor on 4.1 but I dont know how to use it on a dashboard. I downloaded the dashboard with this plugin but can you let me know how I can import it on to an existing dynaTrace server?

        Nikhil

        1. Anonymous (login to see details)

          Import the dashboard, edit the dashboard properties, and change the source to be your dT Server and profile.
          Then be sure to import the plugin, edit your profile, create a new monitor of this type, and specify necessary parameters.

        2. Anonymous (login to see details)

          If you already have the monitor configured, you can edit the dashboard XML with your favorite text editor. Do a replace all on 'RepositoryDB' with the name of your Oracle monitor. As Joe said, the source (dynaTrace server and system profile) can be changed via the dashboard properties.

  6. Anonymous (login to see details)

    Good day

    I am trying to get the Oracle Monitoring Plugin working. I have everything installed as described. In my instance the monitor has to connect through a Unix Based Collector and connect to an Oracle 11G Virtual IP. I have tried all types of connecting combinations, but I cannot get it to connect. It says incorrect login details. How can I debug this some more?  Can the monitor connect through the VIP or should the connection go to each database directly?

    Anton

  7. Anonymous (login to see details)

    I am trying to get the oracle monitor plugin working and I am getting a message that says SQL Exception Exception.  But it doesn't tell me what the exception is.  Is this being written out to a log anywhere so I can figure out what the issue is?

    1. Anonymous (login to see details)

      Every plugin will create a log file. Can you look there for more details? You should be able to find the logfile in the System Information Dashlet under the Collector that executes that plugin

  8. Anonymous (login to see details)

    Does this plugin support Oracle RAC database?

    1. Anonymous (login to see details)

      Hi Matthew,

      It does support Oracle RAC.

      Eugene.

  9. Anonymous (login to see details)

    Would it be possible to extend this plugin to query DBA_LOCKS to enable monitoring of database locks?

    1. Anonymous (login to see details)

      Hi Dean,

      Enhanced version of the plugin which monitors database locks is coming very soon. Please watch this page for updates.

      Eugene.

      1. Anonymous (login to see details)

        Thanks Eugene.  I will keep a close eye.

        1. Anonymous (login to see details)

          Hi Dean,

          The Enhanced Oracle Monitor Plugin is released today. Among other things it allows to monitor database locks historically.

          Let me know if you have any further questions.

          Eugene.

  10. Anonymous (login to see details)

    Eugene,

    Awesome improvement. Thanks much.

    Would it be possible to get a higher resolution closeup picture for the Explain Plan graphic?  Even when you click on the detail view, it's not readable. 

    Some of the others were also too small on the closeup view, may want to check the others.

    thanks much

    joe

    1. Anonymous (login to see details)

      Hi Joe,

      I have changed a way images are displayed on the wiki page. Now they should be readable. Just click on image and zoom in if necessary.

      Eugene.

  11. Anonymous (login to see details)

    Eugene pointed out that it may be necessary to click a second time (effectively a zoom) on the image to make it readable.

  12. Anonymous (login to see details)

    Hi Eugene,

    Is it worth noting that the v$ table names are dynamically generated and therefore select privileges cannot be applied to them? The actual table names are v_$.

    Thanks,

    Tim Hard

    1. Anonymous (login to see details)

      Hi Tim,

      Thank you for pointing this out. Strictly speaking all referenced on our page objects are public synonyms:

      The dba_object is a public synonym to the sys.dba_object view:

      The V_$... and GV_$... are views not tables:

      Reason we haven't provided sql script to grant SELECT privileges to the above views is that different installations have different rules: some are using roles to grant privileges (preferable) others are using direct grants for specific users to the objects. We did not want to interfere with established customer rules. However, if we see issues with setting up SELECT privileges to views, we definitely post a script here.

      Thanks again for your post.

      Eugene.

  13. Anonymous (login to see details)

    Anyone else getting a 'not permitted' error when trying to download 1.0.9?  Downloading 1.0.8 works ok.

    1. Anonymous (login to see details)

      Hi Kevin. Download works well for me. Can you try a different browser? Or clear your browser cache first and then try again?

      1. Anonymous (login to see details)

        Yup, working now, thanks Andi!

  14. Anonymous (login to see details)

    After going through the documentation, I could see that we need to deploy a WEB GUI also. Is it mandatory to have the WEB GUI .Cant we monitor the DB by just installing the plugin and configuring it by providing relevant DB details?

     

    1. Anonymous (login to see details)

      Hi Anurag,

      You do not need to deploy WEB GUI part of the plugin. It is optional. If you are not planning to use "Analysis of Slow SQLs", "Analysis of Locks", and "Explain Plans" dashlets, you can skip installation of the SqlMVC application.

      Eugene.

  15. Anonymous (login to see details)

    I am a little confused by the 1.0.9 documentation; In the case that there are multiple databases and multiple database server across multi application system profiles; Does this mean I would need to set-up a tomcat instance for each, db server ? In setting the env var and creating a database properties, it appears to be 1:1. I am trying to understand  as we expand this capability to multiple database, the best archecture of this installation. 

    This is a great enhancement, so I am looking to take full advantange of the value that it provides. 

    Thank you for posting the update. 

    1. Anonymous (login to see details)

      Hi Brian,

      The Enhanced Oracle Monitor Plugin requires just one instance of the application server (i.e. Tomcat, Jetty, JBoss, etc.) to monitor multiple databases. Plugin has two pieces: regular plugin which is a dynaTrace plugin jar file; a Web UI application which displays data gathered by the plugin and is a war file. Plugin piece of the monitor is gathering data from the given database defined by the hostName, dbPort, dbName,... and persist it in the historical tables which are located in some Oracle instance. This Oracle instance is identified by the hostNameHistory, dbPortHistory, dbNameHistory,... The dynaTrace Performance Warehouse could be used to store historical tables.

      Each plugin piece of the Enhanced Oracle Monitor Plugin is associated with the dynaTrace system profile while Web UI piece is not associated with any dynaTrace system profiles. For given installation you may have multiple instances of the plugin and only one instance of the Web UI application.

      Please let me know if you have further questions.

      Eugene.

      1. Anonymous (login to see details)

        Hello Eugene; 

        Are both sql.html and locks.html supposed to already exist. I feel like we are missing something in the documentation. I ended up creating them, as there was no reference that I could find. 

        example: 

        http://dynatrace-test:8080/myreports/IPS/locks.html

        http://dynatrace-test:8080/myreports/IPS/sql.html

        Warfile deployed

        http://dynatrace-test:8080/SqlMVC

        We have set-up tomcat 7, on the dynatrace server (Port 8080), We have deployed the war file and executed the ddl against the database. It appears we have filled out the monitor correctly but we are receiving errors on monitor execution. 

        Type: Oracle Monitor
        Last Run: 16:35:17 (EST)
        Last Run Result: failed
        Next Run: 16:36:17 (EST)
        Current Run: -
        Duration (last run): < 1s
        Schedule: Every Minute
        Execution Target: dynaTrace Collector@uatdynatraceapm
        Plugin Active: active
        Result Status: failed
        Result: Last polling execution failed
        Reason for failure: Error during execution of plug in occurred
        Error message: Calling setup() failed

        I am not finding a good way to actually see what is preventing us from moving forward. Any thoughts and feedback would be appreciated 

        Brian 

        1. Anonymous (login to see details)

          Hi Brian,

          No worries, we will make it working. 

          htmlFileSqls and htmlFileLocks parameters are not correct.  They should point to a file system and not URL (see Figure 1 on page 5 of the plugin documentation). I think setup method could failed because of that. If your Tomcat server is on the same box with the Collector where plugin is running, you can point htmlFileSqls and htmlFileLocks to the <Tomcat-home>/webapps/<some-directory>/sqls.html and <Tomcat-home>/webapps/<some-directory>/locks.html. Please see example here.

          If you still have issues with the plugin piece, please set log level of the plugin to FINER, reproduce a problem and send me plugin's log file.

          To troubleshoot Web UI, please point to the http://dynatrace-test:8080/SqlMVC/search and send me screenshot.

          Feel free to send me e-mails directly at eugene.turetsky@compuware.com.

          Eugene.

          1. Anonymous (login to see details)

            What if the tomcat and collector are on different hosts? How do we then mention the sql/locks/tablespaces file system in the plugin settings?

            Or is it recommended that we install Tomcat on the collector machine?

            1. Anonymous (login to see details)

              Hi Keerti,

              Tomcat application server (or any other JEE compliant application server) is needed to host Web UI application. If you'd like to use it to serve htmlFileSqls, htmlFileLocks, and htmlFileTablespaces files from Tomcat server then there should be a shared filesystem which Tomcat and the Collector process can access. Please note that the collector process needs to have write access to the shared filesystem. You also can use the Dynatrace internal web server to host these files. Please see items 9 and 10 on page 4 of the section 2 of the plugin documentation.

              You also could have Tomcat server installed on the Collector machine.

              Eugene.

              1. Anonymous (login to see details)

                I have tomcat, dynatrace server and collector on three different machines. So if I use the dynatrace internal web server to host the html files, what would be the requirements? Also can the three machines have different environments (DT server- linux, collector - windows, tomcat - windows)?

                1. Anonymous (login to see details)

                  Hi Keerti,

                  First, if you are planning to use plugin's analysis dashlets, you do not need to have dashlets which are based on files that are set by the  htmlFileSqls, htmlFileLocks, and htmlFileTablespaces parameters. Data which is available in the latter dashlets is subset of data which is presented in the plugin's analysis dashlets.

                  If you still would like to have dashlets which are based on files that are set by the  htmlFileSqls, htmlFileLocks, and htmlFileTablespaces parameters then you have the following choices:

                  • Use  a shared filesystem between Linux (the Dynatrace server box) and Windows (the Collector server box) servers, i.e. the Linux servers mount either an NFS or SMB/CIFS share from the Windows servers. This is preferable solution.
                  • Use embedded Dynatrace Collector on the Dynatrace server and deploy plugin there. In general, it is suboptimal solution because we want to physically separate Dynatrace server with the collectors for demanding installations.

                  Please note that because dashlets are communicating with the Tomcat application server through the HTTP protocol, OS of the server which hosts Tomcat is not relevant.

                  Please let me know if you still have questions.

                  Eugene.

  16. Anonymous (login to see details)

    Hi,

    After I installed Enhanced Oracle Monitor Plugin 1.0.9 on dynaTrace 6.0.0.6662 server successfully, I found that this plugin failed to execute.

    Here is the error message - setup method: htmlFileSqls is null or empty. PS: plugin status is active.

    Could anyone help on that?

    1. Anonymous (login to see details)

      Hi Peter,

      Issue is in the configuration of the Oracle plugin. Parameter htmlFileSqls  is not set. Please set it up and re-execute plugin. Please also setup htmlFileLocks parameter. See Figure 1 on Page 5 of the plugin documentation.

      Let me know if you have further questions.

      Eugene.

  17. Anonymous (login to see details)


    If the Performance Warehouse is used for the storage of historical tables, I am assuming the Performance Warehouse Clean Up Job would have no effect on these new tables.  So another form of data/size management would be needed to maintain these historical metrics?

    1. Anonymous (login to see details)

    2. Anonymous (login to see details)

      Hi Markie,

      Job similar to a job which handles management of the historical metrics inside or outside of the Performance Warehouse will be provided for this plugin. This is included in a coming new release of the plugin. Please note that dynamic measures captured by the plugin are covered by the Performance Warehouse clean up job.

      Eugene.

      1. Anonymous (login to see details)

        Thanks Andreas and Eugene

  18. Anonymous (login to see details)

    Hi Team,

     

    We are using MS SQL database ,so please provide  create_top_sqls_ddl.sql script for MS SQL .

     

    Thanks & Regards,

    Jalpesh

  19. Anonymous (login to see details)

  20. Anonymous (login to see details)

    Hello, 

    Is there a way that the plugin 1.0.8 can store and send credentials in an encrypted format ? The concern from my client is that they are stored or sent in the clear; violating the enterprise security constraints that deal with sensitive data.

    Thanks!

    Stephanie.

    1. Anonymous (login to see details)

      Hi Stephanie,

      Yes, it is possible. We'll need to find out what your customer would like to use from the available 4 choices:

      1. Encrypt the connection between clients and servers.
      2. Authenticate the network client tier: the Database server only accepts connections from clients, or mid-tiers such as the Oracle Application Server, which have a certificate signed by a trusted authority.
      3. Authenticate the Database tier: the JDBC Thin driver can be configured to validate the Database’s certificate. If it hasn’t been signed by a trusted authority, the connection will fail. From the application standpoint, you have proof that the Database can be trusted.
      4. Use SSL as an Authenticate Service on the server (starting in 11.1.0.6 for the JDBC Thin driver): the Database user, as opposed to the network client tier, is authenticated through SSL. In this case each Database user must have his own valid certificate.

      Is it #1 that they are talking about? We also would like to know exact version of the Oracle database. Is their database configured to accept SSL encrypted connections? Listener has to be configured to use TCPS protocol.

      Eugene.

  21. Anonymous (login to see details)

    Hello Eugene,

    I got a workaround for this as my customer provided me specific userid and password. I am trying to set up the monitor but it's failing to run:

    Here's what I have in the logs file :

    2014-08-18 13:19:31 WARNING [OraclePlugin@RepositoryDB_0] could not connect.: Listener refused the connection with the following error:
    ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
    The Connection descriptor used by the client was:
    usvlinkt83:1527/dq7uaxb

    Any idea why ? Thank you for your time and help,

  22. Anonymous (login to see details)

    Hi Stephanie,

    Which version of the plugin you are using and what is a version of Oracle database?

    Eugene.

  23. Anonymous (login to see details)

    Hello Eugene, 

    The version of the plugin is 1.0.8 and the Oracle database version is v11.2.0.3.9. Thanks!

    1. Anonymous (login to see details)

      is there any priviledges the users accessing the DB needs to have for plugin v1.0.8 ? Thanks

      1. Anonymous (login to see details)

        Hi Stephanie,

        No special privileges besides user/password for the Oracle database instance.

        Eugene.

    2. Anonymous (login to see details)

      Hi Stephanie,

      Give me few days to fix this issue. I'll update this page when patch is ready.

      Eugene.

  24. Anonymous (login to see details)

    I am trying to monitor a RAC with the plugin. 

    First it seems from the documentation that I need to use a oracle thin driver connect string.

    Q: What field do I place this connect string in.

    I tried several different fields but the one which makes the most sense is the dbname field.

    Q: what format do I need to use for the thin driver connection string?

    I tried the oracle standard jdbc:oracle:thin@\\host: port\service name  
    I also tried the format in the error message host: port:sid  

     

    Error I am receiving:
     

    2014-09-03 13:21:33 SEVERE [OraclePlugin@BSDC oracle monitor_1] IO Error: NL Exception was generated: IO Error: NL Exception was generated

    2014-09-03 13:23:24 SEVERE [OraclePlugin@BSDC oracle monitor_1] IO Error: Invalid connection string format, a valid format is: "host:port:sid" : IO Error: Invalid connection string format, a valid format is: "host:port:sid"

     

    Any suggestions?

     

    Thanks 

    Eric 

    1. Anonymous (login to see details)

      Hi Eric,

      You do not need to provide the database URL connection string to the Oracle Monitor Plugin, it builds this string internally based on the parameters that are provided to the plugin. Plugin supports thin-style service name URL strings and thin-style SID name URL strings. Please provide basic parameters depicted in the Oracle Monitor documentation, i.e. hostname, dbPort, dbName, etc. Please send me the tnsnames.ora file as well as plugin's FINER log if you still have issues.

      Eugene.

  25. Anonymous (login to see details)

    Eugene,

    Can you tell me how to enable "FINER" logging for the plugin? 

    Thanks

    Eric

    1. Anonymous (login to see details)

      Hi Eric,

      Pickup Manage Plugins option from the Tools drop down list box (see Step 1 in the screenshot here). Double click on the Oracle Plugin in the Installed plugins list (Step 2). Select FINER log level on the pop-up Plugin Properties screen (Step 3). 

      Eugene.

  26. Anonymous (login to see details)

    Hi! 

    The 1.0.9 and 1.0.8 version didn't work with DT6.

  27. Anonymous (login to see details)

    Hi,

    I used the 1.0.9 plugin during a PoC. It worked with DT6.0

    During plugin deployement, we had these two issues we were able to solve:

    • We used a Tomcat on Linux. Before deploying the SqlMVC.war, you have to set variable named ext.prop.dir.  On Linux, to set the environment variable, you have to use the export command. But a variable name containing some dots (.) on Linux is not valid. We had to export a variable named ext_prop_dir. Doing that, we had to update the file named SqlMVC-servlet.xml into the war file, and to replace:
                  <property name="location" value="file:${ext.prop.dir}database.properties"/> by
                  <property name="location" value="file:${ext_prop_dir}database.properties"/>
        We had to expand the war and then repackage it
        I recommend to change this variable name in the next release of the plugin
    • At first, we installed a Tomcat8 version. The SqlMVC application does not work correctly with Tomcat8. We had this exception:
          Error while compiling JSPs: "The method getDispatcherType() is undefined for the type HttpServletRequest"
       We installed Tomcat7 and the exception disappeared. But the method getDispatcherType should be here, even with Tomcat8. Perhaps something wrong with our Tomcat8 installation?

    At the end, plugin worked well and captured valuable data.

    Eric

    1. Anonymous (login to see details)

      Hi Eric,

      Thank you for your observations. The following command exports the ext.prop.dir  environmental variable for Linux/Unix OS'es:

       env "ext.prop.dir=/home/myhome/" bash

      This command will set the ext.prop.dir environmental variable to the /home/myhome/ value. No changes required in the war file. I'll update documentation appropriately.

      In terms of your second question: I'll check if application works on Tomcat 8.

      Again, thank you for your observations.

      Eugene.

       

    2. Anonymous (login to see details)

      Hi Eric,

      I have uploaded on the Oracle plugin page new SqlMVC.war file which supports Tomcat 8 as well as Tomcat 6 and 7. It also supports any JEE compatible application server.

      Please let me know if you have any issues using new war file.

      Eugene.

  28. Anonymous (login to see details)

    Hi, 

    We would like to start using the Oracle plugin to add all this wonderful information to our dynatrace implementation. However the business is a little bit concerned about the impact. Could you please help me to answer this question? 

    • What is the impact of the oracle plugin on the database and thus the business application?

    With regards to the installation, some parts of the installation documentation is not really clear to us.

    • The first thing I would like to know is on what database should we execute the create_top_sqls_ddl.sql. (dynatrace performance warehouse or the application database) 
    • What is the growth rate of the created tables, 

     

    Thanks and regards, 

    Joris

    1. Anonymous (login to see details)

      Hi Joris,

      Impact of the plugin's queries on the monitored database is minimal. In our tests the slowest plugin SQLs were taken few milliseconds.

       Oracle database instance which hosts history tables from the create_top_sqls_ddl.sql script can be dynaTrace performance warehouse instance. No need to create history tables in the application database.

      We haven't done any tests to estimate growth of the history tables. Growth of these tables depends on value of the "Top  Slow SQLs" parameter (default is 10) as well as monitor's schedule. Please note that Oracle plugin creates multiple measures in the performance warehouse which could lead to potential measure explosion. Beside the "Top Slow SQLs" parameter, plugin has two additional parameters which manage volume of saved data: isDynamicMeasure and isExplainPlan.

      Please let me know if you have any further questions.

      Eugene. 

  29. Anonymous (login to see details)

    Hi Eugene, 

    Thanks for these answers, they are really helpful. 

    I noticed to late that the sql script is not compatible with the PostGreSQL. Can you give us some hints on how to convert it to postgreSQL? 

     

    Thanks and regards, 

    Joris

    1. Anonymous (login to see details)

      Hi Joris,

      We have version of the Oracle plugin in beta testing which among other things can use Oracle, MS SQL, or PostgreSQL databases to persist data of the historical tables. However, there is no release date defined for this Oracle plugin version yet.

      Eugene.

       

  30. Anonymous (login to see details)

    Hi Eugene, 

    Is it possible to participate in the beta testing? 

     

    Thanks and regards, 

    Joris

    1. Anonymous (login to see details)

      Hi Joris,

      Absolutely, I'll provide you with link to a beta version of the plugin sometime next week.

      Eugene.

      1. Anonymous (login to see details)

         

        Hello Eugene,

        Would it be possible to participate in the testing too? Thanks

        1. Anonymous (login to see details)

          Hi Stephanie,

          Sure, I'll provide you with link to a beta site. It will be sometime next week as I'm busy this week.

          Eugene.

    2. Anonymous (login to see details)

      Hi Joris,

      The Oracle Monitor version 1.0.10 is available now. It allows using PostgreSql. Here is a script: create_top_sqls_postgresql_ddl.sql that you can use to create plugin's history tables. Keep me updated if you have any questions.

      Eugene. 

  31. Anonymous (login to see details)

    Good morning,

    I've implemented the Oracle plugin for an Oracle Express 11g database. I've done it with Apache Tomcat 8 & dynaTrace version 6. Everything went smoothly but I've encountered a problem during the SqlMVC plugin testing. 

    As you can see in this screenshot "http://imgur.com/sr5uqG8", I've manually added a record in the database. Yet SqlMVC throws an exemption for no records in the database. Before taking the screenshot I've restarted both the oracle database and the Tomcat webserver (in the order). The url in the browser is: "http://localhost:8080/SqlMVC/locks". I've also tried "http://localhost:8080/SqlMVC/search". The corresponding error is "Exception: SearchService searchTopSqls method: There are no names in the T_SRC_DB_NAME table".

    I'm under the impression that the SqlMVC isn't reading out of the correct schema. Is there some way to troubleshoot this problem?
    Is it also possible to turn on verbose logging? I would imagine that SqlMVC would log (in one way or another) the database requests it fires. 

    My connection string is:

    db.url=jdbc:oracle:thin:@localhost:1521/XE (= mind you, it doesn't work with "1521:XE", one has to use "/")
    db.user=dynatrace
    db.password=password.

    Cheers!

    1. Anonymous (login to see details)

      Hi,

      I have performed the following steps and was not able to reproduce problem that you are describing in your post above. Here are steps that I executed:

      1. Created database tables from the sql script located here (db schema owner was changed from c##dt55 to the c##dt551), deployed the Oracle Monitor plugin v 1.0.9 jar file on dynaTrace 5.5 server, deployed SqlMVC war file on Tomcat 8.0. Please see screenshot #1 with the http://localhost:8080/SqlMVC/locks page.
      2. Deleted rows from the c##dt551.T_SRC_DB_NAME table. See screenshot #2
      3. Hit the http://localhost:8080/SqlMVC/locks page and received the same exception that is depicted in your post. See screenshot #3.
      4. Inserted one row in the c##dt551.T_SRC_DB_NAME table. See screenshot #4.
      5. Executed select statement to show content of the c##dt551.T_SRC_DB_NAME table. See screenshot #5.
      6. Hit the same http://localhost:8080/SqlMVC/locks page and received expected page. See screenshot #6.

      I'd like to suggest that you should deploy plugin's jar file and configure it. Please pay attention to the database user name that is configured for the connection to the history database. Database user name is a database schema owner for the history tables. Also make sure that insert SQL statement is followed by the commit statement in case auto commit is set off. Please note that the plugin is persisting data into the history tables while SqlMVC application is displaying tables content in form of web pages.

      I also added logging to the SqlMVC.war application. Please deploy this war file to the application server of your choice. Also put the log4j.properties file into the ${ext.prop.dir} directory and adjust appender's file location in the log4j.properties file. Search for the "SqlMVC:" pattern in the log file to find relevant information.

      In terms of your second note: issue with the JDBC url string was resolved 4 - 5 months ago. Upcoming release of the updated Oracle Monitor plugin among other things contains fix for the JDBC url string. At mean time, we are providing fixed jar file for the customers who is asking about this fix.

      Let me know if you still have issues, then I'll setup webex to walk you through the installation process.

      Eugene.

      1. Anonymous (login to see details)

        Good morning!

        Thank you for the detailed reply and new .war file!.
        I'll do a clean install and report back with my findings.

        Thanks again,

         

        Cheer!

      2. Anonymous (login to see details)

        Hi Eugene,

         

        I'm at a client site having similar issue to the one above. I noted that I did the following (they are using postgresql):

        1. I ran the sql script using user "postgres" in the database "dynatrace62" as my "dynatrace" user cannot run it although dynatrace is the owner.
        2. I configured everything else using "dynatrace" as a user since it is the owner for the database.

        Is this the reason why "Exception: SearchService searchTopSqls method: There are no names in the T_SRC_DB_NAME table" appeared? Is there any workaround to solve this?

         

        Thanks!

         

        Regards,

        Albert

        1. Anonymous (login to see details)

          Hi Albert,

          The plugin part of the monitor and the Web UI part should use the same user id for history tables. Please check it. Also make sure that you have executed at least once the plugin part of the monitor. Please also make sure it was executed successfully.

          Please let me know if you still have issues. You can contact me directly at eugene.turetsky@dynatrace.com.

          Eugene.

  32. Anonymous (login to see details)

  33. Anonymous (login to see details)

    Hi, does this plugin collects contention metrics, such as  index contention (wait to rearrange indexes), row lock contention (wait time for row level locks) etc. If the plugin does not provide such infor, what could be the alternative options? Thanks

  34. Anonymous (login to see details)

    Hi,

    The Oracle Monitor collects any kind of locks including index contention, row level locks, etc.

     Eugene. 

    1. Anonymous (login to see details)

      Thanks a lot Eugene

  35. Anonymous (login to see details)

    When attempting to install the new 1.0.10 plugin we did not see any errors but the plugin was not listed as a monitor in our System Profile.  When I viewed the plugin again in the Server Settings it no longer had the option to check active. 

    Sometimes is says Oracle Monitor Plugin, Oracle SQL, or Oracle Sessions...

    I see the error message in the Server Correlation log below.

    2014-11-14 11:00:24 WARNING [PluginDispatcher] Failed to load extension with id: com.dynatrace.diagnostics.plugins.OraclePlugin.monitor. Exception: com.dynatrace.diagnostics.pde.PluginException: loading class com.dynatrace.diagnostics.plugins.OracleMonitor caused error: com/dynatrace/diagnostics/plugins/OracleMonitor : Unsupported major.minor version 51.0

    1. Anonymous (login to see details)

      Hi Markie,

      I've just re-read your post. Error message is simple: it says that plugin's jar file was compiled with the JVM version which is not supported by JVM 1.6. I'll re-build jar file under dynaTrace 5.5 that you can use it there.

      Eugene.

      1. Anonymous (login to see details)

        Hi Eugene,

        I have tried two different Dynatrace Servers with version 5.5.  I removed the plugin, restarted the Dynatrace Server and re-installed the plugin and got the same results.

        1. Anonymous (login to see details)

          Hi Eugene,

          I just built with 5.5 and saw that it worked.  Thanks for your help.

          1. Anonymous (login to see details)

            Hi Markie,

            I've just uploaded JVM 1.6 compatible version here. Please use it and let me know if you have any issues.

             Eugene.

    2. Anonymous (login to see details)

      I'm having the exact same issue on 5.5 as well. Please post what you find and maybe it can help me as well. Thanks!

      1. Anonymous (login to see details)

        Hi Gabe,

        I've just uploaded JVM 1.6 compatible version of the plugin. Please re-deploy it

        Eugene.

        1. Anonymous (login to see details)

          That worked, thanks Eugene!

  36. Anonymous (login to see details)

    In order to successfully run the version 1.0.10 of the plugin we also needed to request SELECT privileges for the objects dba_free_space and dba_data_files in order to capture the Tablespace metrics.

    1. Anonymous (login to see details)

      Thank you, Markie. Our documentation is obviously not up to date. We will update it shortly.

      Eugene.

  37. Anonymous (login to see details)

    Hi!

     

    Oracle Monitor was working fine before Oracle DB was configured to use SQLNET (AES256 encryption), but now that it has been configured to use that one, it is not working and triggering the error:

    2015-01-21 13:55:30 INFO [OraclePlugin@RepositoryDB_0] Connecting to Oracle, connection string is ... jdbc:oracle:thin://@++++++++:15450/#####
    2015-01-21 13:55:32 WARNING [OraclePlugin@RepositoryDB_0] could not connect.: Io exception: Oracle Error ORA-12650

    Apparently this error means:
    "ORA-12560: TNS:protocol adapter error"

    And Oracle alert log shows:
    TNS-12650: No common encryption or data integrity algorithm

    How can the Oracle Monitor be used with SQLNET encryption?

     

    Thanks!

    Vanessa

    1. Anonymous (login to see details)

      Hi Vanessa,

      Right now the Oracle Monitor plugin doesn't support data encryption. However, we can add this support to the plugin. I'm busy right now but will be able to add this support in about two weeks. Please let me know version of the Oracle DB which you are using. 

       Eugene.

      1. Anonymous (login to see details)

        Hi Eugene,

        thanks for your feedback.

        Our customer is using Oracle 11G R2 via SQLNet with AES256 encryption.

        Please keep me informed and feel free to ask if you have any other question.

        Regards,

        Vanessa

        1. Anonymous (login to see details)

          Hi Eugene,

          as this is very important for our customer, I would like to ask you if you could provide me with a current status or estimated deadline.

          Thanks a lot in advance!

          Vanessa

      2. Anonymous (login to see details)

        Hi Eugene,

        unfortunately I have not had any news from you. Could you please provide me with a current status and/or a estimated deadline?

        Thanks!

        Vanessa

        1. Anonymous (login to see details)

          Hi Vanessa,

          I'm almost done with your request but need one more piece of information: what data integrity algorithm(s) are set by your customer? For Oracle 11g R2 and lower there are MD5 and SHA1. For Oracle 12c there are SHA256, SHA384, and SHA512 in addition to SHA1 and MD5.

          And last question: are you using Oracle Monitor Web UI SqlMVC.war file on the customer site? 

          Eugene. 

          1. Anonymous (login to see details)

            Hello Eugene,

            to your questions:

            sqlnet.encryption_server=required

            sqlnet.encryption_types_server=(AES256,RC4_256)

            sqlnet.crypto_checksum_server=required

            sqlnet.crypto_checksum_types_server = (SHA1)

             

            Thanks for helping on this!

            Vanessa

            1. Anonymous (login to see details)

              Hi Vanessa,

              Thank you for the information. The latest version of the plugin 1.0.11 will work with any combination of supported encryption algorithms and checksum types. So, you should set the "DB Encryption Types" and / or "DB Encryption Types History" parameters to "AES256,RC4_256" (without braces). The "DB Checksum Types" and / or "DB Checksum Types History" parameters should be set to "SHA1" (without braces).

              Let me know if you have any issues or concerns.

              Eugene.

        2. Anonymous (login to see details)

          Hi Vanessa,

          Here are links to the new version 1.0.11 of the Oracle Monitoring plugin which supports Network Data Encryption and Integrity:

          The Oracle Monitor Plugin wiki page is updated to reflect support for network data encryption and integrity by Oracle database server.

          Let me know if you have any issues.

          Eugene.

           

  38. Anonymous (login to see details)

    Hi,

    Is there any clean up job implemented in the plugin.
    We would like to remove all history data for the SqlMVC application that is older than x days.

    I could not find any scheduled task in the "create_top_sqls_oracle_ddl.sql", but I wonder if there is any part of the application that is removing old data.
    Can you tell me if there is any cleanup solution implemented, or if we need to implement it ourselves?

    Thanks in advance.

    Kind regards,

    Thierry

     

     

    1. Anonymous (login to see details)

      Hi Thierry,

      Unfortunately we don't have a cleanup job for the SqlMVC schema. We are planning to create and publish such job for this plugin soon. I'll update your post when it will be created.

      Eugene.

      1. Anonymous (login to see details)

        Hi Eugene,

         

        Thanks for your reply. Do you have any indication of when you expect to implement this feature? (Is this going to be next month, this year, next year.) I'm not pushing for a date, but we'd like to have a global indication to communicate to our customer.

        What is the largest history database that you have encountered?

        We would like to monitor 9 Oracle databases with a measure interval of 10 minutes with 10 slowest queries and explanation plans. Do you have an indication of what amount of storage we need to request for the history database?

         

        Kind regards,

        Thierry

        1. Anonymous (login to see details)

          Hi Thierry,

          A cleanup job will be published in next two weeks. In terms of the size of the data in the SqlMVC schema: please approximate it based on the provided schema. Please note that main factor, which contributes to the size of data, is number of top SQL statements (default number is 10).

          Eugene.

           

          1. Anonymous (login to see details)

            Hi Thierry,

            The latest version of the Oracle Monitor plugin (1.0.11.1) contains Cleanup Task which allows to setup task to run periodically using a task scheduler. The Purge After parameter allows to setup purge interval for the Cleanup Task. 

            Please let me know if you encounter any issues or questions.

            Eugene.

  39. Anonymous (login to see details)

    Hi there!

    I am trying to configure an Oracle Monitor.

    Could someone explain me the difference between the field "hostName" in settings, and the field  "Hosts" ?

    Thank you

    Luiz

    1. Anonymous (login to see details)

      Hi Luiz,

      Plugin is using the "hostName" parameter only. This is done historically. The Hosts parameters is not used but enforced by the thick client. So, you can put any name there.

      Let me know if you have any further questions.

      Eugene

      1. Anonymous (login to see details)

        Thank you Eugene,

        I am trying to monitor a cluster, first I set the hostName as one of the physical nodes, and then I set the virtual nodes on Hosts.

        It was just a test, but I am still getting different values for the virtual nodes.

        So should I create one monitor for each virtual node? But, still why do I get different values when I set them on Hosts?

        1. Anonymous (login to see details)

          Hi Luiz,

          I'm assuming that you are using the Oracle Monitor plugin version 1.0.9 and higher. This plugin monitors databases. For each database, which you are planning to monitor, please setup an instance of the Oracle Monitor plugin. Please get from a DBA a URL connection string for each database. From this string extract hostName, dbPort, dbName  parameters. Check if service name is used in the URL string and if yes, check the isServiceName plugin parameter and set the serviceName parameter with value extracted from the URL connection string. Use it instead of dbName parameter. Get also dbUsername and dbPassword parameters and set them in the plugin. This information is all what plugin requires to connect to the instance of Oracle database. 

          As I mentioned before, the Hosts parameter is not used by the plugin, so, its value does not affect plugin's execution. So, I'm not sure what do you mean by "...I get different values when I set them on Hosts".

          Please let me know if you have any questions or let me know if you need me to setup a webex session to walk you through the plugin setup steps.

          Eugene.

           

  40. Anonymous (login to see details)

    Hi,

    i am using the version "1.0.11" of the plug-in but i can not stablish connection with the DB. im geting the next error message:

    "IO Error: The network Adapter could not establish the connection"

    i am using dynatrace version 5.5

    1. Anonymous (login to see details)

      Hi Luis,

      Most likely there is a problem with the parameters which you have setup for the plugin. As a result connection string which plugin is using could be incorrect. Please see this post to check it. This also could be a firewall issue. If a URL connection string is setup by the plugin correctly (please check plugin FINER level log to find the URL connection string), please verify with LAN administrator if there is a firewall between Dynatrace Collector box and the instance of the Oracle database. If you are using database to keep history of gathered measures, then apply these recommendations to this database.

      Let me know if you still have a problem.

      Eugene.

  41. Anonymous (login to see details)

    We use the latest Oracle plugin with DT6.0 and its extremely useful!

  42. Anonymous (login to see details)

    Hi,

    The user that I have for my “Data warehouse” use windows authentication, so I need to send the domain of my user. How can set the domain of the user in plug-in properties?

    Right now im trying to send it in the user field like: domain\User but it is not working

     

    1. Anonymous (login to see details)

      Hi Luis,

      The easiest thing to do is to use a database authentication, e.g. SQL Server authentication, instead of Windows authentication. Plugin right now does not support Windows authentication. We can enhance plugin to allow Windows NTLM authentication but it will require time considering other request which we have in our queue already.

      Let me know if you have any further questions or issues.

      Eugene.

       

  43. Anonymous (login to see details)

    Hi Eugene,

         While working with this Oracle Plugin, I noticed that some of the values retrieved are showing up as null. I have high lighted some of them below which I believe is for tablespace size usage. Do you have an idea as to why these values are not being retrieved? Also, once I downloaded the Oracle Dashboard example xml file and imported it to my current DynaTrace Server Dashboards, are there any documentation on how I can configure the database I'm using to the dashboard? 

     

    Schedule Details
    Name: hrdbnp
    Status: scheduled
    Description:
    Type: Oracle Monitor
    Last Run: 14:33:44 (EST)
    Last Run Result: ok
    Next Run: 14:33:54 (EST)
    Current Run: -
    Duration (last run): < 1s
    Schedule: Every 10 Seconds
    Execution Target: dynaTrace Collector@unknown
    Plugin Active: active
    Result Status: success
    Result: Last polling execution terminated successfully
    Retrieved measurements: Average CPU Time: null
    Average Elapsed Time: null
    Buffer Busy Waits: 100.0
    Buffer Cache Hit Ratio: 99.97
    Buffer Gets: null
    CPU Time: null
    Child Member: null
    Connection Time: 49.0
    Consistent Gets: 8.420129E7
    Current Concurrent User Sessions: 29.0
    DB Block Changes: 2.8367445E7
    DB Block Gets: 3.0540406E7
    Direct Writes: null
    Disk Reads: null
    Elapsed Time: null
    Execution Without Parse Ratio: 51.62
    Executions: null
    First Load Time: null
    Free: null
    Free Buffer Waits: 0.0
    Highest Concurrent User Sessions: 36.0
    Last Load Time: null
    LastDdl: null
    LockMode: null
    Maximum Concurrent User Sessions: 0.0
    Maximum Named Users: 0.0
    Memory Sort Ratio: 100.0
    Parse Calls: null
    Percent Free: null
    Percent Used: null
    Physical Reads: 31851.0
    Physical Writes: 1314325.0
    Rows Processed: null
    SQL Area Get Ratio: 95.75
    Status: null
    Total: null
    Used: null
    Write Complete Waits: 0.0

    1. Anonymous (login to see details)

      Hi Thushyanth,

      The Free, Percent Free, Percent Used, Total, and Used measures are base measures for your database tablespaces. Plugin is using dynamic measures to populate tablespace measures, that is why all base measures are set to null. In order to see measures for tablespaces you need to perform following steps which are described in the screenshot here:

      1. Select base measure, e.g. Total on the screenshot.
      2. Set Select Measure Splitting to the Tablespace Name.
      3. In the right lower part of the screen under the Splitting Value you will see actual names of tablespaces highlighted in yellow on the screenshot which a monitored database has. Select all of the values or some of them and click Add button.

      Now your dashlet will contain Total values for the selected tablespaces.

      The Oracle Monitor plugin documentation is located here. It could be slightly outdated, so, please use the top part of this page for up to date information.

      Let me know if you have any further questions

      Eugene.

       

      1. Anonymous (login to see details)

        Hi Eugene,

        I am also receiving null values for tablespace measures since they are base measures. I tried performing the steps suggested by you in the above post. But I don't see an option of "Tablespace name" to split the measures. Can you please help me figure out what I am doing wrong?

        Thanks,

        Keerti

  44. Anonymous (login to see details)

    Hello Eugene,

    First of all, thank you for the cleanup task. It looks like it does the trick and will make our lifes a little easier.

    While implementing the plugin the following question arose: how do we handle Oracle data guard environments?
    There are a couple of nodes in a active passive failover situation. Instead of creating a monitor for each of the nodes individually we would like to use a connection method like the tnsnames.ora file. E.g. the following file:

    DB1 =
      (DESCRIPTION_LIST =
        (LOAD_BALANCE = off)
        (FAILOVER = on)
        (DESCRIPTION =
        (ADDRESS_LIST = ( ADDRESS = (PROTOCOL = TCP)(HOST =dbhost-01)(PORT = 1521))
                                        ( ADDRESS = (PROTOCOL = TCP)(HOST =dbhost-02)(PORT = 1521)))
        ( CONNECT_DATA =(SERVER=DEDICATED)(SERVICE_NAME=db1.test.local))))

    Is there a way to handle the failover situation within the plugin in a way that it will always connect to the correct (active) node?

    Kind regards,
    Thierry

     

     

    1. Anonymous (login to see details)

      Hi Thierry,

      We can do it for you that you will not need to create a monitor for each node. Let me enhance plugin. I'll post its new version in this thread that you can test it in your environment first. I'll post updates shortly.

       Eugene. 

    2. Anonymous (login to see details)

      Hi Thierry,

      Here is beta version 1.0.12.0 of the Oracle Monitor plugin which allows to use the Oracle Net Connection Descriptor feature. It has two new parameters:

      •  isOracleNetConnectionDescriptor is a Boolean indicator, when it is "true" then the Oracle Net Connection Descriptor is used, otherwise it is "false";
      •  Oracle Net Connection Descriptor is a string taken from the tnsnames.ora file. Please copy and paste your string 

        (DESCRIPTION_LIST =

            (LOAD_BALANCE = off)

            (FAILOVER = on)

            (DESCRIPTION =

            (ADDRESS_LIST = ( ADDRESS = (PROTOCOL = TCP)(HOST =dbhost-01)(PORT = 1521))

                                            ( ADDRESS = (PROTOCOL = TCP)(HOST =dbhost-02)(PORT = 1521)))

            ( CONNECT_DATA =(SERVER=DEDICATED)(SERVICE_NAME=db1.test.local))))

        into the Oracle Net Connection Descriptor parameter.

      Please deploy this beta version of the plugin on your site and let me know if there are any issues. You can e-mail me results directly at eugene.turetsky@dynatrace.com.

       

      Eugene.

  45. Anonymous (login to see details)

    Hi,

     

    Im using this plug-in and according to the logs it is running "fine" however im not able to see any metrics for "Oracle Locks", "Oracle SQL" and "Oracle Tablespaces".

     

    What should i do/review in order to see metrics there? 

    1. Anonymous (login to see details)

      Hi Luis,

      The "Oracle Locks", "Slow Sqls" and "Tablespaces" dashlets are Web page dashlets. As a result, you need to setup appropriately the URL field in the Content dashlet properties tab. You also need to setup appropriately the htmlFileSqls, htmlFileLocks, and htmlFileTablespaces plugin configuration parameters that web server which you are using in your environment can access and display html files generated by the plugin. Please follow instructions in bullets 9 and 10 in Section 2 on page 4 of the Oracle Monitor plugin documentation .

      Please let me know if you still have issues, I will setup webex session to help you configure the Oracle Monitor plugin. Please send me your availability for the webex directly to me at eugene.turetsky@dynatrace.com or update your post here.

      Eugene. 

       

  46. Anonymous (login to see details)

    Hi,

     

    for those who use this plugin, would I be able to identify and analize database resource contentions?

     

    1. Anonymous (login to see details)

      Hi Renato,

      Yes, the Oracle Locks dashlet will display current locks in the database which will help you to pinpoint resource contention. The Analysis Locks dashlet will allow you to go back in history and find out when this contention first happen. Depending on locks  you can find affected by them slow sqls and their respective explain plans to go further with the root cause analysis.

      Eugene.

  47. Anonymous (login to see details)

    Hi Eugene,

    I have configured plugin successfully and I'm also getting data but I'm facing below discrepancy

    1. Under top slow SQL statements i'm getting spl characters in query "SELECT DISTINCT APP.POS_APPLICATION_NO appnum%2CQI.LIFE_ASSURED_NM LANAME%2CPROD.PRODUCT_DESC PLAN%2C QI.PREMIUM_AMT premium%2C QI.SUM_ASSURED sumassured%2C QI.POLICY_TERM term%2C APP.CREATION_DT%2C QI.TOTAL_PREMIUM_AMT totalpremium%2C STAT.REFERENCE_TYPE_DESC APPSTATUS%2C STAT.REFERENCE_CD status_cd%2C %28SELECT to_char%28MAX%28RECORD_UPDATED_DT%29%2C%3A%22SYS_B_00%22%29 FROM POS_REQUIREMENT_TRANSACTION WHERE POS_APPLICATION_RK %3D APP.POS_APPLICATION_RK%29 rqmntsmodifieddt%2C to_char%" like %2C. I think url encoding not working properly in this.
    2. For SqlMVC/search  Slow SQLs we have drop down for past data selection but even after selecting 1 Min or 5 Min or other its not getting historical data by default its redirecting on "First"


    Pls Suggest.

    Sachin

  48. Anonymous (login to see details)

    Hi Sachin,

    Thank you for pointing our attention on the incorrect encoding of slow SQLs in the latest timeslice dashlet. Please re-deploy the Oracle Monitor plugin with the new release 1.0.12.4 and let me know if you still have issue.

    In terms of your second question: please deploy the latest version of the SqlMVC application from here and let me know your availability for the webex. You can send me e-mail directly at eugene.turetsky@dynatrace.com.

    Eugene. 

  49. Anonymous (login to see details)

    I have added the new oracle plugin and trying to execute, I am getting an error "IO Error: The Network Adapter could not establish the connection" , as troubleshooting steps I am able to telnet to 1521, and also I did install the oracle client on my collector box and was able to connect to the db with the same parameters as i have configured in my plugin

    urgent help is appriciated

    Thankyou in advance

    Regards

    Ibrahim

    1. Anonymous (login to see details)

      HI Ibrahim,

      Could you please send the plugin's FINER log file to eugene.turetsky@dynatrace.com? I suggest that we setup webex that I can help you with setting up the Oracle Monitor plugin in your environment. If it is urgent issue for you we can do it today or tomorrow.

      Eugene.

  50. Anonymous (login to see details)

    Hi Eugene,

     

    I tried setting up the Oracle Monitor Plugin for database "A"  but I am only receiving null values. Also, I didn’t understand what you mean by “hosts” in the end. So, I gave a test database "B" as the host.

    Can you please help me understand what I am doing wrong?

     

    Thanks,

    Keerti

    1. Anonymous (login to see details)

      Hi Keerti,

      Are you available for the webex? Please send me reply at eugene.turetsky@dynatrace.com.

      Eugene.

  51. Anonymous (login to see details)

    I'm getting the following error when executing the plugin:

    ORA-00604: error occurred at recursive SQL level 1

    ORA-01882: timezone region  not found

    I've deployed the plugin successfully in the past and have following the same steps again, but never seen this before - any suggestions how to resolve this?

    1. Anonymous (login to see details)

      Hi Andre,

      Please set plugin's log level to FINER, reproduce problem and send me gathered log file at eugene.turetsky@dynatrace.com. Please include version of your database in the e-mail.

      Eugene.

  52. Anonymous (login to see details)

    Good day,

    We are busy setting the Oracle Monitor up for POC deployment at a client. The Monitor retrieves some database metrics but also displays an error:

                        "2015-07-14 09:21:01 SEVERE [OraclePlugin@ClickUP - Oracle Monitor_0] execute method: 'java.sql.SQLException exception occurred. Message = 'The url                                cannot be null'; Stacktrace is 'java.sql.SQLException: The url cannot be null"

     I didn't see anyone raising a similar error in this forum so am posting this. Hope you have come across something similar and can help me resolve - There is not a lot of time left in the POC.

    Thank you

    Francois

    1. Anonymous (login to see details)

      Hi Francois,

      Please provide FINER log of the plugn when you are experiencing this issue, screenshots of the plugin configuration screen, and exact version of the plugin. Send this information at eugene.turetsky@dynatrace.com. Let me know your availability for the webex.

      Eugene.

       

  53. Anonymous (login to see details)

    Our client thinks the Oracle Plugin is the top CPU utilizer on a database and slowing it down.  Could you help me to see what the problem could be?

    1. Anonymous (login to see details)

      Hi Beth,

      Based on the provided information, I see that the Oracle Monitor plugin was accessing too frequently your production Oracle database. Please reduce this frequency and let me know if you have any further questions.

      Eugene.

  54. Anonymous (login to see details)

    Hello,

    I'm using DT6.1 and I configured the oracle plugin (basic not enhanced). It's executing fine, the only thing is that it doesn't returns any values except connection time. I'm seeing this in the log: 

    2015-08-26 08:30:46 WARNING [OraclePlugin@RepositoryDB_0] db read failed.: ORA-00942: table or view does not exist

    From my understanding the plugin is looking for v$ tables, which sounds like it can't find them in my case, would it be possible to have a confirmation?

    I asked, the DBA to check DB name and user's access. 

    Thank you for your help,

    Stephanie

    1. Anonymous (login to see details)

      Hi Stephanie,

      I would definitely work with the DBAs to check the permissions of the user you are using, whenever I saw this it was due to missing permissions.  You can also turn up the logging level of the plugin, in Server Settings > Plugins > Oracle Plugin > Properties, which may give you more details as to exactly which table the you are trying to access when you see the above warning.

    2. Anonymous (login to see details)

      Hi Stephanie,

      Most likely you are missing read access privilege for at least one of Oracle views from the following list:

      1. v$buffer_pool_statistics
      2. v$sysstat
      3. v$librarycache
      4. v$license
      5. dba_objects
      6. dba_data_files
      7. v$locked_object
      8. v$session

      Depending on version of the plugin this list can vary. Could you please provide exact version of the plugin and I will provide you with the list of views that plugin's user should have read permission for.

      Eugene.

      1. Anonymous (login to see details)

        Thanks both of you for your help.

        I'm using the version 1.0.9

        1. Anonymous (login to see details)

          Hi Stephanie,

          The 1.0.9 version of the Oracle Monitor plugin is the enhanced version of the plugin. It is very old one. Could you please upgrade plugin version to the latest release 1.0.17? It is backward compatible with the 1.0.9 version, i.e. you do not need to use any advanced features which were added since then.

          Again, most likely that user id configured in the plugin to access monitored Oracle instance, does not have SELECT privileges to one of the following views (please see the "Access privileges to the Oracle system tables and views for the Enhanced Oracle Monitor Plugin" section at the top of this page): 

          1. v$buffer_pool_statistics
          2. v$sysstat
          3. v$librarycache
          4. v$license
          5. dba_objects
          6. dba_data_files
          7. dba_free_space
          8. v$locked_object
          9. v$session
          10. v$sql
          11. v$sql_plan
          12. v$sql_plan_statistics_all
          13. v$rowcache

          14. v$sgastat

          15. v$latch

          16. v$latchname

          17. v$waitstat

          18. v$rollstat
          19. v$system_event.

          Please work with your DBA to make sure that user has SELECT access to the above views.

          Let me know if you have any issues or need further help. I'll setup webex session if necessary.

          Eugene.

  55. Anonymous (login to see details)

    I've configured this plugin successfully, But i am facing an issue with the analysis dashboards. These dashboards are not getting reflected when i select last 1 hour or 30 mins.

    Need to understand how does it work.

    Note: I'm getting all plugin related data.

    1. Anonymous (login to see details)

      Hi Sachin,

      I'd suggest setting up webex session to map plugin's measures into dashboard's dashlets. Please propose time for tomorrow or Wednesday that I can work with you on your issue. Please send me your availability at eugene.turetsky@dynatrace.com. I'll send you invite for the webex.

      Eugene.

  56. Anonymous (login to see details)

    Hi,

    If I want to use only the metrics provided in the enhanced plugin, without custom Web UI, is possible to use the plugin without creating the complementary database?

    Thanks. 

    1. Anonymous (login to see details)

      Hi Luis,

      Yes, please uncheck the 'isHistoryOn' parameter. Plugin will not use the database for history tables and will not gather metrics historically.

      Eugene.

      1. Anonymous (login to see details)

        Thanks Eugene!

  57. Anonymous (login to see details)

    Hi Eugene,

    I've configured and getting all the data however i have a doubt about the data for slow SQL. It's showing very low elapsed time 0.01 ms. at the same time dynatrace database are showing more than 1 secs query.

    Kindly suggest the issue.

    Thanks...

    Regards,

    Sachin Salvanikar

    1. Anonymous (login to see details)

      Hi Sachin,

      The Oracle Monitor plugin displays time related metrics for slow SQL in seconds. Please see the following screenshot:

      Most likely that value you are referring to is taken in seconds. Also, please note that the average_elapsed_time metric contains average response time as it is reflected in its name. 

      Eugene.

  58. Anonymous (login to see details)

    Does the new plugin version (getting Lock values from v$locked_objects instead of gv$locked_objects) work correctly for RAC?  I'm not seeing any results in the Analysis of Locks dashlet.

    Please advise - thanks!

    Beth

  59. Anonymous (login to see details)

    Hi Eugene,

    In my analysis dashlet for tablespaces, there are tablespaces where % used is > 80. 

    I have set an alert for the same. But I am not receiving any alerts in my incidents dashlet for the below measure. 

       

     

    Do I have to use a different measure to set an alert for the data from analysis dashlet (tablespace used % > 80)?

     

    Thanks,

    Keerti

    1. Anonymous (login to see details)

      Eugene and Keerti,

      This issue was caused by the dynamic measures checkbox not being selected.  

      Beth

      1. Anonymous (login to see details)

        Hello Beth,

        There is much more then just "the dynamic measures checkbox not being selected". Please check my reply on Keert's post above as last night I finally had few minutes to look into the issue that Keerti is having.

        I strongly recommend you will follow recommendations that are in this reply.

         Eugene.

        1. Anonymous (login to see details)

          Hi,

          I don't see any reply from you to Keerti's post (yet).

          As soon as the dynamic measures checkbox was selected,  TableSpace values were populated for tables:

           

          Percent Free: null

          Percent Free (Tablespace Name,XXXX_1): 99.0

          Percent Free (Tablespace Name,XXXX0T_1): 99.0

          Percent Free (Tablespace Name,XXXND_1): 10.75

          Percent Free (Tablespace Name,XXXTBLS_1): 9.68

          Percent Free (Tablespace Name,XXX00I_1): 99.0

          Percent Free (Tablespace Name,BXXX0T_1): 99.0

           

          Also, TableSpace percent used alerts began being sent.  I still need to do validation around if all of them were properly sent.

           

          I will read through your additional recommendations as soon as they are posted - thanks!

          Beth

           

           

          1. Anonymous (login to see details)

            Hello Beth,

            We do not recommend using dynamic measures for incidents involved tablespaces. Please read my post here and follow its recommendations. 

            While  it is perfectly fine to enable "isDynamicMeasures" indicator for the plugin to gather metrics other than tablespaces, I would like you to use caution when the "isDynamicMeasure" indicator is enabled. Please read section 2.8 of the plugin documentation here to avoid measure explosion. Also please note that dynamic measures by design do not allow to set different thresholds for tablespaces.

            Eugene.

    2. Anonymous (login to see details)

      Hello Keerti,

      I'm sorry for the delay with the reply. I'm still very busy but last night I had a little bit of time and looked into your issue. Please read Release notes for version 1.0.14 of the plugin from 2015-06-18. In particular, please check subsection highlighted in yellow below and create a metric group monitor plugin as described there. Plugin will be able to gather tablespaces' measures in a way that will allow to use them in the incident rules.

       Let me know if you have any further questions or issues.

      Eugene.

      1. Anonymous (login to see details)

        Thanks a lot Eugene for the reply. Will try this out and let you know if I have any questions.

  60. Anonymous (login to see details)

    Hi Eugene,

    As we  deploy this plugin in our customer server. And while we executed this plugin we were getting the results for windows server. but for solaris server we are encountered with the calling setup() failed. We tried to debug with the logs but looks like the logs are also not updating.

    Thanks

    Aravindhan

    1. Anonymous (login to see details)

      Hi Aravindhan,

      Let's setup webex to look into this issue. I'll send you direct e-mail with my availability.

      Eugene.

  61. Anonymous (login to see details)

    Hi Eugene.

    Any update on this.

    Regards,

    Aravindhan

    1. Anonymous (login to see details)

      Hi Aravindhan,

      I did send you this e-mail on Fri 11/6/2015 7:28 AM but unfortunately never received any reply from you. I'm available for the webex starting next week Wednesday, December 2, 2015. I'm in the EST timezone. Please send me your availability and timezone you are in at eugene.turetsky@dynatrace.com.

      Eugene.

  62. Anonymous (login to see details)

    Eugene,

    I've got the 1.0.17 plugin installed (DT 6.2.2). I've just installed the plugin, no dashboards or history yet (history is turned off). I'm getting some data, but have the following exception that appears in the log (twice per run):

    2015-12-03 10:47:22 SEVERE [OraclePlugin@RepositoryDB_0] ORA-01476: divisor is equal to zero

    There's a stacktrace associated with this that I can send you, as well as FINER log output.

    Regards,

    Tom

    1. Anonymous (login to see details)

      Hi Tom,

      Thank you for checking. Yes, please send me plugin's log file at eugene.turetsky@dynatrace.com. I appreciate it.

      Eugene.

      1. Anonymous (login to see details)

        On the way. Please let me know if you do not receive them (Weird message about your email address being invalid, though they haven't bounced back yet).

        Tom

        1. Anonymous (login to see details)

          Hi Tom,

          I have received your e-mail with the logs. Thank you. Let me look into them. I'll update you.

          Eugene.

          1. Anonymous (login to see details)

            Hi Tom,

            Issue is fixed in the v. 1.0.18 of the plugin. Thanks a lot for reporting this issue and checking new build!

            Eugene.

  63. Anonymous (login to see details)

    Hi,

    I have tried to deploy the WAR file and i am getting the following error:

    org.springframework.beans.factory.CannotLoadBeanClassException: Error loading class [com.dynatrace.diagnostics.plugins.web.mvc.controller.TopWaitEventsController] for bean with name 'topWaitEventsController' defined in file [/prjvl01/apache-tomcat-7.0.67/webapps/SqlMVC/WEB-INF/classes/com/dynatrace/diagnostics/plugins/web/mvc/controller/TopWaitEventsController.class]: problem with class file or dependent class; nested exception is java.lang.UnsupportedClassVersionError: com/dynatrace/diagnostics/plugins/web/mvc/controller/TopWaitEventsController : Unsupported major.minor version 51.0 (unable to load class com.dynatrace.diagnostics.plugins.web.mvc.controller.TopWaitEventsController)
    org.springframework.beans.factory.support.AbstractBeanFactory.resolveBeanClass(AbstractBeanFactory.java:1253)

     I am working with DynaTrace 6.2.4.3007

    cat you please assist ?

    Tzachi

    1. Anonymous (login to see details)

      Hi Tzachi,

      The Web UI war file should be deployed on an application server of your choice, e.g. Tomcat, JBoss, WebSphere, Weblogic, etc. This war file requires Java SE 7 and higher. Please make sure that JVM which is running your application server matches this requirement.

      Eugene.

       

      1. Anonymous (login to see details)

        Hi,

        I have Java 1.7.0_71 installed.

        Tzachi

        1. Anonymous (login to see details)

          Hi Tzachi,

          Let's have webex that I can check your application server and JVM it is using. Send me your availability time for the webex at eugene.turetsky@dynatrace.com.

          Eugene.

  64. Anonymous (login to see details)

    Hi Folks!


    I’ve just deployed the Oracle Plugin on the customer, but we are getting a “Oracle - ORA-00942 : table or view does not exist” error.

    The plugin logs do not state the table name which is having problems to be found…

     

    Could you please help me?

    Thanks in advance.

    1. Anonymous (login to see details)

      Hi Lucas,

      Please make sure user that monitors Oracle database instance has the following privileges to Oracle system tables and views:

      Eugene.

      1. Anonymous (login to see details)

        Thanks Eugene, 

        Should this privileges be configured on the plugin DB? or on the monitored DB?

        1. Anonymous (login to see details)

          Hi Lucas,

          These privileges should be given to the user on the monitored DB.

          Please also note that most of plugin's functionality was transferred to the Database Agent on DT 6.3+.

          Eugene.

          1. Anonymous (login to see details)

            Thanks Eugene!

  65. Anonymous (login to see details)

    Hi Eugene!

    Customer is getting a “Oracle - ORA-00942 : table or view does not exist” error using the same credentials they use to monitor another node (that gets no errors).

    Any insights?

     Thanks

    1. Anonymous (login to see details)

      Hi Lucas,

      Please see this post above.Double check that user which monitors Oracle database instance has privileges depicted in this post. If user has all required by the plugin privileges, please send me stack trace of the exception as well as version of the plugin that your customer is using. You can send this information directly to eugene.turetsky@dynatrace.com.

      Eugene.


  66. Anonymous (login to see details)

    Hi Eugene,

    I am Trying to set up the Oracle Monitring Plugin on DT 6.1.
    I used the Dynatrace Plugin Jar File 1.0.20 . I have the APP Deployed in a TomCat ..  I have even given Sysdba priviledges to the C##DT55 user. Executed all the SQL scripts for Historic monitoring.
    I am not Getting Any Measures after Running the Plugin as a Monitor . Am I doing this Correclty ?
    I then Created a Clean up Task and It did Clean up T_SRC_DB_NAME table where i made an Entry of my DB Name. This confirms that the Cleanup Works. But The Actual Monitor Doesnt Work and Capture any Metrics.
    Can you Respond to me on this  ?
    Thanks,
    Manoj Patrick
    1. Anonymous (login to see details)

      I want to Build a Useful Dashboard or Atleast Reuse the Dashboard u have provided. But I dont see any measure despite having a Clean Installation of the Plugin. I have no Errors at my Client or the Server / Collector.

      1. Anonymous (login to see details)

        Do I need to Restart the Dynatrace Server after the Plugin installation ? OR I dont have any measure captured or no exceptions

        1. Anonymous (login to see details)

          Hi Manoj,

          Sorry for the delay with the reply. If plugin was setup correctly, you should see measures coming out from the plugin. There is no need to re-start Dynatrace server after installation of the plugin. Let's setup webex to check installation of the plugin. Unfortunately, I'm very busy this week. Could you please send me e-mail with your availability on Thursday - Friday this week? My e-mail address is eugene.turetsky@dynatrace.com. To save time, please setup log level of the plugin to FINER and send me plugin's log file at the same e-mail address. Could you please also send me catalina log file and its access log file from the Tomcat server?

          Eugene.

  67. Anonymous (login to see details)

    Francois, try the latest plugin version, perhaps that addresses your problem. If not, let Eugene know the version of Oracle they're using and also send him the plugin's log file.

    1. Anonymous (login to see details)

      Managed to get them working Andre. The SID was inserted without last character (silly!) but now fixed. Thanks

  68. Anonymous (login to see details)

    Is it possible to get the current open connection pool information?

    I want not only the count but also the detailed description about a single connection.

    we can get connection pool count from database dashboard but i want detailed description. 

    1. Anonymous (login to see details)

      Hi Mohit,

      Are you talking about DRCP (Database Resident Connection Pooling)? Please clarify.

      Please also note that most of plugin's functionality was transferred to the Database Agent on DT 6.3+. So, if you have any questions or want any enhancements there please work with DT technical support team or open RFE request.

      Eugene.

  69. Anonymous (login to see details)

    Hi Eugene;

    How are you ! I need a litle help ;

    I am installing the plugin 1.0.20 for monitoring Oracle Database and I not understand how deploy the SqlMVC.war file. I have Dynatrace 6.2 , and I setting the database.properties file and run the script create_top_sqls_ddl.sql .

    Its possible to send a step by step about deploy  SqlMVC.war file in Dynatrace 6.2 , Its installed in the Linux server.

    Thank you for help us.

    FDL

     

     

    1. Anonymous (login to see details)

      Hi Fabiano,

      Please follow steps depicted in the "Deploying Enhanced Oracle Monitor Plugin and web UI application" section at the top of this page.

      Let me know if you have issues. I'll setup webex to help you.

      Eugene.

  70. Anonymous (login to see details)

    Hi Eugene, I've come across an error this morning which I would like your thoughs on:

     

    Detailed message: execute method: 'javax.xml.transform.TransformerException exception occurred. Message = 'javax.xml.transform.TransformerException: com.sun.org.apache.xml.internal.utils.WrappedRuntimeException: The entity "iacute" was referenced, but not declared.'; Stacktrace is 'javax.xml.transform.TransformerException: javax.xml.transform.TransformerException: com.sun.org.apache.xml.internal.utils.WrappedRuntimeException: The entity "iacute" was referenced, but not declared.
    at com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.transform(TransformerImpl.java:749)
    at com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.transform(TransformerImpl.java:351)
    at com.dynatrace.diagnostics.plugins.OraclePlugin.convertXMLToHTML(OraclePlugin.java:2619)
    at com.dynatrace.diagnostics.plugins.OraclePlugin.buildSqlsXML(OraclePlugin.java:2602)
    at com.dynatrace.diagnostics.plugins.OraclePlugin.populateSqlsInfo(OraclePlugin.java:1805)
    at com.dynatrace.diagnostics.plugins.OraclePlugin.execute(OraclePlugin.java:764)
    at com.dynatrace.diagnostics.plugins.OracleMonitor.execute(OracleMonitor.java:81)
    ....

    I'm thinking this would be a query that includes the character "Í" (iacute) and the xslt transformer is not being able to handle it. 

    Because of this error the plugin execution fails so I get no data for Slow Sqls.

    This is the values that are coming in:

    Average Elapsed Time: null
    Connection Time: 55.0
    Current Concurrent User Sessions: 1028.0
    Elapsed Time: null
    Executions: null
    Instance Up: 1.0
    Physical Reads: 5.93880966E8
    Physical Writes: 2.6454082E7
    Shared Pool Free Memory: 1.57
    Total Timeouts: null

     

    Thanks,
    Gabriel 

    1. Anonymous (login to see details)

      Hi Gabriel,

      Could you please set plugin's log level to FINER, reproduce the problem and send me: plugin's FINER log file; server log file; collector log file where plugin is installed.

      You can send me these files at eugene.turetsky@dynatrace.com. 

      Eugene. 

      1. Anonymous (login to see details)

        Hi Gabriel,

        Were you able to set FINER log level for the plugin and reproduce the issue? Let me know if you need help in setting the FINER log level for the plugin.

        Eugene.

        1. Anonymous (login to see details)

          Hi Eugene, thanks for the attention. I apologize because my comment must have not gone through when I posted it yesterday.

          The FINER level wasn't showing up so I restarted the collector, but then the error went away. I'll let you know if it comes up again.

          1. Anonymous (login to see details)

            Hello Gabriel,

            Please download and deploy version 1.0.21 of the Oracle Monitor plugin. Please set plugin's log level to FINER and send me the FINER log file of the plugin if you see a problem described in your initial post.

            Eugene.

            1. Anonymous (login to see details)

              Hello Gabriel,

              I'd like to re-iterate my request: could you please download and deploy version 1.0.21 of the Oracle Monitor plugin? Please set plugin's log level to FINER, execute plugin and send me FINER log file. Please make sure that it contains log messages (i.e. "setup method:...") from the "setup" method of the plugin. Please execute these steps independently of the issue that you have observed earlier. I'd like to get metadata of the Oracle instances that are setup in your environment.

              Let me know if you have any further questions.

              Eugene.

              1. Anonymous (login to see details)

                Hi Eugene, I'm afraid I won't be able to complete your request at this moment. The POC ended last Friday, so I'm no longer going to the customer site. I'll let you know if I get the chance to do a webex with them.

                Thanks!

                1. Anonymous (login to see details)

                  Hello,

                  Please use version 1.0.21 of the Oracle Monitor plugin. It processes correctly NLS special characters. See next screenshot as an example of using "iacute" character:


                  Let me know if you have further questions.

                  Eugene.

                  1. Anonymous (login to see details)

                    Hi Eugene,

                    Just FYI, I am at the customer that Gabriel was working on POC and I have upgrade to lastest version and all is working fine.

                    Thanks!
                    Luis Redda 

                    1. Anonymous (login to see details)

                      Hi Luis,

                      It is good to hear. Thank you for updates.

                      Eugene.

                       

  71. Anonymous (login to see details)

    Hello Eugene;

    I installed the Enhanced Oracle Database plug-in dynaTrace 6.2 on a server with Red Hat Enterprise Linux Server release 6.7.

    Follow the steps performed:

    1- Run create_top_sqls_ddl.sql

    2- Installed pluguin of the graphical interface of dynaTrace - ok.

    3-  Installed tomcat -and the test page port 8080 - ok.

    4- Created the environment variable "env = ext.prop.dir"

    This some issues are happen :

    •  When I build the dasboard do not display the metrics.
    • In Dashlet proprieties of my version of dynaTrace does not appear the Content tab to enter the url: http: // localhost: 8080SQLMVC / *.
      Can you help me in the analysis, please.
    1. Anonymous (login to see details)

      Hi Fabiano,

      Please make sure that you set the ext.prop.dir environmental variable based on step 2.b highlighted in yellow below. Also, make sure to the Notes (highlighted in yellow below). Please send me Tomcat catalina logs at eugene.turetsky@dynatrace.com

      Let's plan for a webex session mid next week. I'm available on Wed and Thu. I'm in the EST timezone. Please provide me your availability.

      Eugene.

      1. Anonymous (login to see details)

        Hi Eugene;

        Yes, the user  (root) is executing the TomCat application . And  the user has acess in the files log4j.properties and database.properties.

        Following the permissões :

        -rwxrwxrwx 1 root root 234 Jun 28 16:12 database.properties

        -rw-r--r-- 1 root root  507 Jul 23  2015 log4j.properties

        About the environmental variable  "ext.prop.dir" , It was created:

        [root@spobrdyna01-pi ~]# env ext.prop.dir=/opt/dynatrace/dynatrace-6.2/Past_Plugin

        ext.prop.dir=/opt/dynatrace/dynatrace-6.2/Past_Plugin

        I am able in Wednesday . I am in Brazil (3 hours at opposite) , can be at 11:00 at time Brazil for the Webex, ok ?

        Thank you.

        FDL

        1. Anonymous (login to see details)

          Hi Fabiano,

          I will send you webex session invite.

          Eugene.

          1. Anonymous (login to see details)

            Hi Eugene;

            I think what my problem is variable ext.prop.dir, I can not setting it.
            If I renamed the variable "ext_prop_dir" . What the behavior, I have to do ?
            Why I have file what has name “SqlMVC.war”

            Regards;

            FDL

            1. Anonymous (login to see details)

              Hi Fabiano,

              Please execute this command env "ext.prop.dir=/home/myhome/" bash  to set value of the ext.prop.dir variable. Please change string /home/myhome/ to an appropriate value from your environment. Please see my post from this morning where I explicitly asked if the ext.prop.dir variable was setup correctly and showed what needs to be done to setup the ext.prop.dir variable.

              Please see my reply here from 2014 on a similar question about how to set the ext.prop.dir variable in LINUX/UNIX OS'es.

              Let me know if you have any further questions.

              Eugene.

              1. Anonymous (login to see details)

                Hi Eugene;

                It is a good step , it is workin fine - (env "ext.prop.dir=/home/myhome)

                [root@Server ~]# env

                PATH=/usr/share/centrifydc/sbin:/usr/share/centrifydc/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin ext.prop.dir=/opt/dynatrace/dynatrace-6.2/Past_Plugin

                LANG=en_US.UTF-8

                HOME=/root

                SHLVL=2

                LOGNAME=root

                _______________________________________________________________________________

                Now, still have the problems :

                •  When I build the dasboard do not display the metrics.
                • In Dashlet proprieties of my version of dynaTrace does not appear the Content tab to enter the url: http: // localhost: 8080SQLMVC / *. Can you help me in the analysis, please.
                1. Anonymous (login to see details)

                  Hi Fabiano,

                  I'd like to re-iterate my request to send me Tomcat catalina log files from my above post: please e-mail me catalina.YYYY-MM-DD.log files from the <tomcat-home>/logs directory for the appropriate time frame? Please also include in the e-mail the localhost_access_log.YYYY-MM-DD.txt files from the same directory and for the time frame in question.

                  My e-mail address is eugene.turetsky@dynatrace.com.

                  Eugene.

                  1. Anonymous (login to see details)

                    Hi Eugene;

                    I search in my server the log4j.properties file and found in /usr/local/apache-tomcat-7.0.70/webapps/SqlMVC/resources.

                    I edit the log4j.properties :

                    # Root logger option log4j.rootLogger=DEBUG, file

                    # Redirect log messages to a log file log4j.appender.file=org.apache.log4j.RollingFileAppender #outputs to Tomcat home #log4j.appender.file.File=${catalina.home}/logs/sqlMVC.log log4j.appender.file.File=/tmp/sqlMVC.log log4j.appender.file.MaxFileSize=5MB log4j.appender.file.MaxBackupIndex=10 log4j.appender.file.layout=org.apache.log4j.PatternLayout log4j.appender.file.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss} %-5p %C{1}:%L - %m%

                    So I restart the TomCat but not found the log file in the /tmp/sqlMVC.log

                    Help me please.

                     

                    1. Anonymous (login to see details)

                      Hi Fabiano,

                      Most likely you were not able to install successfully the Web UI war file (i.e. SqlMVC.war) on the Tomcat application server. I suggest that we look into your issue on our webex meeting next week. I will show and help you to install the Web UI war file (SqlMVC.war) on the Tomcat server.

                      Eugene.

                      1. Anonymous (login to see details)

                        Hi Eugene;

                        The file logs were sent for email.

                        Regards;

                        FDL

                         

                         

                        1. Anonymous (login to see details)

                          Hi Fabiano,

                          I did receive your e-mail and looked into the Tomcat catalina log file. From the log file I see that SqlMVC.war application was successfully deployed but I do not see that you ever tried to invoke its services. Have you looked into the Oracle plugin documentation sections 4.4, 4.5 and 4.6 to configure "Analysis of Slow SQL", "Analysis of Locks", and "Explain Plan" dashlets? Please see Figures 11, 13 and 15 for details. 

                          Let me know if you have any further questions.

                          Eugene.

                          1. Anonymous (login to see details)

                            Hi Eugene ;

                             

                            I not see the measures from Oracle by "profile " - System monitoring. Another item, when I will create the dash not appear aba Content for fill the url.

                            1. Anonymous (login to see details)

                              Hi Fabiano,

                              Have you performed steps which are described in my previous post here? Also, could you please send me the following log files:

                              • Oracle Monitor plugin FINER log file;
                              • Tomcat catalina log files (i.e. catalina.YYYY-MM-DD.log);
                              • Tomcat access log files (i.e. <host-name>_access_log.YYYY-MM-DD.txt).

                              Eugene.

                              1. Anonymous (login to see details)

                                Hi Fabiano,

                                I've checked Tomcat access log file: it does not contain requests to the SqlMVC application. Your dashlets are still not configured properly.

                                I suggest that you wait until the webex session tomorrow. I'll help you to configure the Oracle Monitor plugin.

                                Eugene.

                                1. Anonymous (login to see details)

                                  Hi Eugene;

                                  The Plug-in monitor Oracle  is working fine, after webex session.

                                  Thank you for help in this case.

                                  Regards;

                                  FDL

                                  1. Anonymous (login to see details)

                                    Hi Fabiano,

                                    You are very welcome!

                                    Eugene.

  72. Anonymous (login to see details)

    Hi Team,

     

    One of our client is using Oracle Enterprise Manager(OEM) to monitor Database Performance.

    Now we have configured Dynatrace for monitoring  Application and database .

    Client wants to know what is the difference between Dynatrace Database monitoring and OEM ?

    Is there any extra parameter Dynatrace gives?

     

    Please suggest.

     

    Regards,

    Jalpesh Shelar

     

     

  73. Anonymous (login to see details)

    Hi,

    I just went to adjust this plugin to meet our requirements.

    Our DB history schema is on a fail over Oracle Data Guard cluster and I'd like to use a free editable JDBC Url field for the history DB (which allows to define fail over addresses).

    But I miss the source code within the Plugin archive!

    I also miss the WEB UIs sources.

     

    Gruß

    Waldemar

    1. Anonymous (login to see details)

      Hi Waldemar,

      sorry for the late reply. The source code is available here: https://github.com/Dynatrace/Dynatrace-Oracle-Monitor-Plugin

      Ingo

       

      1. Anonymous (login to see details)

        Hi Ingo,

         

        I already saw this on GitHub.

        The problem is that the latest commit there is 9 month old, v 1.0.17.

        But the current version is: 1.0.22 (2016-08-09) ...


        Gruß

        Waldemar

        1. Anonymous (login to see details)

          Hi Waldemar,

          please reach out to eugene.turetsky@dynatrace.com to get the latest source code.

          Thanks

          Ingo

           

           

        2. Anonymous (login to see details)

          1. Anonymous (login to see details)

            Hi Gabriel,

            the zipped sources archive from the release page does not contain a proper packaged source project.

            1. The projects MANIFEST points to the version 1.0.10
            2. the plugin configuration (plugin.xml) does not contain newer changes like "isOracleNetConnectionDescriptor"
            3. The Java source code seems to be newer because it contains some newer configuration items and the line numbers seem to match to some exception stack traces which I got from the log file.
            4. There is a compilation error which points to a missed library - commons-lang3. The library is there but it is not referenced by the plugin configuration.

            Would you please package this plugin along with its source code as well as it will be done by most other community plugins!


            BTW: there is definitely a bug in the history DB connection handling. Just search for "ORA-00942" in this forum. In most cases, that is not a configuration issue! This issue occurs sporadically days or hours after proper working and without any changes. Moving the Monitor to an another collector and then back to the first one will solve this issue (until next time).

            Moving to an another collector triggers the OraclePlugin#setup(..) method which leads to a new connection initialization ...

            To keep the solution simple, I would implement a "checkJdbcConnections()" method and call it as first in the execute().

            Gruß

            Waldemar

             

             

            1. Anonymous (login to see details)

              Hi Waldemar, you're correct. I'm not involved with the development of the plugin, I just remembered that I was able to get the correct source when I needed some time ago, from the releases page, so I just linked there.

              It does seem that releases and tags are not being update as they all show the same timestamp here "Nov 27, 2015".

              In this case, we're definitely going to need Eugene Turetsky's help.

            2. Anonymous (login to see details)

              Hi Waldemar,

              In terms of your statement that "there is definitely a bug in the history DB connection handling." The ORA-00942 exception which you are referring to is not related to the connectivity issues. It is related to a missing table/view or missing privileges to access this table/view. The latter by far was the most common reason which our customers were observing. When missing privileges were added by our customers, the ORA-00942 exceptions went away. I do not have any outstanding issues reported by our customers which are related to the ORA-00942 exception. In fact, I do not have any open issues for the Oracle monitor plugin. 

              If you think that there is a new issue with the plugin, I'd like to suggest that you post detailed description of the issue along with following information:

              1. Version of the Oracle Monitor plugin that you are using. If it is not the latest version of the plugin, please deploy the latest available version of the plugin, i.e. v. 1.0.22 at the moment of this writing and re-run your tests to make sure that issue still exists.
              2. If issue still exists, please set log level of the plugin to FINER, re-run your test and gather plugin's FINER log file.
              3. Post this log file here or send it directly to me at eugene.turetsky@dynatrace.com.
              4. Provide DT version which is used in your tests.
              5. Provide OS version of the server which hosts DT Collector where the Oracle monitoring plugin is installed.

              Eugene.

          2. Anonymous (login to see details)

            Just in addition. There is a compilation error in the OraclePlugin (line 1411) even after correcting the classpath.

            That source code is not working without correction and it cannot belong to the v 1.0.22!

            Yes, I am a big boy an I'm able to solve it. I'm also able to combine the newest plugin.xml with java sources you provided.

            But I think that definitely contradicts the community idea.

  74. Anonymous (login to see details)

    Hi Eugene,

    I have been trying to configure the plugin and have come up against the 'Exception: Could not get JDBC Connection; nested exception is java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection' as others have seen.  I have tried several troubleshooting steps (verified that the connection string is correct in the finer log file, a DBA has used the same connection string and has managed to connect to the database successfully, tested port 1521 from the collector running the plugin to the DB server, etc) and I am still getting the error.

    Looking at the log, I can see the following (customer hostname and SID removed):

    2016-09-29 17:47:47 FINER [OracleMonitor@IE_PW HOSTNAME Oracle Monitor_1] Inside populateSystemInfo method ...
    2016-09-29 17:47:47 FINER [OracleMonitor@IE_PW HOSTNAME Oracle Monitor_1] populateSystemInfo method: Connecting to Oracle ...
    2016-09-29 17:47:47 FINER [OracleMonitor@IE_PW HOSTNAME Oracle Monitor_1] populateSystemInfo method: Connection string is ... jdbc:oracle:thin:@HOSTNAME:1521/SID
    2016-09-29 17:47:47 FINER [OracleMonitor@IE_PW HOSTNAME Oracle Monitor_1] populateSystemInfo method: Opening database connection ...
    2016-09-29 17:47:47 FINER [OracleMonitor@IE_PW HOSTNAME Oracle Monitor_1] populateSystemInfo method: Populating CONNECTION_TIME ...
    2016-09-29 17:47:47 FINER [OracleMonitor@IE_PW HOSTNAME Oracle Monitor_1] populateSystemInfo method: Closing database connection ...

    Similar results can be seen for various metrics throughout the log file.

    This seems to suggest to me that the connection to the DB was successful, yet I still see the Exception in each of the tabs that attempt to make the connection.

    I can send the full log to you directly if it would help.

    Any thoughts on where I might go with this?

    Thanks,

    Adrian

    1. Anonymous (login to see details)

      Hi Adrian,

      Please do the following before we move further: upgrade plugin to the latest version, set its logging level to FINER, execute your test and send me plugin's FINER log file at eugene.turetsky@dynatrace.com.

      Eugene.

      1. Anonymous (login to see details)

        Hi Eugene,

        I hadn't realised I wasn't on the latest version of the plugin, I should learn to read properly!

        I've upgraded and run the plugin again with the same results, so have emailed the log file and the database.properties file to you

        Thanks for your help,

        Adrian.

        1. Anonymous (login to see details)

          Hi Adrian,

          Thank you for upgrading to the latest version of the plugin and for the FINER log file. From the plugin log file I see that plugin executed correctly last two times when you used service name 'YYYYYYYY' to connect to the monitored database running on the host 'XXXXXXXX'. Times of these executions are: 2016-09-30 08:16:42 and 2016-09-30 08:24:42.

          In terms of the database.properties file. Please note that according to the provided plugin log file the 'isHistoryOn' indicator of the plugin is unchecked. Hence you are not gathering historical data for the plugin. As a result the Web UI application will have nothing to display. In order for you to start using Web UI application, please check the 'isHistoryOn' indicator and set appropriate parameters in the plugin. When this is done, please change the first line in the database.properties file to the following line:

          db.url=jdbc:oracle:thin:@XXXXXXXX:1521/YYYYYYYY

          Please make sure to download and deploy the latest Web UI war file. Please let me know if you need a webex session that I can help you.

          Eugene.

          1. Anonymous (login to see details)

            Hi Eugene,

            Thanks for your help, I now have the plugin working fully for one database.  My next question is, for multiple databases (I have 3 I need to monitor for this particular application), do I need to create separate html output files, or will each monitor append data to the same files which will then be read in by the dashboard?

            Thanks,

            Adrian.

            1. Anonymous (login to see details)

              Hi Adrian,

              This is good news. Thank you for updates. In terms of your question about monitoring multiple databases. There are two ways of doing it:

              • (Preferred) If you are using the Web UI application which is accessing history database to get data, you do not need to set the html output files. Just configure a separate plugin instance for each monitored database and set the history database configuration parameters to the same history database. Web UI application will display drop down list box with monitored databases as shown on Figure 5 Navigation Menu in the plugin documentation here.
              • If you are not using Web UI application and hence there are no history database with the historical data, then you need to configure separate set of html output files for each monitored database. Please note that this method is a subset of the first one because you do not have ability to look at statistics historically, i.e. no ability to go back in history to see how statistical data changed overtime.

              Please let me know if you have any further questions or issues.

              Eugene.

               

  75. Anonymous (login to see details)

    Hi,

    I need to use the oracle plugin for database and following the documentation of dynatrace of the community I do not know because I do not leave the metrics that I should leave some idea?

    1) It installs the plugin and activates without problem (com.dynatrace.diagnostics.plugins.OraclePlugin_1.0.24.jar)

    2) The metrics of oracle monitor are not displayed, any ideas?

    thanks...




  76. Anonymous (login to see details)

    Hi Eugene;

    The team database has disable the user what has privileges of connection with the bases oracle, because the process has consumed CPU. This process collect all date of query plugin Oracle. How can diagnostcs and to solve this situation.

    We are with some CPU consumptions on some oracle bench monitors, as reported by the DBA team.

    How can we handle this occurrence, do you need any log?

    Regards; FDL

    1. Anonymous (login to see details)

      Helo ;

      Some return about this ?

      Someone can help me about this ?

      1. Anonymous (login to see details)

        Fabiano,

        How often are you running the Oracle Monitor?  This monitor queries the Oracle v$ tables so you will want to be sure you are not polling too often.

        1. Anonymous (login to see details)

          Every 10 minutes run the query , this paremeter is correct ?

           

          1. Anonymous (login to see details)

            this consumed of CPU is in the oracle databse - ok .

            1. Anonymous (login to see details)

              Hi Fabiano,

              10 minutes should be fine, this plugin is only running queries against the Oracle $v tables, I doubt this is plugin related.  You will need to work with your DBA to determine which queries they are seeing issues with.

              Also - note that most of plugin's functionality was transferred to the Database Agent with Dynatrace Application Monitoring 6.3+, the Database Agent is supported by Dynatrace. I see from previous comments you were using 6.2 for which full support ended December 31, 2016.

  77. Anonymous (login to see details)

    Hello,

    I've installed the plugin on dt 5.6 and configured it but I cannot see everything as an output like:SQL measures, Oracle locks.

    Any keys?

    Thanks

  78. Anonymous (login to see details)

    Hi all,

    We have disabled comments on this plugin page.

    Please use the AppMon & UEM Plugins forum for questions about this plugin.

    Sorry to interrupt ongoing discussions. Please re-post your last question in AppMon & UEM Plugins forum.