• 欢迎访问搞代码网站,推荐使用最新版火狐浏览器和Chrome浏览器访问本网站!
  • 如果您觉得本站非常有看点,那么赶紧使用Ctrl+D 收藏搞代码吧

OEM12c安装配置MySQLPlug-in用来监控MySQL_MySQL

mysql 搞代码 4年前 (2022-01-09) 24次浏览 已收录 0个评论

gaodaima.com

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: 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 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 – MySQ

本文来源gaodai.ma#com搞##代!^码@网*

L 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

–以下是安装配置和监控界面

gaodaima.com


搞代码网(gaodaima.com)提供的所有资源部分来自互联网,如果有侵犯您的版权或其他权益,请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected],我们会在看到邮件的第一时间内为您处理,或直接联系QQ:872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接:OEM12c安装配置MySQLPlug-in用来监控MySQL_MySQL

喜欢 (0)
[搞代码]
分享 (0)
发表我的评论
取消评论

表情 贴图 加粗 删除线 居中 斜体 签到

Hi,您需要填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址