Cannot create Oracle NLS environment for charset 873 and ncharset 1000

[sagar_puri]

Hi,

While connecting Qlik Replicate (6.6.0.384) to Oracle 12.2.0.1.0 we are getting the below error,

Below is the characterset parameter set in oracle,

NLS_CHARACTERSET
AL32UTF8

Thank you in advance!!

Regards,

Sagar Puri

[kishetty03]

I am facing same issue. what needs to be done if My OS is Linux RHEL

[john_wang · Accepted solution]

Hi @kishetty03 ,

Not very sure your RHEL env however if possible, you may remove the existing Oracle client installation and then re-install instant client , it's easy and no need to config TNS or anything, you can use it directly in Qlik Replicate.

In general 2 packages are good enough (choose a version which suited your Replicate version), for example 2 below files in page download Version 19.17 :

oracle-instantclient19.17-basic-19.17.0.0.0-1.x86_64.rpm

oracle-instantclient19.17-sqlplus-19.17.0.0.0-1.x86_64.rpm

where SQL*Plus is optional, it can be used to test the connectivity eg "SQLPlus scott/tiger@<ip>:<port>/<inst>".

Adds the instant client lib library to LD_LIBRARY_PATH in file "site_arep_login.sh" file see Install Oracle Instant Client for Linux (x86-64) Version 12.0 or later , then restart Replicate services.

Hope this helps.

Regards,

John.

[kishetty03]

Thanks a lot @john_wang .
It worked .