Tuesday, August 18, 2015

ERROR OGG-00665 OCI Error calling OCITransRollback (stat us = 3114-ORA-03114

Scenario: 
Replicat abended with following error  "ERROR   OGG-00665"

Root cause:
To find out root cause,  we checked report file, found following error

GGSCI (pida4909) 2> view report RIVIQ1
Source Context :
  SourceModule            : [ggdb.ora.sess]
  SourceID                : [/scratch/aime1/adestore/views/aime1_staxj04/oggcore
/OpenSys/src/gglib/ggdbora/ocisess.c]
  SourceFunction          : [OCISESS_context_def::oci_try(int, const char *, ..]
  SourceLine              : [651]

2015-07-29 10:21:52  ERROR   OGG-00665  OCI Error calling OCITransRollback (stat
us = 3114-ORA-03114: not connected to ORACLE), SQL<Not available>.
***********************************************************************
*                   ** Run Time Statistics **                         *
***********************************************************************

After investigation, we found following results
Investigate why this Replicat is unable to connect to database  ?

Resolution:
1) check database is up & running
2) check Listener is up and running
3) Check with SA | server reboot schedule 

-- Oracle In-memory >>
-- Nikhil Tatineni >>

Querys to monitor RAC

following few  Query's will help to find out culprits-  Query to check long running transaction from last 8 hours  Col Sid Fo...