topic Re: Oracle NLS environment in Qlik Replicate

Oracle NLS environment

SurajKumar007 — Tue, 19 Nov 2024 06:39:30 GMT

Hello Community,

We are encountering the following error while testing an Oracle connection in Qlik Replicate:

- Qlik Replicate Version: 2024.5
- Source: Oracle on Cloud
- Target: Oracle on Cloud
- Error: Cannot create Oracle NLS environment for charset 873 and ncharset 1000. Error encountered while no error handle is active.

We have tried resolving this issue by setting an environment variable in the Oracle Instant Client and even reinstalling the client, but the problem persists.

Your guidance on resolving this issue would be greatly appreciated.
Thank you in advance!

Re: Oracle NLS environment

john_wang — Tue, 19 Nov 2024 06:43:14 GMT

Hello @SurajKumar007 ,

Thanks for reaching out to Qlik Community!

Please check the similar article: Cannot create Oracle NLS environment for charset 873 and ncharset 1000.

Hope this helps.

John.

Re: Oracle NLS environment

SurajKumar007 — Tue, 19 Nov 2024 06:49:49 GMT

Hi @john_wang,

Thank you for responding so quickly. Sorry for not mentioning that I have already checked, reinstalled, and followed the steps mentioned in this link: Cannot create Oracle NLS environment for charset 873, but I am still encountering the same error.

If you could provide any specific guidance or additional steps, it would be greatly appreciated.

Thank you!

Re: Oracle NLS environment

Dana_Baldwin — Fri, 22 Nov 2024 17:46:11 GMT

Hi @SurajKumar007

What are the Oracle server and client versions? Are they a supported combination by Oracle?

Thanks,

Dana

Re: Oracle NLS environment

SurajKumar007 — Mon, 25 Nov 2024 05:43:52 GMT

Hi @Dana_Baldwin ,

Thanks for Replying,As have checked all the verison mentioned in Documents.
oracle server :Oracle cloud 19.0.0.0
Oracle Instant client verison :19.0.0

Thanks,

Suraj Kumar

Re: Oracle NLS environment

Dana_Baldwin — Mon, 25 Nov 2024 16:10:39 GMT

Thank you for checking that @SurajKumar007

Can you run SQLPlus from the Replicate server and successfully log onto the Oracle server without this error?

Please open a support case with us and consider also checking with Oracle support.

Thanks,

Dana

Re: Oracle NLS environment

SurajKumar007 — Wed, 27 Nov 2024 07:43:18 GMT

Hi @Dana_Baldwin ,
Thanks for the update .I have checked using tnsping and got the conenction output .its working but now we got another error mentioned below -
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

Thanks,
Suraj Kumar

Re: Oracle NLS environment

Dana_Baldwin — Wed, 27 Nov 2024 17:07:05 GMT

Hi @SurajKumar007

This message means that the driver is not found in the path. Have the environment variables been set up per the User Guide?

Prerequisites | Qlik Replicate Help

Replicate On Linux

Stop the Replicate service and optionally confirm that it has stopped as described in Replicate server procedures.
Install Oracle Instant Client for Linux (x86-64) Version 19.0 or later.
In addition, if not already included in your system, create a symbolic link in the $Oracle_Home\lib directory. Name the link libclntsh.so, and point it to a specific version of this file.

Example:

lrwxrwxrwx 1 oracle oracle 63 Oct 2 14:16 libclntsh.so -> /u01/app/oracle/home/lib/libclntsh.so.19.1
Change the working directory to <Replicate-Install-Dir>/bin.and append the LD_LIBRARY_PATH environment variable to the Oracle instant client directory and to the Replicate lib directory. Do this by copying the driver location to the site_arep_login.sh file:

echo "export LD_LIBRARY_PATH=\$LD_LIBRARY_PATH:/opt/oracle/instantclient_<version>:/opt/attunity/replicate/lib/" > site_arep_login.sh
Optionally, confirm that the driver location was copied:

cat site_arep_login.sh
Start the Replicate service and optionally confirm that it has started as described in Replicate server procedures."