Quiet Release MySQL Plugin 12.1.0.1.2 — Bug Fixes

Posted in: Technical Track

This is just a small bug-fix release of the plugin. It has actually been quietly released for a while now. If you have downloaded the plugin recently, you have the latest version. To be sure, check the version in the Console, or you can see it in the file name.

There are two bugs fixed:
1. Deployment on an OMS hosted on Solaris didn’t work. (And I suspect it could be the same for Agents on Solaris.)
2. Changing thresholds on the metrics caused the error “Modification of Target Monitoring Settings has Failed”. Also, applying monitoring template was failing for the same reason.


If you didn’t know that you could setup threshold and customized the thresholds that are set out of the box with the plugin, then you are not fully using Enterprise Manager. You can do that in the MySQL target menu — Monitoring -> Metric and Collection Settings. When alert or warning conditions are met, Oracle EM can raise incidents and send notification according to your settings. As I stated above, 12.1.0.1.0 had a bug that prevented users from changing the thresholds.

Same known issues exist as for 12.1.0.1.0 release.
Useful links:

Follow the same deployment procedure for upgrade — (1) import into EM12c using EMCLI, (2) upgrade on OMS by deploying on OMS, (3) upgrade on Agents byt deploying on agents.

Happy monitoring!

Interested in working with Alex? Schedule a tech call.

About the Author

What does it take to be chief technology officer at a company of technology experts? Experience. Imagination. Passion. Alex Gorbachev has all three. He’s played a key role in taking the company global, having set up Pythian’s Asia Pacific operations. Today, the CTO office is an incubator of new services and technologies – a mini-startup inside Pythian. Most recently, Alex built a Big Data Engineering services team and established a Data Science practice. Highly sought after for his deep expertise and interest in emerging trends, Alex routinely speaks at industry events as a member of the OakTable.

13 Comments. Leave new

Is is “Quite release” or “Quiet release”?

Or maybe it was not really quite a quiet release? :-)

Reply

Hehe… just checking if anybody is paying attention. :)

Reply

This is excellent, Alex. Fixed the metric and template issues I has having with the previous version. And works with both OEM 12.1.0.1 and 12.1.0.2. Nice job!

Reply

Hi Alex,

we are using your MySQL-Plugin 12.1.0.1.2 with Cloud Control 12.1.0.2. and are really excited.
Sadly, there is one problem. The monitored MySQL databases logs a warning in the error log every five minutes:
[Warning] Aborted connection 7011 to db: ‘unconnected’ user: ‘our_user’ host: ‘our_host’ (Got an error reading communication packets)

Perhaps, is there a missing close_mysql_connection or something else?

Regards,
Spiker

Reply

Hi Alex,

solved it. I omitted the REPLICATION CLIENT right. We doesn’t use replication, so i thought this user right isn’t necessary.

Regards,
Spiker

Reply
Alex Gorbachev
March 17, 2013 9:39 pm

Interesting… Thanks for reporting. I’ll check to see if there is a better way to handle it in the plugin than leaving unfinished connection.

Reply

Hi Alex,

I am getting 404 file not found, when trying to download the plugin. Also, can you confirm if I need to buy any licenses from oracle to use these plugins. Just to give a bit of background, I am currently using cloud control 12.1.0.2 to monitor my oracle databases. I am using a base installation of OEM with diagnostic and tuning packs enabled for oracle.

The Mysql databases that I am planning to add are all community editions and I do not have any support for the same.

Regards,
annuj

Reply
Alex Gorbachev
June 2, 2014 8:23 am

Anuj: I’ll ask out web team to check download issue. Must have missed links update on web-site relaunch which we’ve just completed.

Regarding the costs — any cost to run EM12c and monitor any targets that Oracle provides is your responsibility. The free version of the MySQL plugin itself downloaded from Pythian web-site does not have licensing fees. However, any other targets you monitor is a different story including monitoring the host itself where you are running the MySQL and local agent if you monitor MySQL by deploying the client on the host.

Commercial support for MySQL plugin is available too if you are interested — just fill Contact Us form.

Reply
Samer Forzley
June 2, 2014 10:57 am

Hi

The links are working now, thank you.

Reply
Nishant Baurai
October 30, 2014 5:34 am

Hi Alex,

We are using cloud control version 12.1.0.3 . To add MySQL server we only see the option to add MySQL Instance and not the MySQL Database.
How can we add the MySQL database also.

Regards,
Nishant

Reply

Nishant: I used term instance to avoid confusion with term database (that is basically a schema in MySQL). You don’t need to add anything else.

Reply

Hi Alex,

We have CC 12104 and we have recently added the 12.1.0.1.2 MySQL plug-in and started to monitor some My SQL databases. When we look into the Incident Manager in Cloud Control, we see that the My SQL incidents are the only ones that don`t have a Category assigned and our incident and notification rules are based on that. Do you know why the My SQL incidents don`t have a category associated with an incident?

Cheers,
Florin

Reply

Hey Alex,
So I’m trying to deploy the MySQL plugin into 12cR3. I get the plugin imported to the library and when I get ready to Deploy to the OMS Server it keeps failing with “java.sql.SQLException: ORA-01017: invalid username/password; logon denied.” I’ve verified that I’m giving it the right SYS password for my EM repository and I’m able to log in to the repository as sys from sqlplus. Any thoughts on what the real problem could be.

Thanks,
Sean

Reply

Leave a Reply

Your email address will not be published. Required fields are marked *