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

[john_wang]

Hello @Vaibhav_19 ,

Thanks for the update.

Good progress. the correct path should be /data/product/19.0.0/lib rather than /data/product/19.0.0.

please confirm if the .so file folder and use the correct folder in LD_LIBRARY_PATH.

Good luck,

John.

[Vaibhav_19]

Hello @john_wang,

Apologies for delay.

We also raised the case with support, and the issue has now been resolved with their assistance over a call.

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
Cannot load <libclntsh.so>: libclntsh.so: cannot open shared object file: No such file or directory

Resolution Steps:

1. Review site_arep_login.sh Script
   Open and inspect the contents of the site_arep_login.sh file.
2. Verify Oracle Instant Client Directory
   Navigate to the Oracle Instant Client directory and verify the presence of the required library files and symbolic links. Identify multiple physical files are pointing to the same symbolic link.
3. Locate the Error File Path
   Check the file paths referenced in the error message (e.g., libclntsh.so.12.1).
4. Update site_arep_login.shIn the site_arep_login.sh file, define a new variable and assign the copied file path as its value.
5. Source the script: Run the command source ./arep_login.sh to apply the changes.
6. Restart Replicate service:Start the Replicate service and reconfigure the endpoint.And test the endpoint to ensure proper functionality.

Regards,

Vaibhav

[john_wang]

Hello @Vaibhav_19 ,

Thanks for the detailed information.

In my experience, set the LD_LIBRARY_PATH correctly in site_arep_login.sh file will help.

Best Regards,

John.