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:
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
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |