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


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