Login to the database as user GGOWNER failed because of error Error while trying to retrieve text for error ORA-01804

 Problem:

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.
 

Solution:

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")

Corrected to:

SETENV (ORACLE_HOME="/u01/oracle/19.5/db")