Tuesday, August 18, 2015

ERROR OGG-00446 Missing filename opening checkpoint file

Scenario: 
Added New Replicat Process, Replicat Abended with following Error

RootCauseAnalysis:
ggsci> view report repri

Replicat Abends with -----
S_LANGUAGE     = "AMERICAN"
NLS_TERRITORY    = "AMERICA"
NLS_CHARACTERSET = "US7ASCII"
Source Context :
  SourceModule            : [er.checkpoint]
  SourceID                : [/scratch/aime1/adestore/views/aime1_staxj04/oggcore/OpenSys/src/app/er/checkpoint.cpp]
  SourceFunction          : [get_checkpoint_context(time_elt_def *, time_elt_def *)]
  SourceLine              : [45]
2015-07-29 08:50:43  ERROR   OGG-00446  Missing filename opening checkpoint file.
2015-07-29 08:50:43  ERROR   OGG-01668  PROCESS ABENDING.


Resolution:
Make sure checkpoint table is created is created in GoldenGate schema

Steps to create checkpoint table
Step1:
GGSCI (nt4567) 25> dblogin userid GGADMIN, PASSWORD XXXXXXXXX
Successfully logged into database.


Step2:
GGSCI (nt4567) 26> add checkpointtable GGADMIN.ckptab
Successfully created checkpoint table GGADMIN.ckptab

Step3: 
After Creating checkpointtable delete abended replicat and re-create Replicat using checkpointtable :)

--Nikhil Tatineni---


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