Skip to main content
Announcements
UPGRADE ADVISORY for Qlik Replicate 2024.5: Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
sagar_puri
Partner - Contributor III
Partner - Contributor III

Cannot create Oracle NLS environment for charset 873 and ncharset 1000

Hi,

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

sagar_puri_0-1604303424587.png

Below is the characterset parameter set in oracle,


NLS_CHARACTERSET
AL32UTF8

Thank you in advance!!

Regards,

Sagar Puri

Labels (1)
12 Replies
kishetty03
Contributor III
Contributor III

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

john_wang
Support
Support

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.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
kishetty03
Contributor III
Contributor III

Thanks a lot @john_wang .
It worked .