Classic Extract Fails To Start With ERROR OGG-03523 Failed to set session time zone to source database time zone 'Etc/Unknown'. (Doc ID 2181904.1)

Last updated on JANUARY 05, 2017

Applies to:

Oracle GoldenGate - Version 12.1.2.0.0 to 12.2.0.1.0 [Release 12.1 to 12.2]
Information in this document applies to any platform.
New Extract

Symptoms

 New setup
Classic extract fails to start, throws below error
.
2016-08-24 16:59:17 ERROR OGG-03523 Failed to set session time zone to
source database time zone 'Etc/Unknown'.
2016-08-24 16:59:17 ERROR OGG-01668 PROCESS ABENDING.

 

++ Able to dblogin from ggsci
.
GGSCI () 2> dblogin userid gg_app password xxxx
Successfully logged into database.
GGSCI () 4> info trandata
XXDS.XXDS_WAG_AR_PRESTAGE
Logging of supplemental redo log data is disabled for table
XXDS.XXDS_WAG_AR_PRESTAGE.
Prepared CSN for table XXDS.XXDS_WAG_AR_PRESTAGE: 9862405825

Changes

 None.

 

Reviewed following settings

SQL> set pages 999
SQL> select systimestamp from dual;
.
SYSTIMESTAMP
---------------------------------------------------------------------------
24-AUG-16 04.52.54.138904 PM -05:00
.
SQL> SELECT SESSIONTIMEZONE FROM DUAL;
.
SESSIONTIMEZONE
---------------------------------------------------------------------------
-05:00
.
SQL> SELECT DBTIMEZONE FROM DUAL;
.
DBTIMEZONE
---------------
America/Chicago
.
SQL> !date
Wed Aug 24 16:53:02 CDT 2016
.
SQL> !env |grep TZ
ORA_TZFILE=
.
=====================================================
.
from archive dump and query output, the DB timezone is central time, which is
same as OS time zone.
.
.
Low scn: 0x08f8.445b1698 (9862391731864) 08/24/2016 16:45:23
Next scn: 0x08f8.445b169b (9862391731867) 08/24/2016 16:45:23
Enabled scn: 0x08e6.0c990309 (9784146854665) 08/24/2014 02:15:04
Thread closed scn: 0x08f8.445b1698 (9862391731864) 08/24/2016 16:45:23
========================================================
.
Linux server:
.
[]$ cat /etc/sysconfig/clock
# The ZONE parameter is only evaluated by system-config-date.
# The timezone of the system is defined by the contents of /etc/localtime.
ZONE="America/Chicago"
UTC=true
ARC=false

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms