Oracle NLS environment

[SurajKumar007]

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!

[john_wang]

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.

[SurajKumar007]

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!

[Dana_Baldwin]

Hi @SurajKumar007 

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

Thanks,

Dana

[SurajKumar007]

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

[Dana_Baldwin]

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

[SurajKumar007]

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

[Dana_Baldwin]

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

1. Stop the Replicate service and optionally confirm that it has stopped as described in Replicate server procedures.

2. Install Oracle Instant Client for Linux (x86-64) Version 19.0 or later.

3. 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

4. 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

5. Optionally, confirm that the driver location was copied:

   cat site_arep_login.sh

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