Install and configure MySQLPlug-in OEM12c to monitor MySQL_MySQL

Install and configure MySQLPlug-in OEM12c to monitor MySQL bitsCN.com

Emcli installation reference

Plug-in

Announcing MySQL Plugin 12.1.0.1.0 for Oracle Enterprise Manager 12c Cloud Control

-- Registration information

[Root @ test agent] #/oem/emcli setup-url = https://omsdb.localdomain: 7301/em-username = sysman
Oracle Enterprise Manager 12c 3.
Copyright (c) 1996,201 3 Oracle Corporation and/or its affiliates. All rights reserved.

The configuration directory "/root" may not be local. See the "dir" option in the help for the setup command.
Do you want to continue using this directory? [Yes/no] yes
Enter password


Warning: This certificate has not been identified as trusted in the local trust store
--------------------------------------
[
[
Version: V1
Subject: CN = omsdb. localdomain, OU = for testing only, O = MyOrganization, L = MyTown, ST = MyState, C = US
Signature Algorithm: MD5withRSA, OID = 1.2.840.113549.1.1.4

Key: Sun RSA public key, 512 bits
Modulus: 9774958300566363503040586563208719740991935019890276590480512776276093552614004362217344254713840684473865384959907800325054231280357054886533950898531631
Public exponent: 65537
Validity: [From: Tue Feb 18 13:40:23 CST 2014,
To: Mon Feb 19 13:40:23 CST 2029]
Issuer: CN = CertGenCAB, OU = for testing only, O = MyOrganization, L = MyTown, ST = MyState, C = US
SerialNumber: [32a8b9c4 41526faa 37b98eb0 1084ec9f]

]
Algorithm: [MD5withRSA]
Signature:
0000: 33 8F 2F 33 59 89 15 46 C3 7A DF 91 3E 6D F6 59 3./3Y... F. z...> m. Y
0010: BC A7 EC 2B D8 9B 70 E1 E6 06 1A C6 DB 3D A6 E6... +... p ..
0020: 7E D6 B8 58 61 86 C5 B0 15 E7 FF 98 61 D5 DD 1C ...... Xa...
0030: F6 63 A3 29 1C C8 CB 4A F0 D6 70 92 BD 0C E6 CA. c.) ...... J. p .....

]
--------------------------------------
Do you trust the certificate chain? [Yes/no] yes
Emcli setup successful

-- Import the plug-in. here/home/oracle/12.1.0.1.2 _ pythian. mysql. prod_2000_0.opar is the path name of the OMS server.
[Root @ test oem] #./emcli import_update-omslocal-file =/home/oracle/12.1.0.1.2 _ pythian. mysql. prod_2000_0.opar
Processing update: Plug-in-MySQL plug-in by Alex gorbacev, The Pythian Group
Successfully uploaded the update to Enterprise Manager. Use the Self Update Console to manage this update.

-- If the em agent installation process is omitted on the MySQL server, refer to the following link. you may need to install some necessary rpm packages.

Install the agent by using agentDeploy on the OEM 12303.

[Mysql @ test bin] $./emctl status agent
Oracle Enterprise Manager Cloud Control 12c Release 3
Copyright (c) 1996,201 3 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
Agent Version: 12.1.0.3.0
OMS Version: 12.1.0.3.0
Protocol Version: 12.1.0.1.0
Agent Home:/agent/agent_inst
Agent Binaries:/agent/core/12.1.0.3.0
Agent Process ID 24406
Parent Process ID: 24364
Agent URL: https://test.localdomain: 3872/emd/main/
Repository URL: https://omsdb.localdomain: 4900/empbs/upload
Started at: 14:15:15
Started by user: mysql
Last Reload: (none)
Last successful upload: 2014-02-20 15:16:34
Last attempted upload: 15:16:34
Total Megabytes of XML files uploaded so far: 0.3
Number of XML files pending upload: 0
Size of XML files pending upload (MB): 0
Available disk space on upload filesystem: 30.47%
Collection Status: Collections enabled
Heartbeat Status: OK
Last attempted heartbeat to OMS: 2014-02-20 15:18:25
Last successful heartbeat to OMS: 2014-02-20 15:18:25
Next scheduled heartbeat to OMS: 2014-02-20 15:19:25


---------------------------------------------------------------
Agent is Running and Ready

-- The following is the installation configuration and monitoring page

BitsCN.com