My Oracle Support Banner

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

Last updated on AUGUST 09, 2018

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.