How to Replicate non- US7ASCII data from one Oracle database to another Oracle database (Doc ID 1466268.1)

Last updated on FEBRUARY 03, 2017

Applies to:

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

Goal

To Replicate non- US7ASCII7 data from one Oracle database to another Oracle database

In an Oracle to Oracle environement, the following message is observed in reports.


Database Language and Character Set:
NLS_LANG environment variable specified has invalid format, default value will be used.
NLS_LANG environment variable not set, using default value AMERICAN_AMERICA.US7ASCII.
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "WE8MSWIN1252"

Warning: your NLS_LANG setting does not match database server language setting.
Please refer to user manual for more information.
 

Solution

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