oracle ogg--ogg搭建过程中遇到的错误及处理

最新推荐文章于 2025-05-24 17:32:46 发布

转载

最新推荐文章于 2025-05-24 17:32:46 发布 · 2.7k 阅读

2 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/yhq1314/p/11065289.html

文章标签：

#数据库 #java #网络

本文档记录了在搭建Oracle GoldenGate (OGG) 过程中遇到的常见错误，包括PRVF-0002错误、无法打开checkpoint文件、数据源无效等问题，并提供了详细的解决步骤和日志分析，帮助读者解决OGG实施中的障碍。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1 PRVF-0002 : Could not retrieve local nodename
---# Begin Stacktrace #---------------------------
ID: oracle.install.commons.util.exception.DefaultErrorAdvisor:37
oracle.cluster.verification.VerificationException: PRVF-0002 : Could not retrieve local nodename
at oracle.cluster.verification.ClusterVerification.<init>(ClusterVerification.java:242)
at oracle.cluster.verification.ClusterVerification.getInstance(ClusterVerification.java:347)
at oracle.install.driver.oui.OUISetupDriver.load(OUISetupDriver.java:430)
at oracle.install.ivw.db.driver.DBSetupDriver.load(DBSetupDriver.java:207)
at oracle.install.commons.base.driver.common.Installer.run(Installer.java:299)
at oracle.install.ivw.common.util.OracleInstaller.run(OracleInstaller.java:106)
at oracle.install.ivw.db.driver.DBInstaller.run(DBInstaller.java:136)
at oracle.install.commons.util.Application.startup(Application.java:896)
at oracle.install.commons.flow.FlowApplication.startup(FlowApplication.java:165)
at oracle.install.commons.flow.FlowApplication.startup(FlowApplication.java:182)
at oracle.install.commons.base.driver.common.Installer.startup(Installer.java:348)
at oracle.install.ivw.db.driver.DBInstaller.startup(DBInstaller.java:124)
at oracle.install.ivw.db.driver.DBInstaller.main(DBInstaller.java:155)
[root@ogg ~]# vim /etc/hosts
10.15.7.26 ogg

2 Could not open checkpoint file /u01/app/ogg/dirchk/RINI_1.cpr
GGSCI (DSI) 12> START EXTRACT EINI_1
Sending START request to MANAGER ...
EXTRACT EINI_1 starting
GGSCI (DSI) 16> VIEW REPORT EINI_1
2019-06-19 14:09:12 WARNING OGG-01194 EXTRACT task RINI_1 abended : Could not open checkpoint file /u01/app/ogg/dirchk/RINI_1.cpr, mode 1 (error 2, No such file
--目标端错误日志
[root@ogg ogg]# more ggserr.log | grep ERROR
2019-06-19 14:09:15 ERROR OGG-00446 Oracle GoldenGate Delivery for Oracle, rini_1.prm: Could not open checkpoint file /u01/app/ogg/dirchk/RINI_1.cpr, mode 1 (error 2, No such file or directory).
###在目标端执行
GGSCI (ogg) 9> add replicat RINI_1,specialrun
REPLICAT added.
##在执行
GGSCI (DSI) 19> START EXTRACT EINI_1
Sending START request to MANAGER ...
EXTRACT EINI_1 starting
GGSCI (DSI) 22> VIEW REPORT EINI_1
Report