ORA-26955 or ORA-26956 in Downstream Capture on Oracle 12.2 with an Oracle 10.2 Source Database

(Doc ID 1928808.1)

Last updated on JANUARY 14, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Oracle GoldenGate - Version 12.1.2.0.0 to 12.1.3.0.0 [Release 12.1]
Information in this document applies to any platform.

Symptoms

The execution of the procedure DBMS_CAPTURE_ADM.CREATE_CAPTURE to create a downstream capture process on a 12.2 database gives the folloiwng warning when the source database is version 10.2 and a database link to the source is provided:

26956, 00000, "capture %s created successfully but the source database time zone is not available"
// *Cause:  The capture process was created successfully; however, it will not be able to capture
//          time stamp with local time zone data unless the source database time zone is set.
// *Action: Refer to My Oracle Support Note 1928808.1 to set the source database time zone for the
//          specified capture process.

The capture process can also signal the folloiwng error in the same type of configuration:

26955, 00000, "cannot capture time stamp with local time zone data"
// *Cause:  The capture process was unable to capture time stamp with local time zone data
//          because the source database time zone was not available.
// *Action: Refer to My Oracle Support Note 1928808.1 to set the source database time zone for the
//          specified capture process.
/

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