How to install MySql plug-in in Oracle Enterprise Manager 12C

The MYSQL plug-in extends monitoring capabilities of Grid Control so that DBAs with heterogeneous environments can monitor MySQL systems using the same tool they use for Oracle products such as Oracle Databases and Application Servers.

MySQL targets behave in the same way as any other Grid Control targets, including availability monitoring, performance metrics collections, configurations management, alerts notifications, and reports. You can access standard EM 12c user interface to metrics, incidents, configuration management, reports, and target setup.
  • 1-To download plug-in follow this link MySql plug-in
  • 2-Next you will be be redirected to the following page where you need to provide your information in order to receive the software+documentaion download link.
  • 3-When you will receive the e-mail confirmation, download the software+documentation on to your host where OMS is located.
    • 12.1.0.1.2_pythian.mysql.prod_2000_0.opar --is the plug0in archive
  • 4-Installing the MySql plug-in:
    • To do so follow the steps:
  • A-Connect to the "emcli" tool using EM12C credentials
    • [oracle@OMS bin]$ ./emcli login -username=sysman
Enter password

Login successful
  • B-Run the following command.
    • [oracle@OMS bin]$ ./emcli sync
Synchronized successfully
  • C-Install the plug-in using the following command
    • Syntax: ./emcli import_update file=<full path to  *.opar file> -omslocal
    [oracle@OMS bin]$ ./emcli import_update -file=/staging/mysql_plug/12.1.0.1.2_pythian.mysql.prod_2000_0.opar -omslocal
Processing update: Plug-in - MySQL plug-in by Alex Gorbachev, The Pythian Group
Successfully uploaded the update to Enterprise Manager. Use the Self Update Console to manage this update.
  • D-Run the following command again.
    • [oracle@OMS bin]$ ./emcli sync
Synchronized successfully
  • 5-Now let's move to our EM12C grid control center, and from the main page Setup >> Extensibility >> Plug-ins
  • 6-Check that the MySql plug-in is available for use.
  • 7-Now let's deploy it - Deploy On >> Management Servers
  • 8-Offer the password for the SYS user (credentials needed for the plug-in to create it's own objects in the OEM database repository).
  • 9-Make sure the process completes with no errors.
  • 10-Review the action.
  • 11-Execute the deploy.
  • 12-See output status confirmation.
  • 13-Check it's status.
    • To Add and MySql instance follow the Add MySql database instance to EM12C.

    Copyright 2020. All Rights Reserved