topic Cannot create Oracle NLS environment for charset 873 and ncharset 1000 in Qlik Replicate

Cannot create Oracle NLS environment for charset 873 and ncharset 1000

sagar_puri — Mon, 02 Nov 2020 08:00:39 GMT

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

Re: Cannot create Oracle NLS environment for charset 873 and ncharset 1000

john_wang — Mon, 02 Nov 2020 22:58:34 GMT

Hello @sagar_puri ,

Good day. In general this error caused by Oracle client installation/configuration. Please let us know more detailed info:

1. The Replicate Server platform (Windows , or Linux)

2. The Oracle client installation type and version

The Oracle Instance Client is highly recommended if your replication data type does not include XMLTYPE.

3. The best practice is using SQLPlus to do troubleshoot. If SQLPlus client (sits on Replicate Server) program can establish the connection to Oracle server successfully then Replicate should work too.

If SQLPlus does not work either, you can remove the existing Oracle client and install a fresh Instance Client. This is a pure Oracle client/server issue.

4. If you need additional assistance please attach task log file, or repsrv.log.

All the Best,

John.

Re: Cannot create Oracle NLS environment for charset 873 and ncharset 1000

sagar_puri — Fri, 06 Nov 2020 09:13:02 GMT

Hi John,

Please find the details ,

We have Qlik Replicate (6.6.0.384) installed on Windows Server 2019 Datacenter (Server is running on Azure Cloud)
Oracle 12c (12.2.0.1.0)

Also we are able to successfully connect to Oracle server using SQL*Plus.

Please find the repsrv.log and NLS Parameter of Oracle.

Thanks,

Sagar Puri

Re: Cannot create Oracle NLS environment for charset 873 and ncharset 1000

john_wang — Tue, 17 Nov 2020 07:33:39 GMT

Hi @sagar_puri ,

Can you let me know what's your connection string in the SQLPLus ? how about if you use the same connection string in Replicate?

From server log file I saw:

2020-11-06T14:18:11:576726 [SERVER ]I: Going to connect to Oracle server localhost:1521\orcl.5bfzmyo25mfutjqfmvvj0cmrya.rx.internal.cloudapp.net with username system (oracle_endpoint_imp.c:1294)

it means the Oracle sit on the as same server as Replicate. is that right?

thanks,

John.

Re: Cannot create Oracle NLS environment for charset 873 and ncharset 1000

sagar_puri — Wed, 18 Nov 2020 16:32:45 GMT

Hi John,

Yes Oracle and Replicate are on the same server.

Also, we are using the same connection string that which we are getting in SQLPLUS. We are able to connect to Oracle SQL Developer too using this string.

Thanks,

Sagar

Re: Cannot create Oracle NLS environment for charset 873 and ncharset 1000

lyka — Thu, 19 Nov 2020 00:14:59 GMT

Hello,

Can you try this -

Please check if oci.dll is under SYSTEM32. If yes, can you remove this file? We saw a similar case before and when this file is removed, it solved the issue.

This problem is hard to trace because sqlplus works fine. Even re-install Oracle client still does not help. So, if you find the symptoms below,

- NLS error but cannot find any ORA-xxxx code in the repsrv.log
-

then please check oci.dll if it exists in SYSTEM32.

Thanks,

Lyka

Re: Cannot create Oracle NLS environment for charset 873 and ncharset 1000

John123Booth — Fri, 20 Nov 2020 04:07:12 GMT

The same problem occurred when i tried this.

Re: Cannot create Oracle NLS environment for charset 873 and ncharset 1000

BhavinPalan — Thu, 04 Feb 2021 13:51:38 GMT

I also got the same error without having oci.dll file in SYSTEM32 Folder. Is this issue resolved ?

Re: Cannot create Oracle NLS environment for charset 873 and ncharset 1000

sagar_puri — Thu, 04 Feb 2021 17:15:38 GMT

Hi Bhavin,

We are not facing this issue anymore.

Try upgrading your Replicate version to more recent one if you haven’t already, also do a global search for OCI.dll file on your machine and remove it from all the folders.

In my case we had few old copies of the file in Bin, deleting them did the trick.

Regards,

Sagar

Re: Cannot create Oracle NLS environment for charset 873 and ncharset 1000

BhavinPalan — Thu, 04 Feb 2021 23:28:24 GMT

Hey Sagar,

Yeah the issue is resolved now. The file that was in System32 was moved but it didn't reflected unless the Server was restarted. Post which this issue was resolved.

Thanks for the Help.

Thanks,

Bhavin

Re: Cannot create Oracle NLS environment for charset 873 and ncharset 1000

kishetty03 — Tue, 20 Dec 2022 09:59:00 GMT

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

Re: Cannot create Oracle NLS environment for charset 873 and ncharset 1000

john_wang — Tue, 20 Dec 2022 13:12:49 GMT

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.

Re: Cannot create Oracle NLS environment for charset 873 and ncharset 1000

kishetty03 — Wed, 21 Dec 2022 06:34:26 GMT

Thanks a lot @john_wang .
It worked .

Re: Cannot create Oracle NLS environment for charset 873 and ncharset 1000

Vaibhav_19 — Tue, 19 Nov 2024 06:41:05 GMT

@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!

Re: Cannot create Oracle NLS environment for charset 873 and ncharset 1000

john_wang — Tue, 19 Nov 2024 06:50:29 GMT

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.

Re: Cannot create Oracle NLS environment for charset 873 and ncharset 1000

Vaibhav_19 — Tue, 19 Nov 2024 06:56:16 GMT

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

Re: Cannot create Oracle NLS environment for charset 873 and ncharset 1000

john_wang — Tue, 19 Nov 2024 14:39:46 GMT

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.

Re: Cannot create Oracle NLS environment for charset 873 and ncharset 1000

Vaibhav_19 — Wed, 20 Nov 2024 07:50:01 GMT

Thanks for Quick response @john_wang

Yes Its Linux, And our LD_LIBRARY_PATH=\$LD_LIBRARY_PATH:/data/product/19.0.0:/opt/attunity/replicate/lib/

we followed the Documentation -
echo "export LD_LIBRARY_PATH=\$LD_LIBRARY_PATH:/opt/oracle/instantclient_<version>:/opt/attunity/replicate/lib/" > site_arep_login.sh

Regards,

Vaibhav

Re: Cannot create Oracle NLS environment for charset 873 and ncharset 1000

john_wang — Wed, 20 Nov 2024 15:14:37 GMT

Hello @Vaibhav_19 ,

It's inaccurate: LD_LIBRARY_PATH=\$LD_LIBRARY_PATH:

where the "\" is unnecessary. please remove it and try again.

Regards,

John.

Re: Cannot create Oracle NLS environment for charset 873 and ncharset 1000

Vaibhav_19 — Thu, 21 Nov 2024 04:39:33 GMT

Thanks @john_wang for response,

we updated the LD_LIBRARY_PATH. But now we are getting the below error

Error:
Stream component initialization function has failed for component 'Oracle', type 'Oracle'.
Cannot load <libclntsh.so, libclntsh.so.12.1, libclntsh.so.11.1, libclntsh.so.10.1, >: No such file or directory
Cannot load <libclntsh.so.10.1>: libclntsh.so.10.1: cannot open shared object file: No such file or directory
Cannot load <libclntsh.so.11.1>: libclntsh.so.11.1: cannot open shared object file: No such file or directory
Cannot load <libclntsh.so.12.1>: libclntsh.so.12.1: cannot open shared object file: No such file or directory

Regards,

Vaibhav

Cannot load <libclntsh.so>: libclntsh.so: cannot open shared object file: No such file or directory