Integrated Extract Writes Incomplete Data for NLS_ISO_CURRENCY in trail DDL record (Doc ID 2255564.1)

Last updated on APRIL 29, 2017

Applies to:

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

Symptoms

Integrated Extract DDL writes incomplete data for SET NLS_ISO_CURRENCY='AUSTRAL' causing replicat to abend with

2016-05-24 16:09:37 ERROR OGG-00519 Fatal error executing DDL replication: error [Error code [12705], ORA-12705:

Cannot access NLS data files or invalid environment specified SQL ALTER SESSION SET NLS_ISO_CURRENCY='AUSTRAL' ], no error handler present.


Ex.,

2016/05/24 16:06:46.000.000 DDLOP Len 1966 RBA 1432
Name:
After Image: Partition 0 G s
 2c43 353d 2730 272c 2c42 373d 2730 272c 2c42 323d | ,C5='0',,B7='0',,B2=
 2738 3932 3034 272c 2c43 3231 3d27 272c 2c42 333d | '89204',,C21='',,B3=
 2748 5227 2c2c 4234 3d27 434f 4e54 4143 5453 272c | 'HR',,B4='CONTACTS',
......ETC......
 
 3d27 4e4c 535f 4355 5252 454e 4359 272c 2c43 3138 | ='NLS_CURRENCY',,C18
 2827 3133 2729 3d27 2427 2c2c 4331 3728 2731 3427 | ('13')='$',,C17('14'
 293d 274e 4c53 5f49 534f 5f43 5552 5245 4e43 5927 | )='NLS_ISO_CURRENCY'
 2c2c 4331 3828 2731 3427 293d 2741 5553 5452 414c | ,,C18('14')='AUSTRAL <<<<< Incomplete
 272c 2c43 3137 2827 3135 2729 3d27 4e4c 535f 4455 | ',,C17('15')='NLS_DU
 414c 5f43 5552 5245 4e43 5927 2c2c 4331 3828 2731 | AL_CURRENCY',,C18('1



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