error ogg-00664
重启数据库实例将各队列停了.
2013-06-01 23:09:10 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT extxx starting.
2013-06-01 23:09:10 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, extxx.prm: EXTRACT extxx starting.
2013-06-01 23:09:10 ERROR OGG-00664 Oracle GoldenGate Capture for Oracle, extxx.prm: OCI Error during OCIServerAttach (status = 12162-Error while trying to retrieve text for error ORA-12162).
2013-06-01 23:09:10 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, extxx.prm: PROCESS ABENDING.
重启mgr解决
ggsci>stop mgr
ggsci>start mgr
ggsci>start extxx
问题解决
重启数据库实例将各队列停了.
2013-06-01 23:09:10 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT extxx starting.
2013-06-01 23:09:10 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, extxx.prm: EXTRACT extxx starting.
2013-06-01 23:09:10 ERROR OGG-00664 Oracle GoldenGate Capture for Oracle, extxx.prm: OCI Error during OCIServerAttach (status = 12162-Error while trying to retrieve text for error ORA-12162).
2013-06-01 23:09:10 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, extxx.prm: PROCESS ABENDING.
重启mgr解决
ggsci>stop mgr
ggsci>start mgr
ggsci>start extxx
问题解决
本文记录了一次解决Oracle GoldenGate (OGG) 中出现的OGG-00664错误的过程。该错误导致了OCIErrorduringOCIServerAttach的状态问题。通过重启数据库实例和mgr服务最终解决了这一问题。
135

被折叠的 条评论
为什么被折叠?



