oracle oci 03113,OGG-00665 OCI Error executing single row select

OGG-

00665  OCI Error executing single row

select (status = 3113-ORA-

03113: end-of-file o

n communication channel

解决

1、

Applies to:

Oracle GoldenGate - Version: 11.1.1.0.7 and later   [Release: 11.1.1 and later ]

Information in this document applies to any platform.

Symptoms

When attempting to start an Extract, we get error

2010-12-09 18:59:25 GGS ERROR 182 OCI Error describe for query (bad syntax) (status = 942-ORA-00942: table or view does not exist), SQL< select value$ from sys.props$ where name = 'NLS_LANGUAGE'>.

2010-12-09 18:59:25 GGS ERROR 190 PROCESS ABENDING.

Cause

The database user does not have the necessary privilege.

Solution

Grant the necessary privilege to the Golden Gate user.

SQL> grant select on sys.props$ to ggsuser;

or

SQL> grant select any dictionary to ggsuser;

方法二

Source Context :

SourceModule            : [ggdb.ora.sess]

SourceID                : [/scratch/aime1/adestore/views/aime1_staxk20/oggcore/OpenSys/src/gglib/ggdbora/ocisess.c]

SourceFunction          : [OCISESS_context_def::oci_try(int, const char *, ...)]

SourceLine              : [650]

2012-12-19 17:25:07  ERROR   OGG-00665  OCI Error executing single row select (status = 3135-ORA-03135: connection lost conta

ct), SQL

a_seq_no>.

原因是数据库重启过，所以ogg需要重新启动即可。

通过自动重启彻底解决：在mgr添加：

AUTOSTART ER *  AUTORESTART ER *, RETRIES 20, WAITMINUTES 5, RESETMINUTES 100