This section describes the prerequisites for a successful Oracle Enterprise Manager for MySQL Database installation.
Oracle Enterprise Manager Cloud Control 12.1.0.4 (or higher) for OMS (12.1.0.4.0 and Patch 20392036), Enterprise Manager Repository, and Management Agent (12.1.0.4.0 + Patch 20613931). Ensure the agent can successfully communicate with your Oracle Enterprise Manager Server and can upload data.
MySQL 5.5 or higher.
Supported platforms: The plugin can be deployed on OEM Management Agents on the following Operating Systems:
Solaris (SPARC)
Solaris Operating System (x86-64)
Linux x86 (32-bit), glib2.4 or higher
Linux x86-64 (64-bit), glib2.4 or higher
Microsoft Windows x86-64 (64-bit)
Consult the MySQL Supported Platforms list for more information. HP-UX, AIX, FreeBSD and Mac OS X are not supported.
The user installing the Oracle Enterprise Manager Agent must, at least, belong to the MySQL user group of the monitored database.
The Oracle Enterprise Manager Agent requires a user on the monitored MySQL instance. This user requires the following privileges:
SELECT
REPLICATION CLIENT
SHOW DATABASES
SUPER
PROCESS ON
The following example shows how to create these rights for a
user named monitoring
, assuming a local
agent with a socket connection:
GRANT SELECT, REPLICATION CLIENT, SHOW DATABASES, SUPER, PROCESS ON *.* TO 'monitoring'@‘localhost' IDENTIFIED BY 'password’;"
For optimal performance, ensure that the monitored MySQL database is on a different machine from the OMS and Enterprise Manager Repository.
Ensure the MyOracle Support credentials are set up using the SYSMAN user.
Ensure that the Software Library (also known as the local store) is configured. Updates are downloaded to the local store before they are deployed.