GoldenGate SESSIONTIMEZONE on the Target Does not Match the DBTIMEZONE of the Source or Target (Doc ID 1397814.1)

Last updated on JANUARY 12, 2017

Applies to:

Oracle GoldenGate - Version 10.4.0.0 and later
Information in this document applies to any platform.

Symptoms

The SESSIONTIMEZONE on the target does not match the DBTIMEZONE of the source or target after replication of data for columns defined as TIMESTAMP WITH LOCAL TIMEZONE.

Check source and target settings for these values:
Source –
SQL> SELECT SESSIONTIMEZONE FROM DUAL;
SESSIONTIMEZONE
---------------------------------------------------------------------------
-07:00

1 row selected.

SQL> SELECT DBTIMEZONE FROM DUAL;
DBTIME
------
-07:00

1 row selected.

Target -
SQL> SELECT SESSIONTIMEZONE FROM DUAL;

SESSIONTIMEZONE
---------------------------------------------------------------------------
-08:00

1 row selected.

SQL> SELECT DBTIMEZONE FROM DUAL;

DBTIME
------
-07:00

1 row selected.


Notice in this example, the SESSIONTIMEZONE on the target doesn’t match the DBTIMEZONE of the source or target.

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