When starting up an extract group on Source DB, it gets ABDENDING with this error:
GGSCI> start extra
Error in ggserr.log:
ERROR OGG-00303 Oracle GoldenGate Capture for Oracle, extra.prm: Unable to connect to database using user GGOWNER@SPR. Ensure that the necessary privileges are granted to the user.
Login to the database as user GGOWNER failed because of error Error while trying to retrieve text for error ORA-01804.
2022-03-04T13:56:23.909+0000 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, extra.prm: PROCESS ABENDING.
Make sure the ORACLE_HOME parameter in the Extract parameter is pointing to the right location, in my case the ORACLE_HOME location was having a typo:
SETENV (ORACLE_HOME="/u01/oracle/19.5/d b")
Post a Comment