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 .

[Vaibhav_19]

@john_wang 

We are encountering the same situation with Qlik Replicate (2024.5). We are getting the following error:

"Cannot create Oracle NLS environment for charset 873 and ncharset 1000. Error encountered while no error handle is active."

We followed the suggested solution in a previous post and reinstalled the Oracle Instant Client, but we are still facing the same issue.

Your assistance in resolving this matter would be greatly appreciated.

Thank you in advance!

[john_wang]

Hello @Vaibhav_19 ,

Would you confirm if SQPLus works in Qlik Replicate Server? please try to connect to remote Oracle Server from Qlik Replicate Server via SQLPlus.

Regards,

John.

[Vaibhav_19]

Yes, we tested the same able to successfully connect to Oracle server using SQL Plus.

[john_wang]

Hello @Vaibhav_19 ,

Not sure if Replicate is running on Linux machine? if yes then please check the system variables to make no other folders/libraries were included in the LD_LIBRARY_PATH except the Oracle Instance Client library folders.

If you are working with Windows platform, then please check if you have the oci.dll under ~\SYSTEM32 directory, if so try to remove it and test the connection again.

Regards,

John.