OCI Error ORA-00904: "INTCOL#": invalid identifier

 Error Details: 

 ERROR   OGG-00663  Oracle GoldenGate Capture for Oracle, ehrint01.prm:  OCI Error ORA-00904: "INTCOL#": invalid identifier

(status = 904), SQL <SELECT md_col_name, md_col_num, md_col_segcol,        md_col_type, md_col_len, md_col_prec,        md_col_scale, md_col_charsetid,        md_col_charsetform, md_col_alt_type,        md_col_alt_prec, md_col_alt_char_used,        md_col_alt_length, md_col_alt_type_owner,        property, xopqtypeflags , intcol#   FROM TABLE (system.logmnr$col_gg_tabf_public(                     :sid, :mdh, :object_id,                     :objv, to_number(:csn) ))>.

Solution: 

Apply the patch 17030189 on database and after applied patch execute script prvtlmcs.plb, prvtlmcb.plb, both script location are GG_HOME.

OGG-02022 Logmining server does not exist on this Oracle database.

 error: 

2021-07-21 16:33:31  ERROR   OGG-02022  Logmining server does not exist on this Oracle database.

2021-07-21 16:33:31  ERROR   OGG-01668  PROCESS ABENDING.

Solution 

dblogin userid gguser@<service_name> password <***>

register extract <extract_name>,database