When starting up OGG extract with the following error in ggserr.log :

ERROR OGG-00901 Failed to lookup object ID for table GG.D7A_GGS_TRACE
ERROR OGG-01668 Oracle GoldenGate Capture for Oracle,CAP.prm:PROCESS ABENDING

Check the parameter file of capture with one line:

tractable GG.D7A_GGS_TRACE

SOLUTION

Manually create trace table as required.

GGSCI>info credentialstore
GGSCI> DBLOGIN USERIDALIAS gg
or
GGSCI>DBLOGIN USERID gg, PASSWORD passwd
GGSCI> INFO TRACETABLE
GGSCI> add tracetable GG.D7A_GGS_TRACE
GGSCI> INFO TRACETABLE
GGSCI> 

SQL> desc GG.D7A_GGS_TRACE
 Name                                      Null?    Type
 ----------------------------------------- -------- -------------------
 GROUP_ID                                  NOT NULL VARCHAR2(8)
 DB_USER                                            VARCHAR2(30)
 LAST_UPDATE                                        DATE

Add default CHECKPOINTTABLE:

GGSCI> INFO TRACETABLE
GGSCI> ADD CHECKPOINTTABLE
GGSCI> info CHECKPOINTTABLE

SQL> select table_name from dba_tables where owner='GG';

TABLE_NAME
------------------------------
GGS_CHECKPOINT
GGS_CHECKPOINT_LOX
D7A_GGS_TRACE