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
Solve 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.
SymptomsWhen attempting to start a Extract, we get the error

2010-12-09 18:59:25 GGS Error OCI error describe for query (bad syntax) (status = 942-ora-00942:table or view does no T exist), sql< select value$ from sys.props$ where name = ' Nls_language '.

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

causeThe database user does not have the necessary privilege.
SolutionGrant the necessary privilege to the Golden Gate user.


Sql> Grant Select on sys.props$ to Ggsuser;
Or
Sql> Grant Select any dictionary to Ggsuser;

Method Two

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 Co Nta
CT), Sql<select DECODE (archived, ' YES ', 1, 0), status from V$log WHERE thread# =: Ora_thread and sequence# =: or
A_seq_no>.

The reason is that the database has been restarted, so Ogg needs to be restarted.

complete resolution by automatic reboot: Add in Mgr:

AUTOSTART ER *
AutoRestart ER *, retries, waitminutes 5, Resetminutes