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