SAP Knowledge Base Article - Preview

2595806 - Error when testing connection for Oracle datastore - SAP Cloud Platform Integration for Data Services

Symptom

When in SAP Cloud Platform Integration for Data Services web application you create an Oracle datastore and select "Test connection" you receive the following error:

  • When using a Linux agent machine the following error is shown:

Test failed for the default configuration '<configuration name>' of datastore: '<datastore name>':
Oracle shared library <libclntsh.so> not found. Please make sure it is installed and can be located using the library search path (LIBPATH on AIX, LD_LIBRARY_PATH on Solaris/Linux, SHLIB_PATH on HP-UX). Please check the file permissions for <libclntsh.so>.

  • When using a Microsoft Windows agent machine the following error is shown:

Test failed for the default configuration '<configuration name>' of datastore: '<datastore name>':
Cannot find NT Oracle Server DLL <OCI.DLL>. Please make sure that Oracle has been installed and the PATH variable points to the correct lib directories.


Read more...

Environment

  • SAP Cloud Platform Integration for Data Services
  • All supported versions of Linux operating system
  • All supported versions of Microsoft Windows operating system
  • All supported versions of Oracle database

Product

SAP Cloud Integration for data services all versions

Keywords

Oracle, connection, test failed, CIDS, test connection, CPIDS , KBA , LOD-HCI-DS , HANA Cloud Integration for Data Services , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.