Oracle GoldenGate - Version 12.2.0.1.0 and later
Information in this document applies to any platform.
SYMPTOMS
OGG-02022 Logmining server does not exist on this Oracle database
CHANGES
Getting error while creating extract
CAUSE
Below steps in solution to be followed in order which if not leads to issue.
Usage of USERIDALIAS instead of USERID and improper setting of ORACLE_HOME ORACLE_SID
SOLUTION
1)Register extract
2)Add extract
3)Start extract
Also please try using USERID instead of USERIDALIAS and setting the ORACLE_HOME ORACLE_SID using the SETENV parameter in the extract parameter file
Below is the example:
dblogin userid c##ggs_user,password ggadminpass#
register extract eo_admin database container(EDRREP)
add extract eo_admin, integrated tranlog, begin now
ADD RMTTRAIL ./dirdat/ea, EXTRACT eo_admin , MEGABYTES 100
start extract eo_admin