Golden gate on Oracle Extract fails to start with these errors
==================
Errors
==================
2026-05-27 15:33:32 ERROR OGG-02022 Logmining server does not exist on this Oracle database.
2026-05-27 15:33:32 ERROR OGG-01668 PROCESS ABENDING.
2026-05-27 15:40:43 ERROR OGG-00303 Unable to connect to database using user ogg. Ensure that the necessary privileges are granted to the user.
2026-05-27T15:47:38.869+0000 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rep_i_01.prm: PROCESS ABENDING.
2026-05-27T15:47:38.879+0000 ERROR OGG-02615 Oracle GoldenGate Delivery for Oracle, rep_s_01.prm: Login to the database as user ogg failed because of error Error while trying to retrieve text for error ORA-01804.
2026-05-27T15:47:38.879+0000 ERROR OGG-08048 Oracle GoldenGate Delivery for Oracle, rep_s_01.prm: Failed to initialize timezone information. Check location of ORACLE_HOME.
2026-05-27T15:47:38.879+0000 ERROR OGG-00664 Oracle GoldenGate Delivery for Oracle, rep_s_01.prm: OCI Error ORA (status = 1804-Error while trying to retrieve text for error ORA-01804).
==================
What to check
What to check
==================
1. Check LD_LIBRARY_PATH
ORACLE_HOME should be in the path
echo $LD_LIBRARY_PATH
/software/oracle/19c/lib:/lib:/usr/lib
2.Check PATH
ORACLE_HOME should be in the path
echo $PATH
/software/oracle/oracle/.local/bin:/software/oracle/oracle/bin:/usr/sbin:/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/software/oracle/19c/bin:/software/oracle/oracle/bin
3.Check prm files of the extract
EXTRACT ext_i_01
setenv (ORACLE_SID="orainst")
setenv (ORACLE_HOME="/software/oracle/122") <=== Should be 19c!!
==================
How to fix
==================
1. Edit all the parameter files for the exatract processes.
1. Edit all the parameter files for the exatract processes.
2. Restart Extract processes.
No comments:
Post a Comment