博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
Oracle Goldengate REPLICAT启动时报正在运行解决办法
阅读量:7110 次
发布时间:2019-06-28

本文共 1837 字,大约阅读时间需要 6 分钟。

stop replicate时报ERROR: opening port for REPLICAT MYREP (TCP/IP error: Connection refused).

start replicate时报REPLICAT xxx is already running.

原因是dirpcs目录下对应的xxx.pcs文件没有正常删除。

解决办法:删除pcs文件,检查是否有删除权限。

以下是引用国外的一篇文章:

We use  to replicate data from an Oracle database into a SQL Server. However, I got an alert the other day that replication had stopped, and when I checked the status of replication, all the REPs we had set up were in status "Starting...", but none we actually doing anything.

Attempting to stop them got the following error:

GGSCI (GGSERVER) 68> stop rep MYREP

Sending STOP request to REPLICAT MYREP ...

ERROR: opening port for REPLICAT MYREP (TCP/IP error: Connection refused).

OR

GGSCI (GGSERVER) 68> start replicat REPYL01C

REPLICAT REPYL01C is already running.

 

Stopping/Starting the manager service or rebooting the PC didn't help either - they still said "Starting" and were unresponsive. Even stranger, deleting and recreating the REP gave the same result - before I even attempted to start the REP for the first time, it said "Starting", and an attempt to start it gave me "Process is starting up - try again later".

The cause was the REP process status file, located in the DIRPCS folder under the Goldengate root - there should be a file for each REP that's currently running giving details about the status. When a REP stops, this file is deleted. Since all of the current REPs weren't doing anything (they were all sitting at the end of the previous trail file), they should have been stopped. I deleted the PCR files for the affected REP streams, and then manager reporting "STOPPED" - at that point, I was able to start up each REP without issue.

I'm not sure how they got that way, but once started again, they all worked without issue. I hope this saves you the troubleshooting time of hunting down these files!

 

转载地址:http://kuqhl.baihongyu.com/

你可能感兴趣的文章
lnmp thinkphp5 tp5系统环境配置问题解决tp5环境配置
查看>>
Solaris系统配置IPMP (基于IP寻址与链路)
查看>>
通过xshell远程登录linux在vim编辑器里编辑东西按数字键出现英文字母的解决办法...
查看>>
Java 正则表达式详解(一)
查看>>
编译型应用程序及程序架构攻防
查看>>
java static块的执行次数
查看>>
域策略组管理
查看>>
BAT移动端入口收割战结束 O2O下一战场
查看>>
一键更改IP地址BAT文件
查看>>
我的友情链接
查看>>
linux学习--命令行快捷键
查看>>
我的友情链接
查看>>
http https ssl/tls三者的区别和联系
查看>>
配置文件路径异常导致HomeAssistant配置文件无效
查看>>
解决 Windows instance 时间不同步问题 - 每天5分钟玩转 OpenStack(153)
查看>>
用 label 控制 Pod 的位置 - 每天5分钟玩转 Docker 容器技术(128)
查看>>
oracle如何恢复被覆盖的存储过程
查看>>
xargs paste
查看>>
Android ROM DIY教程之ROM的修改
查看>>
拼图游戏源码-swift版项目源码
查看>>