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 FEBRUARY 18, 2020

Applies to:

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
schemaname.tablename
Logging of supplemental redo log data is disabled for table
schemaname.tablename
Prepared CSN for table schemaname.tablename: 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.