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.