ERROR OGG-02022 Logmining server does not exist on this Oracle database in Golden Gate

When starting the extract process in Oracle Golden Gate, getting the following error:

iThreading::MainThread::Run(int, char**))]
                          : [/u01/app/oracle/product/gg/extract(main)]
                          : [/lib64/libc.so.6(__libc_start_main)]
                          : [/u01/app/oracle/product/gg/extract()]

2025-08-10 14:54:26  ERROR   OGG-02022  Logmining server does not exist on this 
Oracle database.

2025-08-10 14:54:27  ERROR   OGG-01668  PROCESS ABENDING.

Solution: Register the Extract process because 19c using integrated extract process

REGISTER EXTRACT ext02 DATABASE

Following are the steps using to configure the extract process

GGSCI (localhost.localdomain as gguser@orcl) 40> view param ext02

EXTRACT ext02
USERID gguser@localhost:1521/pdb1, PASSWORD gguser
discardfile /u01/app/oracle/product/gg/dirrpt/ext02.dsc, purge
reportcount every 15 minutes, rate
exttrail /u01/app/oracle/product/gg/dirdat/ext02/et
TABLE hr.data;


GGSCI (localhost.localdomain as gguser@orcl) 41> dblogin userid gguser@localhost:1521/pdb1, PASSWORD gguser
Successfully logged into database.

GGSCI (localhost.localdomain as gguser@orcl) 42> add extract ext02 tranlog,begin now
Integrated Extract added.


GGSCI (localhost.localdomain as gguser@orcl) 43> add exttrail /u01/app/oracle/product/gg/dirdat/ext02/et extract ext02, megabytes 100
EXTTRAIL added.
This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply