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 >>
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 >>