Conversion From Charset UTF-8 Of Source DB To Some Single Byte Charset On Target DB Causes Errors (Doc ID 1946076.1)

Last updated on JANUARY 12, 2017

Applies to:

Oracle GoldenGate - Version 11.1.1.0.0 to 12.1.2.1.2 [Release 11.1.1 to 12.1]
Information in this document applies to any platform.

Check for relevancy 01/12/2017

Symptoms

Trying to do an initial load from a Source database to a Target database ,results in the following errors when the Source has a multibyte charset(i.e. UTF-8) and the Traget has a single byte character set (i.e. windows-1252)
WARNING OGG-01194 Oracle GoldenGate Capture for Oracle, eini_8.prm: EXTRACT task RINI_8 abended : Conversion from character set UTF-8 of source column CLIENT_ALIAS to character set windows-1252 of target column CLIENT_ALIAS failed because the source column contains a character that is not available in the target character set.
ERROR OGG-01203 Oracle GoldenGate Capture for Oracle, eini_8.prm: EXTRACT abending.

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