OGG学习中遇到的一个出错，急！！

weixin_41837849 2018-05-04 10:15:47
试了网上好几个教程，最终都是会报这个错误。不知道改怎么解决
...全文
1998 16 打赏 收藏 转发到动态 举报
写回复
用AI写文章
16 条回复
切换为时间正序
请发表友善的回复…
发表回复
qq_37557269 2020-01-16
  • 打赏
  • 举报
 回复
楼主解决了吗 我现在也遇到了这个问题
bencaca0927 2018-05-08
  • 打赏
  • 举报
 回复
配置的OGG用户在数据库权限够不够，直接给个dba权限试试
weixin_41837849 2018-05-07
  • 打赏
  • 举报
 回复

跑起来是这样的，过1秒差不多 然后会出现右边那个error5那个框...再过两三秒就闪退了 这些都没有了，info一下 也查不到进程在跑。
weixin_41837849 2018-05-07
  • 打赏
  • 举报
 回复
引用 11 楼 baidu_36457652 的回复:
是 ggsci的 dblogin 直接登陆不了是吗？
不是的，dblogin登陆的了，我配置完源数据库的时候 start 源数据库就跑不起来 info all之后 没有启动起来
学海无涯-回头是岸 2018-05-07
  • 打赏
  • 举报
 回复
是 ggsci的 dblogin 直接登陆不了是吗？
weixin_41837849 2018-05-07
  • 打赏
  • 举报
 回复
不知道为啥还是这个错误，试过两个教程 最后都报这个错误，不知道哪里出了问题
weixin_41837849 2018-05-07
  • 打赏
  • 举报
 回复
引用 8 楼 baidu_36457652 的回复:
SOURCEDB test, USERID root@localhost, PASSWORD 123 改成 SOURCEDB test@localhost:3306 ,userid root,password 123
2018-05-07T09:50:46.375+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for MySQL: GGSCI command (admin): start initlod1. 2018-05-07T09:50:46.381+0800 INFO OGG-00963 Oracle GoldenGate Manager for MySQL, MGR.prm: Command received from GGSCI on host [FE80::4055:95D5:777A:ED26]:58418 (START EXTRACT INITLOD1 ). 2018-05-07T09:50:46.386+0800 INFO OGG-00975 Oracle GoldenGate Manager for MySQL, MGR.prm: EXTRACT INITLOD1 starting. 2018-05-07T09:50:46.552+0800 INFO OGG-01017 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: Wildcard resolution set to IMMEDIATE because SOURCEISTABLE is used. 2018-05-07T09:50:46.552+0800 INFO OGG-00992 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: EXTRACT INITLOD1 starting. 2018-05-07T09:50:46.559+0800 INFO OGG-03059 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: Operating system character set identified as GBK. 2018-05-07T09:50:46.562+0800 INFO OGG-02695 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: ANSI SQL parameter syntax is used for parameter parsing. 2018-05-07T09:50:46.575+0800 INFO OGG-01360 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: EXTRACT is running in Initial Load mode. 2018-05-07T09:50:46.616+0800 INFO OGG-01889 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: Flush size (max message size) is set to 27,985. 2018-05-07T09:50:46.767+0800 INFO OGG-01851 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: filecaching started: thread ID: 46244112. 2018-05-07T09:50:46.767+0800 INFO OGG-01815 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: Virtual Memory Facilities for: COM anon alloc: MapViewOfFile anon free: UnmapViewOfFile file alloc: MapViewOfFile file free: UnmapViewOfFile target directories: D:\ogg\dirtmp. 2018-05-07T09:50:46.783+0800 WARNING OGG-01842 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: CACHESIZE PER DYNAMIC DETERMINATION (2G) LESS THAN RECOMMENDED: 64G (64bit system) vm found: 3G Check swap space. Recommended swap/extract: 128G (64bit system). 2018-05-07T09:50:46.800+0800 INFO OGG-06508 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: Wildcard MAP (TABLE) resolved (entry test.*): TABLE "test"."test1". 2018-05-07T09:50:46.814+0800 INFO OGG-06509 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: Using the following key columns for source table test.test1: name, age. 2018-05-07T09:50:46.814+0800 INFO OGG-00993 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: EXTRACT INITLOD1 started. 2018-05-07T09:50:46.782+0800 INFO OGG-00963 Oracle GoldenGate Manager for MySQL, MGR.prm: Command received from EXTRACT on host [127.0.0.1]:58420 (VERSION). 2018-05-07T09:50:46.782+0800 INFO OGG-00960 Oracle GoldenGate Manager for MySQL, MGR.prm: Access granted (rule #1). 2018-05-07T09:50:46.782+0800 INFO OGG-00963 Oracle GoldenGate Manager for MySQL, MGR.prm: Command received from EXTRACT on host [127.0.0.1]:58421 (START SERVER CPU -1 PRI -1 TIMEOUT 300 PARAMS ). 2018-05-07T09:50:47.003+0800 WARNING OGG-01880 Oracle GoldenGate Collector for MySQL: ALLOWOUTPUTDIR D:\ogg\ is the same directory where this GoldenGate instance is installed. 2018-05-07T09:50:47.011+0800 INFO OGG-01888 Oracle GoldenGate Collector for MySQL: TCP network is configured as OS DEFAULT SPECIFIED ACTUAL VALUE IP_DSCP N/A N/A N/A IP_TOS N/A N/A N/A TCP_NODELAY 256 N/A 256 SO_SNDBUF 8192 N/A 8192 SO_RCVBUF 8192 N/A 8192. 2018-05-07T09:50:46.982+0800 INFO OGG-00963 Oracle GoldenGate Manager for MySQL, MGR.prm: Command received from SERVER on host [::1]:58422 (REPORT 7292 7819). 2018-05-07T09:50:46.982+0800 INFO OGG-00960 Oracle GoldenGate Manager for MySQL, MGR.prm: Access granted (rule #1). 2018-05-07T09:50:46.982+0800 INFO OGG-00974 Oracle GoldenGate Manager for MySQL, MGR.prm: Manager started collector process (Port 7819). 2018-05-07T09:50:47.022+0800 INFO OGG-01228 Oracle GoldenGate Collector for MySQL: Timeout in 300 seconds. 2018-05-07T09:50:52.118+0800 INFO OGG-01888 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: TCP network is configured as OS DEFAULT SPECIFIED ACTUAL VALUE IP_DSCP N/A N/A N/A IP_TOS N/A N/A N/A TCP_NODELAY 256 N/A 256 SO_SNDBUF 8192 N/A 8192 SO_RCVBUF 8192 N/A 8192. 2018-05-07T09:50:52.145+0800 INFO OGG-01229 Oracle GoldenGate Collector for MySQL: Connected to admin-PC:58425. 2018-05-07T09:50:52.166+0800 INFO OGG-01478 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: Output file ./dirdat/el1.dat is using format RELEASE 12.3. 2018-05-07T09:50:52.165+0800 INFO OGG-01669 Oracle GoldenGate Collector for MySQL: Opening D:\ogg\./dirdat/el1.dat (byte 0, current EOF 0). 2018-05-07T09:50:52.248+0800 INFO OGG-02911 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: Processing table test.test1. 2018-05-07T09:50:52.375+0800 INFO OGG-01735 Oracle GoldenGate Collector for MySQL: Synchronizing D:\ogg\./dirdat/el1.dat to disk. 2018-05-07T09:50:52.392+0800 INFO OGG-00991 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: EXTRACT INITLOD1 stopped normally. 2018-05-07T09:50:52.447+0800 INFO OGG-01971 Oracle GoldenGate Collector for MySQL: The previous message, 'INFO OGG-01735', repeated 1 times. 2018-05-07T09:50:52.447+0800 INFO OGG-01670 Oracle GoldenGate Collector for MySQL: Closing D:\ogg\./dirdat/el1.dat. 2018-05-07T09:50:52.447+0800 INFO OGG-01735 Oracle GoldenGate Collector for MySQL: Synchronizing D:\ogg\./dirdat/el1.dat to disk.
学海无涯-回头是岸 2018-05-07
  • 打赏
  • 举报
 回复
SOURCEDB test, USERID root@localhost, PASSWORD 123 改成 SOURCEDB test@localhost:3306 ,userid root,password 123
学海无涯-回头是岸 2018-05-07
  • 打赏
  • 举报
 回复
你这里面也没看到报错 ，就只有两个警告
weixin_41837849 2018-05-07
  • 打赏
  • 举报
 回复
引用 5 楼 baidu_36457652 的回复:
你看一下 你的日志里面包的什么错误
2018-05-07T08:53:48.093+0800 INFO OGG-01085 Oracle GoldenGate Manager for MySQL, MGR.prm: mgr received window closed event. 2018-05-07T08:53:54.047+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for MySQL: GGSCI command (admin): start mgr. 2018-05-07T08:53:54.220+0800 WARNING OGG-01877 Oracle GoldenGate Manager for MySQL, MGR.prm: Missing explicit accessrule for server collector. 2018-05-07T08:53:54.220+0800 INFO OGG-00983 Oracle GoldenGate Manager for MySQL, MGR.prm: Manager started (port 7809). 2018-05-07T08:53:59.711+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for MySQL: GGSCI command (admin): start initlod1. 2018-05-07T08:53:59.720+0800 INFO OGG-00963 Oracle GoldenGate Manager for MySQL, MGR.prm: Command received from GGSCI on host [FE80::4055:95D5:777A:ED26]:58049 (START EXTRACT INITLOD1 ). 2018-05-07T08:53:59.724+0800 INFO OGG-00975 Oracle GoldenGate Manager for MySQL, MGR.prm: EXTRACT INITLOD1 starting. 2018-05-07T08:53:59.861+0800 INFO OGG-01017 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: Wildcard resolution set to IMMEDIATE because SOURCEISTABLE is used. 2018-05-07T08:53:59.861+0800 INFO OGG-00992 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: EXTRACT INITLOD1 starting. 2018-05-07T08:53:59.868+0800 INFO OGG-03059 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: Operating system character set identified as GBK. 2018-05-07T08:53:59.873+0800 INFO OGG-02695 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: ANSI SQL parameter syntax is used for parameter parsing. 2018-05-07T08:53:59.885+0800 INFO OGG-01360 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: EXTRACT is running in Initial Load mode. 2018-05-07T08:53:59.926+0800 INFO OGG-01889 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: Flush size (max message size) is set to 27,985. 2018-05-07T08:54:00.075+0800 INFO OGG-01851 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: filecaching started: thread ID: 46113040. 2018-05-07T08:54:00.083+0800 INFO OGG-01815 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: Virtual Memory Facilities for: COM anon alloc: MapViewOfFile anon free: UnmapViewOfFile file alloc: MapViewOfFile file free: UnmapViewOfFile target directories: D:\ogg\dirtmp. 2018-05-07T08:54:00.095+0800 WARNING OGG-01842 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: CACHESIZE PER DYNAMIC DETERMINATION (2G) LESS THAN RECOMMENDED: 64G (64bit system) vm found: 3.44G Check swap space. Recommended swap/extract: 128G (64bit system). 2018-05-07T08:54:00.112+0800 INFO OGG-06508 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: Wildcard MAP (TABLE) resolved (entry test.*): TABLE "test"."test1". 2018-05-07T08:54:00.127+0800 INFO OGG-06509 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: Using the following key columns for source table test.test1: name, age. 2018-05-07T08:54:00.127+0800 INFO OGG-00993 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: EXTRACT INITLOD1 started. 2018-05-07T08:54:00.118+0800 INFO OGG-00963 Oracle GoldenGate Manager for MySQL, MGR.prm: Command received from EXTRACT on host [127.0.0.1]:58051 (VERSION). 2018-05-07T08:54:00.118+0800 INFO OGG-00960 Oracle GoldenGate Manager for MySQL, MGR.prm: Access granted (rule #1). 2018-05-07T08:54:00.118+0800 INFO OGG-00963 Oracle GoldenGate Manager for MySQL, MGR.prm: Command received from EXTRACT on host [127.0.0.1]:58052 (START SERVER CPU -1 PRI -1 TIMEOUT 300 PARAMS ). 2018-05-07T08:54:00.279+0800 WARNING OGG-01880 Oracle GoldenGate Collector for MySQL: ALLOWOUTPUTDIR D:\ogg\ is the same directory where this GoldenGate instance is installed. 2018-05-07T08:54:00.286+0800 INFO OGG-01888 Oracle GoldenGate Collector for MySQL: TCP network is configured as OS DEFAULT SPECIFIED ACTUAL VALUE IP_DSCP N/A N/A N/A IP_TOS N/A N/A N/A TCP_NODELAY 256 N/A 256 SO_SNDBUF 8192 N/A 8192 SO_RCVBUF 8192 N/A 8192. 2018-05-07T08:54:00.258+0800 INFO OGG-00963 Oracle GoldenGate Manager for MySQL, MGR.prm: Command received from SERVER on host [::1]:58053 (REPORT 5168 7819). 2018-05-07T08:54:00.258+0800 INFO OGG-00960 Oracle GoldenGate Manager for MySQL, MGR.prm: Access granted (rule #1). 2018-05-07T08:54:00.258+0800 INFO OGG-00974 Oracle GoldenGate Manager for MySQL, MGR.prm: Manager started collector process (Port 7819). 2018-05-07T08:54:00.296+0800 INFO OGG-01228 Oracle GoldenGate Collector for MySQL: Timeout in 300 seconds. 2018-05-07T08:54:05.303+0800 INFO OGG-01888 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: TCP network is configured as OS DEFAULT SPECIFIED ACTUAL VALUE IP_DSCP N/A N/A N/A IP_TOS N/A N/A N/A TCP_NODELAY 256 N/A 256 SO_SNDBUF 8192 N/A 8192 SO_RCVBUF 8192 N/A 8192. 2018-05-07T08:54:05.303+0800 INFO OGG-01229 Oracle GoldenGate Collector for MySQL: Connected to admin-PC:58058. 2018-05-07T08:54:05.304+0800 INFO OGG-01478 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: Output file ./dirdat/el1.dat is using format RELEASE 12.3. 2018-05-07T08:54:05.304+0800 INFO OGG-01669 Oracle GoldenGate Collector for MySQL: Opening D:\ogg\./dirdat/el1.dat (byte 0, current EOF 0). 2018-05-07T08:54:05.345+0800 INFO OGG-02911 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: Processing table test.test1. 2018-05-07T08:54:05.377+0800 INFO OGG-01735 Oracle GoldenGate Collector for MySQL: Synchronizing D:\ogg\./dirdat/el1.dat to disk. 2018-05-07T08:54:05.457+0800 INFO OGG-00991 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: EXTRACT INITLOD1 stopped normally. 2018-05-07T08:54:05.457+0800 INFO OGG-01971 Oracle GoldenGate Collector for MySQL: The previous message, 'INFO OGG-01735', repeated 1 times. 2018-05-07T08:54:05.457+0800 INFO OGG-01670 Oracle GoldenGate Collector for MySQL: Closing D:\ogg\./dirdat/el1.dat. 2018-05-07T08:54:05.457+0800 INFO OGG-01735 Oracle GoldenGate Collector for MySQL: Synchronizing D:\ogg\./dirdat/el1.dat to disk.
学海无涯-回头是岸 2018-05-07
  • 打赏
  • 举报
 回复
引用 13 楼 weixin_41837849 的回复:
跑起来是这样的，过1秒差不多 然后会出现右边那个error5那个框...再过两三秒就闪退了 这些都没有了，info一下 也查不到进程在跑。
不好意思 不知道了。。
weixin_41837849 2018-05-04
  • 打赏
  • 举报
 回复
我现在是配置完源数据库，start起来 就报这个错
weixin_41837849 2018-05-04
  • 打赏
  • 举报
 回复
EXTRACT INITLOD1 DBOPTIONS HOST 127.0.0.1, CONNECTIONPORT 3306 SOURCEDB test, USERID root@localhost, PASSWORD 123 RMTHOST 127.0.0.1, MGRPORT 7809 RMTFILE ./dirdat/el1.dat, PURGE TABLE test.*;
学海无涯-回头是岸 2018-05-04
  • 打赏
  • 举报
 回复
端口 ip这些网络环境测过吗？
weixin_41837849 2018-05-04
  • 打赏
  • 举报
 回复
学海无涯-回头是岸 2018-05-04
  • 打赏
  • 举报
 回复
你看一下 你的日志里面包的什么错误
android学习
如果你有兴趣为Android平台开发游戏，有很多你需要了解的东西。如果你有过游戏开发经验，那么转移到移动平台上来将不是特别困难。你主要只需学习其架构以及API就行了。如果你是一名游戏开发新手，我总结了一张列表，上面有你必需知道的东西，供你起步用。这些知识适用于很多类型的游戏，包括动作类、策略类、模拟类和益智类。 Android是一个基于Java的环境。这对初学者来说是个好消息，因为相对于C++，...
如何开发安卓游戏（转）
如何开发安卓游戏 如果你以前从没写过代码，在你前进路上还要学习很多，但别气馁。接下来便是开发游戏的一些主要步骤，让我们来学习一下：一、获取tanjurd SDK新手上路的第一步便是获取Android SDK(软件开发工具包)。SDK里有一个核心类库，一个模拟器，一些工具和示例代码。我强烈建议使用Eclipse和Android Eclipse插件。如果你玩Android的话，Eclipse IDE对
android游戏开发须知！
英文 http://dev.chinamobile.com/cmdn/bbs/thread-13718-1-1.html 如果你有兴趣为Android平台开发游戏，有很多你需要了解的东西。我是Light Racer，Light Racer 3D以及Wixel的开发者，这些游戏目前在Android Market上有售。我以前也开发过游戏，但Light Racer是我的第一个Android应
Android游戏开发起步（译文）
如果你有兴趣为Android平台开发游戏，有很多你需要了解的东西。我是Light Racer，Light Racer 3D以及Wixel的开发者，这些游戏目前在Android Market上有售。我以前也开发过游戏，但Light Racer是我的第一个Android应用程序，我从中学到了很多Android游戏开发知识，也愿意与诸位分享。我甚至写了一本在线的书详细介绍了Light Racer3D的开
Android游戏开发初始阶段建议（转）
如果你有兴趣为Android平台开发游戏，有很多你需要了解的东西。如果你有过游戏开发经验，那么转移到移动平台上来将不是特别困难。你主要只需学习其架构以及API就行了。如果你是一名游戏开发新手，我总结了一张列表，上面有你必需知道的东西，供你起步用。这些知识适用于很多类型的游戏，包括动作类、策略类...
基础和管理

17,377

社区成员

95,128

社区内容

发帖
与我相关
我的任务
社区描述
Oracle 基础和管理
社区管理员
  • 基础和管理社区
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章