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>