Pages

Sunday, May 31, 2026

Golden gate Error - ERROR OGG-08048 Failed to initialize timezone information.

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
==================
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.
2. Restart Extract processes.

No comments:

Post a Comment