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

    • cstewart's avatar
      cstewart
      Former Employee
      8 years ago

      Are you running on a Groundplex node that you have access to? (SQLLDR is not available in Cloudplex environments) .

      • Hemanth's avatar
        Hemanth
        New Contributor
        8 years ago

        I am executing using Cloud snaplex, Our Oracle DB is also on cloud.