Skip to Content
avatar image
Former Member

ERROR CON-120402 - SAP Data Services 14.2.8.54 : Cannot find NT Oracle Server DLL ?....

Hi,

When I run a DS job with the client, I have the following error

CON-120402 - SAP Data Services 14.2.8.54 : Cannot find NT Oracle Server DLL <OCI.DLL>. Please make sure that Oracle has been installed and the PATH variable points to the....

I try to transfer data from an excel file (local) to an Oracle database table.

When I create the datastore and the data table (target) before designing the dataflow, the connection with Oracle seems to be OK.


Can you explain me how can I resolve this error?

Thanks,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jan 16, 2017 at 05:44 PM

    I changed the variable Path (to put the directory folder that contains the file oci.dll) in my local machine and the error is displayed again.

    Do I have to change the variable Path in my local machine or in the distance (virtual) machine ?

    I use the Data Services client in my local machine and I enter the information of the virtual machine when I open SAP Data Services Designer.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 17, 2017 at 04:01 PM

    This is a generic error. What is the version of oracle client on your DS Client machine(32 bit or 64 bit)

    If your DS Client is 64 bit then Install the 64-bit Oracle Drivers on the DS client machine.

    Basically, the Data Services client and the Oracle client have to have the same bit version.

    Regards

    Arun Sasi

    Add comment
    10|10000 characters needed characters exceeded