In order to work around this issue without compromising the enhanced security of the latest MySQL version, I suggest the monitoring user be created as follows: create user identified with mysql_native_password by '*********************' “Client does not support authentication protocol requested by server consider upgrading MySQL client …” It does not support this new authentication mode and the console returns the following error message: What does this mean for the plugin? Well, the Perl DB module version 5.10 used to connect to the MySQL instance. Grant process, replication client on *.* to Īlso, this version of the plugin requires Perl 5.10+, which is the base version distributed with OEM 12cR3.įinally, due to the nature of the changes in the plugin required for it to be compatible with OEM 13c, if you have a previous version of the plugin deployed in your system it has to be removed, and with it all the MySQL monitored targets. This should not be the case unless you are upgrading to 13c which, most probably, will render the plugin unusable.īelow is the new zipped OPAR file to be uploaded and deployed to the management server and the management agents as required.įirst of all, if you have an older version of the plugin deployed, just keep it unless you have a very good reason to deploy this new version, such as upgrading to 13c. There are no changes in functionality, just the compatibility. The steps below have been obtained from the Oracle OEM 12cR5 CC documentation. The first step is to upload the OPAR file to the OMS Software Library repository. You will need a working EMCLI setup and we recommend to set it up in the OMS server itself. Processing update: Plug-in - MySQL plug-in by Alex Gorbachev, The Pythian Group When EMCLI is working, create a session to the OMS, sync the repository and upload the OPAR file. Successfully uploaded the update to Enterprise Manager. Use the Self Update Console to manage this update. Once the OPAR file has been uploaded to the OMS repository, you can start deploying it. First to the OMS Management Servers and then to the Management Agents. Deploying the plugin using the OEM Console There are two ways to accomplish this task: Using the OEM Console and using EMCLI. To use the OEM Console go to Setup -> Extensibility -> Plug-ins page. Once there, expand the Databases section and select the Pythian MySQL Plugin entry. #Toad for oracle 13.1 download software.

Oracle toad latest version