Forum Discussion

Hemanth's avatar
Hemanth
New Contributor
8 years ago

Oracle Bulk Load - SQLLDR Path Issue

Hi,

I am trying to use the Oracle Bulk Load option for inserting the data, currently getting the issue for SQLLDR path. I have provided the path of SQLLDR like this and SQLLDR is available in this path on Oracle Database Server. Tried with both
u01/app/oracle/product/12.1.0/dbhome_1/bin/sqlldr.exe
u01/app/oracle/product/12.1.0/dbhome_1/bin/sqlldr

Error Message
Failure: Specified SQLLDR path is not an executable file, Reason: Snap failed unexpectedly and did not provide any reason

Please could suggest me on the path of SQLLDR.

10 Replies

  • dmiller's avatar
    dmiller
    Former Employee
    8 years ago

    I believe you need an opening /, as in:
    /u01/app/oracle/product/12.1.0/dbhome_1/bin/sqlldr

    • Hemanth's avatar
      Hemanth
      New Contributor
      8 years ago

      Tried with opening / as /u01/app/oracle/product/12.1.0/dbhome_1/bin/sqlldr this also did not work.

      • mthirani's avatar
        mthirani
        Employee
        8 years ago

        Have you tried using the suggestions in the snap for this field?
        Also make sure the ORACLE_HOME, PATH and ORACLE_SID is set appropriately in the plex for oracle. For example:

        export ORACLE_HOME=“/u01/app/oracle/product/11.2.0/xe”
        export ORACLE_SID=“XE”
        export PATH=$ORACLE_HOME/bin:$PATH