问题描述:开启ogg投递进程时报错OGG-01224,如下所示:
1、异常重现
GGSCI (leo-oracle-19c) 3> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXTORCL 00:00:00 00:00:02
EXTRACT ABENDED PUMYSQL 00:00:00 04:54:03
GGSCI (leo-oracle-19c) 4> start pumysql
Sending START request to Manager ...
Extract group PUMYSQL starting.
GGSCI (leo-oracle-19c) 5> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXTORCL 00:00:00 00:00:08
EXTRACT ABENDED PUMYSQL 00:00:00 04:54:09
2024-07-16 21:52:54 ERROR OGG-01224 TCP/IP error 113 (No route to host), endpoint: 192.168.133.35:7810.
2024-07-16 21:52:54 ERROR OGG-01668 PROCESS ABENDING.
2、异常原因
目标端防火墙开启导致,目标端防火墙状态如下:
[root@leo-mysql-ogg ~]# systemctl status firewalld
● firewalld.service - firewalld - dynamic firewall daemon
Loaded: loaded (/usr/lib/systemd/system/firewalld.service; enabled; vendor preset: enabled)
Active: active (running) since Tue 2024-07-16 20:10:09 CST; 1h 44min ago
Docs: man:firewalld(1)
Main PID: 885 (firewalld)
Tasks: 2
CGroup: /system.slice/firewalld.service
└─885 /usr/bin/python2 -Es /usr/sbin/firewalld --nofork --nopid
Jul 16 20:10:06 leo-mysql-ogg systemd[1]: Starting firewalld - dynamic firewall daemon...
Jul 16 20:10:09 leo-mysql-ogg systemd[1]: Started firewalld - dynamic firewall daemon.
Jul 16 20:10:10 leo-mysql-ogg firewalld[885]: WARNING: AllowZoneDrifting is enabled. This is considered an insecure configuration option. It will be remo...g it now.
Hint: Some lines were ellipsized, use -l to show in full.
3、解决方案
--关闭目标端防火墙
[root@leo-mysql-ogg ~]# systemctl stop firewalld
[root@leo-mysql-ogg ~]# systemctl disable firewalld
Removed symlink /etc/systemd/system/multi-user.target.wants/firewalld.service.
Removed symlink /etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service.
[root@leo-mysql-ogg ~]#
[root@leo-mysql-ogg ~]# systemctl status firewalld
● firewalld.service - firewalld - dynamic firewall daemon
Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)
Active: inactive (dead)
Docs: man:firewalld(1)
Jul 16 20:10:06 leo-mysql-ogg systemd[1]: Starting firewalld - dynamic firewall daemon...
Jul 16 20:10:09 leo-mysql-ogg systemd[1]: Started firewalld - dynamic firewall daemon.
Jul 16 20:10:10 leo-mysql-ogg firewalld[885]: WARNING: AllowZoneDrifting is enabled. This is considered an insecure configuration option. It will be remo...g it now.
Jul 16 21:55:12 leo-mysql-ogg systemd[1]: Stopping firewalld - dynamic firewall daemon...
Jul 16 21:55:16 leo-mysql-ogg systemd[1]: Stopped firewalld - dynamic firewall daemon.
Hint: Some lines were ellipsized, use -l to show in full.
--重启源端投递进程
GGSCI (leo-oracle-19c) 10> start pumysql
Sending START request to Manager ...
Extract group PUMYSQL starting.
GGSCI (leo-oracle-19c) 11> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXTORCL 00:00:00 00:00:06
EXTRACT RUNNING PUMYSQL 00:00:00 04:56:59
GGSCI (leo-oracle-19c) 12> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXTORCL 00:00:00 00:00:01
EXTRACT RUNNING PUMYSQL 00:00:00 00:00:01
GGSCI (leo-oracle-19c) 13> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXTORCL 00:00:00 00:00:08
EXTRACT RUNNING PUMYSQL 00:00:00 00:00:09
说明:如下所示,源端投递进程成功开启.
开启ogg投递进程时报错OGG-01224
原创
-
OGG 监控AGENT 安装步骤
OGG OEM监控添加
oracle ogg 监控 -
ogg之trail文件操作
ogg
检查点 oracle 删除文件 -
ogg源端投递进程告警OGG-01496、OGG-01668
ogg源端投递进程告警OGG-01496、OGG-01668
OGG-01496 OGG-01668 -
ogg-06569 ogg-01224 ogg-01668 EP进程跟R进程对应实例版本不一致
EP进程跟R进程对应实例版本不一致
EP进程跟R进程对应实例版本不一致 -
ogg在启动应用进程时报错OGG-00412
ogg在启动应用进程时报错OGG-00412
Group bc 数据库oracle -
无法启动ogg配置好的抓取以及投递进程
无法启动ogg配置好的抓取以及投递进程
ABENDED OGG-01224 OGG-10151 OGG-00303 -
OGG复制进程报错OGG-01172
OGG复制进程报错OGG-01172
OGG-01172 -
在oracle 10.2.0.4上搭建ogg添加抓取进程时报错OGG-01756、ORA-00942
在oracle 10.2.0.4上搭建ogg添加抓取进程时报错OGG-01756、ORA-00942
OGG-01756 ORA-00942 ogg抓取进程 -
OGG add schematrandata报错 OGG-01790
一、问题记录GGSCI (s11g) 50> add schematrandata scott2021-03-25 10:14:53 ERROR OGG-01790 Failed to ADD SCHEMATRANDATA on schema scott because of the following SQL error: ORA-26947: Oracle GoldenGate replication is not enabled.ORA-06512: at "SYS.DBMS
# Oracle故障处理 Oracle Oracle 数据库 OGG -
element dialog多窗口
继上一次分享electron24+vite4整合构建桌面端窗口应用。这次在此基础上分享封装多开窗口管理器ElectronVite-MultiWin。截至目前Electron最新稳定版本到25了。 electron快速迭代更新,vite的高效构建运行速度,二者搭配构建独立窗口,打开速度极快。 electron主进程模块BrowserWindow用于创建一个简单的新窗体。https://www.ele
element dialog多窗口 vite+electron25 electron25+vue3 electron25多窗口 electron窗口管理