Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ERROR OGG-03523 Oracle GoldenGate Capture for Oracle, <>.prm: Failed to set session time zone to

SandeepdbaAug 24 2016 — edited Oct 19 2016

OGG-03523 Failed to set session time zone to source database time zone 'EAT' (Doc ID 1961948.1)

We have same time in our database and db server as well.

SQL*Plus: Release 11.2.0.4.0 Production on Wed Aug 24 13:09:02 2016

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

SQL> select to_char( sysdate ,'DD-MON-YY HH24:MI:SS') from dual;

TO_CHAR(SYSDATE,'DD-MON-

------------------------

24-AUG-16 13:09:21

We are trying to setup a new extract process and below are the error massages .

ERROR   OGG-03523  Oracle GoldenGate Capture for Oracle, <>.prm:  Failed to set session time zone to source database time zone 'Etc/Unknown'.

ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, <>.prm:  PROCESS ABENDING.

ERROR   OGG-03523  Oracle GoldenGate Capture for Oracle, <>.prm:  Failed to set session time zone to source database time zone 'Etc/Unknown'.

ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, <>.prm:  PROCESS ABENDING.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 16 2016
Added on Aug 24 2016
11 comments
1,411 views