emcli安装参考
Plug-in
Announcing MySQL Plugin 12.1.0.1.0 for Oracle Enterprise Manager 12c Cloud Control
--注册信息[root@test agent]# /oem/emcli setup -url=https://omsdb.localdomain:7301/em -username=sysman Oracle Enterprise Manager 12c 3. Copyright (c) 1996, 2013 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: MD5 withRSA, 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 41026faa 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.......a... 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
--导入插件，这里/home/oracle/12.1.0.1.2_pythian. mysql .prod_2000_0.opar是OMS服务器所在的路径名称 [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 Gorbachev, The Pythian Group Successfully uploaded the update to Enterprise Manager. Use the Self Update Console to manage this update.
--在MySQL服务器安装em agent过程省略可以参考下面链接,你可能需要安装一些必要的rpm包
OEM 12cR3使用agentDeploy方式安装agent
[mysql@test bin]$ ./emctl status agent Oracle Enterprise Manager Cloud Control 12c Release 3 Copyright (c) 1996, 2013 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 : 2014-02-20 14:15:15 Started by user : mysql Last Reload : (none) Last successful upload : 2014-02-20 15:16:34 Last attempted upload : 2014-02-20 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
--以下是安装配置和监控界面
查看更多关于OEM12c安装配置MySQLPlug-in用来监控MySQL - mysql数据库的详细内容...