Oracle Database Discussions

Dear all ,

I test to run IBM Change Data Capture , to replicate the data from DB2 /iSeries ( 1 byte character set , code page =37) to Oracle (database character set is ALL32UTF8)
It use sql loader to load the data when Full load .
After full load successfully , I got the error ORA-24329 invalid character set identifier when continue apply changes in DB2 to Oracle
The IBM CDC Agent install in Oracle Database server, under username =cdcusr .
I already set in profile of this user cdcusr as NLS_LANG= AMERICAN_AMERICA.UTF8 but it does not help .

I think this IBM CDC agent use Oracle Client to talk with Oracle server based on OCI .



$ id
uid=401(cdcusr) gid=300(dba) groups=1(staff)
$ cat ~/.profile



if [ -s "$MAIL" ] # This is at Shell startup. In normal
then echo "$MAILMSG" # operation, the Shell checks
fi # periodically.

export ORACLE_BASE=/usr/oracle
export ORACLE_SID=edwprd
export ORACLE_HOME=/usr/oracle/product/11.1.0/db_1

export LD_LIBRARY_PATH=/usr/oracle/product/11.1.0/db_1/lib

PATH=/usr/bin:/etc:$ORACLE_HOME/bin:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:.

export PATH

export NLS_LANG=AMERICAN_AMERICA.UTF8
# TS_ORA_BEGIN
# Include Transformation Server Replication Engine environment vars.
. /opt/datamirror/tso/lib/.dmprofile
# TS_ORA_END
$



Pls help :)

Thanks .