合 Oracle EMCC 13.5添加OGG监控
👉 本文共约3427个字，系统预计阅读时间或需13分钟。
添加OGG监控
http://www.oracle.com/technetwork/middleware/weblogic/downloads/index.html
https://www.oracle.com/middleware/technologies/goldengate-downloads.html
https://docs.oracle.com/en/middleware/goldengate/index.html
https://docs.oracle.com/en/middleware/goldengate/emplugin/13.4.2/index.html
https://blog.csdn.net/qinwen740/article/details/79756941
https://edelivery.oracle.com/osdc/faces/SoftwareDelivery
搜：Oracle GoldenGate EM Plugin
插件13.4.2.0.0支持的目标版本：
| 名称 | 目标版本 |
|---|---|
| oracle_goldengate | 12.1.2 - 19.1 |
| oracle_goldengate_adminsrvr | 12.3.0.1.4 - 19.1 |
| oracle_goldengate_dep | 12.3.0.1.4 - 19.1 |
| oracle_goldengate_distsrvr | 12.3.0.1.4 - 19.1 |
| oracle_goldengate_extract | 12.1.2 - 19.1 |
| oracle_goldengate_manager | 12.1.2 - 19.1 |
| oracle_goldengate_pmsrvr | 12.3.0.1.4 - 19.1 |
| oracle_goldengate_recvsrvr | 12.3.0.1.4 - 19.1 |
| oracle_goldengate_replicat | 12.1.2 - 19.1 |
| oracle_goldengate_srvmgr | 12.3.0.1.4 - 19.1 |
OMS导入OGG监控插件
开始导入：
1 2 3 4 5 | unzip OGG-EM-Plugin-13.4.2.0.0.zip cd /u01/app/oracle/middleware/oms/bin/ ./emcli login -username=sysman -password=lhr666666 ./emcli sync ./emcli import_update -omslocal -file=/soft/13.4.2.0.0_oracle.fmw.gg_2000_0.opar |
完成导入后，选择“设置”->“可扩展性”->“插件”，找到相应的goldengate插件条目，选择“管理服务器”：
点击“下一步”继续：
先决条件检查，等待检查完成，点击“下一步”继续：
资粮档案库，勾选“是否已备份资料档案库和第一个管理服务器配置”，输入sys用户和密码，点击“下一步”继续：
复查，点击“部署”开始部署插件：
插件部署活动，等待部署完成，大概30分钟左右：
这时OMS已经关闭，需要在EMCC主机上查看部署活动：
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | [oracle@lhremcc135 bin]$ /u01/app/oracle/middleware/oms/bin//emctl status oms -details -sysman_pwd lhr666666 Oracle Enterprise Manager Cloud Control 13c Release 5 Copyright (c) 1996, 2021 Oracle Corporation. All rights reserved. Console Server Host : lhremcc135 HTTP Console Port : 7788 HTTPS Console Port : 7803 HTTP Upload Port : 4889 HTTPS Upload Port : 4903 EM Instance Home : /u01/app/oracle/middleware/gc_inst/em/EMGC_OMS1 OMS Log Directory Location : /u01/app/oracle/middleware/gc_inst/em/EMGC_OMS1/sysman/log OMS is not configured with SLB or virtual hostname Agent Upload is locked. OMS Console is locked. Active CA ID: 1 Console URL: https://lhremcc135:7803/em Upload URL: https://lhremcc135:4903/empbs/upload WLS Domain Information Domain Name : GCDomain Admin Server Host : lhremcc135 Admin Server HTTPS Port: 7102 Admin Server is RUNNING Oracle Management Server Information Managed Server Instance Name: EMGC_OMS1 Oracle Management Server Instance Host: lhremcc135 WebTier is Up Oracle Management Server status is down possibly because plug-ins are being deployed or undeployed from it. Use -details option to get more details about the plug-in deployment status. Plug-in Deployment/Undeployment Status Destination : Management Server - lhremcc135:4889_Management_Service Plug-in Name : Oracle GoldenGate Version : 13.4.2.0.0 ID : oracle.fmw.gg Content : Plug-in Action : Deployment Status : Deploying Steps Info: ---------------------------------------- ------------------------- ------------------------- ---------- Step Start Time End Time Status ---------------------------------------- ------------------------- ------------------------- ---------- Submit job for deployment 5/18/21 9:05:22 AM CST 5/18/21 9:05:22 AM CST Success Initialize 5/18/21 9:05:27 AM CST 5/18/21 9:05:40 AM CST Success Install software 5/18/21 9:05:40 AM CST 5/18/21 9:05:43 AM CST Success Validate plug-in home 5/18/21 9:05:45 AM CST 5/18/21 9:05:46 AM CST Success Perform custom preconfiguration 5/18/21 9:05:46 AM CST 5/18/21 9:05:46 AM CST Success Check mandatory patches 5/18/21 9:05:46 AM CST 5/18/21 9:05:46 AM CST Success Generate metadata SQL 5/18/21 9:05:46 AM CST 5/18/21 9:05:46 AM CST Success Preconfigure Management Repository 5/18/21 9:05:46 AM CST 5/18/21 9:05:46 AM CST Success Preregister DLF 5/18/21 9:05:46 AM CST 5/18/21 9:05:46 AM CST Success Stop management server 5/18/21 9:05:48 AM CST 5/18/21 9:08:18 AM CST Success Register DLF 5/18/21 9:08:18 AM CST N/A Running Configure Management Repository 5/18/21 9:08:18 AM CST N/A Running Configure middle tier 5/18/21 9:08:18 AM CST N/A Running ---------------------------------------- ------------------------- ------------------------- ---------- [oracle@lhremcc135 bin]$ |
完成后，“目标”菜单中会出现“GoldenGate”项：
添加被监控主机
下载EMCC 13.5的OMS端：
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 | docker rm -f lhremcc135 docker run -d --name lhremcc135 -h lhremcc135 \ -p 31521:1521 -p 35500:5500 -p 35501:5501 -p 37803:7803 -p 3135:3389 \ --network mhalhr --ip 192.168.68.65 \ -v /sys/fs/cgroup:/sys/fs/cgroup \ --privileged=true \ lhrbest/lhremcc135:1.0 init docker network connect bridge lhremcc135 docker restat lhremcc135 docker exec -it lhremcc135 bash https://192.168.66.35:37803/em 用户名：sysman 密码：lhr666666 |
部署agent
添加主机
首先，选择需要添加主机：
1 2 | 客户端配置 mkdir -p /u01/app/oracle/middleware/agent |
root执行：
1 | /u01/app/oracle/middleware/agent/agent_13.5.0.0.0/root.sh |
部署ogg插件
选择“部署位置”->“管理代理”：
点击“继续”：
本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务，私聊QQ646634621或微信dbaup66，谢谢！
