This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Oracle Bulk Load - SQLLDR Path Issue

Hemanth
New Contributor

‎04-04-2018 11:44 AM

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.

0 Kudos
Reply
10 REPLIES 10

dmiller
Former Employee

‎04-05-2018 08:54 AM

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


Diane Miller
0 Kudos
Reply

Hemanth
New Contributor
In response to dmiller

‎04-05-2018 09:08 AM

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

0 Kudos
Reply

mthirani
Employee
Employee
In response to Hemanth

‎04-05-2018 09:15 AM

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

0 Kudos
Reply

cstewart
Former Employee
In response to Hemanth

‎04-05-2018 09:43 AM

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

0 Kudos
Reply