Oracle EMCC 13.5添加OGG监控
添加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插件
选择“部署位置”->“管理代理”：
点击“继续”：
选择主机，点击“继续”：
先决条件检查，点击“下一步”：
复查，点击“部署”：
1 | emcli get_plugin_deployment_status |
确认界面，等待部署完成，大概2分钟左右：
点击“显示状态”：
部署OGG Monitor agent
需要部署OGG Monitor agent才可以。
ogg操作
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 | i. 配置部署Agent所用的操作系统用户JDK的环境变量 export JAVA_HOME=<PATH to JDK installation> export PATH =$JAVA_HOME/bin:$JAVA_HOME/jre/bin:$PATH ii. Jagent 配置 GGSCI>EDIT PARAMS ./GLOBALS 添加一行： ENABLEMONITORING iii 创建Wallet： # su - oracle $ cd /ogg $ ./pw_agent_util.sh -jagentonly Pleasecreate a password for Java Agent: Pleaseconfirm password for Java Agent: Walletis created successfully. 输入两次密码 该密码是为后面的jagent.username创建密码； iv. 编辑jagent配置文件 $ cd cfg $ vi Config.properties 修改相应的值为： agent.type.enabled=OEM jagent.host=127.0.0.1 jagent.jmx.port=5555 jagent.rmi.port=5559 jagent.username=lhr jagent.ssl=false v. 启动GoldenGate $ ggsci ggsci>create datastore ggsci>info all ggsci>start mgr ggsci>start jagent ggsci>start * |
EMCC配置
在EMCC中，选择“设置”->“添加目标”->“配置自动搜索”：
选择受监控主机，点击“搜索模块”：
勾选“GoldenGateDiscovery”，输入相应的值，点击“确定”：
选择受监控主机，点击“立即搜索”，点击“是”继续：
等待搜索完成：
“搜索到的目标”列出现相应的值：
点击“搜索到的目标”列对应主机的值：
选择GoldenGate项，点击“升级”：
点击“Promote”，继续：
等待完成：
选择“目标”->“GoldenGate”，查看对GoldenGate的监控信息：
选择“Oracle GoldenGate”->“成员”->“拓扑”：
查看GoldenGate的拓扑结构：
至此，EMCC对GoldenGate的监控部署完成。
配置身份证明
How To Set OGG plugin 13.2+ Preferred Credentials For GoldenGate Targets? [VIDEO] (Doc ID 2465490.1)
若不配置的话，那么下图红框中的几个按钮都不可用：
