OGG-00665 OCI Error executing single row select(status = 3135-ORA-03135: connection lost contact
来源:互联网 发布:如何购买app软件 编辑:程序博客网 时间:2024/06/06 05:09
【现象】:oracle端goldengate的抽取进程状态为abend,但mgr和投递进程为running状态
【排查】:1、查看抽取进程的dsc日志文件,无记录
2、查看ggserr.log,报“2014-01-17 18:25:56 ERROR OGG-00665 Oracle GoldenGate Capture for Oracle, ex_xxxx.prm: OCI Error executing single row select (status = 3135-ORA-03135: connection lost contact
Process ID: 2520
Session ID: 351 Serial number: 9), SQL<SELECT DECODE(archived, 'YES', 1, 0), status FROM v$log WHERE thread# = :ora_thread AND sequence# = :ora_seq_no>.”错误日志提示抽取进程与oracle的连接断开
3、查看oracle的alert日志,显示goldengate报错时,数据库进行了shutdown操作。
【分析】:抽取进程abend的原因是,oracle数据库关闭,导致抽取进程与oracle的连接中断,所以抽取进程abend了,但投递进程和mgr进程正常。
【解决】:启动抽取进程即可,也可在mgr中配置抽取进程autorestart,使其自动启动
- OGG-00665 OCI Error executing single row select(status = 3135-ORA-03135: connection lost contact
- OGG-00665 OCI Error executing single row select
- ORA-03135: connection lost contact
- ORA-03135: connection lost contact;ORA-02068
- [转帖]ORA-03135: connection lost contact的解决方法
- 使用Navicat 连接oracle “ORA-03135: Connection Lost Contact”
- DBSPI40-1: Unable to fetch data from table 'V$SYSSTAT' [ORA-03135: connection lost contact]
- ORA-03135: connection lost contact的解决方法(未解决本人问题)
- PLSQL链接Oracle报错:ORA-03135: connection lost contact 错误
- ORA-12547: TNS:lost contact
- ORA-12547: TNS:lost contact
- ORA-12547: TNS:lost contact
- ORA-12547: TNS:lost contact
- ORA-12547: TNS:lost contact
- ORA-12547:TNS:lost contact
- ORA-12547: TNS:lost contact
- ORA-12547: TNS:lost contact
- rep进程删不掉-OCI Error ORA-00942: table or view does not exist (status = 942
- etl kettle的源代码导入
- OpenCV,OpenGL,DirectX区别
- ASP.NET中的内置对象(2)
- 解决AppStore上传ipa包速度慢的问题
- 有毛病的单例2
- OGG-00665 OCI Error executing single row select(status = 3135-ORA-03135: connection lost contact
- vim 分屏
- 实时监听js改变value,跨浏览器支持
- Presenting view controllers on detached view controllers is discouraged
- 有效删除CI框架中URL中的index.php
- 指针的大小
- print 格式化输出
- [Leetocde] 4Sum (Java)
- UVA 1330 - City Game(扫描方法 | 单调栈维护)