Configure the cmpServer.bat file (Oracle)
About this task
On the Unica Campaign client machines, modify the Unica Campaign Listener startup script as follows:
For Windows™
Add the following line to the cmpServer.bat file, located in the <CAMPAIGN_HOME>/bin directory:
set NLS_LANG=AMERICAN_AMERICA.UTF8
From V12.1 Fixpack 4 onwards, if oracle connection with Non-native (via ODBC)
Add following lines in setenv file located in the <CAMPAIGN_HOME>/bin directory.
set NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'
set NLS_TIMESTAMP_FORMAT='YYYY-MM-DD HH24:MI:SSXFF'
set ODBCINI=<Path_to_odbc.ini>
For UNIX™
Add the following lines to the rc.unica_ac file, located in the <CAMPAIGN_HOME>/bin directory:
NLS_LANG=AMERICAN_AMERICA.UTF8
export NLS_LANG
(The syntax will vary depending on operating system).
From V12.1 Fixpack 4 onwards, if oracle connection with Non-native (via ODBC)
export NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'
export NLS_TIMESTAMP_FORMAT='YYYY-MM-DD HH24:MI:SSXFF'
export ODBCINI=<Path_to_odbc.ini>